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
