Guest User

Untitled

a guest
Mar 14th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. label='ave_number'
  2.  
  3. sql_cmd=u"""UPDATE rpt.so_form2_test_noquotes SET %s=%s WHERE channel_id=%s and report_id=%s and load_date=current_date;"""
  4. sql_params=(label, e[u"label"],channel_id,report_id,)
  5. calldb(conn, sql_cmd, sql_params)
  6.  
  7. def calldb( db, sql_cmd, sql_params): # invoke backend function that is a INSERT/UPDATE statement
  8. try:
  9. cur = db.cursor() # use standard cursor as return is likely void
  10. print 'Executing sql cmd "{0}"'.format(cur.mogrify(sql_cmd, sql_params))
  11. cur.execute(sql_cmd, sql_params)
  12. return # execute returns None expected
  13.  
  14. except Exception as e:
  15. print u'Error ', e
  16. raise
  17.  
  18. from psycopg2.extensions import AsIs
  19. import psycopg2
  20.  
  21.  
  22. def calldb( db, sql_cmd, sql_params): # invoke backend function that is a INSERT/UPDATE statement
  23. try:
  24. cur = db.cursor() # use standard cursor as return is likely void
  25. print 'Executing sql cmd "{0}"'.format(cur.mogrify(sql_cmd, sql_params))
  26. cur.execute(sql_cmd, sql_params)
  27. return # execute returns None expected
  28.  
  29. except Exception as e:
  30. print u'Error ', e
  31. raise
  32.  
  33.  
  34. conn = psycopg2.connect(host='localhost', port=5432, user='xxxxxxx', password='xxxxxx')
  35.  
  36. label='ave_number'
  37.  
  38. e={u'label':'test_label'}
  39. channel_id=1
  40. report_id=1
  41.  
  42. sql_cmd=u"""UPDATE rpt.so_form2_test_noquotes SET %s=%s WHERE channel_id=%s and report_id=%s and load_date=current_date;"""
  43. sql_params=(AsIs(label), e[u"label"],channel_id,report_id,)
  44. calldb(conn, sql_cmd, sql_params)
  45.  
  46. Executing sql cmd "UPDATE rpt.so_form2_test_noquotes SET ave_number='test_label' WHERE channel_id=1 and report_id=1 and load_date=current_date;"
Add Comment
Please, Sign In to add comment