class UserDAO(object): __database = None __cursor = None def __init__(self): self.__database = Access() self.__cursor = self.__database.getCursor() self.initDatabase() def initDatabase(self): try: self.__cursor.execute(""" create table user (name text, username text, password text) """) self.__database.commit() except: pass def insert(self, user): if len(self.getUser(user.getUsername())) == 0: users = [(user.getName(), user.getUsername() , user.getPassword()), ] self.__cursor.executemany("INSERT INTO user VALUES (?,?,?)", users) self.__database.commit() def update(self, user): users = [(user.getName(),user.getPassword(), user.getUsername())] self.__cursor.executemany("UPDATE user SET name = ?, password = ? where username = ? ", users) self.__database.commit() def delete(self, username): self.__cursor.execute("DELETE FROM user WHERE username = "******"SELECT * FROM user") print self.__cursor.fetchall() def getUser(self, username): self.__cursor.execute("SELECT * FROM user WHERE username = ?",[(username)] ) return self.__cursor.fetchall() def log(self, user, request): flines = user.toString() + " >>> " + request + "\n" f = open(log, 'a') f.writelines([flines,]) f.close()