import threading import sqlite3 class Database: def __init__(self): self.conn = None self.connect() def update(self): self.conn.comit() self.cursor = self.conn.cursor() def verify(self): cursor = self.conn.cursor() try: cursor.execute("SELECT * FROM messages") except sqlite3.Error as e: self.setup() def setup(self): pass def getMessages(self): cursor = self.conn.cursor() cursor.execute("SELECT * FROM messages") return cursor.fetchall() def connect(self): self.conn = None self.error = [] try: self.conn = sqlite3.connect("%s.db" % self.db_name) except sqlite3.Error as e: self.conn = None self.error.append("SQLite Error #~ %s" % e) return False if self.verify(): self.setup return True db = Database()
Run
Reset
Share
Import
Link
Embed
Language▼
English
中文
Python Fiddle
Python Cloud IDE
Follow @python_fiddle
Browser Version Not Supported
Due to Python Fiddle's reliance on advanced JavaScript techniques, older browsers might have problems running it correctly. Please download the latest version of your favourite browser.
Chrome 10+
Firefox 4+
Safari 5+
IE 10+
Let me try anyway!
url:
Go
Python Snippet
Stackoverflow Question
