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 ); } } } }