本文整理汇总了Python中MySQL.MySQL.save方法的典型用法代码示例。如果您正苦于以下问题:Python MySQL.save方法的具体用法?Python MySQL.save怎么用?Python MySQL.save使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类MySQL.MySQL
的用法示例。
在下文中一共展示了MySQL.save方法的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: user_auth
# 需要导入模块: from MySQL import MySQL [as 别名]
# 或者: from MySQL.MySQL import save [as 别名]
def user_auth(data):
db = MySQL()
userId = None
isNewUser = None
validate = db.get("SELECT * FROM `validate` WHERE `mobile`=%s and `device` = %s ORDER BY `valid_date` desc", (data['Id'], data['Device']))
if validate and (validate['code'] == data['Validate'] or '147258369' == data['Validate'] or '0147258369' == data['Validate']): # 需要验证下时间,目前后门验证码为:0147258369
#
# 手机号+验证码 登录
#
user = db.get("SELECT * FROM `user` WHERE `mobile`=%s",(data['Id']))
userId = Utils.UUID() if not user else user['id']
isNewUser = True if not user else False
if isNewUser:
# New user
# TODO: 是否需要生成默认用户名和密码?
result = db.save("INSERT INTO `user` (`id`, `mobile`) VALUES (%s,%s)", (userId, data['Id']))
db.end()
# 关联新用户数据
db.save("UPDATE `share` SET `to_user_id` = %s WHERE `to_mobile` = %s AND `to_user_id` IS NULL", (userId, data['Id']))
db.end()
else:
#
# 通过 用户名/邮箱 + 密码 方式登录
#
user = db.get("SELECT * FROM `user` WHERE (`login`=%s or `email`=%s) and password = %s",
(data['Id'], data['Id'], Utils.MD5(data['Validate'])))
if user:
userId = user['id']
isNewUser = False
else:
raise Exception("验证信息不存在或验证码错误.")
#
# create session
#
sessionId = Utils.UUID()
valid_date = datetime.now() + timedelta(days=300) # 默认登录验证有效期300天
# clear old session
db.delete("DELETE FROM `session` WHERE `user_id`=%s and `device` = %s", (userId, data['Device']))
db.end()
# insert new session
result = db.save("""INSERT INTO `session` (`id`, `user_id`, `device`, `valid_time`) VALUES (%s,%s,%s,%s)"""
, (sessionId, userId, data['Device'], valid_date.strftime('%Y-%m-%d %H:%M:%S')))
db.end()
return {
'UserKey' : sessionId,
'NewUser' : isNewUser,
'ValidityDate' : valid_date
}
示例2: create
# 需要导入模块: from MySQL import MySQL [as 别名]
# 或者: from MySQL.MySQL import save [as 别名]
def create(toUserId, notifyContent, sender=None, refId=None):
notifyId = Utils.UUID()
db = MySQL()
db.save("INSERT INTO `user_notify` (`id`,`user_id`,`notify`,`sender`,`ref_id`) VALUES (%s,%s,%s,%s,%s)", (notifyId, toUserId, notifyContent, sender, refId))
db.end()
try:
NotifyTCPServer.notify_server_has_new(toUserId)
except Exception as e:
print "Error: %s" % e
return notifyId
示例3: get
# 需要导入模块: from MySQL import MySQL [as 别名]
# 或者: from MySQL.MySQL import save [as 别名]
def get(self, numStr):
num = NumberCodec.decode(numStr)
db = MySQL()
# first find
urlInstance = db.get(r"SELECT * FROM `short_urls` WHERE `id`=%s", num)
if urlInstance:
self.redirect(urlInstance['url'])
# log
db.save(r"INSERT INTO `short_urls_log` (`url_id`) VALUES (%s)", (num))
db.end()
else:
raise tornado.web.HTTPError(404)
示例4: invite_code
# 需要导入模块: from MySQL import MySQL [as 别名]
# 或者: from MySQL.MySQL import save [as 别名]
def invite_code(data):
userId = UserService.user_id(data['UserKey'])
db = MySQL()
code = Utils.UUID()
result = db.save("INSERT INTO `invite` (`id`, `user_id`, `type`, `refer_id`, `info`) VALUES (%s,%s,%s,%s,%s)",
(code, userId, data.get('Type', None), data.get('ReferId', None), data.get('Info', None)))
db.end()
return {
'Code': code,
}
示例5: share_video
# 需要导入模块: from MySQL import MySQL [as 别名]
# 或者: from MySQL.MySQL import save [as 别名]
def share_video(data):
"""
分享视频
方法:
share_video
参数:
UserKey[string] –用户登录后的会话ID。
VID[string] – 分配的视频ID
To[Array] – 分享对象列表,分享对象如下定义:
Mobile[string] – 分享手机号,必填
Name[string] – 分享姓名,可选
返回值:
sessionId[string] – 分配的分享会话ID
Results[Array] – 分享结果对象列表,分享结果对象如下定义:
Mobile[string] – 分享手机号
Signup[boolean] – 是否注册用户
"""
userId = UserService.user_id(data['UserKey'])
db = MySQL()
videoInstance = db.get('SELECT * FROM `video` WHERE `id` = %s', (data['VID']))
if not videoInstance:
raise Exception("视频不存在.")
sessionId = Utils.UUID()
results = []
for to in data.get('To', ()):
toUserId = UserService.getUserIdByMobile(to.get('Mobile'))
result = db.save("""INSERT INTO `share` (`session_id`,`owner_id`,`video_id`,`to_user_id`,`to_mobile`,`to_name`) VALUES (%s,%s,%s,%s,%s,%s)"""
, (sessionId, userId, data['VID'], toUserId, to.get('Mobile'), to.get('Name')))
db.end()
if toUserId:
# create app notify
NotifyService.create(toUserId, Utils.json_dumps({
'Type' : 'share_video',
'From' : UserService.user_mobile(userId),
'To' : to.get('Mobile'),
'Date' : datetime.now(),
'VID' : data['VID'],
}), sender = 'share_video', refId = sessionId)
if result:
results.append({
'Mobile': to.get('Mobile'),
'Signup': toUserId != None
})
return {'SessionId': sessionId, 'Results': results}
示例6: user_validate
# 需要导入模块: from MySQL import MySQL [as 别名]
# 或者: from MySQL.MySQL import save [as 别名]
def user_validate(data):
db = MySQL()
code = str(randint(10000,99999))
valid_date = datetime.now() + timedelta(seconds=180)
#
# TODO: 发送短信到 data['Mobile'] , 验证码为 code, 过期时间 90秒
#
result = db.save("INSERT INTO `validate` (`mobile`, `code`, `device`, `valid_date`) VALUES (%s,%s,%s,%s)",
(data['Mobile'], code, data['Device'], valid_date.strftime('%Y-%m-%d %H:%M:%S')))
db.end()
return valid_date
示例7: createShortUrl
# 需要导入模块: from MySQL import MySQL [as 别名]
# 或者: from MySQL.MySQL import save [as 别名]
def createShortUrl(url):
urlId = 0
db = MySQL()
urlhash = Utils.MD5(url)
# first find
urlInstance = db.get(r"SELECT * FROM `short_urls` WHERE `hash`=%s", urlhash)
if urlInstance:
urlId = urlInstance['id']
# create if don't found
if urlId == 0:
result = db.save(r"INSERT INTO `short_urls` (`hash`, `url`) VALUES (%s,%s)", (urlhash, url))
urlId = db.getInsertId()
db.end()
return __short_url_prefix + NumberCodec.encode(urlId)
示例8: space_create
# 需要导入模块: from MySQL import MySQL [as 别名]
# 或者: from MySQL.MySQL import save [as 别名]
def space_create(data):
userId = UserService.user_id(data['UserKey'])
db = MySQL()
spaceId = Utils.UUID()
result = db.save("INSERT INTO `space` (`id`, `user_id`, `name`) VALUES (%s,%s,%s)",
(spaceId, userId, data.get('Name', '')))
db.end()
space_reindex({
'UserKey': data['UserKey'],
'Id': spaceId,
'After': data.get('After', ''),
})
return {
'Id': spaceId,
'Name': data.get('Name', '')
}
示例9: video_create
# 需要导入模块: from MySQL import MySQL [as 别名]
# 或者: from MySQL.MySQL import save [as 别名]
def video_create(data):
"""
设置视频信息
方法:
video_create
参数:
UserKey[string] –用户登录后的会话ID。
UploadId[string] – 分配的上传会话ID
Title[string] – 视频标题
Author[string] – 分享者/创作者名称
CreateTime[date] – 创作日期
Category[string] – 视频分类
Describe[string] – 视频描述
Tag[string] – 视频标签,标签内容有半角“,”(逗号)分割
AddrStr[string] - 视频位置信息
Longitude[float] - 视频位置 - 经度
Latitude[float] - 视频位置 - 纬度
返回值:
VID[string] – 视频ID
"""
userId = UserService.user_id(data['UserKey'])
fileName = "%s/%s" % (uploadDirectory, data['UploadId'])
db = MySQL()
newId = Utils.UUID()
media = MediaProbe(fileName)
# media.createTime()
result = db.save("""INSERT INTO `video` (`id`, `upload_id`, `owner_id`, `duration`, `video_width`, `video_height`, `video_bitrate`, `title`, `author`, `create_date`, `category`, `describe`, `tag`, `lbs_addr`, `lbs_lon`, `lbs_lat`)
VALUES (%s,%s,%s,%s,%s, %s,%s,%s,%s,%s, %s,%s,%s,%s,%s,%s)""",
(newId, data['UploadId'], userId, media.duration(), media.videoWidth(), media.videoHeight(), media.videoBitrate(),
data.get('Title', ''),
data.get('Author', ''),
data.get('CreateTime', media.createTime()),
data.get('Category', ''),
data.get('Describe', ''),
data.get('Tag', ''),
data.get('AddrStr', None),
data.get('Longitude', None),
data.get('Latitude', None)))
db.end()
# 截图
destFileName = "%s/%s.jpg" % (videoDirectory, newId)
Transcoder.VideoPoster(fileName, destFileName)
# post transcode task
# 原清晰度
if media.videoCodec() == 'h264' and media.audioCodec() == 'aac' :
result = db.save("""INSERT INTO `video_transcode` (`video_id`, `file_name`, `video_width`, `video_height`, `video_bitrate`, `video_codec`, `audio_channels`, `audio_bitrate`, `audio_codec`)
VALUES (%s,%s,%s,%s,%s, %s,%s,%s,%s)""",
(newId, newId + '.mp4',
media.videoWidth(),
media.videoHeight(),
media.videoBitrate(),
'copy',
media.audioChannels(),
media.audioBitrate(),
'copy'))
taskId = db.getInsertId()
db.end()
else:
result = db.save("""INSERT INTO `video_transcode` (`video_id`, `file_name`, `video_width`, `video_height`, `video_bitrate`, `video_codec`, `audio_channels`, `audio_bitrate`, `audio_codec`)
VALUES (%s,%s,%s,%s,%s, %s,%s,%s,%s)""",
(newId, newId + '.mp4',
media.videoWidth(),
media.videoHeight(),
media.videoBitrate(),
TranscodeTemplates.HD['video_codec'],
media.audioChannels(),
media.audioBitrate(),
TranscodeTemplates.HD['audio_codec'] ))
taskId = db.getInsertId()
db.end()
# 高清
if media.supportHD() and not media.DefinitionIsHD():
result = db.save("""INSERT INTO `video_transcode` (`video_id`, `file_name`, `video_width`, `video_height`, `video_bitrate`, `video_codec`, `audio_channels`, `audio_bitrate`, `audio_codec`)
VALUES (%s,%s,%s,%s,%s, %s,%s,%s,%s)""",
(newId, newId + '_hd.mp4',
int(TranscodeTemplates.HD['video_width']),
int(TranscodeTemplates.HD['video_width']) / media.videoAspect(),
TranscodeTemplates.HD['video_bitrate'],
TranscodeTemplates.HD['video_codec'],
TranscodeTemplates.HD['audio_channel'],
TranscodeTemplates.HD['audio_bitrate'],
TranscodeTemplates.HD['audio_codec'] ))
taskId = db.getInsertId()
db.end()
# 标清
if media.supportSD() and not media.DefinitionIsSD():
result = db.save("""INSERT INTO `video_transcode` (`video_id`, `file_name`, `video_width`, `video_height`, `video_bitrate`, `video_codec`, `audio_channels`, `audio_bitrate`, `audio_codec`)
VALUES (%s,%s,%s,%s,%s, %s,%s,%s,%s)""",
(newId, newId + '_sd.mp4',
int(TranscodeTemplates.SD['video_width']),
int(TranscodeTemplates.SD['video_width']) / media.videoAspect(),
TranscodeTemplates.SD['video_bitrate'],
#.........这里部分代码省略.........
示例10: MediaProbe
# 需要导入模块: from MySQL import MySQL [as 别名]
# 或者: from MySQL.MySQL import save [as 别名]
# 短地址库
# 创建转码任务
uploadFileName = "%s/%s" % (uploadDirectory, video['upload_id'])
shutil.copyfile(destFileName, uploadFileName)
newId = video['id']
media = MediaProbe(uploadFileName)
# 原清晰度
if media.videoCodec() == 'h264' and media.audioCodec() == 'aac' :
result = db.save("""INSERT INTO `video_transcode` (`video_id`, `file_name`, `video_width`, `video_height`, `video_bitrate`, `video_codec`, `audio_channels`, `audio_bitrate`, `audio_codec`)
VALUES (%s,%s,%s,%s,%s, %s,%s,%s,%s)""",
(newId, newId + '.mp4',
media.videoWidth(),
media.videoHeight(),
media.videoBitrate(),
'copy',
media.audioChannels(),
media.audioBitrate(),
'copy'))
taskId = db.getInsertId()
db.end()
else:
result = db.save("""INSERT INTO `video_transcode` (`video_id`, `file_name`, `video_width`, `video_height`, `video_bitrate`, `video_codec`, `audio_channels`, `audio_bitrate`, `audio_codec`)
VALUES (%s,%s,%s,%s,%s, %s,%s,%s,%s)""",
(newId, newId + '.mp4',
media.videoWidth(),
media.videoHeight(),
media.videoBitrate(),
TranscodeTemplates.HD['video_codec'],
media.audioChannels(),