if __name__ == "__main__":
# Get connection string from arguments
parser = argparse.ArgumentParser(description="This example shows select runs and put them by dates")
parser.add_argument("connection_string",
nargs='?',
help="RCDB connection string mysql://rcdb@localhost/rcdb",
default="mysql://[email protected]/rcdb")
args = parser.parse_args()
# Open DB connection
db = RCDBProvider(args.connection_string)
# Get runs from run period
run_min, run_max, description = run_periods["2016-02"]
print("Selecting runs {}-{} from run period: '{}'".format(run_min, run_max, description))
# print resulting array
# sql = text('SELECT * FROM runs WHERE number > :run')
# sql.bindparams(run_number=30000)
# result = db.session.connection().execute(sql, run=31000)
# for row in result:
# print row
result = db.select_values(['event_count', 'daq_run', 'beam_energy', 'beam_current'], "@is_production", 30000)
print (result.performance)
for row in result:
print (row)
if __name__ == "__main__":
print sys.argv
# Get connection string from arguments
parser = argparse.ArgumentParser(
description=
"This example shows basics of how to select runs using search queries")
parser.add_argument(
"connection_string",
help="RCDB connection string mysql://rcdb@localhost/rcdb",
nargs='?',
default='mysql://[email protected]/rcdb')
args = parser.parse_args()
# Open DB connection
db = RCDBProvider(args.connection_string)
# Select production runs with event_count > 0.5M
result = db.select_values(
["event_count", "polarization_direction", "beam_current"],
"@is_production and event_count > 500000", 10000, 20000)
# print title
print("{:>7} {:>15} {:>15} {:>15}".format('run', 'polarization_direction',
'beam_current', 'event_count'))
# Iterate through results
for row in result:
run, event_count, polarization_direction, beam_current = tuple(row)
print("{:>7} {:>15} {:>15} {:>15}".format(run, polarization_direction,
beam_current, event_count))
