def __init__(self, dbname, db_dir, sql_dir): self.db_dir = db_dir self.sql_dir = sql_dir self.dbpath = os.path.join(db_dir, dbname + '.db') if not os.path.exists(self.dbpath): conn = sqlite3.connect(self.dbpath) cursor = conn.cursor() sql = os.path.join(sql_dir, dbname + '.sql') cursor.executescript(open(sql).read()) conn.commit() cursor.close() conn.close() SqliteDB.__init__(self, db=self.dbpath)
def __init__(self, dbname, db_dir, sql_dir): self.db_dir = db_dir self.sql_dir = sql_dir self.dbpath = os.path.join(db_dir, dbname + '.db') # print self.dbpath if not os.path.exists(self.dbpath): conn = sqlite3.connect(self.dbpath) cursor = conn.cursor() sql = os.path.join(sql_dir, dbname + '.sql') # print sql cursor.executescript(open(sql).read()) conn.commit() cursor.close() conn.close() # print 'create db: %s' % dbname SqliteDB.__init__(self, db=self.dbpath)
def query(self, *args, **kwargs): return unIter(SqliteDB.query(self, *args, **kwargs))
def select(self, *args, **kwargs): return unIter(SqliteDB.select(self, *args, **kwargs))
def __init__(self, dbname): SqliteDB.__init__(self, db=dbname) self.printing = False