def test_add_ts_entry(self):
create(self.temp_dir)
db = PhilDB(self.temp_dir)
db.add_timeseries('410730')
conn = sqlite3.connect(db._PhilDB__meta_data_db())
c = conn.cursor()
c.execute("SELECT * FROM timeseries;")
pk, primary_id = c.fetchone();
self.assertEqual(primary_id, '410730')
def test_add_measurand_entry(self):
create(self.temp_dir)
db = PhilDB(self.temp_dir)
db.add_measurand('P', 'PRECIPITATION', 'Precipitation')
conn = sqlite3.connect(db._PhilDB__meta_data_db())
c = conn.cursor()
c.execute("SELECT * FROM measurand;")
pk, measurand_short_id, measurand_long_id, measurand_description = c.fetchone();
self.assertEqual(measurand_short_id, 'P')
self.assertEqual(measurand_long_id, 'PRECIPITATION')
self.assertEqual(measurand_description, 'Precipitation')
def test_add_measurand_entry(self):
create(self.temp_dir)
db = PhilDB(self.temp_dir)
db.add_measurand('P', 'PRECIPITATION', 'Precipitation')
conn = sqlite3.connect(db._PhilDB__meta_data_db())
c = conn.cursor()
c.execute("SELECT * FROM measurand;")
pk, measurand_short_id, measurand_long_id, measurand_description = c.fetchone(
)
self.assertEqual(measurand_short_id, 'P')
self.assertEqual(measurand_long_id, 'PRECIPITATION')
self.assertEqual(measurand_description, 'Precipitation')
def test_create_existing_dir(self):
db_name = os.path.join(self.temp_dir)
create(db_name)
db = PhilDB(db_name)
self.assertEqual(os.path.exists(db._PhilDB__meta_data_db()), True)
def test_create_new(self):
db_name = os.path.join(self.temp_dir, 'new_project')
create(db_name)
db = PhilDB(db_name)
self.assertEqual(os.path.exists(db._PhilDB__meta_data_db()), True)
def test_create_existing_dir(self):
db_name = os.path.join(self.temp_dir)
create(db_name)
db = PhilDB(db_name)
self.assertEqual(os.path.exists(db._PhilDB__meta_data_db()), True)
def test_create_new(self):
db_name = os.path.join(self.temp_dir, 'new_project')
create(db_name)
db = PhilDB(db_name)
self.assertEqual(os.path.exists(db._PhilDB__meta_data_db()), True)
