def insertSql(self, sql): connect = self._createDatabase() framelog().debug("执行SQLite语句 %s" %sql) try: inId = connect.execute(sql) connect.commit() connect.close() return inId.lastrowid except Exception, e: framelog().error(e)
def _createDatabase(self): try: conn = sqlite3.connect(self.DB_FILE) conn.cursor() conn.execute(self.CREATE_COUNT_SQL) conn.execute(self.CREATE_DETAIL_SQL) conn.commit() return conn except Exception, e: framelog().error(e)
def selectSql(self, sql): connect = self._createDatabase() framelog().debug("执行SQLite语句 %s" %sql) try: action = connect.execute(sql) connect.commit() if action: re = action.fetchall() else: framelog().warning("执行语句没有结果返回") connect.close() return re except Exception, e: framelog().error(e)
def createPassword(self, length): password = ''.join( random.sample(self.LETTERS + self.NUMBER + self.LETTERSBIG, length)) framelog().debug(u'create password 【%s】' % password) return password
def createEmail(self, length, suffix="163.com"): email_name = random.sample(self.LETTERS + self.NUMBER, length) email = ''.join(email_name) + "@" + suffix framelog().debug(u'create Email 【%s】' % email) return email
def createPassword(self,length): password = ''.join(random.sample(self.LETTERS+self.NUMBER+self.LETTERSBIG, length)) framelog().debug(u'create password 【%s】' % password) return password
def createEmail(self, length, suffix="163.com"): email_name = random.sample(self.LETTERS+self.NUMBER, length) email = ''.join(email_name) + "@" + suffix framelog().debug(u'create Email 【%s】' % email) return email