Python db.dbInitialize函数代码示例

def main():
  print 'Content-type: text/plain'
  print 
  db = dbInitialize(db="libtech")
  cur = db.cursor()
  form = cgi.FieldStorage()
  if form.has_key('CustomField'):# is not None:
    callid = form['CustomField'].value
    query="select audio from callQueue where callid=%s" % callid
  elif form.has_key('From'):
    phone=form['From'].value
    sid=form['CallSid'].value
    last10Phone=phone[-10:]
    query="select audio from callQueue where isTest=1 and sid='%s'" % sid
  else:
    query="select filename from audioLibrary where id=1579"
  with open('/tmp/y.txt', 'w') as outfile:
    outfile.write(str(form)+query)
  cur.execute(query)
  if cur.rowcount == 1:
    row=cur.fetchone()
    audioFiles=row[0]
    audioFileList=audioFiles.split(',')
    for audio in audioFileList:
      print "http://callmgr.libtech.info/open/audio/%s" % audio;
  else:
    print "http://callmgr.libtech.info/open/audio/1652_ResearchRSCDR2p18000.wav"

def main():
  args = argsFetch()
  logger = loggerFetch(args.get('log_level'))
  db = dbInitialize(db=nregaDB, charset="utf8")  # The rest is updated automatically in the function
  cur=db.cursor()
  db.autocommit(True)
  #Query to set up Database to read Hindi Characters
  query="SET NAMES utf8"
  cur.execute(query)
  
  if args['updateMusterStats']:
    updateMusterStats(cur,logger) 
  if args['selectRandomDistricts']:
    selectRandomDistricts(cur,logger)
  if args['updatePanchayatStats']:
    updatePanchayatStats(cur,logger)
  if args['genMusterURL']:
    genMusterURLs(cur,logger,args['musterID'])
  if args['downloadRejectedPaymentReport']:
    if args['finyear']:
      finyear=args['finyear']
    else:
      finyear='17'
    downloadRejectedPaymentReport(cur,logger,finyear)
  dbFinalize(db) # Make sure you put this if there are other exit paths or errors
  logger.info("...END PROCESSING")     
  exit(0)

def main():
  print 'Content-type: text/plain'
  print 
  db = dbInitialize(db='libtech')
  cur = db.cursor()
  form = cgi.FieldStorage()
# phone=form['From'].value
# sid=form['CallSid'].value
# last10Phone=phone[-10:]
  digits=form['digits'].value
  digits=digits.strip('"')
  with open('/tmp/bihar1.txt', 'w') as outfile:
    outfile.write(str(form)+digits)
 # digits='12380030041412'
  fpsCode=digits[:-2]
  month=int(digits[-2:])

  audioFiles=getPDSAudioList(fpsCode,month)
  if audioFiles is not None:
    audioFileList=audioFiles.split(',')
    s=''
    for audioID in audioFileList:
      query="select filename from audioLibrary where id=%s " % str(audioID)
      cur.execute(query)
      row=cur.fetchone()
      audio=row[0]
      s+=audio
      print "http://callmgr.libtech.info/open/audio/%s" % audio;
    with open('/tmp/bihar.txt', 'w') as outfile:
      outfile.write(str(form)+s)
  else:
    audioFile="spss_try_again.wav"
    print "http://callmgr.libtech.info/open/audio/prompts/%s" % audioFile
  dbFinalize(db) # Make sure you put this if there are other exit paths or errors

