Advertisement
Guest User

Untitled

a guest
Nov 27th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. Ex: Decimal(2.3), Decimal(3.4) etc
  2.  
  3. import cx_Oracle
  4. import Decimal
  5.  
  6. def convert_as_decimal(cursor, name, defaultType, size, precision, scale):
  7. if defaultType == cx_Oracle.NUMBER:
  8. return cursor.var(str, 100, cursor.arraysize, outconverter = decimal.Decimal)
  9.  
  10. class foo:
  11. def __init__(self, db, user, password):
  12. self.db = db
  13. self.user = user
  14. self.password = password
  15.  
  16. def connect(self, convert_to_decimal=None):
  17. conn = cx_Oracle.connect(self.user, self.password, self.db)
  18. db.outputtypehandler = convert_as_decimal
  19. self.conn = conn
  20.  
  21. def execute(self, sql):
  22. cur = self.conn.cursor()
  23. cur.execute(sql)
  24. return cur
  25.  
  26.  
  27. sql = 'select * from example_table'
  28.  
  29. db_conn = foo('example_user', example_password, example_db)
  30. cursor_a = db_conn.execute(sql)
  31.  
  32. for row in cursor_a:
  33. print row
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement