Project Description

A Python program that runs a SQL script stored in a text file against a PostgreSQL, MS-Access, SQLite, MS-SQL-Server, MySQL, MariaDB, Firebird, or Oracle database, or an ODBC DSN. execsql also supports a set of special commands (metacommands) that can import and export data, copy data between databases, conditionally execute SQL statements and metacommands, display data to the user, and prompt the user for additional information.

Different DBMSs and DBMS-specific client programs provide different and incompatible extensions to the SQL language, ordinarily to allow interactions with the file system and to allow conditional tests and looping. Some DBMSs do not have any native extensions of this sort. execsql provides these features, as well as features for user interaction, in an identical fashion for all supported DBMSs.

execsql's metacommands make up a control language that works the same across all supported DBMSs, and can be used to create both automated and interactive data processing applications. Metacommands are embedded in SQL comments, so they will be ignored by other script processors (e.g., psql for Postgres and sqlcmd for SQL Server).

execsql also supports substitution variables: words that can be replaced with alternate text anywhere within a SQL statement or metacommand. Substitution variables can be used for configuration settings, data values extracted from the database, or user input.

Whereas SQL is often embedded in programs written in other languages, execsql inverts this paradigm through the use of metacommands embedded in SQL scripts. This approach allows database operations to be interleaved with user interactions and file system access in a way that may be easier to develop, easier to re-use, and more accessible to multiple users than embedded SQL in a high-level programming language.

Instalar can be installed as an executable script from the Python Package Index (PyPI) using pip:     `pip install execsql` Alternatively the file can be downloaded from... Show How to Install


Complete documentation describing execsql's features and usage is at . Show Usage


win32 Windows (Fecha: 2023-04-19, Tamaño: 582.98 KB)
linux Linux (Fecha: 2023-04-19, Tamaño: 582.98 KB)
unix_unknown UNIX (Fecha: 2023-04-19, Tamaño: 582.98 KB)
source Source Code (Fecha: 2023-04-19, Tamaño: 582.98 KB)

Your rating
Review this project


Recent Activities

[File Release] Release 'v. 1.115.2 2023-04-07' has been deleted
[Hg] commits were pushed to 'execsql' (current: 8d8959f8ef8d4cb65fef71dd34e986eefb7aed03)
Fixed description handling when exporting multiple tables to ODS at once.
Show history