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 __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, 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()