def main():
  db = MySQLdb.connect(host=dbhost, user=dbuser, passwd=dbpasswd, charset='utf8')
  db = dbInitialize(db='libtech', charset="utf8")  # The rest is updated automatically in the function
  cur=db.cursor()
  db.autocommit(True)
  query="SET NAMES utf8"
  cur.execute(query)
  query="use libtech"
  cur.execute(query)
  query="select bid,completed,name from broadcasts where bid>1000 and error=0 and approved=1 and processed=1 and completed=0 order by bid DESC "
  print query
  cur.execute(query)
  results = cur.fetchall()
  for row in results:
    bid=str(row[0])
    completed=str(row[1])
    name=row[2]
    print bid+"  "+name+"  "+completed
    query="select a.district,a.block,a.panchayat,c.phone,DATE_FORMAT(c.callStartTime,'%d-%M-%Y') callTime,c.status,c.attempts,c.duration,c.durationPercentage,f.feedback,c.sid from addressbook a,callSummary c left join callFeedback f on c.sid=f.sid where c.phone=a.phone and bid="+str(bid)
    if(completed == '0' or completed=='1'):
      csvname=broadcastReportFilePath+str(bid)+"_"+name.replace(' ',"")+".csv"
      print csvname
      writecsv(cur,query,csvname)
      updateBroadcastTable(cur,bid)
    query="select bid,vendor,phone,callStartTime,duration,vendorCallStatus,cost from callLogs where bid=%s order by phone" % str(bid) 
    if(completed == '0' or completed=='1'):
      csvname=broadcastReportFilePath+str(bid)+"_"+name.replace(' ',"")+"_detailed.csv"
      print csvname
      writecsv(cur,query,csvname)
  dbFinalize(db) # Make sure you put this if there are other exit paths or errors
  logger.info("...END PROCESSING")     
  exit(0)

def main():
  args = argsFetch()
  logger = loggerFetch(args.get('log_level'))
  logger.info('args: %s', str(args))
  db = dbInitialize(db="libtech", charset="utf8")  # The rest is updated automatically in the function
  cur=db.cursor()
  db.autocommit(True)
  #Query to set up Database to read Hindi Characters
  query="SET NAMES utf8"
  cur.execute(query)
  
  query="select phone,bid from callLogs where DATE(callStartTime) = CURDATE() group by phone "
  cur.execute(query)
  results=cur.fetchall()
  for row in results:
    #rowid=str(row[0])
    phone=row[0]
    logger.info("  Phone %s " % (phone)) 
    query="select count(*) from callLogs where phone='%s'" % (phone)
    totalCalls=singleRowQuery(cur,query)
    query="select count(*) from callLogs where phone='%s' and status='pass'" % (phone)
    totalSuccessCalls=singleRowQuery(cur,query)
    if totalCalls > 0:
      logger.info("Calculating Percentage")
      successP=math.trunc(totalSuccessCalls*100/totalCalls)
    else:
      successP=0
    logger.info("Total Calls %s Success Calls %s Success Percentage %s " % (str(totalCalls),str(totalSuccessCalls),str(successP)))
    query="update addressbook set totalCalls='%s',successPercentage='%s'  where phone='%s' " % (str(totalCalls),str(successP),phone) 
    cur.execute(query)

  dbFinalize(db) # Make sure you put this if there are other exit paths or errors
  logger.info("...END PROCESSING")     
  exit(0)

def main():
  print 'Content-type: text/html'
  print 

  form = cgi.FieldStorage()
  with open('/tmp/z.txt', 'w') as outfile:
    outfile.write(str(form))

  sid = form['CallSid'].value
  phone = form['From'].value
  digits = form['digits'].value.replace('"','')

  import os

  db = dbInitialize(db="libtech")
  cur = db.cursor()
  query="select a.filename,b.bid from broadcasts b, audioLibrary a where b.bid=%s and b.fileid=a.id" % (digits);
  cur.execute(query)
  row=cur.fetchone()
  filename=row[0]
  
  query = 'insert into testBroadcast (sid,vendor,phone,callStartTime,bid,filename) values ("%s", "exotel","%s", now(), "%s","%s")' % (sid, phone,digits,filename)
  with open('/tmp/z.txt', 'a') as outfile:
    outfile.write(query)
  cur.execute(query)
  dbFinalize(db)

  return 0

def main():
  print 'Content-type: text/html'
  print 
  myhtml=''  
  
  db = dbInitialize(db="crawlDistricts", charset="utf8")  # The rest is updated automatically in the function
  cur=db.cursor()
  db.autocommit(True)
  #Query to set up Database to read Hindi Characters
  query="SET NAMES utf8"
  cur.execute(query)
  
  section_html = getButtonV2('./crawlStatus.py', 'status', 'status')
  query="select name from districts"
  hiddenNames=['districtName'] 
  hiddenValues=[0]
  query_table = "<br />"
  query_table += bsQuery2HtmlV2(cur, query, query_caption="",extraLabel='status',extra=section_html,hiddenNames=hiddenNames,hiddenValues=hiddenValues)
  myhtml+=query_table
  

  myhtml=htmlWrapper(title="NREGA Status", head='<h1 aling="center">Nrega Status</h1>', body=myhtml)
  print myhtml.encode('UTF-8')

  dbFinalize(db) # Make sure you put this if there are other exit paths or errors

def sql2json(logger,):
  db = dbInitialize(db="surguja", charset="utf8")

  query = 'select id, panchayatName, name, jobcard, musterNo, workCode, accountNo, bankNameOrPOName, musterStatus from workDetails limit 10'
  cur = db.cursor()
  cur.execute(query)
  res = fetchindict(cur)
  logger.info("Converting query[%s]" % query)
  #data = str(res[0]).encode('utf-8')
  data = res
  logger.info("Data[%s]" % data)

  '''
  with open(filename, 'wb') as outfile:
      logger.info('Writing to file[%s]' % filename)
      outfile.write(res)
  '''

  with open(filename, 'w') as outfile:
    logger.info('Writing to file[%s]' % filename)
    json.dump(data, outfile, ensure_ascii=False, indent=4)
      
  dbFinalize(db)

  return 'SUCCESS'

def main():
  regex=re.compile(r'<input+.*?"\s*/>+',re.DOTALL)
  args = argsFetch()
  finyear=args['finyear']
  if args['limit']:
    limit = int(args['limit'])
  else:
    limit =50000
  if args['musterID']:
    mid=args['musterID']
  else:
    mid=None
  if args['maxProcess']:
    maxProcess=int(args['maxProcess'])
  else:
    maxProcess=1
  additionalFilters=''
  if args['district']:
    additionalFilters+= " and b.districtName='%s' " % args['district']
  if args['block']:
    additionalFilters+= " and b.blockName='%s' " % args['block']
  fullfinyear=getFullFinYear(finyear)
  logger = loggerFetch(args.get('log_level'))
  logger.info('args: %s', str(args))
  logger.info("BEGIN PROCESSING...")


  db = dbInitialize(db=nregaDB, charset="utf8")  # The rest is updated automatically in the function
  cur=db.cursor()
  db.autocommit(True)
  #Query to set up Database to read Hindi Characters
  query="SET NAMES utf8"
  cur.execute(query)
  tasks = multiprocessing.JoinableQueue()
  results = multiprocessing.Queue()
  if mid is None:
    query="select m.id from musters m,blocks b where m.fullBlockCode=b.fullBlockCode and m.finyear='%s' and (m.isDownloaded=0  or (m.wdComplete=0 and TIMESTAMPDIFF(HOUR, m.downloadAttemptDate, now()) > 48 )) %s order by isDownloaded,m.downloadAttemptDate limit %s" % (finyear,additionalFilters,str(limit))
  else:
    query="select m.id from musters m where m.id=%s " % str(mid)
  logger.info(query) 
  cur.execute(query)
  noOfTasks=cur.rowcount
  results1=cur.fetchall()
  for row in results1:
    musterID=row[0]
    tasks.put(Task(musterID))  
  
  for i in range(maxProcess):
    tasks.put(None)

  myProcesses=[musterProcess(tasks, results) for i in range(maxProcess)]
  for eachProcess in myProcesses:
    eachProcess.start()
  while noOfTasks:
    result = results.get()
    logger.info(result)
    noOfTasks -= 1


  dbFinalize(db) # Make sure you put this if there are other exit paths or errors

def main():
  args = argsFetch()
  logger = loggerFetch(args.get('log_level'))
  logger.info('args: %s', str(args))

  logger.info("BEGIN PROCESSING...")
  db = dbInitialize(db="biharPDS", charset="utf8")  # The rest is updated automatically in the function
  cur=db.cursor()
  db.autocommit(True)
  #Query to set up Database to read Hindi Characters
  query="SET NAMES utf8"
  cur.execute(query)
  inyear=args['year']
  
  logger.info(inyear)
  display = displayInitialize(args['visible'])
  driver = driverInitialize(args['browser'])
  
  #Start Program here
  url="http://www.google.com"
  driver.get(url)
  myhtml=driver.page_source
  print myhtml
  # End program here

  driverFinalize(driver)
  displayFinalize(display)
  dbFinalize(db) # Make sure you put this if there are other exit paths or errors


  
  logger.info("...END PROCESSING")     
  exit(0)

