search

ole1986 / centronic-py

Centronic USB Stick to control Becker Shutter CC31/CC51
43 stars 10 forks source link

Implement sqllite #3

Closed ole1986 closed 4 years ago

ole1986 commented 4 years ago

Example code:

import os
import time
import sqlite3

sqldb = 'centronic-py.db'

if not os.path.isfile(sqldb):
    conn = sqlite3.connect(sqldb)
    c = conn.cursor()
    c.execute('CREATE TABLE channel (number INTEGER(1), increment INTEGER(4), executed INTEGER)')
    conn.commit()
else:
    conn = sqlite3.connect(sqldb)
    c = conn.cursor()

result = c.execute('SELECT * FROM channel')

print result.fetchall()
conn.close()