Code: Alles auswählen
import sqlite3
import time
class database:
def __init__(self):
con = sqlite3.connect('my.db')
self.c = con.cursor()
def create(self):
self.c.execute("CREATE TABLE `files` (\
id INTEGER PRIMARY KEY,\
name VARCHAR(100),\
hash VARCHAR(100),\
public VARCHAR(3),\
meta VARCHAR(100),\
time INT(15),\
ip VARCHAR(25),\
data TEXT)")
def insert_file(self, name, hash, public, meta, ip, data):
self.c.execute("INSERT INTO files (id, name, hash, public, meta, time, ip, data) VALUES (NULL, '%s', '%s','%s', '%s', '%s', '%s', '%s')"""%(
name, hash, public, meta, time.time(), ip, data))
def get_file(self, name='%%', meta='%%', hash='%%'):
self.c.execute("SELECT * FROM files WHERE `name` LIKE '%s' AND `meta` LIKE '%s' AND `hash` LIKE '%s'; "%(name, meta, hash))
return self.c.fetchall()
#database().create()
print database(). insert_file("lol","lol","lol","lol","lol","lol")
print database().get_file(name='lol')
PS: So etwas wie commit gibt es ja bei SQLite nicht?!