def connect(self):
try:
self.handle = SQLiteHandle(self, sqlite3.connect(self.filename))
except:
self.connected = False
if self.msg_log:
self.msg_log("%s: %s" % (sys.exc_type, sys.exc_value))
return
self.current_db = SQLiteDb(self, "dummydb")
self.databases = {"dummydb": self.current_db}
self.connected = True
self.refresh()
def connect(self):
try:
self.handle = SQLiteHandle(self, sqlite3.connect(self.filename))
except:
self.connected = False
if self.msg_log:
self.msg_log("%s: %s" % (sys.exc_type, sys.exc_value))
return
self.current_db = SQLiteDb(self, "dummydb")
self.databases = {"dummydb": self.current_db}
self.connected = True
self.refresh()
class SQLiteHost():
def __init__(self, sql_log, msg_log, filename, *args):
self.sql_log, self.msg_log, self.filename = sql_log, msg_log, filename
self.name = self.filename
self.host = "localhost"
self.user = os.getenv("USER")
self.charset = "utf8"
self.connected = False
self.expanded = False
self.handle = None
self.current_db = None
self.databases = {}
self.processlist = None
self.update_ui = None
self.last_error = ""
self.query_time = 0
self.update_ui_args = None
def get_connection_string(self):
return "::sqlite::"
def set_update_ui(self, update_ui, *args):
self.update_ui = update_ui
self.update_ui_args = args
def connect(self):
try:
self.handle = SQLiteHandle(self, sqlite3.connect(self.filename))
except:
self.connected = False
if self.msg_log:
self.msg_log("%s: %s" % (sys.exc_type, sys.exc_value))
return
self.current_db = SQLiteDb(self, "dummydb")
self.databases = {"dummydb": self.current_db}
self.connected = True
self.refresh()
def ping(self):
return True
def close(self):
self.databases = {}
self.processlist = None
if self.handle:
self.handle.close()
self.handle = None
self.connected = False
if self.update_ui:
self.update_ui(self, *self.update_ui_args)
def query(self, query, check_use=True, append_to_log=True, encoding=None):
if not self.handle:
if self.msg_log:
self.msg_log("not connected! can't execute %s, %s, %s" %
(query, str(self.handle), str(self)))
return False
if append_to_log:
if self.sql_log:
self.sql_log(query)
try:
self.query_time = 0
start = time.time()
if encoding:
query = query.encode(encoding, "ignore")
#print "executing query (encoding: %s): %r" % (encoding, query)
self.handle.execute(query)
self.query_time = time.time() - start
except:
print "error executing query:\n%s" % traceback.format_exc()
s = str(sys.exc_value)
self.last_error = s
if self.msg_log:
self.msg_log(s)
return False
return True
def query_dict(self,
query,
check_use=False,
append_to_log=True,
encoding=None):
if self.query(query, check_use, append_to_log, encoding):
return result2hash(self.handle)
def use_db(self, name, do_query=True):
pass
def select_database(self, db):
pass
def refresh(self):
pass
def refresh_processlist(self):
pass
def insert_id(self):
raise Exception("todo") # return self.handle.insert_id()
def escape(self, s):
return repr(s)[1:-1]
def escape_field(self, field):
return field
def escape_table(self, table):
return table
class SQLiteHost:
"""
@param sql_log:
@param msg_log:
@param filename: str
@param args: []
"""
def __init__(self, sql_log, msg_log, filename, *args):
self.sql_log, self.msg_log, self.filename = sql_log, msg_log, filename
self.name = self.filename
self.host = "localhost"
self.user = os.getenv("USER")
self.charset = "utf8"
self.connected = False
self.expanded = False
self.handle = None
self.current_db = None
self.databases = {}
self.processlist = None
self.update_ui = None
self.last_error = ""
self.query_time = 0
self.update_ui_args = None
def get_connection_string(self):
"""
@return: str
"""
return "::sqlite::"
def set_update_ui(self, update_ui, *args):
self.update_ui = update_ui
self.update_ui_args = args
def connect(self):
try:
self.handle = SQLiteHandle(self, sqlite3.connect(self.filename))
except:
self.connected = False
if self.msg_log:
self.msg_log("%s: %s" % (sys.exc_type, sys.exc_value))
return
self.current_db = SQLiteDb(self, "dummydb")
self.databases = {"dummydb": self.current_db}
self.connected = True
self.refresh()
def ping(self):
return True
def close(self):
self.databases = {}
self.processlist = None
if self.handle:
self.handle.close()
self.handle = None
self.connected = False
if self.update_ui:
self.update_ui(self, *self.update_ui_args)
def query(self, query, check_use=True, append_to_log=True, encoding=None):
if not self.handle:
if self.msg_log:
self.msg_log("not connected! can't execute %s, %s, %s" %
(query, str(self.handle), str(self)))
return False
if append_to_log:
if self.sql_log:
self.sql_log(query)
try:
self.query_time = 0
start = time.time()
if encoding:
query = query.encode(encoding, "ignore")
# print "executing query (encoding: %s): %r" % (encoding, query)
self.handle.execute(query)
self.query_time = time.time() - start
except:
# print "error executing query:\n%s" % traceback.format_exc()
s = str(sys.exc_value)
self.last_error = s
if self.msg_log:
self.msg_log(s)
return False
return True
def query_dict(self, query, check_use=False, append_to_log=True, encoding=None):
if self.query(query, check_use, append_to_log, encoding):
return result2hash(self.handle)
def use_db(self, name, do_query=True):
pass
def select_database(self, db):
pass
def refresh(self):
pass
def refresh_processlist(self):
pass
def insert_id(self):
raise Exception("todo") # return self.handle.insert_id()
def escape(self, s):
return repr(s)[1:-1]
def escape_field(self, field):
return field
def escape_table(self, table):
return table
