#
# 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()
