PHP OA_DB_Sql::selectWhereOne 예제들

예제 #1

파일: Sql.tbl.test.php 프로젝트: ballistiq/revive-adserver

 function testSelectWhereOne()
 {
     $this->initTables(array('banners', 'ad_zone_assoc', 'placement_zone_assoc', 'zones'));
     $id = DataGenerator::generateOne('banners');
     $rsBanners = OA_DB_Sql::selectWhereOne('banners', 'bannerid', $id);
     $this->assertTrue($rsBanners->fetch());
     $this->assertFalse($rsBanners->fetch());
     $aConf = $GLOBALS['_MAX']['CONF'];
     $this->oaTable->dropTable($aConf['table']['prefix'] . 'banners');
     $this->oaTable->dropTable($aConf['table']['prefix'] . 'ad_zone_assoc');
     $this->oaTable->dropTable($aConf['table']['prefix'] . 'placement_zone_assoc');
     $this->oaTable->dropTable($aConf['table']['prefix'] . 'zones');
 }