Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- import datetime
- import pytz
- from tzlocal import get_localzone
- db = sqlite3.connect("tztestings.sqlite", detect_types=sqlite3.PARSE_DECLTYPES)
- db.execute("CREATE TABLE IF NOT EXISTS accounts (name TEXT PRIMARY KEY NOT NULL, balance INTEGER NOT NULL)")
- db.execute("CREATE TABLE IF NOT EXISTS history (time TIMESTAMP NOT NULL, timediff TZINFO,"
- " account TEXT NOT NULL, amount INTEGER NOT NULL, PRIMARY KEY (time, account))")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement