def PrintSalaryTable(connection): cursor = GetCursor(connection) SQL = "SELECT * FROM PYTHON.PHONE_TABLE" cursor.execute(SQL) for firstName, lastName, phone in cursor.fetchall(): print "%-10s%-10s%-10s" % (firstName, lastName, phone)
def PrintSalaryTable(connection): cursor = GetCursor(connection) SQL = "SELECT * FROM PYTHON.SALARY_TABLE" cursor.execute(SQL) for name, salary in cursor.fetchall(): print("%-10s%-10i" % (name, salary))
def DeleteRow(connection, name): try: SQL = "DELETE FROM PYTHON.SALARY_TABLE WHERE Name = '" + name + "'" cursor = GetCursor(connection) cursor.execute(SQL) connection.commit() except Exception, reason: print reason connection.rollback()
def DeleteRow(connection, name): try: SQL = "DELETE FROM PYTHON.SALARY_TABLE WHERE Name = '" + name + "'" cursor = GetCursor(connection) cursor.execute(SQL) connection.commit() except Exception as reason: print(reason) connection.rollback()
def InsertRow(connection, name, salary): try: SQL = "INSERT INTO PYTHON.SALARY_TABLE (Name, Salary) " + \ "VALUES ('" + name +"'" + \ " ,'" + str(salary) +"')" cursor = GetCursor(connection) cursor.execute(SQL) cursor.close() connection.commit() except Exception as reason: connection.rollback() print(reason)
def UseStoredProcedure(connection, name, increase): try: cursor = GetCursor(connection) newSalary = cursor.var(cx_Oracle.NUMBER) result = cursor.callproc('PYTHON.INCREASE_SALARY',[name, increase, newSalary]) print("result=", result) print("newSalary=", newSalary) print("newSalary=", newSalary.getvalue()) connection.commit() except Exception as reason: connection.rollback() print(type(reason)) print("context: ", reason.message.context) print("code: ", reason.message.code) print("message: ", reason.message.message)
def UseStoredProcedure(connection, name, increase): try: cursor = GetCursor(connection) newSalary = cursor.var(cx_Oracle.NUMBER) result = cursor.callproc('PYTHON.INCREASE_SALARY', [name, increase, newSalary]) print "result=", result print "newSalary=", newSalary print "newSalary=", newSalary.getvalue() connection.commit() except Exception, reason: connection.rollback() print type(reason) print "context: ", reason.message.context print "code: ", reason.message.code print "message: ", reason.message.message
def UseBindVariables(connection, name, salary): try: cursor = GetCursor(connection) method1(cursor, name, salary) method2(cursor, name, salary) method3(cursor, name, salary) connection.commit() except Exception as reason: connection.rollback() print(reason)