def create(cls, content, news_id, author_id):
sql = '''insert into {}(content, news_id, author_id, create_time)
values(%s, %s, %s, %s)
'''.format(cls.__table__)
params = (content, news_id, author_id, now())
try:
store.execute(sql, params)
_id = store.commit()
except e:
print "Error", e.args[0], e.args[1]
store.rollback()
return cls.get(_id) if _id else None
def create(cls, username, passwd, nickname, gender, birthday, avatar_url):
salt = ''.join(random.sample(string.ascii_letters, 6))
passwd = md5.new(passwd + salt).hexdigest()
sql = '''insert into {}(username, passwd, nickname, salt, gender, birthday, avatar_url, register_time)
values(%s, %s ,%s, %s, %s, %s, %s, %s)'''.format(cls.__table__)
params = (username, passwd, nickname, salt, gender, birthday, avatar_url, now())
try:
store.execute(sql, params)
_id = store.commit()
except e:
print "Error", e.args[0], e.args[1]
store.rollback()
print _id
return cls.get(_id) if _id else None
