void SQLiteExpectation::insert ()
{
	char* info = getFileAsCharPtr ( MsparamsDir::instance ().getParamPath ( fileName ) );

	string xparams = XMLParser::getStringValue ( info, "parameters" );
	ParameterList expParamList ( xparams, false, false, false );
	StringVector pNames;
	StringVectorVector pValues;
	expParamList.getParams ( pNames, pValues );
	v1 [4] = "";
	v1 [5] = "1";
	v1 [6] = "0";
	v1 [0] = "expectation";
	v1 [1] = "default";
	for ( StringVectorSizeType i = 0 ; i < pNames.size () ; i++ ) {
		v1 [2] = pNames [i];
		for ( StringVectorSizeType j = 0 ; j < pValues [i].size () ; j++ ) {
			v1 [3] = pValues [i] [j];
			insertTable ( tableName, n1, v1 );
		}
	}
	StringVector cparams = XMLParser::getStringVectorValue ( info, "copy_parameter" );
	v1 [0] = "expectation";
	v1 [1] = "copy";
	v1 [3] = "";
	for ( StringVectorSizeType k = 0 ; k < pNames.size () ; k++ ) {
		v1 [2] = pNames [k];
		insertTable ( tableName, n1, v1 );
	}

	delete [] info;
}
void SQLiteMGF::insert ()
{
	v1 [3] = "";
	v1 [4] = "1";
	v1 [5] = "0";
	char* info = getFileAsCharPtr ( MsparamsDir::instance ().getParamPath ( fileName ) );

	StringVector xparams = XMLParser::getStringVectorValue ( info, "mgf_type" );
	for ( StringVectorSizeType i = 0 ; i < xparams.size () ; i++ ) {
		ParameterList pList ( xparams [i], false, false, false );
		StringVector pNames;
		StringVectorVector pValues;
		pList.getParams ( pNames, pValues );
		v1 [0] = pList.getStringValue ( "name" );
		for ( StringVectorSizeType j = 0 ; j < pNames.size () ; j++ ) {
			if ( pNames [j] != "name" ) {
				v1 [1] = pNames [j];
				for ( StringVectorSizeType k = 0 ; k < pValues [j].size () ; k++ ) {
					v1 [2] = pValues [j] [k];
					insertTable ( tableName, n1, v1 );
				}
			}
		}
	}

	delete [] info;
}
void SQLiteParameterLists::insert ()
{
	StringVector fileList;
	fileList.push_back ( "batchtag" );
	fileList.push_back ( "dbstat" );
	fileList.push_back ( "msbridge" );
	fileList.push_back ( "mscomp" );
	fileList.push_back ( "msdigest" );
	fileList.push_back ( "msfilter" );
	fileList.push_back ( "msfit" );
	fileList.push_back ( "msfitupload" );
	fileList.push_back ( "mshomology" );
	fileList.push_back ( "msisotope" );
	fileList.push_back ( "msnonspecific" );
	fileList.push_back ( "mspattern" );
	fileList.push_back ( "msproduct" );
	fileList.push_back ( "msseq" );
	fileList.push_back ( "mstag" );
	fileList.push_back ( "msviewer" );
	fileList.push_back ( "searchCompare" );
	v1 [4] = "";
	v1 [5] = "1";
	v1 [6] = "0";
	for ( StringVectorSizeType i = 0 ; i < fileList.size () ; i++ ) {
		ParameterList pList ( MsparamsDir::instance ().getParamPath ( fileList [i] + SLASH + "default.xml" ), false, false, false, false );
		StringVector pNames;
		StringVectorVector pValues;
		pList.getParams ( pNames, pValues );
		v1 [0] = fileList [i];
		v1 [1] = "default";
		for ( StringVectorSizeType j = 0 ; j < pNames.size () ; j++ ) {
			v1 [2] = pNames [j];
			for ( StringVectorSizeType k = 0 ; k < pValues [j].size () ; k++ ) {
				v1 [3] = pValues [j] [k];
				insertTable ( tableName, n1, v1 );
			}
		}
	}
}