# # You should have received a copy of the GNU General Public License along with # this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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.BOUNDARY_LAYER_FLOW_CLASS year = 1940 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, "SchultzGrunowF+1940+deu+JOUR", 1) conn.commit() conn.close()
# this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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.BOUNDARY_LAYER_FLOW_CLASS year = 2010 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, "JimenezJ+2010+eng+JOUR", 1) sd.add_source(cursor, study_identifier, "SilleroJA+2013+eng+JOUR", 1) sd.add_source(cursor, study_identifier, "SilleroJA+2014+eng+JOUR", 1) conn.commit() conn.close()
# # You should have received a copy of the GNU General Public License along with # this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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.EXTERNAL_FLOW_CLASS year = 1929 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, "StantonTE+1929+eng+RPRT", 1) conn.commit() conn.close()
# You should have received a copy of the GNU General Public License along with # this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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 = 1951 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, "SenecalVE+1951+eng+THES", 1) sd.add_source(cursor, study_identifier, "SenecalVE+1953+eng+JOUR", 1) conn.commit() conn.close()
# # You should have received a copy of the GNU General Public License along with # this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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.BOUNDARY_LAYER_FLOW_CLASS year = 2011 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, "PirozzoliS+2011+eng+JOUR", 1 ) conn.commit() conn.close()
cursor = conn.cursor() cursor.execute( "PRAGMA foreign_keys = ON;" ) flow_class = sd.DUCT_FLOW_CLASS year = 1928 study_number = 2 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, "CornishRJ+1928+eng+JOUR", 1 ) sd.add_source( cursor, study_identifier, "JonesOC+1976+eng+JOUR", 2 ) sd.add_source( cursor, study_identifier, "ObotNT+1988+eng+JOUR", 2 ) # p. 691 # # \begin{quote} # The object of the research was to investigate the flow of water in a pipe of # rectangular cross-section. # \end{quote} # p. 692 # # \begin{quote} # The width of the channel ($2 a$) was 1.178 cms., and the depth ($2 b$) was # 0.404 cm. The maximum variation from these average figures was less than 0.5
# # You should have received a copy of the GNU General Public License along with # this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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.EXTERNAL_FLOW_CLASS year = 1971 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, "RoosFW+1971+eng+JOUR", 1) conn.commit() conn.close()
cursor = conn.cursor() cursor.execute("PRAGMA foreign_keys = ON;") flow_class = sd.DUCT_FLOW_CLASS year = 1911 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, "StantonTE+1911+eng+JOUR", 1) sd.add_source(cursor, study_identifier, "KooEC+1932+eng+THES", 2) globals_filename = "../data/{:s}/globals.csv".format(study_identifier) with open(globals_filename, "r") as globals_file: globals_reader = csv.reader( globals_file, delimiter=",", quotechar='"', \ skipinitialspace=True ) next(globals_reader) for globals_row in globals_reader: series_number = int(globals_row[0]) diameter = sd.sdfloat(globals_row[2]) * 1.0e-2 # p. 367 # # \begin{quote} # The arrangement of one of the experimental pipes and the air fan used
# # You should have received a copy of the GNU General Public License along with # this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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.BOUNDARY_LAYER_FLOW_CLASS year = 2010 study_number = 2 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, "SchlatterP+2010+eng+JOUR", 1) conn.commit() conn.close()
# # You should have received a copy of the GNU General Public License along with # this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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.BOUNDARY_LAYER_FLOW_CLASS year = 2018 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, "ZhangC+2018+eng+JOUR", 1) conn.commit() conn.close()
cursor = conn.cursor() cursor.execute("PRAGMA foreign_keys = ON;") flow_class = sd.DUCT_FLOW_CLASS year = 1947 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, "HuebscherRG+1947+eng+JOUR", 1) # Distance between pressure taps # # p. 129 # # \begin{quote} # Static pressure explorations made within the rectangular duct on a single # plane perpendicular to the long axis of the duct disclosed no measureable # variation over the cross-section. A single internal static pressure taken at # the axis of the duct at several locations along the duct length served to # define the static friction pressure gradient. # # It was found that insertion of the tubes into the duct caused sufficient # resistance to decrease the air flow in the round and square ducts. Since # this eeffect was negligible when insertion was less than 2 in. the tubes were
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 = 1932 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, "NikuradseJ+1932+deu+JOUR", 1) sd.add_source(cursor, study_identifier, "NikuradseJ+1933+deu+JOUR", 1) sd.add_source(cursor, study_identifier, "RobertsonJM+1957+eng+CPAPER", 2) sd.add_source(cursor, study_identifier, "LindgrenER+1965+eng+RPRT", 2) sd.add_source(cursor, study_identifier, "BeattieDRH+1995+eng+CPAPER", 2) sd.add_source(cursor, study_identifier, "HagerWH+2008+eng+JOUR", 2) sd.add_source(cursor, study_identifier, "LaVioletteM+2017+eng+JOUR", 2) conn.commit() conn.close()
cursor = conn.cursor() cursor.execute("PRAGMA foreign_keys = ON;") flow_class = sd.DUCT_FLOW_CLASS year = 1914 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, "StantonTE+1914+eng+JOUR", 1) sd.add_source(cursor, study_identifier, "ObotNT+1988+eng+JOUR", 2) class Pipe: diameter = None distance_between_pressure_taps = None material = None # p. 202 # # \begin{quote} # The length of ``leading in'' pipe, of the same diameter as the # experimental portion, through which the fluid passed before any # observations of its velocity or pressure were made, varied from 90 to 140 # diameters, as it was considered that this length was sufficient both to
# You should have received a copy of the GNU General Public License along with # this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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.BOUNDARY_DRIVEN_FLOW_CLASS year = 1956 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, "ReichardtH+1956+deu+JOUR", 1) sd.add_source(cursor, study_identifier, "ReichardtH+1959+deu+RPRT", 1) conn.commit() conn.close()
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: globals_reader = csv.reader( globals_file, delimiter=",", quotechar='"', \ skipinitialspace=True,
# You should have received a copy of the GNU General Public License along with # this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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 = 1956 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, "WhanGA+1956+eng+THES", 1) sd.add_source(cursor, study_identifier, "WhanGA+1959+eng+JOUR", 1) conn.commit() conn.close()
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, # employing either mercury or water as a fluid according to the range of # pressure. # \end{quote} mt_flow_rate = sd.MT_WEIGHING_METHOD mt_wall_shear_stress = sd.MT_MOMENTUM_BALANCE
# # You should have received a copy of the GNU General Public License along with # this file. If not, see <https://www.gnu.org/licenses/>. import csv import math 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 = 2 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, "LeeM+2015+eng+JOUR", 1) conn.commit() conn.close()