def main():
  db = dbInitialize(db="libtech")
  cur = db.cursor()
  form = cgi.FieldStorage()
  with open('/tmp/y.txt', 'w') as outfile:
    outfile.write(str(form))
 
  phone1 = form['From'].value
  phone=phone1[-10:]
  
  direction = form['Direction'].value
  isAdmin=0
  if str(direction) =='incoming': #Only for Incoming calls we need to check if the phone number is incoming or no
    #Get admin status
    query="select * from addressbook where isAdmin=1 and phone='%s' " % phone
    with open('/tmp/yyy.txt', 'w') as outfile:
      outfile.write(query)
    cur.execute(query)
    if cur.rowcount == 1:
      isAdmin=1
  if isAdmin == 1:
    print 'Status: 200 OK'
    print 
  else:
    print 'Status: 302 Found'
    print 

def checkAudioFiles(logger):
  logger.info("Checking if all AudioFiles are present or not")
  db = dbInitialize(host=pdsDBHost,db=pdsDB, charset="utf8")  # The rest is updated automatically in the function
  cur=db.cursor()
  db.autocommit(True)
  #Query to set up Database to read Hindi Characters
  query="SET NAMES utf8"
  cur.execute(query)
  query="select id,fpsCode from fpsShops where cRequired=1 order by id desc "
  cur.execute(query)
  results=cur.fetchall()
  for row in results:
    rowid=str(row[0])
    fpsCode=row[1]
    logger.info("row id: %s dpsCode: %s  " % (rowid,fpsCode))
    audioPresent=1
    fpsFileName="%s/fps/%s.wav" % (pdsAudioDir,fpsCode)
    if not os.path.isfile(fpsFileName):
      audioPresent=0
    logger.info("THe audioPresent : %s " % str(audioPresent))
    query="update fpsShops set audioPresent=%s where id=%s " % (str(audioPresent),rowid)
    cur.execute(query)
    query="update fpsStatus set audioPresent=%s where fpsCode=%s " % (str(audioPresent),fpsCode)
    cur.execute(query)
  dbFinalize(db) # Make sure you put this if there are other exit paths or errors

def main():
  print 'Content-type: text/html'
  print 
  myhtml=''  
  form = cgi.FieldStorage()
  additionalFilter=''
  districtName=''
  if form.has_key('district'):# is not None:
    additionalFilter+=" and b.districtName='%s' " % form["district"].value
    districtName=form["district"].value
  finyear='17'
  if form.has_key('finyear'):# is not None:
    finyear=form["finyear"].value 
  db = dbInitialize(db="nicnrega", charset="utf8")  # The rest is updated automatically in the function
  cur=db.cursor()
  db.autocommit(True)
  #Query to set up Database to read Hindi Characters
  query="SET NAMES utf8"
  cur.execute(query)
  finyear='17' 
  
   
  myhtml+=  getCenterAligned('<h2 style="color:blue"> %s</h2>' % (districtName.upper()))

  myhtml+=  getCenterAligned('<h3 style="color:red"> Pending Muster Download MusterWise</h3>')
  query="select m.id,m.musterNo,b.districtName district,b.blockName block,m.wdError,TIMESTAMPDIFF(HOUR,m.downloadAttemptDate,NOW()) timeDiff,m.crawlDate,m.downloadAttemptDate from musters m,blocks b,panchayats p  where m.finyear='%s' and b.isRequired=1 and m.fullBlockCode=b.fullBlockCode and m.stateCode=p.stateCode and m.districtCode=p.districtCode and m.blockCode=p.blockCode and m.panchayatCode=p.panchayatCode and p.isRequired=1  and m.musterType='10' and (m.isDownloaded=0 or m.wdError=1 or (m.wdComplete=0 and TIMESTAMPDIFF(HOUR, m.downloadAttemptDate, now()) > 48 ) ) %s order by isDownloaded,TIMESTAMPDIFF(HOUR,m.downloadAttemptDate,NOW()) DESC limit 4" % (finyear,additionalFilter)
  query_table = "<br />"
  query_table += bsQuery2HtmlV2(cur, query, query_caption="")
  myhtml+=query_table
 
  myhtml=htmlWrapper(title="NREGA Status", head='<h1 aling="center">Nrega Status</h1>', body=myhtml)
  print myhtml.encode('UTF-8')
  dbFinalize(db) # Make sure you put this if there are other exit paths or errors

 def __init__(self, task_queue, result_queue):
     multiprocessing.Process.__init__(self)
     self.task_queue = task_queue
     self.result_queue = result_queue
     self.pyConn = dbInitialize(db=nregaDB, charset="utf8")  # The rest is updated automatically in the function
     #self.pyConn.set_isolation_level(0)
     self.pyConn.autocommit(True)

