public static function setUpBeforeClass() { self::$dbm = \TestHelperMw::getDBManager(); if (!self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL) { return; } $schema = new \Doctrine\DBAL\Schema\Schema(); $cacheTable = $schema->createTable('mw_cache_test'); $cacheTable->addColumn('id', 'string', array('length' => 255)); $cacheTable->addColumn('siteid', 'integer', array('notnull' => false)); $cacheTable->addColumn('expire', 'datetime', array('notnull' => false)); $cacheTable->addColumn('value', 'text', array('length' => 0xffff)); $cacheTable->addUniqueIndex(array('id', 'siteid')); $cacheTable->addIndex(array('expire')); $tagTable = $schema->createTable('mw_cache_tag_test'); $tagTable->addColumn('tid', 'string', array('length' => 255)); $tagTable->addColumn('tsiteid', 'integer', array('notnull' => false)); $tagTable->addColumn('tname', 'string', array('length' => 255)); $tagTable->addUniqueIndex(array('tid', 'tsiteid', 'tname')); $tagTable->addForeignKeyConstraint('mw_cache_test', array('tid', 'tsiteid'), array('id', 'siteid'), array('onDelete' => 'CASCADE')); $conn = self::$dbm->acquire(); foreach ($schema->toSQL($conn->getRawObject()->getDatabasePlatform()) as $sql) { $conn->create($sql)->execute()->finish(); } self::$dbm->release($conn); }
/** * Sets up the fixture, for example, opens a network connection. * This method is called before a test is executed. * * @access protected */ protected function setUp() { $this->config = \TestHelperMw::getConfig(); if ($this->config->get('resource/db/adapter', false) === false) { $this->markTestSkipped('No database configured'); } $this->dbm = \TestHelperMw::getDBManager(); }
/** * Tears down the fixture, for example, closes a network connection. * This method is called after a test is executed. * * @access protected */ protected function tearDown() { $this->dbm = \TestHelperMw::getDBManager(); $conn = $this->dbm->acquire(); $conn->create('DROP INDEX "idx_msdt_smallint" ON "mw_setup_dbschema_test"')->execute()->finish(); $conn->create('DROP TABLE "mw_setup_dbschema_test"')->execute()->finish(); $this->dbm->release($conn); }
protected function tearDown() { if (($adapter = \TestHelperMw::getConfig()->get('resource/db/adapter', false)) === 'pgsql') { $this->dbm = \TestHelperMw::getDBManager(); $conn = $this->dbm->acquire(); $conn->create('DROP TABLE "mw_setup_dbschema_test"')->execute()->finish(); $this->dbm->release($conn); } }
/** * Sets up the fixture, for example, opens a network connection. * This method is called before a test is executed. * * @access protected */ protected function setUp() { if (\TestHelperMw::getConfig()->get('resource/db/adapter', false) === false) { $this->markTestSkipped('No database configured'); } $dbm = \TestHelperMw::getDBManager(); $conn = $dbm->acquire(); $this->object = new \Aimeos\MW\Criteria\SQL($conn); $dbm->release($conn); }
/** * Tears down the fixture, for example, closes a network connection. * This method is called after a test is executed. * * @access protected */ protected function tearDown() { if (\TestHelperMw::getConfig()->get('resource/db/adapter', false) === false) { return; } $this->dbm = \TestHelperMw::getDBManager(); $conn = $this->dbm->acquire(); $conn->create('DROP TABLE "mw_log_test"')->execute()->finish(); $this->dbm->release($conn); }
protected function setUp() { $config = \TestHelperMw::getConfig(); if ($config->get('resource/db/adapter', false) === false) { $this->markTestSkipped('No database configured'); } $dbm = \TestHelperMw::getDBManager(); $conn = $dbm->acquire(); $schema = new \Aimeos\MW\Setup\DBSchema\Mysql($conn, $config->get('resource/db/database', 'notfound'), 'mysql'); $this->object = new BaseImpl($schema, $conn); $dbm->release($conn); }
public static function setUpBeforeClass() { self::$dbm = \TestHelperMw::getDBManager(); if (!self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL) { return; } $schema = new \Doctrine\DBAL\Schema\Schema(); $table = $schema->createTable('mw_log_test'); $table->addColumn('facility', 'string', array('length' => 32)); $table->addColumn('request', 'string', array('length' => 32)); $table->addColumn('tstamp', 'string', array('length' => 20)); $table->addColumn('priority', 'integer', array()); $table->addColumn('message', 'text', array('length' => 0xffff)); $conn = self::$dbm->acquire(); foreach ($schema->toSQL($conn->getRawObject()->getDatabasePlatform()) as $sql) { $conn->create($sql)->execute()->finish(); } self::$dbm->release($conn); }
public static function setUpBeforeClass() { self::$dbm = \TestHelperMw::getDBManager(); if (!self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL) { return; } $schema = new \Doctrine\DBAL\Schema\Schema(); $table = $schema->createTable('mw_mqueue_test'); $table->addColumn('id', 'integer', array('autoincrement' => true)); $table->addColumn('queue', 'string', array('length' => 255)); $table->addColumn('cname', 'string', array('length' => 32)); $table->addColumn('rtime', 'datetime', array()); $table->addColumn('message', 'text', array('length' => 0xffff)); $table->setPrimaryKey(array('id')); $conn = self::$dbm->acquire(); foreach ($schema->toSQL($conn->getRawObject()->getDatabasePlatform()) as $sql) { $conn->create($sql)->execute()->finish(); } self::$dbm->release($conn); }
public static function setUpBeforeClass() { self::$dbm = \TestHelperMw::getDBManager(); if (!self::$dbm instanceof \Aimeos\MW\DB\Manager\DBAL) { return; } $schema = new \Doctrine\DBAL\Schema\Schema(); $table = $schema->createTable('mw_tree_test'); $table->addColumn('id', 'integer', array('autoincrement' => true)); $table->addColumn('parentid', 'integer', array('notnull' => false)); $table->addColumn('label', 'string', array('length' => 16)); $table->addColumn('code', 'string', array('length' => 32)); $table->addColumn('level', 'integer', array()); $table->addColumn('nleft', 'integer', array()); $table->addColumn('nright', 'integer', array()); $table->addColumn('status', 'smallint', array()); $table->setPrimaryKey(array('id')); $conn = self::$dbm->acquire(); foreach ($schema->toSQL($conn->getRawObject()->getDatabasePlatform()) as $sql) { $conn->create($sql)->execute()->finish(); } self::$dbm->release($conn); }
public function testToString() { $dbm = \TestHelperMw::getDBManager(); $conn = $dbm->acquire(); $dbm->release($conn); $types = array('list' => \Aimeos\MW\DB\Statement\Base::PARAM_STR, 'string' => \Aimeos\MW\DB\Statement\Base::PARAM_STR, 'float' => \Aimeos\MW\DB\Statement\Base::PARAM_FLOAT, 'int' => \Aimeos\MW\DB\Statement\Base::PARAM_INT, 'undefined' => \Aimeos\MW\DB\Statement\Base::PARAM_INT, 'bool' => \Aimeos\MW\DB\Statement\Base::PARAM_BOOL); $expr1 = array(); $expr1[] = new \Aimeos\MW\Criteria\Expression\Compare\SQL($conn, '==', 'list', array('a', 'b', 'c')); $expr1[] = new \Aimeos\MW\Criteria\Expression\Compare\SQL($conn, '~=', 'string', 'value'); $expr2 = array(); $expr2[] = new \Aimeos\MW\Criteria\Expression\Compare\SQL($conn, '<', 'float', 0.1); $expr2[] = new \Aimeos\MW\Criteria\Expression\Compare\SQL($conn, '>', 'int', 10); $objects = array(); $objects[] = new \Aimeos\MW\Criteria\Expression\Combine\SQL('&&', $expr1); $objects[] = new \Aimeos\MW\Criteria\Expression\Combine\SQL('&&', $expr2); $object = new \Aimeos\MW\Criteria\Expression\Combine\SQL('||', $objects); $test = new \Aimeos\MW\Criteria\Expression\Combine\SQL('!', array($object)); $expected = " NOT ( ( list IN ('a','b','c') AND string LIKE '%value%' ) OR ( float < 0.1 AND int > 10 ) )"; $this->assertEquals($expected, $test->toString($types)); $obj = new \Aimeos\MW\Criteria\Expression\Combine\SQL('&&', array()); $this->assertEquals('', $obj->toString($types)); $this->setExpectedException('\\Aimeos\\MW\\Common\\Exception'); new \Aimeos\MW\Criteria\Expression\Combine\SQL('', array()); }
/** * Tears down the fixture, for example, closes a network connection. * This method is called after a test is executed. * * @access protected */ protected function tearDown() { $sql = 'DROP TABLE "mw_tree_test"'; $this->dbm = \TestHelperMw::getDBManager(); $conn = $this->dbm->acquire(); $conn->create($sql)->execute()->finish(); $this->dbm->release($conn); }
/** * Tears down the fixture, for example, closes a network connection. * This method is called after a test is executed. * * @access protected */ protected function tearDown() { $dbm = \TestHelperMw::getDBManager(); $dbm->release($this->conn); }
public function testFactory() { $config = array('sql' => array('delete' => '', 'deletebytag' => '', 'get' => '', 'getbytag' => '', 'set' => '', 'settag' => ''), 'search' => array('cache.id' => '', 'cache.siteid' => '', 'cache.value' => '', 'cache.expire' => '', 'cache.tag.name' => '')); $object = \Aimeos\MW\Cache\Factory::createManager('DB', $config, \TestHelperMw::getDBManager()); $this->assertInstanceOf('\\Aimeos\\MW\\Cache\\Iface', $object); }