oktopost/squid

MySQL library build on top of PDO

Sunday, July 22, 2018
by alexey-pkv
Repository
7 Watchers
2 Stars
637 Installations

PHP
4 Dependents
2 Suggesters
1 Forks
0 Open issues
30 Versions
5 % Grown

The README.md

Squid

Squid is a MySQL library, _(*1)

Example code:, _(*2)

$select = $connector->select();
$select
    ->column('a.*', 'b.Modified')
    ->from('TableName', 'a')
    ->leftJoin('AnotherTable', 'b', 'a.ID = b.TableNameID AND b.Status = ?', 'valid')
    ->byField('b.Name', 'Jhon')
    ->where('DATE(a.Created) > ?', new \DateTime());

$result = $select->query();

$modifiedAt = $result[0]['Modified'];

Basic Configuration

use Squid\MySql;

$mysql = new MySql();
$mysql->config()
    ->addConfig(
    'connection_name',
    [
        'db'    => 'db_name',
        'host'  => 'localhost',
        'pass'  => 'password',
        'user'  => 'user_name'
    ]);

// Aquire new connector object
$connector = $mysql->getConnector('connection_name');

// Aquiring commands
$select = $connector->select();
$insert = $connector->insert();
$delete = $connector->delete();

Select

Columns

column method

public function column(...$columns)

Set the columns to select., _(*3)

Example:, _(*4)

$select1->column('a', 'NOW()');
$select2->column('a.a', 'a.b');

Will result respectively in:, _(*5)

SELECT a, NOW()
SELECT a.a, a.b

columns method

public function columns($columns, $table = false)

Set the columns to select using an array variable., _(*6)

Example:, _(*7)

$select1->columns(['a', 'NOW()']);
$select2->columns(['a', 'b'], 'a');

Will result respectively in:, _(*8)

SELECT a, NOW()
SELECT a.a, a.b

From

from method

NOTE: A select can have only one main table. Calling this method a second time on the same select object will replace previous table selection., _(*9)

public function from($table, $alias = false)

Describe the main table you want to select from. This method can't be used for selecting from multiplay tables. To do so, use the join method., _(*10)

Example:, _(*11)

$select1->from('Table');
$select2->from('Table', 'a');

Will result respectively in:, _(*12)

SELECT * FROM Table
SELECT * FROM Table a

Where Clause

The where clause commands are available in select, insert, update, upsert and delete commands., _(*13)

where method

public function where($exp, $bind = false)

Provide any costume where expression with optional bind parameters., _(*14)

Example:, _(*15)

$select1->where('1 + 1 = ?', 2);
$select2->where('Table.SomeFieldName = ? - ?', [3, 1]);
$delete->where('NOW() > DATE(NOW())');

Will result respectively in:, _(*16)

SELECT * WHERE 1 + 1 = 2
SELECT * WHERE Table.SomeFieldName = 3 - 1
DELETE * WHERE NOW() > DATE(NOW())

byField method

public function byField($field, $value)

Search for field = value or, if value is an array, where field IN (values), _(*17)

Example:, _(*18)

$select1->byField('Name', ['Jhon']);
$select1->byField('ROUND(Price)', [23]);
$select1->byField('ID', [2, 3]);

Will result respectively in:, _(*19)

SELECT * WHERE Name = 'Jhon'
SELECT * WHERE ROUND(Price) = 23
SELECT * WHERE ID IN (2, 3)

The Versions

22/07 2018

1.1.0

1.1.0.0 https://github.com/Oktopost/Squid

MySQL library build on top of PDO

library squid

MySQL library build on top of PDO

oktopost/squid

The README.md

Squid

Basic Configuration

Select

Columns

column method

columns method

From

from method

Where Clause

where method

byField method

The Versions

1.1.0

The Requires

The Development Requires

by Alexey Puchkov

by Daniel Podrabinek

by Ivan Demchenkov

dev-wherein-fix-5.6

The Requires

The Development Requires

by Alexey Puchkov

by Daniel Podrabinek

by Ivan Demchenkov

dev-master

The Requires

The Development Requires

by Alexey Puchkov

by Daniel Podrabinek

by Ivan Demchenkov

1.0.26

The Requires

The Development Requires

by Alexey Puchkov

by Daniel Podrabinek

by Ivan Demchenkov

1.0.25

The Requires

The Development Requires

by Alexey Puchkov

by Daniel Podrabinek

by Ivan Demchenkov

1.0.24

The Requires

The Development Requires

by Alexey Puchkov

by Daniel Podrabinek

by Ivan Demchenkov

1.0.23

The Requires

The Development Requires

by Alexey Puchkov

by Daniel Podrabinek

by Ivan Demchenkov

dev-dev

The Requires

by Alexey Puchkov

1.0.22

The Requires

by Alexey Puchkov

1.0.21

The Requires

by Alexey Puchkov

1.0.20

The Requires

by Alexey Puchkov

1.0.19

The Requires

by Alexey Puchkov

1.0.18

The Requires

by Alexey Puchkov

1.0.17

The Requires

by Alexey Puchkov

1.0.16