def main():
  print 'Content-type: text/html'
  print 
 
  db = dbInitialize(db="biharPDS", charset="utf8")  # The rest is updated automatically in the function
  cur=db.cursor()
  db.autocommit(True)
  
  queryFilter=' and ' 
  distCodeValue='000'
  blockCodeValue='000'
  fpsCodeValue='000' 
  noInputPassed=1
  form = cgi.FieldStorage()
  if form.has_key('distCode'):
    noInputPassed=0
    distCodeValue=form["distCode"].value
    queryFilter+="p.distCode = '%s' and " %(distCodeValue)
    if form.has_key('blockCode'):
      blockCodeValue=form["blockCode"].value
      if blockCodeValue != '000':
        noInputPassed=0
        queryFilter+="p.blockCode = '%s' and " %(blockCodeValue)
      if form.has_key('fpsCode'):
        fpsCodeValue=form["fpsCode"].value
        if fpsCodeValue != '000':
          noInputPassed=0
          queryFilter+="p.fpsCode = '%s' and " %(fpsCodeValue)
  
  if noInputPassed == 1: 
    queryFilter=queryFilter.lstrip(' and')
  queryFilter=queryFilter.rstrip('and ') 
   
  myhtml=""
  myform=getButtonV2("./shopStatus.py", "biharPDS", "Submit") 
  extraInputs=''
  extraInputs+=getInputRow(cur,"distCode",distCodeValue)
  extraInputs+=getInputRow(cur,"blockCode",blockCodeValue,distCodeValue)
  extraInputs+=getInputRow(cur,"fpsCode",fpsCodeValue,distCodeValue,blockCodeValue)
  myform=myform.replace("extrainputs",extraInputs)

  
  query_table=''
  query_table+="<center><h2>Download Status </h2></center>"
  query="select p.distName,p.blockName,p.fpsName,ps.fpsMonth,ps.fpsYear,ps.downloadAttemptDate,ps.statusRemark from pdsShops p, pdsShopsDownloadStatus ps where p.distCode=ps.distCode and p.blockCode=ps.blockCode and p.fpsCode=ps.fpsCode %s limit 30" %(queryFilter)
  query_table += bsQuery2HtmlV2(cur, query)
 
  query_table+="<center><h2>Detailed Information</h2></center>"
  query="select p.distName,p.blockName,p.fpsName,psms.fpsMonth,psms.fpsYear,psms.scheme,psms.status,psms.sioStatus,psms.driverName0,psms.vehicle0,psms.dateOfDelivery0 from pdsShops p, pdsShopsMonthlyStatus psms where p.distCode=psms.distCode and p.blockCode=psms.blockCode and p.fpsCode=psms.fpsCode %s order by dateOfDelivery0 DESC limit 100" %(queryFilter)
  query_table += bsQuery2HtmlV2(cur, query)
 
  myhtml+=myform
  #myhtml+=query
  myhtml+=query_table
 

  myhtml=htmlWrapper(title="Shop Status", head='<h1 aling="center">Bihar PDS Shop Status</h1>', body=myhtml)
  print myhtml.encode('UTF-8')
  dbFinalize(db) # Make sure you put this if there are other exit paths or errors