### ARM v7 Wheel File Examples

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux.md

Examples of wheel filenames for ARM v7 architecture and instructions to copy them to a prebuilt location.

```bash
######### ARM v7
# /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.1-cp27-cp27mu-linux_armv7l.whl
# /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl

# Python 3.x wheel build to the prebuilt location for ARM v7
# cp /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl /work/t1/IfxPy/prebuilt/3x/ARM/.
# md5sum /work/t1/IfxPy/prebuilt/3x/ARM/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl

# You may use pip install to install the driver from the whl file
# For example:
# pip3 install  /work/t1/IfxPy/prebuilt/3x/ARM/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl
# pip3 uninstall  /work/t1/IfxPy/prebuilt/3x/ARM/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl
```

--------------------------------

### Database Setup

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/Sample1.ipynb

Create a new database and a dedicated user with DBA privileges for the application.

```bash
dbaccess sysmaster <<EOF

create database db1 with log;

create user dbuser1 with password 'mypwd123' properties 
USER nobody authorization (DBSA);

GRANT CONNECT TO dbuser1;
GRANT DBA     TO dbuser1;

EOF
```

--------------------------------

### Install Wheel Package

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildWindows.md

Install the wheel package before building the wheel distribution. This is a prerequisite for creating the .whl file.

```bash
# Make sure you have installed wheel before doing the build
pip install wheel
```

--------------------------------

### Python 3.x Build Environment Setup

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildWindows.md

Configure environment variables for building IfxPy with Python 3.x. Ensure Visual Studio 2015 or later is installed.

```bat
# Open VS2015 (or latest) command windows

SET CSDK_HOME=c:\informix
SET MY_PY_DIR=C:\Dev\Anaconda

```

--------------------------------

### Install Wheel Package

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux.md

Install the wheel package using pip. This is a prerequisite for building wheel distributions.

```bash
# Make sure you have installed wheel before doing the build
pip install wheel
#pip3 install wheel
```

--------------------------------

### Compile and Install Python from Source

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Compiles and installs the Python interpreter from its source code after configuration. This command should be run from the Python source directory.

```bash
cd /work/dev/Python
sudo ./configure --enable-unicode=ucs4
sudo make

sudo make install
```

--------------------------------

### Install Local Wheel Build

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Installs the IfxPy driver from a locally built wheel file using pip3. Includes commands for both installation and uninstallation.

```bash
# You may use the whl file you have just built

sudo pip3 install /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.2-cp37-cp37m-manylinux1_x86_64.whl
# sudo pip3 uninstall /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.2-cp37-cp37m-manylinux1_x86_64.whl
```

--------------------------------

### Install Prebuilt Wheel Package (Python 3.x)

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildWindows.md

Installs a prebuilt wheel package for the IfxPy driver on Python 3.x using pip.

```bash
pip install C:\work\IfxPy\prebuilt\3x\Win64\IfxPy-3.0.1-cp36-cp36m-win_amd64.whl
```

--------------------------------

### Setup Graph Dataset Tables

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/cte.ipynb

Creates and populates 'loc' and 'road' tables to represent a graph dataset for pathfinding queries.

```sql
cur.execute("drop table if exists loc;")
cur.execute("create table loc (id int, name char(10));")
cur.execute("insert into loc values (1, 'A');")
cur.execute("insert into loc values (2, 'B');")
cur.execute("insert into loc values (3, 'C');")
cur.execute("insert into loc values (4, 'D');")
cur.execute("insert into loc values (5, 'E');")
cur.execute("insert into loc values (6, 'F');")
cur.execute("create index loc_idx1 on loc(id);")
cur.execute("create index loc_idx2 on loc(name);")

cur.execute("drop table if exists road;")
cur.execute("create table road(start int, end int, cost int);")
cur.execute("insert into road values (1, 2, 50);")
cur.execute("insert into road values (1, 3, 50);")
cur.execute("insert into road values (1, 4, 100);")
cur.execute("insert into road values (2, 4, 40);")
cur.execute("insert into road values (3, 4, 40);")
cur.execute("insert into road values (3, 5, 80);")
cur.execute("insert into road values (4, 5, 30);")
cur.execute("insert into road values (4, 6, 80);")
cur.execute("insert into road values (5, 6, 40);")
cur.execute("create index road_idx1 on road(start, end);")
```

--------------------------------

### Install IfxPy Driver

Source: https://github.com/openinformix/ifxpy/blob/master/README.md

Install the IfxPy driver using pip or pip3. This command installs the driver and its dependencies.

```bash
pip install ifxpy
or  # if Python 3.x then
pip3 install ifxpy
```

--------------------------------

### Build and Install Wheel Package

Source: https://github.com/openinformix/ifxpy/blob/master/prebuilt/README.md

Steps to build a wheel package for IfxPy using pip and wheel, and instructions for installing or uninstalling the driver from a wheel file.

