Oracle database operations for Python combat

1. To enable Python to operate the Oracle database, you first need to install the Cx_oracle package, which can be obtained from the address below

[Plain]View PlainCopy

1. http://cx-oracle.sourceforge.net/

2. Additional Oracle class libraries are required to install the Oracle Instant client package on a machine running Python, which can be obtained from the following address

[Plain]View PlainCopy

1. Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Find the package that fits your platform, then install it, I'm using the RPM package, so install it using the following command

[Plain]View PlainCopy

1. $ sudo rpm-ivh oracle-instantclient11.2-basic-11.2.0.3.0-1.i386.rpm

After the installation, you need to set the environment variables, as follows

[Plain]View PlainCopy

1. $ Export Ld_library_path=${ld_library_path}:/usr/lib/oracle/11.2/client/lib

3. Create a simple Python file to test whether the installation was successful

[Python]View PlainCopy

1. Import Cx_oracle
3. conn = Cx_oracle.connect (' fkong/[email protected]/orcl ')
4. cursor = Conn.cursor ()
5. Cursor.execute ("SELECT * from dual")
6. row = Cursor.fetchone ()
7. Print row[0]
9. Cursor.close ()
10. Conn.close ()

4. Look at a Database build table and insert operation

[Python]View PlainCopy

2. Import Cx_oracle
6. conn = Cx_oracle.connect (' fkong/[email protected]/orcl ')
8. cursor = Conn.cursor ()
12. Cursor.execute ("CREATE TABLE TEST" (ID INT, COL1 varchar (+), COL2 varchar (), COL3 varchar (+)) ")
16. Cursor.execute ("INSERT into TEST (ID, COL1, COL2, COL3) VALUES (1, ' A ', ' B ', ' C ')")
18. Cursor.execute ("INSERT into TEST (ID, COL1, COL2, COL3) VALUES (2, ' AA ', ' BB ', ' cc ')")
20. Cursor.execute ("INSERT into TEST (ID, COL1, COL2, COL3) VALUES (3, ' AAA ', ' BBB ', ' CCC ')")
22. Conn.commit ()
26. Cursor.close ()
28. Conn.close ()

5. Here's a look at the query, there are usually two ways of querying: one is to get all the query results using Cursor.fetchall () and then one line of iterations, and the other one to get a record by Cursor.fetchone () until the result is empty. Take a look at the following example:

[Python]View PlainCopy

2. Import Cx_oracle
6. conn = Cx_oracle.connect (' fkong/[email protected]/orcl ')
8. cursor = Conn.cursor ()
12. Cursor.execute ("select * from TEST")
14. rows = Cursor.fetchall ()
16. For row in rows:
18. print "%d,%s,%s,%s"% (row[0], row[1], row[2], row[3])
22. Print "Number of rows returned:%d"% cursor.rowcount
26. Cursor.execute ("select * from TEST")
28. while (1):
30. row = Cursor.fetchone ()
32. if row = = None:
34. Break
36. print "%d,%s,%s,%s"% (row[0], row[1], row[2], row[3])
40. Print "Number of rows returned:%d"% cursor.rowcount
44. Cursor.close ()
46. Conn.close ()

Oracle database operations for Python combat