def test_cz2010_station_metadata_table_count():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(""" select count(*) from cz2010_station_metadata """)
(count, ) = cur.fetchone()
assert count == 86
def test_iecc_moisture_regime_metadata_table_count():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(''' select count(*) from iecc_moisture_regime_metadata ''')
(count,) = cur.fetchone()
assert count == 3
def test_isd_station_metadata_table_count(snapshot):
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(""" select count(*) from isd_station_metadata """)
(count, ) = cur.fetchone()
snapshot.assert_match(count, "count")
def test_ca_climate_zone_metadata_table_count():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(""" select count(*) from ca_climate_zone_metadata """)
(count, ) = cur.fetchone()
assert count == 16
def test_isd_file_metadata_table_count(snapshot):
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(''' select count(*) from isd_file_metadata ''')
(count,) = cur.fetchone()
snapshot.assert_match(count, 'count')
def test_zcta_metadata_table_count():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(''' select count(*) from zcta_metadata ''')
(count,) = cur.fetchone()
assert count == 33144
def test_isd_station_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(
""" select * from isd_station_metadata where quality='high' limit 1 """
)
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {
"ba_climate_zone": "Hot-Dry",
"ca_climate_zone": "CA_14",
"elevation": "+0625.1",
"icao_code": "KNXP",
"iecc_climate_zone": "3",
"iecc_moisture_regime": "B",
"latitude": "+34.300",
"longitude": "-116.167",
"name": "TWENTY NINE PALMS",
"quality": "high",
"recent_wban_id": "93121",
"state": "CA",
"usaf_id": "690150",
"wban_ids": "93121,99999",
}
def test_cz2010_station_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(""" select * from cz2010_station_metadata limit 1""")
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {"usaf_id": "690150"}
def test_isd_file_metadata_table_content(snapshot):
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(""" select * from isd_file_metadata limit 1""")
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
snapshot.assert_match(data, "data")
def test_isd_file_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(''' select * from isd_file_metadata limit 1''')
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {'usaf_id': '407330', 'wban_id': '99999', 'year': '2007'}
def test_ba_climate_zone_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(''' select ba_climate_zone from ba_climate_zone_metadata limit 1''')
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {'ba_climate_zone': 'Cold'}
def test_iecc_moisture_regime_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(''' select iecc_moisture_regime from iecc_moisture_regime_metadata limit 1''')
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {'iecc_moisture_regime': 'A'}
def test_isd_file_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(""" select * from isd_file_metadata limit 1""")
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {"usaf_id": "407330", "wban_id": "99999", "year": "2007"}
def test_iecc_climate_zone_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(
""" select iecc_climate_zone from iecc_climate_zone_metadata limit 1"""
)
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {"iecc_climate_zone": "1"}
def test_ca_climate_zone_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(
""" select ca_climate_zone, name from ca_climate_zone_metadata limit 1"""
)
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {"ca_climate_zone": "CA_01", "name": "Arcata"}
def test_tmy3_station_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(''' select * from tmy3_station_metadata limit 1''')
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {
'class': 'I',
'name': 'Twentynine Palms',
'state': 'CA',
'usaf_id': '690150',
}
def test_tmy3_station_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(""" select * from tmy3_station_metadata limit 1""")
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {
"class": "I",
"name": "Twentynine Palms",
"state": "CA",
"usaf_id": "690150",
}
def test_database_tables():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(''' select name from sqlite_master where type='table' ''')
tables = [name for (name,) in cur.fetchall()]
assert tables == [
'isd_station_metadata',
'isd_file_metadata',
'zcta_metadata',
'iecc_climate_zone_metadata',
'iecc_moisture_regime_metadata',
'ba_climate_zone_metadata',
'ca_climate_zone_metadata',
'tmy3_station_metadata',
'cz2010_station_metadata',
]
def test_zcta_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(''' select * from zcta_metadata limit 1''')
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {
'ba_climate_zone': 'Hot-Humid',
'ca_climate_zone': None,
'geometry': None,
'iecc_climate_zone': '1',
'iecc_moisture_regime': 'A',
'latitude': '18.1800455429617',
'longitude': '-66.752178136408',
'state': 'PR',
'zcta_id': '00601'
}
def test_zcta_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(""" select * from zcta_metadata limit 1""")
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {
"ba_climate_zone": "Hot-Humid",
"ca_climate_zone": None,
"geometry": None,
"iecc_climate_zone": "1",
"iecc_moisture_regime": "A",
"latitude": "18.1800455429617",
"longitude": "-66.752178136408",
"state": "PR",
"zcta_id": "00601",
}
def test_isd_station_metadata_table_content():
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
cur.execute(''' select * from isd_station_metadata where quality='high' limit 1 ''')
row = cur.fetchone()
data = {desc[0]: value for value, desc in zip(row, cur.description)}
assert data == {
'ba_climate_zone': 'Hot-Dry',
'ca_climate_zone': 'CA_14',
'elevation': '+0625.1',
'icao_code': 'KNXP',
'iecc_climate_zone': '3',
'iecc_moisture_regime': 'B',
'latitude': '+34.300',
'longitude': '-116.167',
'name': 'TWENTY NINE PALMS',
'quality': 'high',
'recent_wban_id': '93121',
'state': 'CA',
'usaf_id': '690150',
'wban_ids': '93121,99999'
}