```bash
# Make sure you have installed wheel before doing the build
pip install wheel
#pip3 install wheel

cd /work/t1/IfxPy/IfxPy
python setup.py bdist_wheel
#python3 setup.py bdist_wheel

# On successful build, it would have created the whl file under dist folder. 
# For example : 
# /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.1-cp27-cp27mu-linux_armv7l.whl
# /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl

# Python 3.x wheel build to the prebuilt location for ARM v7
# cp /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl /work/t1/IfxPy/prebuilt/3x/ARM/.
# md5sum /work/t1/IfxPy/prebuilt/3x/ARM/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl

# YOu may use pip intall to install the driver from the whl file
# For example:
# pip3 install  /work/t1/IfxPy/prebuilt/3x/ARM/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl
# pip3 uninstall  /work/t1/IfxPy/prebuilt/3x/ARM/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl
```

--------------------------------

### Install IFXPY Driver

Source: https://github.com/openinformix/ifxpy/blob/master/notes/SolarisBuild-note1.md

Installs the IFXPY driver using pip from the previously built wheel file. Ensure the path to the wheel file is correct.

```bash
pip install ../prebuilt/27x/Linux64/IfxPy-2.7.1-cp27-cp27mu-solaris_2_11_sun4v_32bit.whl
```

--------------------------------

### Configure and Build Python from Source

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux.md

Configures Python with UCS4 Unicode support, compiles it, and installs it. The Python executable path should be added to the system's PATH.

```bash
$cd /work/dev/Python
$sudo ./configure --enable-unicode=ucs4
$sudo make

$sudo make install

# /work/dev/Python to be added to the path
# install is not needed for driver build thouhg
# sudo altinstall
```

--------------------------------

### Build Environment Setup

Source: https://github.com/openinformix/ifxpy/blob/master/notes/SolarisBuild-note1.md

Configures essential environment variables for building the IFXPY driver, including CSDK paths, library paths, and INFORMIX server details.

```bash
export CSDK_HOME=/informix_1/cs/csdk
export MY_PY_DIR=/opt/csw/bin
export PATH=/opt/csw/bin:/informix_1/cs/csdk/bin:/usr/bin:/usr/bin:$PATH
export INFORMIXDIR=/informix_1/cs/csdk
export LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/cli
export INFORMIXSQLHOSTS=/informix_1/cs/csdk/etc/sqlhosts
INFORMIXSERVER=DEVELOPMENT_IT
```

--------------------------------

### Informix Database Connection Example

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/cte.ipynb

This snippet shows how to establish a connection to an Informix database using IFXPY. Ensure you have the necessary connection parameters.

```python
import ifxdb

# Connection parameters (replace with your actual details)
conn_str = "SERVER=ids_server;DATABASE=testdb;USERID=informix;PASSWORD=password"

try:
    conn = ifxdb.connect(conn_str)
    print("Successfully connected to Informix database.")
    # Perform database operations here
    conn.close()
except ifxdb.Error as e:
    print(f"Error connecting to Informix database: {e}")
```

--------------------------------

### Python 2.7 Build Environment Setup

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildWindows.md

Configure environment variables for building IfxPy with Python 2.7. This includes setting VS90COMNTOOLS to point to your Visual Studio installation.

```bat
# Open VS2008 (or latest) command windows
# set VS90COMNTOOLS if you are using latest vs, for eg, vs2015 then
SET VS90COMNTOOLS=%VS140COMNTOOLS%

SET CSDK_HOME=c:\informix
SET MY_PY_DIR=C:\Dev\Python27
```

--------------------------------

### Verify and Copy Wheel File

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux.md

Verify the created wheel file and copy it to a prebuilt location. This example shows the path for a Python 3.x build on Linux x86_64.

```bash
# On successful build, it would have created the whl file under dist folder.
# For example :
########### Python 3.x build on Linux x86 64
ls /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.1-cp35-cp35m-linux_x86_64.whl
# Copy the binary to prebuild (if you are refreshing the prebuild binary)
cp /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.1-cp35-cp35m-linux_x86_64.whl /work/t1/IfxPy/prebuilt/3x/Linux64/.
# FYI: to install
# pip3 install /work/t1/IfxPy/prebuilt/3x/Linux64/IfxPy-3.0.1-cp35-cp35m-linux_x86_64.whl
```

--------------------------------

### Execute Table Setup SQL

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/Sample1.ipynb

Iterate through the list of SQL statements to create the table and insert records. Tracks the number of records inserted.

```python
# let us create few records in the table
i = 0
for sql in SetupSqlSet:
    i += 1
    print (sql)
    stmt = IfxPy.exec_immediate(conn, sql)
    
# The first record executed is for create table
i -= 1
```

--------------------------------

### Install Python Libraries for Informix Data Analysis

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/ifx_pandas.ipynb

