<?php include '../bootstrap.php'; $config = array('host' => 'localhost', 'user' => 'root', 'password' => 'ghjrcbvf', 'schema' => 'test', 'charset' => 'utf8', 'fetch' => MYSQL_ASSOC); $db = FireKit\Factories\DataProviderFactory::createProvider('MYSQL', $config); $db->Connect(); class t extends FireKit\Database\Model\ModelTable { protected $table = array('name' => 'ttt', 'structure' => array("id" => array("type" => "bigint", "options" => array("not null", "auto_increment"), "key" => "primary", "comment" => "rowid"), "crdate" => array("type" => "timestamp", "default" => "CURRENT_TIMESTAMP", "options" => array("not null")), "value" => array("type" => "varchar", "size" => "100", "comment" => "тестовое поле, текстовое")), 'indexes' => array("UK" => array(array("name" => "ttt_name_ui", "fields" => array("crdate")))), "options" => array("engine" => "MyISAM", "charset" => "utf8", "collate" => "utf8_general_ci")); protected $relations = array("users" => array("table" => "users", "key" => "id2"), "users_temp" => array("table" => "users_temp")); } $m = new t($db); $m->Cols("users.login")->With("users")->Many(false, false, 1); echo $m->GetTotal() . "\n\n\n"; //$m->With("users")->One(1); //echo $m->DescribeObject()."\n"; //$m->Delete(false, array("users"=>"id2")); $sql_poll = $m->GetQueries(); echo "Queries poll:\n"; var_dump($sql_poll); $db->Disconnect();