result[runnum] = afterglow
except:
del qHandle
raise
del qHandle
for run in runs:
if run not in result.keys():
result[run] = 1.0 #those have no fillscheme
return result
if __name__ == "__main__":
import sessionManager
#myconstr='oracle://cms_orcoff_prod/cms_lumi_prod'
myconstr = 'oracle://cms_orcoff_prep/cms_lumi_dev_offline'
svc = sessionManager.sessionManager(myconstr,
authpath='/afs/cern.ch/user/x/xiezhen',
debugON=False)
session = svc.openSession(isReadOnly=True,
cpp2sqltype=[('unsigned int', 'NUMBER(10)'),
('unsigned long long', 'NUMBER(20)')
])
#runrange=[163337,163387,163385,163664,163757,163269,1234,152611]
schema = session.nominalSchema()
session.transaction().start(True)
driftresult = driftcorrectionsForRange(schema, [160467, 152611])
print(driftresult)
#result=correctionsForRange(schema,runrange)
session.transaction().commit()
del session
'''
dataIdsByTagId(schema,currenttagid,runlist)
output:
(currenttagname,{run:(lumidataid,trgdataid,hltdataid)})
'''
(currenttagid,currenttagname)=currentDataTag(schema)
result=dataIdsByTagId(schema,currenttagid,runlist=runlist,withcomment=False,lumitype=lumitype)
return (currenttagname,result)
if __name__ == "__main__":
import sessionManager
import lumidbDDL
#myconstr='oracle://cms_orcoff_prep/cms_lumi_dev_offline'
#authpath='/afs/cern.ch/user/x/xiezhen'
myconstr='sqlite_file:test.db'
svc=sessionManager.sessionManager(myconstr,debugON=False)
session=svc.openSession(isReadOnly=False,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')])
schema=session.nominalSchema()
session.transaction().start(False)
tables=lumidbDDL.createTables(schema)
trunkinfo=createBranch(schema,'TRUNK',None,comment='main')
#print trunkinfo
datainfo=createBranch(schema,'DATA','TRUNK',comment='hold data')
#print datainfo
norminfo=createBranch(schema,'NORM','TRUNK',comment='hold normalization factor')
#print norminfo
(branchid,branchparent)=branchInfoByName(schema,'DATA')
databranchinfo=(branchid,'DATA')
print databranchinfo
for runnum in [1200,1211,1222,1233,1345,1222,1200]:
lumientryid=entryInBranch(schema,nameDealer.lumidataTableName(),str(runnum),'DATA')
if cursor.currentRow()['fillscheme']:
fillscheme=cursor.currentRow()['fillscheme'].data()
if fillscheme and len(fillscheme)!=0:
afterglow=afterglowByFillscheme(fillscheme,afterglows)
result[runnum]=afterglow
except :
del qHandle
raise
del qHandle
for run in runs:
if run not in result.keys():
result[run]=1.0 #those have no fillscheme
return result
if __name__ == "__main__":
import sessionManager
#myconstr='oracle://cms_orcoff_prod/cms_lumi_prod'
myconstr='oracle://cms_orcoff_prep/cms_lumi_dev_offline'
svc=sessionManager.sessionManager(myconstr,authpath='/afs/cern.ch/user/x/xiezhen',debugON=False)
session=svc.openSession(isReadOnly=True,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')])
#runrange=[163337,163387,163385,163664,163757,163269,1234,152611]
schema=session.nominalSchema()
session.transaction().start(True)
driftresult=driftcorrectionsForRange(schema,[160467,152611])
print(driftresult)
#result=correctionsForRange(schema,runrange)
session.transaction().commit()
del session
def dropUNIQUEConstraints(schema):
'''
'''
pass
def describe(schema):
'''
'''
pass
if __name__ == "__main__":
import sessionManager
myconstr='oracle://devdb10/cms_xiezhen_dev'
authpath='/afs/cern.ch/user/x/xiezhen'
#myconstr='sqlite_file:test.db'
svc=sessionManager.sessionManager(myconstr,authpath=authpath,debugON=False)
session=svc.openSession(isReadOnly=False,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')])
schema=session.nominalSchema()
session.transaction().start(False)
tables=createTables(schema)
if len(tables)==0:
dropTables(schema,nameDealer.schemaV2Tables())
else:
dropTables(schema,tables)
dropTables(schema,nameDealer.commonTables())
#createUniqueConstraints(schema)
#session.transaction().commit()
#print 'droped new '
session.transaction().start(False)
def startApp(self):
self.sessionManager = sessionManager(self._server) # Crear el manejador de la sessión
self.sessionManager.splash.show() # Mostrar la pantalla splash
QTimer.singleShot(5000, lambda: self.sessionManager.splash.hide()) # Ocultamiento de la pantalla splash
QTimer.singleShot(5500, lambda: self.sessionManager.show()) # Despliegue del manejador de sessiones
return exit(self.exec_()) # Bucle principal de la aplicación
pass
def describe(schema):
'''
'''
pass
if __name__ == "__main__":
import sessionManager
myconstr = 'oracle://devdb10/cms_xiezhen_dev'
authpath = '/afs/cern.ch/user/x/xiezhen'
#myconstr='sqlite_file:test.db'
svc = sessionManager.sessionManager(myconstr,
authpath=authpath,
debugON=False)
session = svc.openSession(isReadOnly=False,
cpp2sqltype=[('unsigned int', 'NUMBER(10)'),
('unsigned long long', 'NUMBER(20)')
])
schema = session.nominalSchema()
session.transaction().start(False)
tables = createTables(schema)
if len(tables) == 0:
dropTables(schema, nameDealer.schemaV2Tables())
else:
dropTables(schema, tables)
dropTables(schema, nameDealer.commonTables())
#createUniqueConstraints(schema)
#session.transaction().commit()
# -*- coding:utf-8 -*-
import json
import requests
import settings
from sessionManager import sessionManager
from flask import Flask, request, Response, render_template, jsonify
from requests_oauthlib import OAuth1Session
from urllib.parse import parse_qsl
app = Flask(__name__)
session_manager = sessionManager()
twitter = None
@app.route('/')
def index():
return render_template('signin.html')
@app.route('/signin', methods=["GET"])
def getSignIn():
return render_template('signin.html')
@app.route('/signin', methods=["POST"])
def postSignIn():
consumer_key, consumer_secret = session_manager.getConsumerKey()
twitter = OAuth1Session(consumer_key, consumer_secret)
endpoint = "https://api.twitter.com/oauth/request_token"
oauth_callback = "http://192.168.10.107:5000/main"
