File size: 561 Bytes
57c4258 2d31646 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
import sqlite3
from sqlite3 import Error
class Database:
def __init__(self, db_path='data/database.sqlite'):
self.db_path = db_path
def execute_query(self, query):
try:
conn = sqlite3.connect(self.db_path)
cursor = conn.cursor()
cursor.execute(query)
results = cursor.fetchall()
columns = [desc[0] for desc in cursor.description]
conn.close()
return {"columns": columns, "data": results}
except Error as e:
return {"error": str(e)} |