Download the PHP package php-etl/sql-plugin without Composer

On this page you can find all versions of the php package php-etl/sql-plugin. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of php-etl/sql-plugin

Informations about the package sql-plugin

SQL Plugin

Mutations PHPUnit Quality PHPStan level 5 PHPStan level 6 PHPStan level 7 PHPStan level 8 PHP

What is it ?

The SQL plugin allows you to write your own SQL queries and use them into the Pipeline stack.

SQL, Structured Query Language, is a language for manipulating databases.

Installation

Usage

Database connection

The SQL plugin uses the PDO extension and relies on its interface to access databases using the dsn, username and password parameters.

This connection must be present in any case, whether it be when defining the extractor, loader or lookup.

It is possible to specify options at the time of this connection using options. Currently, it is only possible to specify if the database connection should be persistent.

Building an extractor

Building a lookup

Building a loader

Advanced Usage

Using params in your queries

Thanks to the SQL plugin, it is possible to write your queries with parameters.

If you write a prepared statement using named parameters (:param), your parameter key in the configuration will be the name of your parameter without the : :

If you are using a prepared statement using interrogative markers (?), your parameter key in the configuration will be its position (starting from 1) :

Creating before and after queries

In some cases, you may need to run queries in order to best prepare for the execution of your pipeline.

Before queries

Before queries will be executed before performing the query written in the configuration. Often, these are queries that set up the database.

After queries

After queries will be executed after performing the query written in the configuration. Often, these are queries that clean up the database.

All versions of sql-plugin with dependencies

PHP Build Version
Package Version
Requires php Version ^8.2
nikic/php-parser Version ^4.10
symfony/config Version ^6.0
symfony/expression-language Version ^6.0
php-etl/configurator-contracts Version 0.8.*
php-etl/satellite-toolbox Version *
php-etl/fast-map-plugin Version *
php-etl/packaging Version *
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package php-etl/sql-plugin contains the following files

Loading the files please wait ....