Using Python to Operate Informix
To operate an Informix database using Python, you need to install the Informix database driver. Recommend using IBM_ DB or Pyodbc driver. Here we use IBM_ Take the db driver as an example to introduce it.
1. Install IBM_ DB driver:
pip install ibm_db
2. Connect to database:
python
import ibm_db
conn_str = 'DATABASE=your_database;HOSTNAME=your_host;PORT=your_port;PROTOCOL=TCPIP;UID=your_username;PWD=your_password;'
conn = ibm_db.connect(conn_str, '', '')
if conn:
print("Database connected successfully.")
else:
print("Failed to connect database.")
3. Insert data:
python
sql = "INSERT INTO your_table (column1, column2) VALUES (?, ?)"
stmt = ibm_db.prepare(conn, sql)
column1_value = "value1"
column2_value = "value2"
ibm_db.bind_param(stmt, 1, column1_value)
ibm_db.bind_param(stmt, 2, column2_value)
if ibm_db.execute(stmt):
print("Data inserted successfully.")
else:
print("Failed to insert data.")
ibm_db.close(stmt)
4. Query data:
python
sql = "SELECT * FROM your_table"
stmt = ibm_db.exec_immediate(conn, sql)
while ibm_db.fetch_row(stmt):
column1_value = ibm_db.result(stmt, 0)
column2_value = ibm_db.result(stmt, 1)
print(f"Column1: {column1_value}, Column2: {column2_value}")
ibm_db.close(stmt)
5. Modify data:
python
sql = "UPDATE your_table SET column1 = ? WHERE column2 = ?"
stmt = ibm_db.prepare(conn, sql)
column1_value = "new_value"
column2_value = "value2"
ibm_db.bind_param(stmt, 1, column1_value)
ibm_db.bind_param(stmt, 2, column2_value)
if ibm_db.execute(stmt):
print("Data updated successfully.")
else:
print("Failed to update data.")
ibm_db.close(stmt)
6. Delete data:
python
sql = "DELETE FROM your_table WHERE column1 = ?"
stmt = ibm_db.prepare(conn, sql)
column1_value = "value1"
ibm_db.bind_param(stmt, 1, column1_value)
if ibm_db.execute(stmt):
print("Data deleted successfully.")
else:
print("Failed to delete data.")
ibm_db.close(stmt)
The above is a basic example of using Python to operate an Informix database. Please make corresponding adjustments based on your actual situation.
