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, )