Install necessary Python libraries including numpy, pandas, and jupyter for data manipulation and analysis with Informix.

```bash
pip3 install numpy
pip3 install pandas
pip3 install jupyter
```

--------------------------------

### Using Transactions

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/cte.ipynb

This example illustrates how to manage database transactions using IFXPY, including committing and rolling back changes.

```python
import ifxdb

conn_str = "SERVER=ids_server;DATABASE=testdb;USERID=informix;PASSWORD=password"

try:
    conn = ifxdb.connect(conn_str)
    cursor = conn.cursor()
    
    # Start a transaction implicitly
    
    # Perform operations within the transaction
    cursor.execute("INSERT INTO orders (order_date, customer_id) VALUES (CURRENT, 101)")
    cursor.execute("UPDATE products SET stock = stock - 1 WHERE product_id = 50"))
    
    # If all operations are successful, commit the transaction
    conn.commit()
    print("Transaction committed successfully.")
    
    cursor.close()
    conn.close()
except ifxdb.Error as e:
    print(f"Transaction failed: {e}")
    # If any operation fails, rollback the transaction
    if conn:
        conn.rollback()
        print("Transaction rolled back.")
```

--------------------------------

### Set Environment Variables for Driver Build

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Sets essential environment variables for building the IfxPy driver. CSDK_HOME should point to the Informix Connect SDK installation, and MY_PY_DIR to the Python installation directory.

```bash
# sudo ln -s /home/informix/1210UC9 /work/informix
# Assuming 'CSDK' is installed at /work/informix
export CSDK_HOME=/work/informix
export MY_PY_DIR=/work/dev/Python
export PATH=/work/dev/Python:$PATH
```

--------------------------------

### Python DB API Example: Parameterized Queries

Source: https://github.com/openinformix/ifxpy/blob/master/README.md

Illustrates how to use parameterized queries with `execute` for safe and efficient updates and selections. This helps prevent SQL injection vulnerabilities.

```Python
#-- -- -- -- --
#-- -- -- -- --
c1_val = 4
cur.execute("UPDATE t1 SET c2 = 'Wednesday!' WHERE c1 = (?)", (c1_val,))
conn.commit()

c3_val = 1004
cur.execute("UPDATE t1 SET c3 = (?) WHERE c1 = 4", (c3_val,))
conn.commit()

cur.execute("select * FROM t1 WHERE c1 = ?", (c1_val,))
row = cur.fetchone()
print ( "value = ", row)
#-- -- -- -- --
#-- -- -- -- --

```

--------------------------------

### Install IfxPy Driver from Wheel Package

Source: https://github.com/openinformix/ifxpy/blob/master/TmpInstallFromPrebuiltBinary.md

Install the IfxPy driver using PIP with the downloaded Wheel Package. This command is specific to the target architecture (ARM, Linux x86_64, or Windows 64-bit).

```bash
# if ARM v7
pip3 install IfxPy/prebuilt/3x/ARM/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl
# if Linux_x86_64
pip3 install IfxPy/prebuilt/3x/Linux64/IfxPy-3.0.1-cp35-cp35m-linux_x86_64.whl
# if Win64
pip3 install IfxPy\prebuilt\3x\Win64\IfxPy-3.0.1-cp36-cp36m-win_amd64.whl
```

--------------------------------

### Set Informix Client SDK Runtime Environment on Windows

Source: https://github.com/openinformix/ifxpy/blob/master/RunTests.md

Configures the system's PATH environment variable to include the Informix Client SDK's bin directory on Windows. Assumes CSDK is installed at C:\informix.

```bat
SET PATH=C:\informix\bin;%PATH%
```

--------------------------------

### Setup Employee Table for Hierarchic Data

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/cte.ipynb

Drops the 'employee' table if it exists, creates it with employee ID, name, and manager ID, and inserts sample hierarchical data.

```python
cur.execute("drop table if exists employee;")

cur.execute("""CREATE TABLE employee(
                      empid  INTEGER NOT NULL PRIMARY KEY,
                      name   CHAR(10),
                      mgrid  INTEGER
);""")

cur.execute("INSERT INTO employee VALUES  ( 1, 'Jones',     10);")
cur.execute("INSERT INTO employee VALUES  ( 2, 'Hall',      10);")
cur.execute("INSERT INTO employee VALUES  ( 3, 'Kim',       10);")
cur.execute("INSERT INTO employee VALUES  ( 4, 'Lindsay',   10);")
cur.execute("INSERT INTO employee VALUES  ( 5, 'McKeough',  11);")
cur.execute("INSERT INTO employee VALUES  ( 6, 'Barnes',    11);")
cur.execute("INSERT INTO employee VALUES  ( 7, 'ONeil',     12);")
cur.execute("INSERT INTO employee VALUES  ( 8, 'Smith',     12);")
cur.execute("INSERT INTO employee VALUES  ( 9, 'Shoeman',   12);")
cur.execute("INSERT INTO employee VALUES  (10, 'Monroe',    15);")
cur.execute("INSERT INTO employee VALUES  (11, 'Zander',    16);")
cur.execute("INSERT INTO employee VALUES  (12, 'Henry',     16);")
cur.execute("INSERT INTO employee VALUES  (13, 'Aaron',     15);")
cur.execute("INSERT INTO employee VALUES  (14, 'Scott',     16);")
cur.execute("INSERT INTO employee VALUES  (15, 'Mills',     17);")
cur.execute("INSERT INTO employee VALUES  (16, 'Goyal',     17);")
cur.execute("INSERT INTO employee VALUES  (17, 'Urbassek',  NULL);")
```

