2017 © Pedro Peláez
 

library lazer-database

PHP library to use JSON files like flat-file database

image

greg0/lazer-database

PHP library to use JSON files like flat-file database

  • Tuesday, June 26, 2018
  • by Greg0
  • Repository
  • 16 Watchers
  • 176 Stars
  • 2,056 Installations
  • PHP
  • 1 Dependents
  • 0 Suggesters
  • 26 Forks
  • 3 Open issues
  • 25 Versions
  • 33 % Grown

The README.md

Lazer - php flat file database based on JSON files

Unit Current Version PHP Version Downloads, (*1)

PHP Library to use JSON files like a database.
Functionality inspired by ORM's, (*2)

Requirements

  • PHP 7.1+
  • Composer

Installation

Easiest way to install Lazer Database is to use Composer. Of course you can use your own autoloader but you must configure it properly by yourself. You can find my Package on Packagist.org., (*3)

To add library to your dependencies, execute:, (*4)

composer require greg0/lazer-database

Tests

Easiest way to run unit tests is to use composer script, (*5)

composer run test

You can also use docker, (*6)

docker build -t lazer-db .
docker run -it --rm lazer-db

Structure of table files

table_name.data.json - table file with data
table_name.config.json - table file with configuration, (*7)

Basic Usage

First of all you should define constant LAZER_DATA_PATH containing absolute path to folder with JSON files:, (*8)

define('LAZER_DATA_PATH', realpath(__DIR__).'/data/'); //Path to folder with tables

Then set up namespace:, (*9)

use Lazer\Classes\Database as Lazer; // example

Methods

Chain methods
  • setField() - set value of field (alternative to magic __set())
  • limit() - returns results between a certain number range. Should be used right before ending method findAll().
  • orderBy() - sort rows by key in order, can order by more than one field (just chain it).
  • groupBy() - group rows by field.
  • where() - filter records. Alias: and_where().
  • orWhere() - other type of filtering results.
  • with() - join other tables by defined relations
Ending methods
  • getField - get value of field (alternative to magic __get())
  • issetField - check if field is isset (alternative to magic __isset())
  • addFields() - append new fields into existing table
  • deleteFields() - removing fields from existing table
  • set() - get key/value pair array argument to save.
  • save() - insert or Update data (automatically detect if it needs an insert or update).
  • insert() - force an insert.
  • delete() - deleting data.
  • relations() - returns array with table relations
  • config() - returns object with configuration.
  • fields() - returns array with fields name.
  • schema() - returns assoc array with fields name and fields type field => type.
  • lastId() - returns last ID from table.
  • find() - returns one row with specified ID.
  • findAll() - returns rows.
  • asArray() - returns data as indexed or assoc array: ['field_name' => 'field_name']. Should be used after ending method findAll() or find().
  • count() - returns the number of rows. Should be used after ending method findAll() or find().

Create database

Lazer::create('table_name', array(
    'id' => 'integer',
    'nickname' => 'string',
    {field_name} => {field_type}
));

More information about field types and usage in PHPDoc, (*10)

Remove database

Lazer::remove('table_name');

Check if a database exists

try{
    \Lazer\Classes\Helpers\Validate::table('table_name')->exists();
} catch(\Lazer\Classes\LazerException $e){
    //Database doesn't exist
}

Select

Multiple select

$table = Lazer::table('table_name')->findAll();

foreach($table as $row)
{
    print_r($row);
}

Single record select

$row = Lazer::table('table_name')->find(1);

echo $row->id; // or $row->getField('id')

Type ID of row in find() method., (*11)

You also can do something like that to get first matching record:, (*12)

$row = Lazer::table('table_name')->where('name', '=', 'John')->find();

echo $row->id;

Insert

$row = Lazer::table('table_name');

$row->nickname = 'new_user'; // or $row->setField('nickname', 'new_user')
$row->save();

Do not set the ID., (*13)

Update

It's very smilar to Inserting., (*14)

$row = Lazer::table('table_name')->find(1); //Edit row with ID 1

$row->nickname = 'edited_user'; // or $row->setField('nickname', 'edited_user')
$row->save();

You can also set many field by simple key-value array, (*15)

$row = Lazer::table('table_name')->find(1); //Edit row with ID 1

$row->set(array(
    'nickname' => 'user',
    'email' => 'user@example.com'
));
$row->save();

Remove

Single record deleting

Lazer::table('table_name')->find(1)->delete(); //Will remove row with ID 1

// OR

