import sqlite3 import sheardata as sd import sys conn = sqlite3.connect(sys.argv[1]) cursor = conn.cursor() cursor.execute("PRAGMA foreign_keys = ON;") flow_class = sd.DUCT_FLOW_CLASS year = 1928 study_number = 1 study_identifier = sd.add_study( cursor, flow_class=flow_class, year=year, study_number=study_number, study_type=sd.EXPERIMENTAL_STUDY_TYPE, ) sd.add_source(cursor, study_identifier, "DaviesSJ+1928+eng+JOUR", 1) sd.add_source(cursor, study_identifier, "DeanRB+1974+eng+RPRT", 2) sd.add_source(cursor, study_identifier, "JonesOC+1976+eng+JOUR", 2) sd.add_source(cursor, study_identifier, "DeanRB+1978+eng+JOUR", 2) # p. 93 # # \begin{quote} # The water under pressure was taken from the mains, with suitable arrangements # to ensure sufficient constancy of flow. The water flowing in a definite time # was weighted. Pressure differences were measured by a simple manometer,
import sqlite3 import sheardata as sd import sys conn = sqlite3.connect(sys.argv[1]) cursor = conn.cursor() cursor.execute("PRAGMA foreign_keys = ON;") flow_class = sd.DUCT_FLOW_CLASS year = 2015 study_number = 1 study_identifier = sd.add_study( cursor, flow_class=flow_class, year=year, study_number=study_number, study_type=sd.DIRECT_NUMERICAL_SIMULATION_STUDY_TYPE, ) sd.add_source(cursor, study_identifier, "TrettelA+2015+eng+THES", 1) sd.add_source(cursor, study_identifier, "TrettelA+2016+eng+JOUR", 1) dynamic_viscosity_note = None with open("../data/{:s}/note_dynamic_viscosity.tex".format(study_identifier), "r") as f: dynamic_viscosity_note = f.read() series_number = 0 globals_filename = "../data/{:s}/globals.csv".format(study_identifier, ) with open(globals_filename, "r") as globals_file: