Lines Matching refs:query
66 vtkSQLQuery* query = db->GetQueryInstance(); in TestMySQLDatabase() local
69 query->SetQuery( createQuery.c_str() ); in TestMySQLDatabase()
70 if ( !query->Execute() ) in TestMySQLDatabase()
82 query->SetQuery( insertQuery ); in TestMySQLDatabase()
83 if ( !query->Execute() ) in TestMySQLDatabase()
91 query->SetQuery( queryText ); in TestMySQLDatabase()
92 cerr << endl << "Running query: " << query->GetQuery() << endl; in TestMySQLDatabase()
95 if ( !query->Execute() ) in TestMySQLDatabase()
101 for ( int col = 0; col < query->GetNumberOfFields(); ++ col ) in TestMySQLDatabase()
107 cerr << query->GetFieldName( col ); in TestMySQLDatabase()
110 while ( query->NextRow() ) in TestMySQLDatabase()
112 for ( int field = 0; field < query->GetNumberOfFields(); ++ field ) in TestMySQLDatabase()
118 cerr << query->DataValue( field ).ToString().c_str(); in TestMySQLDatabase()
124 if ( !query->Execute() ) in TestMySQLDatabase()
129 for ( int col = 0; col < query->GetNumberOfFields(); ++ col ) in TestMySQLDatabase()
135 cerr << query->GetFieldName( col ); in TestMySQLDatabase()
139 while ( query->NextRow( va ) ) in TestMySQLDatabase()
155 reader->SetQuery( query ); in TestMySQLDatabase()
173 query->SetQuery( "DROP TABLE people" ); in TestMySQLDatabase()
174 if ( ! query->Execute() ) in TestMySQLDatabase()
181 query->Delete(); in TestMySQLDatabase()
213 query = db->GetQueryInstance(); in TestMySQLDatabase()
214 query->SetQuery( "SHOW TABLES" ); in TestMySQLDatabase()
215 if ( ! query->Execute() ) in TestMySQLDatabase()
222 while ( query->NextRow() ) in TestMySQLDatabase()
224 tables.push_back( query->DataValue( 0 ).ToString() ); in TestMySQLDatabase()
269 query->SetQuery( queryStr ); in TestMySQLDatabase()
270 if ( ! query->Execute() ) in TestMySQLDatabase()
276 int numFields = query->GetNumberOfFields(); in TestMySQLDatabase()
278 for ( ; query->NextRow(); ++ colHandle ) in TestMySQLDatabase()
289 if ( colName != query->DataValue( field ).ToString() ) in TestMySQLDatabase()
292 << query->DataValue( field ).ToString() in TestMySQLDatabase()
300 cerr << query->DataValue( field ).ToString().c_str(); in TestMySQLDatabase()
318 query->SetQuery( queryStr ); in TestMySQLDatabase()
319 if ( ! query->Execute() ) in TestMySQLDatabase()
325 numFields = query->GetNumberOfFields(); in TestMySQLDatabase()
327 while ( query->NextRow() ) in TestMySQLDatabase()
329 int cnmHandle = atoi( query->DataValue( 3 ).ToString() ) - 1; in TestMySQLDatabase()
346 cerr << query->DataValue( field ).ToString().c_str(); in TestMySQLDatabase()
350 if ( colName != query->DataValue( 4 ).ToString() ) in TestMySQLDatabase()
353 << query->DataValue( 4 ).ToString() in TestMySQLDatabase()
376 query->SetQuery( queryStr ); in TestMySQLDatabase()
377 if ( ! query->Execute() ) in TestMySQLDatabase()
380 query->Delete(); in TestMySQLDatabase()
386 query->SetQuery( queryStr ); in TestMySQLDatabase()
387 if ( ! query->Execute() ) in TestMySQLDatabase()
390 query->Delete(); in TestMySQLDatabase()
396 query->SetQuery( queryStr ); in TestMySQLDatabase()
397 if ( ! query->Execute() ) in TestMySQLDatabase()
400 query->Delete(); in TestMySQLDatabase()
411 query->SetQuery( queryStr ); in TestMySQLDatabase()
412 if ( ! query->Execute() ) in TestMySQLDatabase()
415 query->Delete(); in TestMySQLDatabase()
423 for ( ; query->NextRow(); ++ numDpt ) in TestMySQLDatabase()
425 if ( query->DataValue( 0 ).ToString() != dpts[numDpt] ) in TestMySQLDatabase()
428 << query->DataValue( 0 ).ToString() in TestMySQLDatabase()
432 query->Delete(); in TestMySQLDatabase()
437 << query->DataValue( 0 ).ToString() in TestMySQLDatabase()
448 query->Delete(); in TestMySQLDatabase()
460 query->EscapeString( vtkStdString( "Str\"ang'eS\ntring" ), true ) + in TestMySQLDatabase()
462 query->SetQuery( queryStr ); in TestMySQLDatabase()
463 if ( ! query->Execute() ) in TestMySQLDatabase()
466 query->Delete(); in TestMySQLDatabase()
477 query->SetQuery( queryStr ); in TestMySQLDatabase()
478 if ( ! query->Execute() ) in TestMySQLDatabase()
481 query->Delete(); in TestMySQLDatabase()
486 if ( ! query->NextRow() ) in TestMySQLDatabase()
489 query->Delete(); in TestMySQLDatabase()
494 cerr << query->DataValue( 0 ).ToString().c_str() << "> "; in TestMySQLDatabase()
505 query->SetQuery( queryStr ); in TestMySQLDatabase()
507 if ( ! query->Execute() ) in TestMySQLDatabase()
519 …query->SetQuery("create table if not exists time (_date DATE, _time TIME, _timestamp TIMESTAMP, _d… in TestMySQLDatabase()
520 cerr << query->GetQuery() << endl; in TestMySQLDatabase()
521 if ( ! query->Execute() ) in TestMySQLDatabase()
526 …query->SetQuery("insert into time values ('2008-01-01', '01:23:45', '2008-01-01 01:23:45', '2008-0… in TestMySQLDatabase()
527 cerr << query->GetQuery() << endl; in TestMySQLDatabase()
528 if ( ! query->Execute() ) in TestMySQLDatabase()
533 query->SetQuery("select * from time"); in TestMySQLDatabase()
534 cerr << query->GetQuery() << endl; in TestMySQLDatabase()
535 if ( ! query->Execute() ) in TestMySQLDatabase()
540 query->NextRow(); in TestMySQLDatabase()
541 vtkTypeUInt64 date = vtkTimePointUtility::ISO8601ToTimePoint( query->DataValue( 0 ).ToString() ); in TestMySQLDatabase()
542 vtkTypeUInt64 time = vtkTimePointUtility::ISO8601ToTimePoint( query->DataValue( 1 ).ToString() ); in TestMySQLDatabase()
543 …vtkTypeUInt64 timestamp = vtkTimePointUtility::ISO8601ToTimePoint( query->DataValue( 2 ).ToString(… in TestMySQLDatabase()
544 …vtkTypeUInt64 datetime = vtkTimePointUtility::ISO8601ToTimePoint( query->DataValue( 3 ).ToString()… in TestMySQLDatabase()
570 year = query->DataValue( 4 ).ToInt(); in TestMySQLDatabase()
576 query->SetQuery("drop table time;"); in TestMySQLDatabase()
577 cerr << query->GetQuery() << endl; in TestMySQLDatabase()
578 if ( ! query->Execute() ) in TestMySQLDatabase()
586 query->Delete(); in TestMySQLDatabase()