本文整理汇总了Python中DB.openDB方法的典型用法代码示例。如果您正苦于以下问题:Python DB.openDB方法的具体用法?Python DB.openDB怎么用?Python DB.openDB使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DB
的用法示例。
在下文中一共展示了DB.openDB方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: monitoringPlots
# 需要导入模块: import DB [as 别名]
# 或者: from DB import openDB [as 别名]
def monitoringPlots(N_CAM=2,MAX_NUM=40000):
cur = DB.openDB()
if cur is None:
print "Could not connect to database!"
return 1
tmp_dir = "/usr/local/apache2/html/tmp/"
deltaT = timedelta(0,0,0,0,0,5)
EndT = datetime.utcnow()
StartT = EndT - deltaT
#strip microseconds from values:
StartT = StartT - timedelta(0,0,StartT.microsecond)
EndT = EndT - timedelta(0,0,EndT.microsecond)
deltaT = StartT-EndT
totalT = (deltaT.microseconds + 10**6*(deltaT.seconds+3600*24*deltaT.days))/10**6 #in seconds
stT = StartT.isoformat(" ")
enT = EndT.isoformat(" ")
cmd = "(SELECT 'pressure' AS col_name,value, setval,timestamp, rms FROM pressure WHERE timestamp>\'"+stT+"\' && timestamp<\'"+enT+"\' ORDER BY timestamp DESC LIMIT "+str(MAX_NUM)+") UNION"
cmd += "(SELECT 'wire_i' AS col_name,value, setval,timestamp, rms FROM wire_i WHERE timestamp>\'"+stT+"\' && timestamp<\'"+enT+"\' ORDER BY timestamp DESC LIMIT "+str(MAX_NUM)+")UNION"
cmd += "(SELECT 'wire_hv' AS col_name,value, setval,timestamp, rms FROM wire_hv WHERE timestamp>\'"+stT+"\' && timestamp<\'"+enT+"\' ORDER BY timestamp DESC LIMIT "+str(MAX_NUM)+")UNION"
cmd += "(SELECT 'mesh_hv' AS col_name,value, setval,timestamp, rms FROM mesh_hv WHERE timestamp>\'"+stT+"\' && timestamp<\'"+enT+"\' ORDER BY timestamp DESC LIMIT "+str(MAX_NUM)+")UNION"
cmd += "(SELECT 'temp0' AS col_name,value, setval,timestamp, rms FROM temp0 WHERE timestamp>\'"+stT+"\' && timestamp<\'"+enT+"\' ORDER BY timestamp DESC LIMIT "+str(MAX_NUM)+")UNION"
cmd += "(SELECT 'ccd' AS col_name,avgpixel, temperature,timestamp, ccdid FROM ccd WHERE timestamp>\'"+stT+"\' && timestamp<\'"+enT+"\' ORDER BY timestamp DESC LIMIT "+str(N_CAM*MAX_NUM)+")UNION"
cmd += "(SELECT 'scope' AS col_name,scopeid,nwf,timestamp,esum FROM scope WHERE timestamp>\'"+stT+"\' && timestamp<\'"+enT+"\' ORDER BY timestamp DESC LIMIT "+str(MAX_NUM)+")UNION"
cmd += "(SELECT 'humidity' AS col_name,value,setval,timestamp,rms FROM humidity WHERE timestamp>\'"+stT+"\'&×tamp<\'"+enT+"\' ORDER BY timestamp DESC LIMIT "+str(MAX_NUM)+")"
COL_NAME=0
VALUE=1
SETVAL=2
TIMESTAMP=3
AVGPIXEL=1
TEMPERATURE=2
RMS = 4
CCDID = 4
NWF = 2
now = datetime.now()
try:
num = cur.execute(cmd)
except MySQLdb.Error, e:
print "Error %d: %s"%(e.args[0],e.args[1])
return 2