PHP download

Download the PHP package fos1/sf-s-q-l-tools-plugin without Composer

On this page you can find all versions of the php package fos1/sf-s-q-l-tools-plugin. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download fos1/sf-s-q-l-tools-plugin
More information about fos1/sf-s-q-l-tools-plugin
Files in fos1/sf-s-q-l-tools-plugin

Vendor fos1
Package sf-s-q-l-tools-plugin
Short Description Doctrine SQL Tools Plugin for Symfony1. Task to execute SQL files with triggers, procedures and events in order. Compatible with any kind of database engines.
License MIT

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 fos1/sf-s-q-l-tools-plugin

Informations about the package sf-s-q-l-tools-plugin

sfSQLToolsPlugin

The sfSQLToolsPlugin is a symfony1 plugin that provides easy way to execute database specific features like stored procedures, triggers, events and any other SQL commands.

It gives you one task to execute SQL files with additional options.

Installation

Download the plugin

Add the plugin your composer.json requirements:

Install the plugin: edit your ProjectConfiguration.class.php file
Clear you cache symfony cc

Usage

Options:

--application The application name (default: 1)
--env The environment (default: dev)
--dir The directory where to look for *.sql file (default: data/sql/tasks)
--dir-depth Search directory depth (default: 0)
--file One file to be executed
--exclude Exclude file pattern or file list separated by commas
--delimiter Query delimiter (default: ~)

Description:

The sql:execute task reads *.sql files in search directory and then runs them in order

Call it with:
```
$ ./symfony sql:execute
```
To work in certain environment run this command with --env option
```
$ ./symfony sql:execute --env=prod
```
To use certain application`s database settings use --application option
```
$ ./symfony sql:execute --application=frontend
```
If you need to customize the *.sql location dirname (default is "data/sql/tasks"), you can pass a --dir option:
```
$ ./symfony sql:execute --dir=data/my/folder
```
To exclude one or more files from --dir folder use --exclude option. In order to exclude "00-misc.sql" file from "data/my/folder" directory use:
```
$ ./symfony sql:execute --dir=data/my/folder --exclude="00-misc.sql"
```

In order to exclude many files from "data/my/folder" directory, separate is by commas:

$ ./symfony sql:execute --dir=data/my/folder --exclude="00-misc.sql, 10-triggers.sql, 20-events.sql"

Or you can use glob patterns (exclude all filename which contains words: U"old" and "backup"):
```
$ ./symfony sql:execute --dir=data/my/folder --exclude="*old*,*backup*"
```

To run only one specific SQL file use --file:

$ ./symfony sql:execute --file=data/sql/tasks_1/alter-tables.sql

or to run one specific file in directory "data/sql/tasks_1"

$ ./symfony sql:execute --dir=data/sql/tasks_1 --file=alter-tables.sql

To search for *.sql file until sub folder certain level use --dir-depth option:
```
$ ./symfony sql:execute --dir-depth=5
```
To search for .sql file recursively pass "\" to --dir-depth option:
```
$ ./symfony sql:execute --dir-depth=*
```

Example

This is your file "00-procedures.sql" content (MySQL)

Now, setup your DBMS conntecion in config/databases.yml (if you haven't done this yet)
And execute this procedures in development environment: symfony sql:execute --env=dev --file=data/sql/00-procedures.sql
After you run this task, you should get the following output:

Unit test

Unit tests (14 of 14) successfully completed.
Tested with:
- MySQL 5.0.84
- MySQL 5.1.40
- PostgreSQL 8.3.8

All versions of sf-s-q-l-tools-plugin with dependencies

PHP Build Version

Package Version

Version v1.0.4 Release 20. Aug 2015
create-project require 0 people choosed require and
0 people choosed create-project.

Download

Download latest version of sf-s-q-l-tools-plugin from vendor fos1

Requires composer/installers Version ~1.0

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 fos1/sf-s-q-l-tools-plugin contains the following files

Loading the files please wait ....