本文整理汇总了Python中DB类的典型用法代码示例。如果您正苦于以下问题:Python DB类的具体用法?Python DB怎么用?Python DB使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了DB类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: get_playlists
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
示例2: getCampaignWordsPerDay
def getCampaignWordsPerDay(campaignID):
# print "Get Campaign Words Per Day"
connection = Connection(DB.getDBHost(), DB.getDBPort())
try:
db = connection.meteor
campaign = db.campaigns.find_one({"_id":campaignID})
connection.close()
if (campaign == ""):
return "1"
wordsPerDay = campaign['sendcount']
if (wordsPerDay == ""):
return "1"
return wordsPerDay
except:
print "**** getCampaignWordsPerDay Exception ****"
return "1"
示例3: auth
def auth():
TeacherID = 01475963
AdminID = 36957410
DB clockAideDB = DB("ClockAideDB")
id = keypad.ReadLine()
clockAideDB.authenticateUser(id)
if id == TeacherID:
keypad.SendLine(MODES['4'])
return [,,modes[4]] # auth() returns a list of the form [ID, Name, Session - True/False, Mode - Read/Set]
elif id == AdminID:
keypad.SendLine(MODES['5'])
return [,,modes[5]] # auth() returns a list of the form [ID, Name, Session - True/False, Mode - Read/Set]
elif clockAideDB.isUserAuthenticated():
keypad.SendLine(command["good"]) # Sends "Correct" Code to Keypad
time.sleep(2)
keypad.SendLine(name) # Sends Student Name to Keypad
# beginning logging information
return [0,'',modes[int(keypad.ReadLine())]] # auth() returns a list of the form [ID, Name, Session - True/False, Mode - Read/Set]
else:
print(keypad.SendLine(command["wrong"])) # Sends "Wrong" Code to Keypad
time.sleep(2)
return modes[0]
示例4: get_user
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 = ''
示例5: open
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
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 = ''
示例7: getNearbyCateringInfo
def getNearbyCateringInfo(self):
hotel_list = DB.query("select * from hotel where id > 570");
for hotel in hotel_list:
hotel_id = hotel["id"]
hotel_name = hotel["name_cn"]
#hotel_name = "桔子水晶酒店(北京总部基地店)(原双赢酒店)"
print hotel_name
headers = {
'User-Agent': 'Mozilla/5.0 (X11; U; Linux i686; zh-CN; rv:1.9.1.2) Gecko/20090803 Fedora/3.5.2-2.fc11 Firefox/3.5.2'
}
dianping_search_url = self.dianping_search_hotel_url+ hotel_name
page_code = requests.get(dianping_search_url,headers = headers)
soup = BeautifulSoup(page_code.text, "html.parser")
#print soup
ul = soup.find('ul',{'class':'hotelshop-list'})
h2 = ul.find('h2',{'class':'hotel-name'})
title = ''
url = ''
if h2 is not None:
a = h2.find('a',{'class':'hotel-name-link'})
title = a.string
url = a['href']
print title
print url
else:
title = 'n/a'
url = 'n/a'
sql = "insert into hotel_dianping_info(id,name_cn,dianping_url,dianping_name) values("+str(hotel_id)+",\""+hotel_name+"\",\""+url+"\",\""+title+"\")"
print sql
DB.insert(sql)
示例8: getData
def getData(self):
url = "http://202.118.201.228/academic/teacher/teachresource/roomschedule_week.jsdo"
# 提交周一至周日的表单数据
for i in self.week:
form_data = {
"aid": self.aid,
"buildingid": self.buildingid,
"room": self.room,
"whichweek": self.whichweek,
"week": i, # 星期1-7
}
html = LG.s.post(url=url, data=form_data).text # 发送Post请求
tmp = re.finditer(r'<tr style="display:" id="tr(.*?)".*?</table>', html, re.S) # 返回迭代器,即各教室
for j in tmp:
id = j.group(1)
tr = re.findall(r'<tr align="center" >(.*?)</tr>', j.group(), re.S)
lst = re.findall(r"<td.*?</td>", tr[1], re.S)
cnt = 0 # 记录课程节数
for k in lst[::2]:
cnt += 1
if k[3] == " ":
flag = 0
else:
flag = 1
DB.insert(id, i, cnt, flag) # 将数据插入数据库
示例9: getActiveStudents
def getActiveStudents(campaignID):
# print "ACTIVE Students"
connection = Connection(DB.getDBHost(), DB.getDBPort())
# print "Connecting to Students"
try:
db = connection.meteor
print "Connected to Students"
activeStudentList = []
print "Active Student List for Campaign " + campaignID
for students in db.students.find({'campaign':campaignID}):
# print students['cell'] + " " + students['campaign']
# print " IS Active"
activeStudentList.append(students['cell'])
connection.close()
# print "ACTIVE Students List EXIT"
return activeStudentList
except:
print "GET ACTIVE STUDENT EXCEPTION"
示例10: processCrawlJob
def processCrawlJob(crawlJob):
DB.removeFromCrawlQueue(crawlJob.url)
resp = callAgent(crawlJob)
processAgentResponse(resp)
DB.addToCrawlQueue(crawlJob.url)
crawlJob.success = True
return crawlJob
示例11: getCrawlLogData
def getCrawlLogData():
data = {
"errorRows": [],
"newestRows": []
}
errorRecords = DB.getCrawlRecordsWithErrors()
crawlRecords = DB.getNewestCrawlRecords(limit=100)
def pr(rows, crawlRecords):
seenUrls = {}
for cr in crawlRecords:
dashboardRow = {
"url": cr['url'],
"renderTime": cr['renderTime'],
"serverErrors": len(cr['serverErrors']),
"browserErrors": len(cr['browserErrors']),
"errorsPresent": cr['errorsPresent']
}
if dashboardRow['url'] not in seenUrls:
rows.append(dashboardRow)
seenUrls[dashboardRow['url']] = True
pr(data['newestRows'], crawlRecords)
pr(data['errorRows'], errorRecords)
return data
示例12: getTFIDF
def getTFIDF():
if not request.get_json(force=True) or not 'text' in request.get_json(force=True):
print 'aborting'
abort(400)
# istr = request.json['text']
istr = request.get_json(force=True)['text']
n = int(request.get_json(force=True)['max_n'] )
# remove all nonAsciiCharacters
istr = removeNonAscii(istr)
inclusion_list = DB.getInclusionList()
exclusion_list = DB.getExclusionList()
istr = removeNonAscii(istr)
TFIDF_results = TFIDF.findTFIDFkeywords(istr)
keywords = TFIDF_results[0:n]
keywords = NER.excludeKeywords(exclusion_list, keywords)
return jsonify({'keywords': keywords}), 201
示例13: open
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)
示例14: open
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
示例15: getActiveWordList
def getActiveWordList(campaignID):
print "ACTIVE Word List Order"
connection = Connection(DB.getDBHost(), DB.getDBPort())
# print "Connecting to Campaigns"
db = connection.meteor
# print "Connected to Words"
activeWordList = []
# print "Active Word List Order"
campaign = db.campaigns.find_one({"_id":campaignID})
connection.close()
if (campaign == ""):
return ""
wordOrder = campaign['cwordorder']
if (wordOrder == ""):
return ""
wordOrderArray = wordOrder.split(",")
for word in wordOrderArray:
if (len(word) > 0):
activeWordList.append(word)
# print "activeWordList add- > " + word
return activeWordList