--------------------------------

### Locate Built Wheel File

Source: https://github.com/openinformix/ifxpy/blob/master/notes/SolarisBuild-note1.md

Lists the generated wheel file in the 'dist' directory after a successful build. This file is used for installation.

```bash
ls -lrt ./dist/*whl
```

--------------------------------

### Build Wheel for Python 3.x (ARM)

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Builds a wheel package for the IfxPy driver using Python 3.x on ARM architecture. Ensure the 'wheel' package is installed.

```bash
# Make sure you have installed wheel before doing the build
python setup.py bdist_wheel
# On successful build, it would have created the 'whl' file under '/work/t1/IfxPy/IfxPy/dist' folder.
```

--------------------------------

### Build Wheel for Python 2.7 (x86_64 and ARM)

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Builds a wheel package for the IfxPy driver using Python 2.7. Ensure the 'wheel' package is installed.

```bash
# Make sure you have installed wheel before doing the build
python setup.py bdist_wheel

# On successful build, it would have created the 'whl' file under '/work/t1/IfxPy/IfxPy/dist' folder.
ls -l /work/t1/IfxPy/IfxPy/dist
```

--------------------------------

### Build Wheel for Python 3.x (Linux x86_64)

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Builds a wheel package for the IfxPy driver for Python 3.x on Linux x86_64, specifying the platform tag. Ensure the 'wheel' package is installed.

```bash
# Make sure you have installed wheel before doing the build
python3 setup.py bdist_wheel  --plat-name manylinux1_x86_64

# On successful build, it would have created the whl file under '/work/t1/IfxPy/IfxPy/dist' folder.
ls /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.2-cp37-cp37m-manylinux1_x86_64.whl

# FYI: to install the newly build driver binary on your system then
# pip3 install /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.2-cp37-cp37m-manylinux1_x86_64.whl
# pip3 uninstall /work/t1/IfxPy/IfxPy/dist/IfxPy-3.0.2-cp37-cp37m-manylinux1_x86_64.whl
```

--------------------------------

### Python DB API Example: Basic CRUD Operations

Source: https://github.com/openinformix/ifxpy/blob/master/README.md

Demonstrates connecting to a database, creating a table, inserting multiple rows, committing changes, fetching all rows, and closing the connection using Python DB API v2.0.

```Python
import IfxPyDbi as dbapi2

ConStr = "SERVER=ids0;DATABASE=db1;HOST=127.0.0.1;SERVICE=9088;UID=informix;PWD=xxxx;"

conn = dbapi2.connect( ConStr, "", "")
cur = conn.cursor()

try:
    stmt = cur.execute('drop table t1;')
except:
    print ('FYI: drop table failed')

cur.execute('create table t1 ( c1 int, c2 char(20), c3 int, c4 int ) ')

cur.execute("insert into t1 values( 1, 'Sunday', 101, 201 )")
cur.execute("insert into t1 values( 2, 'Monday', 102, 202 )")
cur.execute("insert into t1 values( 3, 'Tuesday', 103, 203 )")
cur.execute("insert into t1 values( 4, 'Wednesday', 104, 204 )")
cur.execute("insert into t1 values( 5, 'Thursday', 105, 2005 )")
cur.execute("insert into t1 values( 6, 'Friday', 106, 206 )")
cur.execute("insert into t1 values( 7, 'Saturday', 107, 207 )

conn.commit ()

cur.execute ("SELECT * FROM t1")
rows = cur.fetchall()
for i, row in enumerate(rows):
    print ("Row", i, "value = ", row)

cur.close()

conn.close()
print ("Done")

```

--------------------------------

### Python DB API Example: Bulk Inserts with executemany

Source: https://github.com/openinformix/ifxpy/blob/master/README.md

Shows how to efficiently insert multiple records into a table using the `executemany` method with a list of tuples. This is useful for bulk data loading.

