本文整理汇总了Python中db.Database.select方法的典型用法代码示例。如果您正苦于以下问题:Python Database.select方法的具体用法?Python Database.select怎么用?Python Database.select使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类db.Database
的用法示例。
在下文中一共展示了Database.select方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: Excel
# 需要导入模块: from db import Database [as 别名]
# 或者: from db.Database import select [as 别名]
# -*- coding: utf-8 -*-
# authors 13077/13130
# data: 05 de outubro de 2014
#
from excel import Excel
from db import Database
try:
x = Excel("../Data/IPC_Portugal_1977_2013.xls")
x.read_data()
lista2 = x.lista
d = Database(lista2)
d.drop_table()
d.create_table()
d.insert_data()
d.select('va')
except IOError as e:
print "I/O error ({0}): {1}".format(e.errno, e.strerror)
示例2: Database
# 需要导入模块: from db import Database [as 别名]
# 或者: from db.Database import select [as 别名]
try:
os.remove(fname)
print "Rimosso il vecchio database client."
except:
print "Il database client non esiste."
s = Database()
d = Database(fname)
print "Creato nuovo database client."
sql = 'CREATE TABLE "type" ("id" VARCHAR(25) PRIMARY KEY NOT NULL ,"hp" CHAR,"mp" CHAR,"str" CHAR,"dex" CHAR,"vit" CHAR,"agi" CHAR,"int" CHAR,"mnd" CHAR)'
if d.execute(sql):
print "Creata tabella type."
check = False
for r in s.select("*", "type"):
r = ["'%s'" % v for v in r]
if not d.insert("type", r):
check = True
print "Database client popolato con le entry..."
for r in d.select("*", "type"):
print r
if check:
print "ERRORE: Alcuni type possono non essere stati inseriti!!!"
else:
print "Impossibile creare tabella type."
sql = 'CREATE TABLE "scale" ("id" CHAR PRIMARY KEY NOT NULL ,"scaleHP" REAL DEFAULT 0 ,"baseHP" REAL DEFAULT 0 ,"scaleHPXXX" REAL DEFAULT 0 ,"scaleMP" REAL DEFAULT 0 ,"baseMP" REAL DEFAULT 0 ,"scaleSTATS" REAL DEFAULT 0 ,"baseSTATS" REAL DEFAULT 0 )'
if d.execute(sql):
print "Creata tabella scale."
示例3: select
# 需要导入模块: from db import Database [as 别名]
# 或者: from db.Database import select [as 别名]
def select(self, query):
db = Database(connect=True)
q = db.select(query)
db.close()
return q