XApqFq9s

1#!/usr/bin/env python3
2
3import uuid, time
4import sqlite3 as db_api
5DB_DSN = 'log.sqlite'
6
7#import psycopg as db_api
8#DB_DSN = 'host=xxx user=xxx'
9
10db = db_api.connect(DB_DSN)
11
12cur = db.cursor()
13cur.execute('''
14        CREATE TABLE IF NOT EXISTS items (
15            uuid VARCHAR(80) PRIMARY KEY,
16            timestamp INTEGER NOT NULL
17        )
18''')
19db.commit()
20
21an_id = str(uuid.uuid4())
22a_time = time.time()
23cur.execute('''
24            INSERT INTO items(uuid,timestamp) 
25            VALUES (?,?)''',
26            [an_id, a_time])
27db.commit()
28
29cur.execute('''SELECT timestamp,uuid FROM items
30            ORDER BY timestamp LIMIT 1''')
31print(cur.fetchone())