```Python
#-- -- -- -- --
#-- -- -- -- --
cur.execute('create table t1 ( c1 int, c2 char(20), c3 int, c4 int ) ')
days = [ (1, 'Sunday',  101, 201),
         (2, 'Monday',  102, 202),
         (3, 'Tuesday', 103, 203),
         (4, 'Wednesday', 104, 204),
         (5, 'Thursday', 105, 205),
         (6, 'Friday', 106, 206),
         (7, 'Saturday', 1027, 207),
       ]
cur.executemany('INSERT INTO t1 VALUES (?,?,?,?)', days)
conn.commit ()
#-- -- -- -- --
#-- -- -- -- --

```

--------------------------------

### Python 3.x Prebuilt Binaries (Wheel Package)

Source: https://github.com/openinformix/ifxpy/blob/master/TmpInstallFromPrebuiltBinary.md

Locate the prebuilt driver binaries for Python 3.x in Wheel Package format. These are compatible with Python Enhancement Proposals (PEPs) and are typically installed via PIP.

```bash
IfxPy/prebuilt/3x/ARM/IfxPy-3.0.1-cp35-cp35m-linux_armv7l.whl
IfxPy/prebuilt/3x/Linux64/IfxPy-3.0.1-cp35-cp35m-linux_x86_64.whl
IfxPy\prebuilt\3x/Win64\IfxPy-3.0.1-cp36-cp36m-win_amd64.whl
```

--------------------------------

### Prepare Configuration File

Source: https://github.com/openinformix/ifxpy/blob/master/RunTests.md

Copies a sample configuration file to be used for setting up connection properties. This is a preliminary step before running tests.

```bash
cd /work/t1/IfxPy/IfxPy
cp   config.py.sample   config.py
```

--------------------------------

### Run IfxPy Sample Application

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux.md

Navigates to the sample directory, edits the Sample.py connection information, and then executes the sample script using Python.

```bash
# '/work/dev/Python' has added to the path, then
# $ which python
# /work/dev/Python/python

cd /work/try/
vi Sample.py
# Edit Sample.py connection information, and then run
python Sample.py

```

--------------------------------

### Set PATH and Run Sample Application

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildWindows.md

Sets the Informix bin directory in the PATH environment variable and then runs the sample Python application.

```bash
set PATH=C:\Informix\bin;%PATH%

# Edit Sample.py connection information, and then run
python Sample.py
```

--------------------------------

### Copy Sample Application Source

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildWindows.md

Copies the sample application source file to the current directory for local testing.

```bash
cd C:\work\IfxPy\try
######### copy sample application source ####################
copy C:\work\IfxPy\Examples\Sample1.py  Sample.py
```

--------------------------------

### Python Version Check

Source: https://github.com/openinformix/ifxpy/blob/master/notes/SolarisBuild-note1.md

Verifies the installed Python version and its location. Ensure Python 2.7.11 is installed in '/opt/csw/bin'.

```bash
python -V => Python 2.7.11 and it is installed in "/opt/csw/bin"
ls -lrt /opt/csw/bin/py*
```

--------------------------------

### Prepare for Local Build Test

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux.md

Copy a sample Python script and remove any existing IfxPy.so files to prepare for testing a local build.

```bash
cd /work/try/
cp /work/t1/IfxPy/Examples/Sample1.py Sample.py

rm IfxPy.so
# rm *.so
```

--------------------------------

### Build IfxPy Driver

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildWindows.md

Execute the build command for IfxPy using setup.py. This command is common for both Python 2.7 and 3.x builds. Output is redirected to out.txt.

```bash
# common for Python 2.7 and 3.x
cd C:\work\IfxPy\IfxPy
python setup.py build > out.txt 2>&1
```

--------------------------------

### IfxPy.get_option

Source: https://github.com/openinformix/ifxpy/blob/master/README.md

Gets the specified option in the resource.

```APIDOC
## IfxPy.get_option

### Description
Gets the specified option in the resource.

### Method
Not specified (assumed to be a function call within the IfxPy module).

### Parameters
Not specified in the source text.
```

--------------------------------

### IfxPy.get_smart_trigger_session_id

Source: https://github.com/openinformix/ifxpy/blob/master/README.md

Get already opened Smart Trigger session ID

```APIDOC
## IfxPy.get_smart_trigger_session_id

### Description
Get already opened Smart Trigger session ID.

### Method
Not specified (assumed to be a function call within the IfxPy module).

### Parameters
Not specified in the source text.
```

--------------------------------

### Run IfxPy Sample

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Executes a sample Python script to test the IfxPy driver. This involves copying a sample file, editing connection information, and running the script with either python or python3.

```bash
cd /work/try/
cp /work/t1/IfxPy/Examples/Sample1.py Sample.py

# Edit Sample.py connection information, 
vi Sample.py

# and then run the sample
python Sample.py
# or if Pythong 3.x
python3 Sample.py
```

--------------------------------

### Clean Build Directories

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Removes the build and distribution directories before starting a new build.

```bash
cd /work/t1/IfxPy/IfxPy
rm -rf /work/t1/IfxPy/IfxPy/build
rm -rf /work/t1/IfxPy/IfxPy/dist
```

