<?php
// composer autoloader for required packages and dependencies
require_once('vendor/autoload.php');

$f3 = \Base::instance();
$f3->set('AUTOLOAD', 'app/');

$f3->set('DB', new \DB\SQL('sqlite:sqlite.db'));

class Member extends \DB\Cortex {

    protected $fieldConf = array(
        'username'          => array('type' => \DB\SQL\Schema::DT_VARCHAR128),
        'password'          => array('type' => \DB\SQL\Schema::DT_VARCHAR256),
        'email'             => array('type' => \DB\SQL\Schema::DT_VARCHAR128),
        'group'             => array('type' => \DB\SQL\Schema::DT_INT),
        'company'           => array('type' => \DB\SQL\Schema::DT_VARCHAR128),
        'active'            => array('type' => \DB\SQL\Schema::DT_BOOL),
        'verified'          => array('type' => \DB\SQL\Schema::DT_BOOL),
        'activationcode'    => array('type' => \DB\SQL\Schema::DT_VARCHAR128),
    );
    protected $primary = 'id';
    protected $db = 'DB';
    protected $table = 'members';
}


$f3->route('GET /',function(Base $f3){

    Member::setup();

    $member = new Member();

    $member->load(array('id = ?',1));

    if ($member->dry()) {
        $member->username = 'ikkez';
        $member->password = 'secret';
        $member->email = 'mail@domain.com';
        $member->group = 1;
        $member->company = 'ACME Inc.';
        $member->active = true;
        $member->verified = true;
        $member->activationcode = $f3->hash(uniqid());
        $member->save();
        $member->reset();
    }

    header('Content-Type: text');

    // complete results
    $results = $member->paginate(0,10,null,array('order'=>'name desc'));
    print_r($results['subset']->castAll());

    // cut down fields
    $member->fields(array('username','email'));
    $results = $member->paginate(0,10,null,array('order'=>'name desc'));
    print_r($results['subset']->castAll());

    //print_r($f3->get('DB')->log());

});
$f3->run();