Exemplos de GetCursor em Python

Exemplo n.º 1

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)

Exemplo n.º 2

Arquivo: PrintSalaryTable.py Projeto: seddon-software/python3-examples

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))

Exemplo n.º 3

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))

Exemplo n.º 4

Arquivo: DeleteRow.py Projeto: ithenis/python-course

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()

Exemplo n.º 5

Arquivo: DeleteRow.py Projeto: seddon-software/python3-examples

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()

Exemplo n.º 6

Arquivo: InsertRow.py Projeto: seddon-software/python3-examples

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)

Exemplo n.º 7

Arquivo: StoredProcedures.py Projeto: seddon-software/python3-examples

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)

Exemplo n.º 8

Arquivo: StoredProcedures.py Projeto: ithenis/python-course

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

Exemplo n.º 9

Arquivo: BindVariables.py Projeto: seddon-software/python-course

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)

Exemplo n.º 10

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)