--------------------------------

### Register Smart Trigger with Callback Functions

Source: https://github.com/openinformix/ifxpy/blob/master/README.md

This sample demonstrates how to set up and register smart triggers using multiple threads. It includes defining callback functions to handle trigger events and opening a smart trigger with specific parameters.

```python
# test_SmartTrigger.py
import IfxPy
from ctypes import *
import threading
import os

def printme1(outValue1):
   """This prints a passed string into this function1"""
   print ("\nTest for callback function, value = ", outValue1)
   return

def printme2(outValue2):
   """This prints a passed string into this function2"""
   print ("\nTest for callback function, value = ", outValue2)
   return
 
def task1():
    print("Task 1 assigned to thread: {}".format(threading.current_thread().name))
    print("ID of process running task 1: {}".format(os.getpid()))
    temp4 = IfxPy.register_smart_trigger_loop(conn, printme1, temp, "t1", "informix", "sheshdb", "select * from t1;", "label1", False, False)
    #temp4 = IfxPy.register_smart_trigger_loop(conn, printme1, temp, "बस", "informix", "sheshdb_utf8", "select * from बस;", "label1", False, False)
 
def task2():
    print("Task 2 assigned to thread: {}".format(threading.current_thread().name))
    print("ID of process running task 2: {}".format(os.getpid()))
    #temp5 = IfxPy.register_smart_trigger_loop(conn, printme2, temp, "t2", "informix", "sheshdb", "select * from t2;", "label2", False, False)
    temp5 = IfxPy.register_smart_trigger_loop(conn, printme2, temp, "t2", "informix", "sheshdb_utf8", "select * from t2;", "label2", False, False)
 
# if __name__ == "__main__":
             
# ConStr = "SERVER=ol_informix1410;DATABASE=sheshdb_utf8;HOST=127.0.0.1;SERVICE=1067;UID=informix;PWD=xxxx;DB_LOCALE=en_us.utf8;CLIENT_LOCALE=en_us.UTF8;"
ConStr = "SERVER=ol_informix1410;DATABASE=sheshdb;HOST=127.0.0.1;SERVICE=1067;UID=informix;PWD=xxx;"

conn = IfxPy.connect( ConStr, "", "")

temp = IfxPy.open_smart_trigger(conn, "Unique1", False, 5, 1, 0)
print ("\nFile descriptor = ", temp)
 
# creating threads
t1 = threading.Thread(target=task1, name='t1')
t2 = threading.Thread(target=task2, name='t2')  
 
# starting threads
t1.start()
t2.start()
 
# wait until all threads finish
t1.join()
t2.join()

IfxPy.close(conn)
print ("Done")

```

--------------------------------

### Get Cursor Type

Source: https://github.com/openinformix/ifxpy/wiki/Home

Retrieves the cursor type of an IFXStatement to determine if it's forward-only or scrollable.

```python
int IfxPy.cursor_type ( IFXStatement stmt )
```

--------------------------------

### Display Thank You Message

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/cte.ipynb

This snippet prints a thank you message to the console. It requires no special setup or imports.

```python
print("Thank you!")
```

--------------------------------

### Generate Julia Set in Python

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/cte.ipynb

This Python code generates a Julia Set fractal image. It is a port from a PostgreSQL example.

```python
# Query to generate a Julia Set (a beautiful tree like image)
# port from PostgreSQL https://explainextended.com/2013/12/31/happy-new-year-5/

```

--------------------------------

### Executing a Simple SQL Query

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/cte.ipynb

Demonstrates how to execute a simple SQL query and fetch results using IFXPY. This is a fundamental operation for data retrieval.

```python
import ifxdb

conn_str = "SERVER=ids_server;DATABASE=testdb;USERID=informix;PASSWORD=password"

try:
    conn = ifxdb.connect(conn_str)
    cursor = conn.cursor()
    
    # Execute a query
    cursor.execute("SELECT first_name, last_name FROM customers WHERE customer_id = 101")
    
    # Fetch one row
    row = cursor.fetchone()
    if row:
        print(f"Customer Name: {row[0]} {row[1]}")
    
    cursor.close()
    conn.close()
except ifxdb.Error as e:
    print(f"Error executing query: {e}")
```

--------------------------------

### Update and Install pip for Python 2.7

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Installs/upgrades pip for Python 2.7. Ensure pip version 10.0.1 or higher is used.

```bash
##### if python 2.7
#sudo apt install python-pip
pip install --upgrade pip
pip --version
```

--------------------------------

### Legacy Build Process

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Performs a legacy build of the IfxPy driver without using wheel packages. This method is not recommended. It involves cleaning the build directory and running 'setup.py build'.

