def __init__(self, sess, name=None, filename=None):
SqlConnection.__init__(self, sess)
#self._isTemporary = isTemporary
self._mtime = 0.0
self._filename = filename
if name is None:
name = sess.name
if name is None:
name = sess.__class__.__name__
if len(sess._connections):
name += str(len(sess._connections) + 1)
self.name = name
if filename is None:
# assert isTemporary
filename = ":memory:"
elif os.path.exists(filename):
self._mtime = os.stat(filename).st_mtime
self._status = self.CST_OPENED
self._dbconn = QtSql.QSqlDatabase.addDatabase("QSQLITE", self.name)
self._dbconn.setDatabaseName(filename)
_qtapp.processEvents()
if not self._dbconn.open():
raise DatabaseError(filename + ":" +
str(self._dbconn.lastError().text()))
def __init__(self,sess,name=None,filename=None):
SqlConnection.__init__(self,sess)
#self._isTemporary = isTemporary
self._mtime = 0.0
self._filename = filename
if name is None:
name=sess.name
if name is None:
name=sess.__class__.__name__
if len(sess._connections):
name+=str(len(sess._connections)+1)
self.name=name
if filename is None:
# assert isTemporary
filename=":memory:"
elif os.path.exists(filename):
self._mtime = os.stat(filename).st_mtime
self._status = self.CST_OPENED
self._dbconn=QtSql.QSqlDatabase.addDatabase("QSQLITE",self.name)
self._dbconn.setDatabaseName(filename)
_qtapp.processEvents()
if not self._dbconn.open():
raise DatabaseError(filename+":"+str(self._dbconn.lastError().text()))
def __init__(self,filename=None):
self.threadLock = threading.Lock()
SqlConnection.__init__(self)
self.dbapi = sqlite
#self._isTemporary = isTemporary
self._mtime = 0.0
self._filename = filename
if filename is None:
# assert isTemporary
filename=":memory:"
elif os.path.exists(filename):
self._mtime = os.stat(filename).st_mtime
self._status = self.CST_OPENED
try:
self._dbconn = sqlite.connect(filename,
check_same_thread=False)
self._dbconn.create_function("month",1,month)
self._dbconn.create_function("year",1,year)
self._dbconn.create_function("day",1,day)
except sqlite.DatabaseError,e:
raise DatabaseError(filename + ":" +str(e))
def executeCreateTable(self,table):
try:
self.sql_exec("DROP TABLE %s" % table.getName())
except odbc.DatabaseError:
pass
SqlConnection.executeCreateTable(self,table)
def executeCreateTable(self, table):
try:
self.sql_exec("DROP TABLE %s" % table.getName())
except odbc.DatabaseError:
pass
SqlConnection.executeCreateTable(self, table)
def __init__(self, ui, dbname="temp", dbdir=r"c:\temp\gadflydb"):
SqlConnection.__init__(self, ui)
#self.dbapi = gadfly
#self._isTemporary = isTemporary
self._mtime = 0.0
self._dbname = dbname
self._dbdir = dbdir
try:
self._dbconn = gadfly.gadfly(dbname, dbdir)
self._mtime = 0
self._status = self.CST_OPENED
except gadfly.Error, e:
self._dbconn = gadfly.gadfly()
self._dbconn.startup(dbname, dbdir)
def __init__(self,ui,dbname="temp",
dbdir=r"c:\temp\gadflydb"):
SqlConnection.__init__(self,ui)
#self.dbapi = gadfly
#self._isTemporary = isTemporary
self._mtime = 0.0
self._dbname = dbname
self._dbdir=dbdir
try:
self._dbconn=gadfly.gadfly(dbname,dbdir)
self._mtime = 0
self._status = self.CST_OPENED
except gadfly.Error,e:
self._dbconn = gadfly.gadfly()
self._dbconn.startup(dbname,dbdir)
def __init__(self,
ui,
filename=None,
dsn=None,
host=None,
user="******",
pwd="masterkey"):
SqlConnection.__init__(self, ui)
self.dbapi = kinterbasdb
self._user = user
self._pwd = pwd
if dsn is not None:
assert host is None
assert filename is None
host, filename = dsn.split(':', 1)
self._host = host
if filename is None:
self._filename = r"c:\temp\tmp.fdb"
self._host = "localhost"
if os.path.exists(self._filename):
os.remove(self._filename)
else:
self._filename = filename
if os.path.exists(filename):
self._mtime = os.stat(filename).st_mtime
self._status = self.CST_OPENED
self._dbconn = kinterbasdb.connect(host=self._host,
database=filename,
user=self._user,
password=self._pwd)
self.setup_connection()
return
self._mtime = 0.0
self._dbconn = kinterbasdb.create_database(
"create database '%s:%s' user '%s' password '%s'" %
(self._host, self._filename, self._user, self._pwd))
self.setup_connection()
def __init__(self,ui,
filename=None, dsn=None, host=None,
user="******",pwd="masterkey"):
SqlConnection.__init__(self,ui)
self.dbapi = kinterbasdb
self._user=user
self._pwd=pwd
if dsn is not None:
assert host is None
assert filename is None
host,filename=dsn.split(':',1)
self._host=host
if filename is None:
self._filename=r"c:\temp\tmp.fdb"
self._host="localhost"
if os.path.exists(self._filename):
os.remove(self._filename)
else:
self._filename = filename
if os.path.exists(filename):
self._mtime = os.stat(filename).st_mtime
self._status = self.CST_OPENED
self._dbconn = kinterbasdb.connect(
host=self._host,
database=filename,
user=self._user,
password=self._pwd)
self.setup_connection()
return
self._mtime = 0.0
self._dbconn = kinterbasdb.create_database(
"create database '%s:%s' user '%s' password '%s'" % (
self._host,self._filename,
self._user,self._pwd))
self.setup_connection()
