示例#1
0
 /**
  * Initializes base query for model $m.
  *
  * @param Model $m
  *
  * @return \atk4\dsql\Query
  */
 public function initQuery($m)
 {
     $d = $m->persistence_data['dsql'] = $this->connection->dsql();
     if ($m->table) {
         if (isset($m->table_alias)) {
             $d->table($m->table, $m->table_alias);
         } else {
             $d->table($m->table);
         }
     }
     return $d;
 }
示例#2
0
 public function testException4()
 {
     $c = new Connection();
     $q = $c->expr('select (2+2)');
     $this->assertEquals('select (2+2)', $q->render());
     $this->setExpectedException('atk4\\dsql\\Exception');
     $q->execute();
 }
示例#3
0
 public function testSQLite()
 {
     $c = Connection::connect($GLOBALS['DB_DSN'], $GLOBALS['DB_USER'], $GLOBALS['DB_PASSWD']);
     return (string) $c->expr("SELECT date('now')")->getOne();
 }
示例#4
0
文件: SelectTest.php 项目: atk4/dsql
 public function __construct()
 {
     $this->c = Connection::connect($GLOBALS['DB_DSN'], $GLOBALS['DB_USER'], $GLOBALS['DB_PASSWD']);
     $this->pdo = $this->c->connection();
     $this->pdo->query('CREATE TEMPORARY TABLE employee (id int not null, name text, surname text, retired bool, PRIMARY KEY (id))');
 }