Skip to content

mhujer/json-simple-db

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

24 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

JSON SimpleDB Build Status

Latest Stable Version Total Downloads License Coverage Status

For a project that generates static HTML I needed a data source, so I created this simple library for storing data in JSON. It is intended only for CLI usage by a single client, not for websites!

Usage

  1. Install the latest version with composer require mhujer/json-simple-db
  2. Use it according to the example bellow and check the docblocks
<?php
require_once 'vendor/autoload.php';

//initialize DB
$db = new JsonSimpleDb\Db('./foo');

//initialize table
if (!$db->tableExists('mytable')) {
    $db->createTable('mytable');
}
$table = $db->getTable('mytable');

//get items count
$table->count(); //0

//insert into table
$table->insert([
    'id' => '1',
    'name' => 'foo',
]);

//find by array - like in MongoDB
$items = $table->find(['id' => '1']);
/*
array(1) {
  [0] =>
  array(2) {
    'id' =>
    string(1) "1"
    'name' =>
    string(3) "foo"
  }
}
 */

//update record
$table->update(['id' => '1'], ['name' => 'boo']);

//delete record
$table->delete(['id' => '1']);

//persist the data to file - don't forget this :-)
$table->persist();

Requirements

JSON SimpleDB works with PHP 5.6 or PHP 7.

Submitting bugs and feature requests

Bugs and feature request are tracked on GitHub

Author

Martin Hujer - mhujer@gmail.com - http://www.martinhujer.cz

Changelog

1.1.1 (2015-11-26)

  • Stored JSON is pretty printed

1.1.0 (2015-11-26)

  • Added posibility to delete records

1.0.1 (2015-11-17)

  • Comparator does strict matching

1.0.0 (2015-11-14)

  • initial release

About

Work with JSON file like with a simple database

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages