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:
