def benchmark_conditions_add(cycles, auto_commit=True):
# Create RCDBProvider object that connects to DB and provide most of the functions
db = RCDBProvider("sqlite:///example.db")
# Create condition type
runs = [db.create_run(1), db.create_run(2)]
ct = db.create_condition_type("my_val", ConditionType.INT_FIELD,
"This is my value")
print("Start {} cycles in benchmark_conditions_add".format(cycles))
# cycle
for i in range(0, cycles):
print_cycle(i, cycles, "benchmark_conditions_add")
db.add_condition(random.choice(runs),
ct,
random.randrange(0, 1000),
replace=True,
auto_commit=auto_commit)
# commit in the end if needed
if not auto_commit:
db.session.commit()
print("Done benchmark_conditions_add")
def benchmark_conditions_add(cycles, auto_commit=True):
# Create RCDBProvider object that connects to DB and provide most of the functions
db = RCDBProvider("sqlite:///example.db")
# Create condition type
runs = [db.create_run(1), db.create_run(2)]
ct = db.create_condition_type("my_val", ConditionType.INT_FIELD, "This is my value")
print ("Start {} cycles in benchmark_conditions_add".format(cycles))
# cycle
for i in range(0, cycles):
print_cycle(i, cycles, "benchmark_conditions_add")
db.add_condition(random.choice(runs), ct, random.randrange(0, 1000),
replace=True, auto_commit=auto_commit)
# commit in the end if needed
if not auto_commit:
db.session.commit()
print ("Done benchmark_conditions_add")
"""
import argparse
import sys
from rcdb import RCDBProvider
from rcdb.model import ConditionType, Run
from rcdb import DefaultConditions
if __name__ == "__main__":
print sys.argv
# 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='?', default="mysql://[email protected]/rcdb")
args = parser.parse_args()
# Open DB connection
db = RCDBProvider(args.connection_string)
# add two conditions type. If they are already exist this function just does nothing
db.create_condition_type(DefaultConditions.RUN_START_TIME, ConditionType.TIME_FIELD, "Run start time by DAQ")
db.create_condition_type(DefaultConditions.RUN_END_TIME, ConditionType.TIME_FIELD, "Run end time by DAQ")
# get all runs
runs = db.get_runs(0, sys.maxint)
for run in runs:
print (run.number)
if run.start_time:
db.add_condition(run, DefaultConditions.RUN_START_TIME, run.start_time)
if run.end_time:
db.add_condition(run, DefaultConditions.RUN_END_TIME, run.end_time)