```bash
cd /work/t1/IfxPy/IfxPy
rm -rf build

# '/work/dev/Python' has added to the path, then
# export PATH=/work/dev/Python:$PATH
# $ which python
# /work/dev/Python/python
# pip install setuptools
python setup.py build > out.txt 2>&1
#python3 setup.py build > out.txt 2>&1

# if all go well, then Informix native python driver will be at

# if Linux x86_64bit with Python 2.7 build then
ls -l ./build/lib.linux-x86_64-2.7/IfxPy.so

# if ARM v7 with Python 2.7 then
ls -l build/lib.linux-armv7l-2.7/IfxPy.so

# if Linux x86_64bit with Python 3.x build then
# ls -l ./build/lib.linux-x86_64-3.5/IfxPy.cpython-35m-x86_64-linux-gnu.so

# on armv7 with Python 3.x
# ls -l ls ./build/lib.linux-armv7l-3.5/IfxPy.cpython-35m-arm-linux-gnueabihf.so
```

--------------------------------

### Logon to the VM

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/Sample1.ipynb

Connect to the Informix server VM using SSH and switch to the informix user.

```bash
ssh demo1@168.61.54.126

# Switch to user informix
sudo -u informix bash
```

--------------------------------

### Get Informix Statement Cursor Type

Source: https://github.com/openinformix/ifxpy/blob/master/README.IfxPyAPI.md

Retrieves the cursor type used by an IFXStatement. This helps determine if the cursor is forward-only or scrollable.

```python
cursor_type = IfxPy.cursor_type(stmt)
```

--------------------------------

### Deleting Data from a Table

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/cte.ipynb

This example shows how to delete records from an Informix table using IFXPY. Parameter binding is crucial for safe deletion.

```python
import ifxdb

conn_str = "SERVER=ids_server;DATABASE=testdb;USERID=informix;PASSWORD=password"

try:
    conn = ifxdb.connect(conn_str)
    cursor = conn.cursor()
    
    # ID of the record to delete
    customer_id_to_delete = 102
    
    # SQL statement with placeholder
    sql = "DELETE FROM customers WHERE customer_id = ?"
    
    # Execute the delete statement with data
    cursor.execute(sql, (customer_id_to_delete,))
    conn.commit() # Commit the transaction
    
    print(f"Customer ID {customer_id_to_delete} deleted successfully.")
    
    cursor.close()
    conn.close()
except ifxdb.Error as e:
    print(f"Error deleting data: {e}")
    if conn:
        conn.rollback() # Rollback on error
```

--------------------------------

### Display Employee Hierarchy Image

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/cte.ipynb

Displays an image representing the employee hierarchy, likely used in conjunction with the following recursive CTE example.

```python
from IPython.display import display, Image
display(Image(filename='employee.png'))
```

--------------------------------

### Insert Data with Parameter Binding

Source: https://github.com/openinformix/ifxpy/blob/master/README.md

Demonstrates inserting data using prepared statements and parameter binding with basic data types like INTEGER and CHAR. Use IfxPy.bind_param to associate Python variables with SQL parameters and IfxPy.execute to run the statement.

```python
# Sample2.py
import IfxPy


def my_Sample():
    ConStr = "SERVER=ids0;DATABASE=db1;HOST=127.0.0.1;SERVICE=9088;UID=informix;PWD=xxxxx;"

    try:
        # netstat -a | findstr  9088
        conn = IfxPy.connect( ConStr, "", "")
    except Exception as e:
        print ('ERROR: Connect failed')
        print ( e )
        quit()


    try:
        sql = "drop table t1;"
        print ( sql )
        stmt = IfxPy.exec_immediate(conn, sql)
    except:
        print ('FYI: drop table failed')

    sql = "create table t1 ( c1 int, c2 char(20), c3 int, c4 int ) ;"
    stmt = IfxPy.exec_immediate(conn, sql)


    sql = "INSERT INTO t1 (c1, c2, c3, c4) VALUES ( ?, ?, ?, ? )"
    stmt = IfxPy.prepare(conn, sql)

    c1 = None
    c2 = None
    c3 = None
    c4 = None
    # Create bindings for the parameter
    IfxPy.bind_param(stmt, 1, c1, IfxPy.SQL_PARAM_INPUT, IfxPy.SQL_INTEGER)
    IfxPy.bind_param(stmt, 2, c2, IfxPy.SQL_PARAM_INPUT, IfxPy.SQL_CHAR)
    IfxPy.bind_param(stmt, 3, c1, IfxPy.SQL_PARAM_INPUT, IfxPy.SQL_INTEGER)
    IfxPy.bind_param(stmt, 4, c1, IfxPy.SQL_PARAM_INPUT, IfxPy.SQL_INTEGER)

    print("Inserting Recors ……")
    i = 0
    while i < 10:
        i += 1
        c1 = 100 + i
        c2 = "Testing {0}".format(i)
        c3 = 20000 + i
        c4 = 50000 + i
        # supply new values as a tuple
        IfxPy.execute(stmt, (c1, c2, c3, c4) )


    # Try select those rows we have just inserted
    print("Selecting Recors ……")
    sql = "SELECT * FROM t1"
    stmt = IfxPy.exec_immediate(conn, sql)
    tu = IfxPy.fetch_tuple(stmt)
    rc = 0
    while tu != False:
        rc += 1
        print( tu )
        tu = IfxPy.fetch_tuple(stmt)

    print()
    print( "Total Record Inserted {}".format(i) )
    print( "Total Record Selected {}".format(rc) )

    # Free up memory used by result and then stmt too
    IfxPy.free_result(stmt)
    IfxPy.free_stmt (stmt)

    # close the connection
    IfxPy.close(conn)

    print ("Done")

####### Run the sample function ######
my_Sample()

```

