本文整理汇总了Python中DB.cursor方法的典型用法代码示例。如果您正苦于以下问题:Python DB.cursor方法的具体用法?Python DB.cursor怎么用?Python DB.cursor使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DB
的用法示例。
在下文中一共展示了DB.cursor方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: open
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def open(self, i_user):
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
# Special case, used by playlist (amongst other things)
if i_user == 0:
self.id = 0
self.username = 'Random'
self.password = ''
return
if self.Config.user['backend'] == 'mysql':
db.execute(self.queryUserSelect, (i_user))
elif self.Config.user['backend'] == 'simplemachines':
db.execute(self.querySMFUserSelect, (i_user))
else:
# TODO: Throw an exception here, but I don't know how to do that
# at the moment :(
pass
row = db.fetchone()
try:
self.id = i_user
self.username = row[1]
self.password = row[2]
except:
self.id = 0
self.username = ''
self.password = ''
示例2: get_playlists
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def get_playlists(i_user=0):
playlists = [ ]
listenum = { }
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
db.execute("""SELECT id,listnum
FROM playlists
WHERE i_user = %s
ORDER BY listnum,id """, (i_user))
rows = db.fetchall()
for row in rows:
try:
if listenum[row[1]]:
continue
except:
pass
listenum[row[1]] = True;
p = Playlist(row[1], i_user)
playlists.append(p)
return playlists
示例3: get_user
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def get_user(self, username):
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
if self.Config.user['backend'] == 'mysql':
db.execute(self.queryUnameSelect, (username))
elif self.Config.user['backend'] == 'simplemachines':
db.execute(self.querySMFUnameSelect, (username))
else:
# TODO: Throw an exception here, but I don't know how to do that
# at the moment :(
pass
row = db.fetchone()
try:
self.id = row[0]
self.username = row[1]
self.password = row[2]
except:
self.id = 0
self.username = ''
self.password = ''
示例4: open
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def open(self, i_user=0):
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
if i_user == 0:
self.id = 0
self.username = None
self.password = None
self.options = None
return
db.execute(self.queryUserSelect, (i_user))
row = db.fetchone()
try:
self.id = i_user
self.username = row[1]
self.password = row[2]
except:
self.id=0
self.username = None
self.password = None
self.options = None
self.options = User_Options(self.id)
示例5: open
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def open(self, i_nas=0):
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
if i_nas == 0:
self.id = 0
self.identifier = None
self.description = None
self.options = None;
return
db.execute(self.queryNidSelect, (i_nas))
row = db.fetchone()
try:
self.id = row[0]
self.identifier = row[1]
self.description = row[2]
except:
self.id = 0
self.identifier = None
self.description = None
self.options = None;
self.options = Nas_Options(self.id)
示例6: open
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def open(self, i_song):
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
db.execute(self.querySongSelect, (i_song))
row = db.fetchone()
try:
self.id = i_song
self.artist = row[1]
self.title = row[2]
self.path = row[3]
except:
self.id = 0
self.artist = False
self.title = False
self.path = False
try:
self.artist = self.artist.decode('UTF-8')
self.title = self.title.decode('UTF-8')
except:
pass
示例7: del_playlist_song
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def del_playlist_song(i_user=0, i_playlist=0, i_song=0):
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
db.execute("DELETE FROM playlists WHERE i_user=%s AND listnum=%s AND i_song=%s", (i_user, i_playlist, i_song))
示例8: subscribe
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def subscribe(self, i_user):
""" Subscribe a user to a thread """
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
db.execute(self.queryAddSubscription, (self.id, i_user))
示例9: getLinkHash
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def getLinkHash(self, i_topic):
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
db.execute(self.queryGetLinkHash, (i_topic))
row = db.fetchone();
return row[2]
示例10: link
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def link(self, post):
""" This is used to link a post to this thread """
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
db.execute(self.queryInsertLink, (self.id, post.id))
self.posts.append(post)
示例11: updatecount
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def updatecount(self, i_thread=0, count=0):
if count == 0 or i_thread == 0:
return 0
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
db.execute(self.queryUpdateCount, (count, i_thread))
return(self.postcount)
示例12: searchby_linkhash
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def searchby_linkhash(self, linkhash):
""" Used to generate a thread ID from the supplied link """
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
db.execute(self.querySearchByLinkHash, (linkhash))
row = db.fetchone()
i_thread = row[1]
self.open(i_thread)
示例13: add_playlist_song
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def add_playlist_song(i_user=0, i_playlist=0, i_song=0):
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
print "i_user: {0}".format(i_user)
print "i_playlist: {0}".format(i_playlist)
print "i_song: {0}".format(i_song)
db.execute("INSERT INTO playlists (i_user, listnum, i_song) VALUES (%s, %s, %s)", (i_user, i_playlist, i_song))
示例14: get_song_count
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def get_song_count(self):
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
db.execute(self.queryCountSongs, (self.id, self.i_user))
row = db.fetchone()
self.count = row[0]
示例15: new
# 需要导入模块: import DB [as 别名]
# 或者: from DB import cursor [as 别名]
def new(self, subject=None):
""" Generates a new thread number """
try:
db = conn.cursor()
except NameError:
conn = DB()
db = conn.cursor()
db.execute(self.queryNewThread, (subject))
self.id = db.lastrowid
self.bump()