create table if not exists DataQuality ( dataqualityrow int , subdetectorrow int , starttime int , endtime int , flag bigint , createtime int , versionrow int , authorrow int , flagdefrow int , histo varchar(100) , comments text , loadtime int ) ; create table if not exists Authors ( authorrow int , author varchar(80) , primary key( authorrow ) ) ; create table if not exists FlagDefs ( flagdefrow int , flagdef varchar(160) , primary key ( flagdefrow ) ) ; create table if not exists Versions ( versionrow int , version varchar(120) , primary key ( versionrow ) ) ; create table if not exists SubDetectors ( subdetectorrow int , subdetector varchar(20) , primary key ( subdetectorrow ) ) ; create table if not exists DataQualityTest ( dataqualityrow int , subdetectorrow int , starttime int , endtime int , flag bigint , createtime int , versionrow int , authorrow int , flagdefrow int , histo varchar(100) , comments text , loadtime int ) ; create table if not exists AuthorsTest ( authorrow int , author varchar(80) , primary key( authorrow ) ) ; create table if not exists FlagDefsTest ( flagdefrow int , flagdef varchar(160) , primary key ( flagdefrow ) ) ; create table if not exists VersionsTest ( versionrow int , version varchar(120) , primary key ( versionrow ) ) ; create table if not exists SubDetectorsTest ( subdetectorrow int , subdetector varchar(20) , primary key ( subdetectorrow ) ) ; # DataQuality_insert:: INSERT INTO DataQuality VALUES(%d, %d, %d, %d, %d, %d, %d, %d, %d, %s, %s, %d); # Authors_insert:: INSERT INTO Authors VALUES(%d, %s); # FlagDefs_insert:: INSERT INTO FlagDefs VALUES(%d,%s); # Versions_insert:: INSERT INTO Versions VALUES(%d, %s); # SubDetectors_insert:: INSERT INTO SubDetectors VALUES(%d, %s); # DataQualityTest_insert:: INSERT INTO DataQualityTest VALUES(%d, %d, %d, %d, %d, %d, %d, %d, %d, %s, %s, %d); # AuthorsTest_insert:: INSERT INTO AuthorsTest VALUES(%d, %s); # FlagDefsTest_insert:: INSERT INTO FlagDefsTest VALUES(%d, %s); # VersionsTest_insert:: INSERT INTO VersionsTest VALUES(%d, %s); # SubDetectorsTest_insert:: INSERT INTO SubDetectorsTest VALUES(%d, %s); # DataQuality_query_row:: SELECT dataqualityrow FROM DataQuality; # Authors_query_row:: SELECT authorrow FROM Authors; # FlagDefs_query_row:: SELECT flagdefrow FROM FlagDefs; # Versions_query_row:: SELECT versionrow FROM Versions; # SubDetectors_query_row:: SELECT subdetectorrow FROM SubDetectors; # DataQualityTest_query_row:: SELECT dataqualityrow FROM DataQualityTest; # AuthorsTest_query_row:: SELECT authorrow FROM AuthorsTest; # FlagDefsTest_query_row:: SELECT flagdefrow FROM FlagDefsTest; # VersionsTest_query_row:: SELECT versionrow FROM VersionsTest; # SubDetectorsTest_query_row:: SELECT subdetectorrow FROM SubDetectorsTest; # DataQuality_query_exists:: SELECT * FROM DataQuality WHERE subdetectorrow = %d AND starttime = %d AND endtime = %d AND flag = %d AND createtime = %d AND versionrow = %d AND authorrow = %d AND flagdefrow = %d AND histo = %s AND comments = %s; # Authors_query_exists:: SELECT * FROM Authors WHERE author = %s; # FlagDefs_query_exists:: SELECT * FROM FlagDefs WHERE flagdef = %s; # Versions_query_exists:: SELECT * FROM Versions WHERE version = %s; # SubDetectors_query_exists:: SELECT * FROM SubDetectors WHERE subdetector = %s; # DataQualityTest_query_exists:: SELECT * FROM DataQualityTest WHERE subdetectorrow = %d AND starttime = %d AND endtime = %d AND flag = %d AND createtime = %d AND versionrow = %d AND authorrow = %d AND flagdefrow = %d AND histo = %s AND comments = %s; # AuthorsTest_query_exists:: SELECT * FROM AuthorsTest WHERE author = %s; # FlagDefsTest_query_exists:: SELECT * FROM FlagDefsTest WHERE flagdef = %s; # VersionsTest_query_exists:: SELECT * FROM VersionsTest WHERE version = %s; # SubDetectorsTest_query_exists:: SELECT * FROM SubDetectorsTest WHERE subdetector = %s; # DataQuality_query_flag_subdetector:: SELECT flag, starttime, endtime, createtime, loadtime FROM DataQuality, SubDetectors WHERE SubDetectors.subdetector = '%s' AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND starttime <= %d AND endtime > %d; # DataQuality_query_flag:: SELECT flag, starttime, endtime, createtime, loadtime FROM DataQuality, SubDetectors WHERE DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND starttime <= %d AND endtime > %d; # DataQualityTest_query_flag_subdetector:: SELECT flag, starttime, endtime, createtime FROM DataQualityTest, SubDetectorsTest WHERE SubDetectorsTest.subdetector = '%s' AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND starttime <= %d AND endtime > %d; # DataQualityTest_query_flag:: SELECT flag, starttime, endtime, createtime FROM DataQualityTest, SubDetectorsTest WHERE DataQualityTest.subdetectorrow = SubDetectorsTest.subdetectorrow AND starttime <= %d AND endtime > %d; # DataQuality_query_all:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow; # DataQualityTest_query_all:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow; # DataQuality_query_subdetector:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow ; # DataQualityTest_query_subdetector:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubdetectorsTest.subdetector = '%s'AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_starttime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE starttime >= %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow; # DataQualityTest_query_starttime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE starttime >= %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_endtime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE endtime <= %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow ; # DataQualityTest_query_endtime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE endtime <= %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_createtime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE createtime >= %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow ; # DataQualityTest_query_createtime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE createtime >= %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_version:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE Versions.version = '%s' AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow ; # DataQualityTest_query_version:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE VersionsTest.version = '%s' AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_author:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE Authors.author = '%s' AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow; # DataQualityTest_query_author:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE AuthorsTest.author = '%s' AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow; # DataQuality_query_flagdef:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE FlagDefs.flagdef = '%s' AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow; # DataQualityTest_query_flagdef:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE FlagDefs.flagdef = '%s' AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_subdetector_gtstarttime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND starttime >= %d AND starttime <= %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow; # DataQualityTest_query_subdetector_starttime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND starttime >= %d AND starttime <= %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_subdetector_ltendtime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND endtime <= %d AND endtime >= %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow ; # DataQualityTest_query_subdetector_endtime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND endtime <= %d AND endtime >= %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_subdetector_starttime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND AND starttime >= %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow; # DataQualityTest_query_subdetector_starttime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND starttime >= %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_subdetector_endtime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND endtime <= %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow ; # DataQualityTest_query_subdetector_endtime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND AND endtime <= %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_subdetector_flag:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND flag = %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow; # DataQualityTest_query_subdetector_flag:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND flag = %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_subdetector_createtime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND createtime >= %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow ; # DataQualityTest_query_subdetector_createtime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND createtime >= %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_subdetector_version:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND Versions.version = '%s' AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow ; # DataQualityTest_query_subdetector_version:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND VersionsTest.version = '%s' AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_subdetector_author:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND Authors.author = '%s' AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow; # DataQualityTest_query_subdetector_author:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND AuthorsTest.author = '%s' AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_subdetector_interval:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND (((starttime <= %d AND endtime >= %d) OR (starttime >= %d AND endtime <= %d) OR (starttime <= %d AND endtime <= %d) OR (starttime >= %d AND endtime >= %d))) AND starttime < %d AND endtime > %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow; # DataQualityTest_query_subdetector_starttime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND starttime >= %d AND endtime <= %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQuality_query_subdetector_interval2:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQuality, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND starttime <= %d AND endtime >= %d AND DataQuality.subdetectorrow=SubDetectors.subdetectorrow AND DataQuality.versionrow=Versions.versionrow AND DataQuality.authorrow=Authors.authorrow AND DataQuality.flagdefrow=FlagDefs.flagdefrow; # DataQualityTest_query_subdetector_starttime2:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND starttime <= %d AND endtime >= %d AND DataQualityTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityTest.versionrow=VersionsTest.versionrow AND DataQualityTest.authorrow=AuthorsTest.authorrow AND DataQualityTest.flagdefrow=FlagDefsTest.flagdefrow ; create table if not exists DataQualityCosmics ( dataqualityrow int , subdetectorrow int , starttime int , endtime int , flag bigint , createtime int , versionrow int , authorrow int , flagdefrow int , histo varchar(100) , comments text , loadtime int ) ; create table if not exists Authors ( authorrow int , author varchar(80) , primary key( authorrow ) ) ; create table if not exists FlagDefs ( flagdefrow int , flagdef varchar(160) , primary key ( flagdefrow ) ) ; create table if not exists Versions ( versionrow int , version varchar(120) , primary key ( versionrow ) ) ; create table if not exists SubDetectors ( subdetectorrow int , subdetector varchar(20) , primary key ( subdetectorrow ) ) ; create table if not exists DataQualityCosmicsTest ( dataqualityrow int , subdetectorrow int , starttime int , endtime int , flag bigint , createtime int , versionrow int , authorrow int , flagdefrow int , histo varchar(100) , comments text , loadtime int ) ; create table if not exists AuthorsTest ( authorrow int , author varchar(80) , primary key( authorrow ) ) ; create table if not exists FlagDefsTest ( flagdefrow int , flagdef varchar(160) , primary key ( flagdefrow ) ) ; create table if not exists VersionsTest ( versionrow int , version varchar(120) , primary key ( versionrow ) ) ; create table if not exists SubDetectorsTest ( subdetectorrow int , subdetector varchar(20) , primary key ( subdetectorrow ) ) ; # DataQualityCosmics_insert:: INSERT INTO DataQualityCosmics VALUES(%d, %d, %d, %d, %d, %d, %d, %d, %d, %s, %s, %d); # Authors_insert:: INSERT INTO Authors VALUES(%d, %s); # FlagDefs_insert:: INSERT INTO FlagDefs VALUES(%d,%s); # Versions_insert:: INSERT INTO Versions VALUES(%d, %s); # SubDetectors_insert:: INSERT INTO SubDetectors VALUES(%d, %s); # DataQualityCosmicsTest_insert:: INSERT INTO DataQualityCosmicsTest VALUES(%d, %d, %d, %d, %d, %d, %d, %d, %d, %s, %s, %d); # AuthorsTest_insert:: INSERT INTO AuthorsTest VALUES(%d, %s); # FlagDefsTest_insert:: INSERT INTO FlagDefsTest VALUES(%d, %s); # VersionsTest_insert:: INSERT INTO VersionsTest VALUES(%d, %s); # SubDetectorsTest_insert:: INSERT INTO SubDetectorsTest VALUES(%d, %s); # DataQualityCosmics_query_row:: SELECT dataqualityrow FROM DataQualityCosmics; # Authors_query_row:: SELECT authorrow FROM Authors; # FlagDefs_query_row:: SELECT flagdefrow FROM FlagDefs; # Versions_query_row:: SELECT versionrow FROM Versions; # SubDetectors_query_row:: SELECT subdetectorrow FROM SubDetectors; # DataQualityCosmicsTest_query_row:: SELECT dataqualityrow FROM DataQualityCosmicsTest; # AuthorsTest_query_row:: SELECT authorrow FROM AuthorsTest; # FlagDefsTest_query_row:: SELECT flagdefrow FROM FlagDefsTest; # VersionsTest_query_row:: SELECT versionrow FROM VersionsTest; # SubDetectorsTest_query_row:: SELECT subdetectorrow FROM SubDetectorsTest; # DataQualityCosmics_query_exists:: SELECT * FROM DataQualityCosmics WHERE subdetectorrow = %d AND starttime = %d AND endtime = %d AND flag = %d AND createtime = %d AND versionrow = %d AND authorrow = %d AND flagdefrow = %d AND histo = %s AND comments = %s; # Authors_query_exists:: SELECT * FROM Authors WHERE author = %s; # FlagDefs_query_exists:: SELECT * FROM FlagDefs WHERE flagdef = %s; # Versions_query_exists:: SELECT * FROM Versions WHERE version = %s; # SubDetectors_query_exists:: SELECT * FROM SubDetectors WHERE subdetector = %s; # DataQualityCosmicsTest_query_exists:: SELECT * FROM DataQualityCosmicsTest WHERE subdetectorrow = %d AND starttime = %d AND endtime = %d AND flag = %d AND createtime = %d AND versionrow = %d AND authorrow = %d AND flagdefrow = %d AND histo = %s AND comments = %s; # AuthorsTest_query_exists:: SELECT * FROM AuthorsTest WHERE author = %s; # FlagDefsTest_query_exists:: SELECT * FROM FlagDefsTest WHERE flagdef = %s; # VersionsTest_query_exists:: SELECT * FROM VersionsTest WHERE version = %s; # SubDetectorsTest_query_exists:: SELECT * FROM SubDetectorsTest WHERE subdetector = %s; # DataQualityCosmics_query_flag_subdetector:: SELECT flag, starttime, endtime, createtime, loadtime FROM DataQualityCosmics, SubDetectors WHERE SubDetectors.subdetector = '%s' AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND starttime <= %d AND endtime > %d; # DataQualityCosmics_query_flag:: SELECT flag, starttime, endtime, createtime, loadtime FROM DataQualityCosmics, SubDetectors WHERE DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND starttime <= %d AND endtime > %d; # DataQualityCosmicsTest_query_flag_subdetector:: SELECT flag, starttime, endtime, createtime FROM DataQualityCosmicsTest, SubDetectorsTest WHERE SubDetectorsTest.subdetector = '%s' AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND starttime <= %d AND endtime > %d; # DataQualityCosmicsTest_query_flag:: SELECT flag, starttime, endtime, createtime FROM DataQualityCosmicsTest, SubDetectorsTest WHERE DataQualityCosmicsTest.subdetectorrow = SubDetectorsTest.subdetectorrow AND starttime <= %d AND endtime > %d; # DataQualityCosmics_query_all:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow; # DataQualityCosmicsTest_query_all:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow; # DataQualityCosmics_query_subdetector:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow ; # DataQualityCosmicsTest_query_subdetector:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubdetectorsTest.subdetector = '%s'AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_starttime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE starttime >= %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow; # DataQualityCosmicsTest_query_starttime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE starttime >= %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_endtime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE endtime <= %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow ; # DataQualityCosmicsTest_query_endtime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE endtime <= %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_createtime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE createtime >= %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow ; # DataQualityCosmicsTest_query_createtime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE createtime >= %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_version:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE Versions.version = '%s' AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow ; # DataQualityCosmicsTest_query_version:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE VersionsTest.version = '%s' AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_author:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE Authors.author = '%s' AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow; # DataQualityCosmicsTest_query_author:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE AuthorsTest.author = '%s' AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow; # DataQualityCosmics_query_flagdef:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE FlagDefs.flagdef = '%s' AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow; # DataQualityCosmicsTest_query_flagdef:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE FlagDefs.flagdef = '%s' AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_subdetector_gtstarttime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND starttime >= %d AND starttime <= %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow; # DataQualityCosmicsTest_query_subdetector_starttime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND starttime >= %d AND starttime <= %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_subdetector_ltendtime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND endtime <= %d AND endtime >= %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow ; # DataQualityCosmicsTest_query_subdetector_endtime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND endtime <= %d AND endtime >= %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_subdetector_starttime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND AND starttime >= %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow; # DataQualityCosmicsTest_query_subdetector_starttime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND starttime >= %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_subdetector_endtime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND endtime <= %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow ; # DataQualityCosmicsTest_query_subdetector_endtime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND AND endtime <= %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_subdetector_flag:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND flag = %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow; # DataQualityCosmicsTest_query_subdetector_flag:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND flag = %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_subdetector_createtime:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND createtime >= %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow ; # DataQualityCosmicsTest_query_subdetector_createtime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND createtime >= %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_subdetector_version:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND Versions.version = '%s' AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow ; # DataQualityCosmicsTest_query_subdetector_version:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND VersionsTest.version = '%s' AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_subdetector_author:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND Authors.author = '%s' AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow; # DataQualityCosmicsTest_query_subdetector_author:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND AuthorsTest.author = '%s' AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_subdetector_interval:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND (((starttime <= %d AND endtime >= %d) OR (starttime >= %d AND endtime <= %d) OR (starttime <= %d AND endtime <= %d) OR (starttime >= %d AND endtime >= %d))) AND starttime < %d AND endtime > %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow; # DataQualityCosmicsTest_query_subdetector_starttime:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND starttime >= %d AND endtime <= %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ; # DataQualityCosmics_query_subdetector_interval2:: SELECT SubDetectors.subdetector, starttime, endtime, flag, createtime, Versions.version, Authors.author, FlagDefs.flagdef, histo, comments FROM DataQualityCosmics, SubDetectors, Versions, Authors, FlagDefs WHERE SubDetectors.subdetector = '%s' AND starttime <= %d AND endtime >= %d AND DataQualityCosmics.subdetectorrow=SubDetectors.subdetectorrow AND DataQualityCosmics.versionrow=Versions.versionrow AND DataQualityCosmics.authorrow=Authors.authorrow AND DataQualityCosmics.flagdefrow=FlagDefs.flagdefrow; # DataQualityCosmicsTest_query_subdetector_starttime2:: SELECT SubDetectorsTest.subdetector, starttime, endtime, flag, createtime, VersionsTest.version, AuthorsTest.author, FlagDefsTest.flagdef, histo, comments FROM DataQualityCosmicsTest, SubDetectorsTest, VersionsTest, AuthorsTest, FlagDefsTest WHERE SubDetectorsTest.subdetector = '%s' AND starttime <= %d AND endtime >= %d AND DataQualityCosmicsTest.subdetectorrow=SubDetectorsTest.subdetectorrow AND DataQualityCosmicsTest.versionrow=VersionsTest.versionrow AND DataQualityCosmicsTest.authorrow=AuthorsTest.authorrow AND DataQualityCosmicsTest.flagdefrow=FlagDefsTest.flagdefrow ;