richard4339/pipsqueek-sqlite

Extension of the Medoo SQLite extension with specific logic

1.1.3 2017-07-16 14:20 UTC

Requires

• php: >=5.6
• catfan/medoo: ^1.4

Requires (Dev)

• phpdocumentor/phpdocumentor: 2.*
• phpunit/phpunit: ^5

MIT

• Richard

README

SQLite addon for Medoo with constructor, meant for the PipSqueek Bot but usable anywhere

Install via composer

$ composer require richard4339/pipsqueek-sqlite

Usage

use Pipsqueek\DB\SQLite\DB;
  
require 'vendor/autoload.php';
  
// Initialize
$db = new DB([
    'database_type' => 'sqlite',
    'database_file' => DBPATH
]);
  
$where["chatid"] = 12345;
  
$results = $db->getRandom(SOMETABLE, ["column1", "column2"], $where);

See more specifics on Medoo itself on their Readme or their website

Links

• Medoo website

• PipSqueek IRC Bot