--------------------------------

### Configure and Build Python 3.7.1 from Source (UCS4)

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Downloads, extracts, and configures Python 3.7.1 source code for UCS4 Unicode encoding. Assumes build environment is set up in /work/dev.

```bash
cd /work/dev

rm ./Python
sudo rm -rf ./Python-3.7.1

wget https://www.python.org/ftp/python/3.7.1/Python-3.7.1.tgz

tar zxvf Python-3.7.1.tgz

ln -s  ./Python-3.7.1  ./Python

cd /work/dev/Python
sudo ./configure --enable-unicode=ucs4
```

--------------------------------

### Upgrade Build Tools for Python 3.x

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux.md

Upgrades setuptools, wheel, and twine to their latest versions for Python 3.x builds.

```bash
# if python 3.x
sudo pip3 install setuptools --upgrade
sudo pip3 install wheel --upgrade
sudo pip3 install twine --upgrade
pip3 install --upgrade pip
```

--------------------------------

### Map Visual Studio Version for Python 2.7 Build

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildWindows.md

When building with Python 2.7, setup.py looks for Visual Studio 2008. Map the VSxxCOMNTOOLS variable to VS90COMNTOOLS if you are using a different version of Visual Studio.

```bash
#For example:   
#If you are using Visual Studio 2010 (VS10):  
SET VS90COMNTOOLS=%VS100COMNTOOLS%  

#If you are using Visual Studio 2012 (VS11):   
SET VS90COMNTOOLS=%VS110COMNTOOLS%  

#If you are using Visual Studio 2013 (VS12):   
SET VS90COMNTOOLS=%VS120COMNTOOLS%  

#If you are using Visual Studio 2015 (VS14):   
SET VS90COMNTOOLS=%VS140COMNTOOLS%  

#If you are using Visual Studio 2017 (VS15):   
SET VS90COMNTOOLS=%VS150COMNTOOLS%
```

--------------------------------

### Update and Install pip for Python 3

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildLinux_v2.md

Updates system packages and installs/upgrades pip for Python 3. Ensure pip version 10.0.1 or higher is used.

```bash
sudo apt update

#### For Python 3
# sudo apt install python3-pip
# python3 -m pip install --upgrade pip
# sudo python3 -m pip uninstall pip
pip3 install --upgrade pip
pip3 --version
```

--------------------------------

### Clone IfxPy Repository

Source: https://github.com/openinformix/ifxpy/blob/master/TmpInstallFromPrebuiltBinary.md

Clone the IfxPy repository to access prebuilt driver binaries. This is a common first step for both Python 2.7 and Python 3.x installations.

```bash
git clone https://github.com/OpenInformix/IfxPy.git
```

--------------------------------

### Copy Prebuilt Driver Binary Zip (Python 3.x)

Source: https://github.com/openinformix/ifxpy/blob/master/LocalBuildWindows.md

Copies a prebuilt driver binary zip file for Python 3.x. This can then be unzipped.

```bash
COPY  C:\work\IfxPy\prebuilt\3x\Win64\IfxPy.zip
# then unzip it
```

--------------------------------

### Inserting Data into a Table

Source: https://github.com/openinformix/ifxpy/blob/master/Examples/cte.ipynb

This example shows how to insert new data into an Informix table using IFXPY. It includes parameter binding to prevent SQL injection.

```python
import ifxdb

conn_str = "SERVER=ids_server;DATABASE=testdb;USERID=informix;PASSWORD=password"

try:
    conn = ifxdb.connect(conn_str)
    cursor = conn.cursor()
    
    # Data to insert
    new_customer_data = ('John', 'Doe', 'john.doe@example.com')
    
    # SQL statement with placeholders
    sql = "INSERT INTO customers (first_name, last_name, email) VALUES (?, ?, ?)"
    
    # Execute the insert statement with data
    cursor.execute(sql, new_customer_data)
    conn.commit() # Commit the transaction
    
    print("New customer inserted successfully.")
    
    cursor.close()
    conn.close()
except ifxdb.Error as e:
    print(f"Error inserting data: {e}")
    if conn:
        conn.rollback() # Rollback on error
```