example.php

<?php

require_once "vendor/autoload.php";

use Lib\DB;
use Lib\ENV;
use Models\User;

DB::config((new ENV)->read());
dumpl("PDO", DB::pdo());

// WHERE
$user = new User;
$result = $user->where("{{id}} = :id AND {{email}} = :email", [
    ":id" => 2,
    ":email" => "johann@mail.com"
]);
dumpl("WHERE", $result);

// FIND ID
$user = new User;
$result = $user->findId(1);
dumpl("FIND ID", $result);

if ($result === null) {
    // INSERT
    $user = new User;
    $user->name = "Matheus";
    $user->email = "matheus@mail.com";
    $user->age = 23;
    dumpl("INSERT", $user->save());

    $user = new User;
    $user->name = "Johann";
    $user->email = "johann@mail.com";
    $user->age = 23;
    dumpl("INSERT", $user->save());
} else {
    // UPDATE
    $user = new User;
    $user->id = 1;
    $user->name = "Matheus Johann " . md5(rand(0, 9999999));
    $user->age = $result->age + 1;
    dumpl("UPDATE", $user->save());

    if ($result->age == 25) {
        // DELETE
        $user = new User;
        dumpl("DELETE", $user->delete(1));
    }
}

// ALL
$user = new User;
$result = $user->all();
dumpl("ALL", $result);
if (count($result) > 3) {
    // TRUNCATE
    $user = new User;    
    dumpl("TRUNCATE", $user->truncate(true));
}