Skip to content

LocalDB is a small package to read and write JSON files in a Laravel Eloquent like style.

License

Notifications You must be signed in to change notification settings

vollborn/local-db

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

LocalDB

LocalDB is a small package to read and write JSON files in a Laravel Eloquent like style.
It was originally developed for small web servers that cannot connect to classic databases.


Installation

This package ist available via composer.

composer require vollborn/local-db

Configuration

Set the base path

In the base path all json files are stored. The default value is ../storage/local-db.

You can change it if you need to:

LocalDB::setBasePath(<your path>);

Register a table

Every table or json file needs to be registered beforehand.

LocalDB::table('test', static function (Table $table) {
    $table->int('int')->autoincrements();
    $table->array('array')->nullable();
    $table->boolean('boolean');
    $table->float('float');
    $table->string('string');
});

As you can see, there are multiple data types available:

Name Function
Integer int
Array array
Boolean boolean
Float float
String string

In addition, integers can have autoincrements.
All data types can also be nullable.


Usage

Create data

LocalDB::query('test')->create([
    'float' => 1.00,
    'string' => null,
    'boolean' => false,
    'array' => []
]);

Get data

You can either get all data...

LocalDB::query('test')->get();

or just the first entry...

LocalDB::query('test')->first();

The data can also be filtered.

LocalDB::query('test')->where('float', '=', 1.00)->get();

Available operators:

  • =
  • !=
  • <
  • >
  • <=
  • >=

Furthermore, the data can be ordered.

// ascending
LocalDB::query('test')->orderBy('float')->get();

// descending
LocalDB::query('test')->orderBy('float', true)->get();

There are some numeric operations available too.

// minimal value
LocalDB::query('test')->min('float');

// maximal value
LocalDB::query('test')->max('float');

// average value
LocalDB::query('test')->avg('float');

// summed value
LocalDB::query('test')->sum('float');

Update data

LocalDB::query('test')
    ->where('boolean', '=', false)
    ->update([
        'boolean' => true
    ]);

Delete data

LocalDB::query('test')
    ->where('boolean', '=', false)
    ->delete();