Sqlite WAL test

sqlite3_wal_test.py

import time
from playhouse.sqlite_ext import SqliteExtDatabase

sqlite_db = SqliteExtDatabase('my_app.db', journal_mode="WAL", autocommit=False)
with sqlite_db.transaction() as cursor:
    cursor = sqlite_db.execute_sql("""CREATE TABLE server_status (
                        id INTEGER PRIMARY KEY,
                        time_created INT);""")
    assert cursor.rowcount == -1

n = 10000000
bulk = range(n)
SQL = "INSERT INTO server_status(time_created) VALUES " + ",".join(map(lambda x: "(%d)" % x, bulk))
while True:
    with sqlite_db.transaction() as cursor:
        ret = sqlite_db.execute_sql(SQL)
        assert ret.rowcount == n
    time.sleep(.1)