Site icon Embarcadero RAD Studio, Delphi, & C++Builder Blogs

InterBase and Python

the future of starts demands massive productivity

Author: Gabe Goldfield

 

Install PyDev using the Eclipse IDE

The instructions for installing PyDev are here:
http://www.pydev.org/manual_101_install.html

In the Eclipse IDE I chose Help > Install Updates and Entered the URL for PyDev

Install Python3.4

I chose the Windows x86 .msi installer from here
https://www.python.org/downloads/release/python-342/ and installed to C:Python34_2

Configure Eclipse to use Python

In Eclipse select Windows>Preferences

Under the Pydev tree, select PyDev> Interpreters> Python Interpreter

Click New and set the Python Interpreter name and executable to the previously install Python

 

 

Download the FDB 1.4.9 driver sources

The sources are available here
https://pypi.python.org/pypi/fdb

I extracted the sources to
C:fdb-1.4.9

Edit the sources to use the InterBase client library gds32.dll instead of the FireBird default library

There were 2 files that needed to be changed to work with Embarcadero InterBase XE7 instead of the Default FireBrid server.

Ibase.py
Starting at line 1163

Original

[crayon-672a37fc21165776038754/]

New

[crayon-672a37fc21171309806457/]

 

Starting at line 1479

Original

[crayon-672a37fc21173338532836/]

New

[crayon-672a37fc21175241014442/]

 

Fbcore.py

Starting at line 542

Original

[crayon-672a37fc21177461861273/]

New

[crayon-672a37fc21178899716907/]

 

Starting at line 923

Original

[crayon-672a37fc2117b535479019/]

New

[crayon-672a37fc2117c508704426/]

 

Starting at 1343

Original

[crayon-672a37fc2117e247635898/]

New

[crayon-672a37fc2117f289004161/]

 

Install the driver to your local Python Environment

After making the changes to ibase.py and fbcore.py, you are now ready to install the driver to your Python Environment.

From the commandline navigate to the fdb1.4.9 directory.
C:fdb-1.4.9>python.exe setup.py install

After installed you should see the message
Installed c:python34_2libsite-packagesfdb-1.4.9-py3.4.egg
Processing dependencies for fdb==1.4.9
Finished processing dependencies for fdb==1.4.9

Write a simple test to connect to InterBase in Eclipse

In Eclipse select file > new > project > PyDev > PyDev project

More complete instructions can be found here
http://www.pydev.org/manual_101_project_conf.html

After creating a blank Python module, I added this code.

[crayon-672a37fc21180948087959/]

 

This is all the code needed to import the driver, create a connection, create a cursor, select the data, and print the result.

After adding this code to a blank Python Module, select the Module > Run As > Python Run.

 

Exit mobile version