def init_db(sqlite_conn, data_factory, dates):
sqlite_conn.executescript(SCHEMA_SQL)
import_dates(sqlite_conn, dates)
practice_codes = _get_active_practice_codes(data_factory, dates)
sqlite_conn.executemany(
"INSERT INTO practice (offset, code) VALUES (?, ?)", enumerate(practice_codes)
)
def test_generate_filename(self):
filename = os.path.join(self.tempdir, "test.sqlite")
connection = sqlite3.connect(filename)
connection.executescript(SCHEMA_SQL)
import_dates(connection, generate_dates("2018-10-01"))
connection.commit()
connection.close()
last_modified = time.mktime(
datetime.datetime(2018, 12, 6, 15, 5, 3).timetuple())
os.utime(filename, (last_modified, last_modified))
new_filename = generate_filename(filename)
self.assertRegex(
new_filename,
"matrixstore_2018-10_2018-12-06--15-05_[a-f0-9]{16}\.sqlite")
def init_db(sqlite_conn, data_factory, dates):
sqlite_conn.executescript(SCHEMA_SQL)
import_dates(sqlite_conn, dates)
practice_codes = _get_active_practice_codes(data_factory, dates)
sqlite_conn.executemany(
"INSERT INTO practice (offset, code) VALUES (?, ?)",
enumerate(practice_codes))
presentations = ((p["bnf_code"], p["is_generic"], p["adq_per_quantity"],
p["name"]) for p in data_factory.presentations)
sqlite_conn.executemany(
"""
INSERT INTO presentation
(bnf_code, is_generic, adq_per_quantity, name)
VALUES (?, ?, ?, ?)
""",
presentations,
)