Do you want to connect your databases with Object-relational mapper capabilities in your Python Build Tools? This post will get to understand how to use SQLAlchemy Python Library using Python4Delphi in Delphi/C++ application. SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. Check out the SQLAlchemy overview here.
Python for Delphi (P4D) is a set of free components that wrap up the Python DLL into Delphi. They let you easily execute Python scripts, create new Python modules and new Python types. You can use Python4Delphi in a number of different ways such as:
- Create a Windows GUI around your existing Python app.
- Add Python scripting to your Delphi Windows apps.
- Add parallel processing to your Python apps through Delphi threads.
- Enhance your speed-sensitive Python apps with functions from Delphi for more speed.
What are the prerequisites to build Object Relational Mapper (ORM) apps?
- If not python and Python4Delphi is not installed on your machine, Check this how to run a simple python script in Delphi application using Python4Delphi sample app
- Open windows open command prompt, and type pip install -U SQLAlchemy to install SQLAlchemy. For more info for Installing Python Modules check here
- First, run the Demo1 project for executing Python script in Python for Delphi. Then load the SQLAlchemy sample script in the Memo1 field and press the Execute Script button to see the result. On Clicking Execute Button the script strings are executed using the below code. Go to GitHub to download the Demo1 source.
Is there an example or sample SQLAlchemy ORM Python script?
Here are the SQLAlchemy Python Library sample script details:
- Create an SQLAlchemy application object called the Engine. This object acts as a central source of connections to a particular database, providing both a factory as well as a holding space called a connection pool for these database connections. Here SQLLite database is used to connect.
- SQLAlchemy Expression Language that is the primary feature of SQLAlchemy, make use of one simple construct within this package called the
text()construct, which allows us to write SQL statements as textual SQL. - Create some_table and insert values into it, commit the transaction, retrieve the data and print it.
- Above were executed sql scripts using connection and the same can be performed by Executing with an ORM session.
- Creation of metadata, table ,column and adding constraints were included. Apart from these much more can be done such as table reflection, data manipulation ,etc. using SQLAlchemy library.
Note: Samples used for demonstration were picked from here with only the difference of printing the outputs to the Memo. You can check the APIs and some more samples from the same place. You can show the table values to grids as well.
You have read the quick overview of SQLAlchemy library, download this library from here, and connect to the database with object relational mapper capabilities in your applications. Check out Python4Delphi and easily build Python GUIs for Windows using Delphi.