Lazer::table('table_name')->where('name', '=', 'John')->find()->delete(); //Will remove John from DB

Multiple records deleting

Lazer::table('table_name')->where('nickname', '=', 'edited_user')->delete();

Clear table

Lazer::table('table_name')->delete();

Relations

To work with relations use class Relation, (*16)

use Lazer\Classes\Relation; // example

Relation types

  • belongsTo - relation many to one
  • hasMany - relation one to many
  • hasAndBelongsToMany - relation many to many

Methods

Chain methods
  • belongsTo() - set relation belongsTo
  • hasMany() - set relation hasMany
  • hasAndBelongsToMany() - set relation hasAndBelongsToMany
  • localKey() - set relation local key
  • foreignKey() - set relation foreign key
  • with() - allow to work on existing relation
Ending methods
  • setRelation() - creating specified relation
  • removeRelation() - remove relation
  • getRelation() - return informations about relation
  • getJunction() - return name of junction table in hasAndBelongsToMany relation

Create relation

Relation::table('table1')->belongsTo('table2')->localKey('table2_id')->foreignKey('id')->setRelation();
Relation::table('table2')->hasMany('table1')->localKey('id')->foreignKey('table2_id')->setRelation();
Relation::table('table2')->hasAndBelongsToMany('table1')->localKey('id')->foreignKey('id')->setRelation(); // Junction table will be crete automaticly

Remove relation

Relation::table('table1')->with('table2')->removeRelation();

Get relation information

You can do it by two ways. Use Standard Database class or Relation but results will be different., (*17)

Relation::table('table1')->with('table2')->getRelation(); // relation with specified table
Lazer::table('table1')->relations(); // all relations
Lazer::table('table1')->relations('table2'); // relation with specified table

Description

For some examples please check Examples and Tutorial file. More informations you can find in PHPDoc, I think it's documented very well., (*18)

E-mail: gerg0sz92@gmail.com, (*19)

If you like and using/want to use my repo or you have any suggestions I will be greatful for sending me few words on e-mail., (*20)

The Versions

26/06 2018

dev-new-feature-to-save

dev-new-feature-to-save https://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.6

 

The Development Requires

by Grzegorz Kuźnik

database file json simple db flat lazer

15/06 2018

dev-master

9999999-dev https://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.6

 

The Development Requires

by Grzegorz Kuźnik

database file json simple db flat lazer

24/05 2018

1.1.4

1.1.4.0 https://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.6

 

The Development Requires

by Grzegorz Kuźnik

database file json simple db flat lazer

23/05 2018

1.1.3

1.1.3.0 https://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.6

 

The Development Requires

by Grzegorz Kuźnik

database file json simple db flat lazer

22/05 2018

1.1.2

1.1.2.0 https://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.6

 

The Development Requires

by Grzegorz Kuźnik

database file json simple db flat lazer

22/05 2018

1.1.1

1.1.1.0 https://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.6

 

The Development Requires

by Grzegorz Kuźnik

database file json simple db flat lazer

03/10 2015

dev-tests

dev-tests http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

 

by Grzegorz Kuźnik

database file json simple db flat lazer

03/10 2015

1.1

1.1.0.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

 

by Grzegorz Kuźnik

database file json simple db flat lazer

16/06 2015

1.0.14

1.0.14.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

20/04 2015

1.0.13

1.0.13.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

20/04 2015

1.0.12

1.0.12.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

20/04 2015

1.0.11

1.0.11.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

13/04 2015

1.0.10

1.0.10.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

10/04 2015

1.0.9

1.0.9.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

10/04 2015

1.0.8

1.0.8.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

27/03 2015

dev-revert-11-add-like

dev-revert-11-add-like http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

13/03 2015

1.0.7

1.0.7.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

23/02 2015

1.0.6

1.0.6.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

25/10 2014

1.0.5

1.0.5.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

29/09 2014

1.0.4

1.0.4.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

28/09 2014

1.0.3

1.0.3.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

28/09 2014

dev-build

dev-build http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4
  • mountain/enum dev-master

 

by Grzegorz Kuźnik

database file json simple db flat lazer

29/08 2014

1.0.2

1.0.2.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

16/04 2014

1.0.1

1.0.1.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer

16/04 2014

1.0.0

1.0.0.0 http://github.com/Greg0/Lazer-Database

PHP library to use JSON files like flat-file database

  Sources   Download

MIT

The Requires

  • php >=5.4

 

by Grzegorz Kuźnik

database file json simple db flat lazer