コード例 #1
0
 public function testBasicStatementWhere()
 {
     $finder = new Finder('like');
     $finder->setCondition(array('author_name' => 'alganet', 'text' => 'foo', 'UPPER(like.mycolumn)="OI"'));
     $schema = new Schemas\Infered();
     $query = $schema->generateQuery($finder);
     $params = $query->getParams();
     $this->assertEquals('SELECT like.* FROM like WHERE like.author_name=:LikeAuthorName AND like.text=:LikeText AND UPPER(like.mycolumn)="OI"', (string) $query);
     $this->assertEquals('alganet', $params['LikeAuthorName']);
     $this->assertEquals('foo', $params['LikeText']);
 }