{
    "require": {
        "webtron/database": "dev-master"
    }
}

use Webtron\Database\Connector\Connector as Connector;

use Webtron\Database\Query\Builder as DB;

$connector = new Connector([
	"database" => "app",
	"host"     => "localhost",
	"username" => "root",
	"password" => "root"
]);

DB::connect($connector);

$users = DB::table("users")->get();
print_r($users);

$users = DB::table("users")->where('username','Mark')->get();
print_r($users);

$users = DB::table("users")
			->where('username','Mark')
			->orWhere(function($query){
				$query->where('id','>',3)->where('username','LIKE',"J%");
			})
			->get(['username']);
print_r($users);

$users = DB::table("users")
			->where('username',function($query){
				$query->select(["username"])->from("list")->where("id",1);
			})
			->get(['username']);
print_r($users);

$posts = DB::table('users')
			->join('comments',function($join){
				$join->on('users.id','=','comments.user_id')
					 ->where('users.id','>',2);
			})
			->get(['users.username','comments.body']);
print_r($posts);

use Webtron\Database\Model\Model;

class User extends Model {

	protected $table = 'users';
}

$users = User::all();
print_r($users);