/**
* @param $name
*
* @return Filesystem
*/
public function create($name)
{
switch ($name) {
case 'local':
$adapter = new Adapter\Local($this->getParameter('local', 'folder'), $this->getParameter('local', 'create'));
break;
case 'sftp_phpseclib':
$sftp = new \phpseclib\Net\SFTP($this->getParameter('sftp', 'host'), $this->getParameter('sftp', 'port'));
$sftp->login($this->getParameter('sftp', 'login'), $this->getParameter('sftp', 'password'));
$adapter = new Adapter\PhpseclibSftp($sftp, $this->getParameter('sftp', 'folder'), true);
break;
case 'sftp':
$configuration = new Ssh\Configuration($this->getParameter('sftp', 'host'), $this->getParameter('sftp', 'port'));
$authentication = new Ssh\Authentication\Password($this->getParameter('sftp', 'login'), $this->getParameter('sftp', 'password'));
// for other options, check php-ssh docs
$session = new Ssh\Session($configuration, $authentication);
$adapter = new Adapter\Sftp($session->getSftp());
break;
case 's3':
$service = new \Aws\S3\S3Client(array('credentials' => ['key' => $this->getParameter('s3', 'key'), 'secret' => $this->getParameter('s3', 'secret')], 'endpoint' => $this->getParameter('s3', 'endpoint'), 'bucket_endpoint' => $this->getParameter('s3', 'bucket_endpoint'), 'region' => $this->getParameter('s3', 'region'), 'version' => $this->getParameter('s3', 'version')));
$adapter = new Adapter\AwsS3($service, $this->getParameter('s3', 'bucket'));
break;
case 'ftp':
$adapter = new Adapter\Ftp('/', $this->getParameter('ftp', 'host'), array('username' => $this->getParameter('ftp', 'username'), 'password' => $this->getParameter('ftp', 'password'), 'passive' => $this->getParameter('ftp', 'passive'), 'port' => $this->getParameter('ftp', 'port')));
break;
case 'gridfs':
$client = new MongoClient(sprintf('mongodb://%s:%s', $this->getParameter('gridfs', 'host'), $this->getParameter('gridfs', 'port')));
$db = $client->selectDB($this->getParameter('gridfs', 'db'));
$adapter = new Adapter\GridFS(new MongoGridFS($db));
break;
case 'mogilefs':
$adapter = new Adapter\MogileFS('http://*****:*****@%s/%s', $this->getParameter('mysql', 'user'), $this->getParameter('mysql', 'password'), $this->getParameter('mysql', 'host'), $this->getParameter('mysql', 'db'))]);
$sm = $connection->getSchemaManager();
$table = new \Doctrine\DBAL\Schema\Table('files');
if (!$sm->tablesExist(['files'])) {
$table = new \Doctrine\DBAL\Schema\Table('files');
$table->addColumn('key', 'string');
$table->addColumn('content', 'text');
$table->addColumn('mtime', 'string');
$table->addColumn('checksum', 'string');
$sm->createTable($table);
}
$adapter = new Adapter\DoctrineDbal($connection, $table->getName());
break;
default:
throw new \RuntimeException(sprintf('Unknown adapter %s', $name));
}
return new Filesystem($adapter);
}
public function testGenerateTableWithMultiColumnUniqueIndex()
{
$table = new \Doctrine\DBAL\Schema\Table('test');
$table->addColumn('foo', 'string', array('notnull' => false, 'length' => 255));
$table->addColumn('bar', 'string', array('notnull' => false, 'length' => 255));
$table->addUniqueIndex(array("foo", "bar"));
$sql = $this->_platform->getCreateTableSQL($table);
$this->assertEquals($this->getGenerateTableWithMultiColumnUniqueIndexSql(), $sql);
}
protected function createQueryTestTable()
{
$table = new \Doctrine\DBAL\Schema\Table('query_test');
$table->addColumn('id', 'integer');
$table->addColumn('val1', 'string');
$table->addColumn('val2', 'integer');
try {
$this->connection->getSchemaManager()->createTable($table);
} catch (DBALException $e) {
}
}
public function setUp()
{
parent::setUp();
try {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("fetch_table");
$table->addColumn('test_int', 'integer');
$table->addColumn('test_string', 'string');
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
$this->_conn->insert('fetch_table', array('test_int' => 1, 'test_string' => 'foo'));
} catch (\Exception $e) {
}
}
public function testDomainsTable()
{
if ($this->_conn->getDatabasePlatform()->getName() != "postgresql") {
$this->markTestSkipped('PostgreSQL only test');
}
$table = new \Doctrine\DBAL\Schema\Table("domains");
$table->addColumn('id', 'integer');
$table->addColumn('parent_id', 'integer');
$table->setPrimaryKey(array('id'));
$table->addForeignKeyConstraint('domains', array('parent_id'), array('id'));
$this->_conn->getSchemaManager()->createTable($table);
$table = $this->_conn->getSchemaManager()->listTableDetails('domains');
$this->assertEquals('domains', $table->getName());
}
public function setUp()
{
parent::setUp();
try {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("write_table");
$table->addColumn('test_int', 'integer');
$table->addColumn('test_string', 'string', array('notnull' => false));
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
} catch (\Exception $e) {
}
$this->_conn->executeUpdate('DELETE FROM write_table');
}
/**
* @group DDC-2387
*/
public function testCompositeAssociationKeyDetection()
{
$product = new \Doctrine\DBAL\Schema\Table('ddc2387_product');
$product->addColumn('id', 'integer');
$product->setPrimaryKey(array('id'));
$attributes = new \Doctrine\DBAL\Schema\Table('ddc2387_attributes');
$attributes->addColumn('product_id', 'integer');
$attributes->addColumn('attribute_name', 'string');
$attributes->setPrimaryKey(array('product_id', 'attribute_name'));
$attributes->addForeignKeyConstraint('ddc2387_product', array('product_id'), array('product_id'));
$metadata = $this->convertToClassMetadata(array($product, $attributes), array());
$this->assertEquals(ClassMetadataInfo::GENERATOR_TYPE_NONE, $metadata['Ddc2387Attributes']->generatorType);
$this->assertEquals(ClassMetadataInfo::GENERATOR_TYPE_AUTO, $metadata['Ddc2387Product']->generatorType);
}
public function testListTableWithBinary()
{
$tableName = 'test_binary_table';
$table = new \Doctrine\DBAL\Schema\Table($tableName);
$table->addColumn('id', 'integer');
$table->addColumn('column_varbinary', 'binary', array());
$table->addColumn('column_binary', 'binary', array('fixed' => true));
$table->setPrimaryKey(array('id'));
$this->_sm->createTable($table);
$table = $this->_sm->listTableDetails($tableName);
$this->assertInstanceOf('Doctrine\\DBAL\\Types\\BinaryType', $table->getColumn('column_varbinary')->getType());
$this->assertFalse($table->getColumn('column_varbinary')->getFixed());
$this->assertInstanceOf('Doctrine\\DBAL\\Types\\BinaryType', $table->getColumn('column_binary')->getType());
$this->assertFalse($table->getColumn('column_binary')->getFixed());
}
public function testGenerateTableWithAutoincrement()
{
$table = new \Doctrine\DBAL\Schema\Table('autoinc_table');
$column = $table->addColumn('id', 'integer');
$column->setAutoincrement(true);
$this->assertEquals(array('CREATE TABLE autoinc_table (id SERIAL NOT NULL)'), $this->_platform->getCreateTableSQL($table));
}
public function setUp()
{
parent::setUp();
try {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("write_table");
$table->addColumn('test_int', 'integer');
$table->addColumn('test_string', 'string', array('notnull' => false));
$table->setPrimaryKey(array('test_int'));
foreach ($this->_conn->getDatabasePlatform()->getCreateTableSQL($table) as $sql) {
$this->_conn->executeQuery($sql);
}
} catch (\Exception $e) {
}
$this->_conn->executeUpdate('DELETE FROM write_table');
}
public function setUp()
{
parent::setUp();
try {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("blob_table");
$table->addColumn('id', 'integer');
$table->addColumn('clobfield', 'text');
$table->addColumn('blobfield', 'blob');
$table->setPrimaryKey(array('id'));
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
} catch (\Exception $e) {
}
$this->_conn->exec($this->_conn->getDatabasePlatform()->getTruncateTableSQL('blob_table'));
}
public function setUp()
{
parent::setUp();
if (self::$generated === false) {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("fetch_table");
$table->addColumn('test_int', 'integer');
$table->addColumn('test_string', 'string');
$table->addColumn('test_datetime', 'datetime', array('notnull' => false));
$table->setPrimaryKey(array('test_int'));
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
$this->_conn->insert('fetch_table', array('test_int' => 1, 'test_string' => 'foo', 'test_datetime' => '2010-01-01 10:10:10'));
self::$generated = true;
}
}
public function testGenerateMixedCaseTableCreate()
{
$table = new \Doctrine\DBAL\Schema\Table("Foo");
$table->addColumn("Bar", "integer");
$sql = $this->_platform->getCreateTableSQL($table);
$this->assertEquals('CREATE TABLE Foo (Bar INT NOT NULL) ENGINE = InnoDB', array_shift($sql));
}
/**
* Do the migration
*/
public function up()
{
$container = $this->getContainer();
$table = new Doctrine\DBAL\Schema\Table('target_log');
$table->addColumn('id', 'integer', array('unsigned' => true, 'autoincrement' => true));
$table->addColumn('target_type', 'string', array('length' => 64, 'default' => '', 'null' => false, 'comment' => '日志对象类型'));
$table->addColumn('target_id', 'integer', array('default' => 0, 'null' => false, 'comment' => '日志对象ID'));
$table->addColumn('action', 'string', array('length' => 64, 'default' => '', 'null' => false, 'comment' => '日志行为'));
$table->addColumn('level', 'smallint', array('default' => 0, 'null' => false, 'comment' => '日志等级'));
$table->addColumn('message', 'text', array('comment' => '日志信息'));
$table->addColumn('context', 'text', array('comment' => '日志上下文'));
$table->addColumn('user_id', 'integer', array('default' => 0, 'null' => false, 'comment' => '操作人ID'));
$table->addColumn('ip', 'string', array('length' => 32, 'default' => '', 'null' => false, 'comment' => '操作人IP'));
$table->addColumn('created', 'integer', array('default' => 0, 'null' => false, 'comment' => '创建时间'));
$table->setPrimaryKey(array('id'));
$container['db']->getSchemaManager()->createTable($table);
}
public function setUp()
{
parent::setUp();
if (self::$generated === false) {
self::$generated = true;
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("write_table");
$table->addColumn('test_int', 'integer');
$table->addColumn('test_string', 'string');
$table->addColumn('test_float', 'float');
$table->addColumn('test_array', 'array', array('columnDefinition' => 'ARRAY(STRING)'));
$platformOptions = array('type' => MapType::STRICT, 'fields' => array(new Column('id', Type::getType('integer'), array()), new Column('name', Type::getType('string'), array()), new Column('value', Type::getType('float'), array())));
$table->addColumn('test_obj', MapType::NAME, array('platformOptions' => $platformOptions));
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
}
}
public function testCreateFederatedOnTable()
{
$table = new \Doctrine\DBAL\Schema\Table("tbl");
$table->addColumn("id", "integer");
$table->addOption('azure.federatedOnDistributionName', 'TblId');
$table->addOption('azure.federatedOnColumnName', 'id');
$this->assertEquals(array('CREATE TABLE tbl (id INT NOT NULL) FEDERATED ON (TblId = id)'), $this->platform->getCreateTableSQL($table));
}
public function setUp()
{
parent::setUp();
if (!self::$tableCreated) {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("modify_limit_table");
$table->addColumn('test_int', 'integer');
$table->setPrimaryKey(array('test_int'));
$table2 = new \Doctrine\DBAL\Schema\Table("modify_limit_table2");
$table2->addColumn('id', 'integer', array('autoincrement' => true));
$table2->addColumn('test_int', 'integer');
$table2->setPrimaryKey(array('id'));
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
$sm->createTable($table2);
self::$tableCreated = true;
}
}
public function testStrictMapTableCreationWithSchemaManager()
{
$platform = $this->_conn->getDatabasePlatform();
$table = new \Doctrine\DBAL\Schema\Table('items');
$objDefinition = array('type' => \Crate\DBAL\Types\MapType::STRICT, 'fields' => array(new \Doctrine\DBAL\Schema\Column('id', \Doctrine\DBAL\Types\Type::getType('integer'), array()), new \Doctrine\DBAL\Schema\Column('name', \Doctrine\DBAL\Types\Type::getType('string'), array())));
$table->addColumn('object_column', \Crate\DBAL\Types\MapType::NAME, array('platformOptions' => $objDefinition));
$createFlags = CratePlatform::CREATE_INDEXES | CratePlatform::CREATE_FOREIGNKEYS;
$sql = $platform->getCreateTableSQL($table, $createFlags);
$this->assertEquals(array('CREATE TABLE items (object_column OBJECT ( strict ) AS ( id INTEGER, name STRING ))'), $sql);
}
public function setUp()
{
parent::setUp();
if (self::$generated === false) {
self::$generated = true;
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$sm = $this->_conn->getSchemaManager();
$table = new \Doctrine\DBAL\Schema\Table("fetch_table");
$table->addColumn('test_int', 'integer');
$table->addColumn('test_string', 'string');
$table->addColumn('test_datetime', 'timestamp', array('notnull' => false));
$table->addColumn('test_array', 'array', array('columnDefinition' => 'ARRAY(STRING)'));
$platformOptions = array('type' => MapType::STRICT, 'fields' => array(new Column('id', Type::getType('integer'), array()), new Column('name', Type::getType('string'), array()), new Column('value', Type::getType('float'), array())));
$table->addColumn('test_object', MapType::NAME, array('platformOptions' => $platformOptions));
$table->setPrimaryKey(array('test_int'));
$sm->createTable($table);
$this->_conn->insert('fetch_table', array('test_int' => 1, 'test_string' => 'foo', 'test_datetime' => new \DateTime('2010-01-01 10:10:10'), 'test_array' => array('foo', 'bar'), 'test_object' => array('id' => 1, 'name' => 'foo', 'value' => 1.234)), array('integer', 'string', 'timestamp', 'array', 'map'));
$this->refresh('fetch_table');
}
}
protected function setUp()
{
parent::setUp();
if ($this->_conn->getDriver() instanceof \Doctrine\DBAL\Driver\PDOSqlsrv\Driver) {
$this->markTestSkipped('This test does not work on pdo_sqlsrv driver due to a bug. See: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5a755bdd-41e9-45cb-9166-c9da4475bb94/how-to-set-null-for-varbinarymax-using-bindvalue-using-pdosqlsrv?forum=sqldriverforphp');
}
try {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("blob_table");
$table->addColumn('id', 'integer');
$table->addColumn('clobfield', 'text');
$table->addColumn('blobfield', 'blob');
$table->addColumn('binaryfield', 'binary', array('length' => 50));
$table->setPrimaryKey(array('id'));
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
} catch (\Exception $e) {
}
$this->_conn->exec($this->_conn->getDatabasePlatform()->getTruncateTableSQL('blob_table'));
}
public function setUp()
{
parent::setUp();
try {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("caching");
$table->addColumn('test_int', 'integer');
$table->addColumn('test_string', 'string', array('notnull' => false));
$table->setPrimaryKey(array('test_int'));
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
} catch (\Exception $e) {
}
$this->_conn->executeUpdate('DELETE FROM caching');
foreach ($this->expectedResult as $row) {
$this->_conn->insert('caching', $row);
}
$config = $this->_conn->getConfiguration();
$config->setSQLLogger($this->sqlLogger = new \Doctrine\DBAL\Logging\DebugStack());
$cache = new \Doctrine\Common\Cache\ArrayCache();
$config->setResultCacheImpl($cache);
}
public function testCreateYamlWithForeignKeyFromDatabase()
{
if (!$this->_em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) {
$this->markTestSkipped('Platform does not support foreign keys.');
}
$tableB = new \Doctrine\DBAL\Schema\Table("dbdriver_bar");
$tableB->addColumn('id', 'integer');
$tableB->setPrimaryKey(array('id'));
$this->_sm->dropAndCreateTable($tableB);
$tableA = new \Doctrine\DBAL\Schema\Table("dbdriver_baz");
$tableA->addColumn('id', 'integer');
$tableA->setPrimaryKey(array('id'));
$tableA->addColumn('bar_id', 'integer');
$tableA->addForeignKeyConstraint('dbdriver_bar', array('bar_id'), array('id'));
$this->_sm->dropAndCreateTable($tableA);
$metadata = $this->extractClassMetadata("DbdriverBaz");
$this->assertArrayNotHasKey('bar', $metadata->fieldMappings);
$this->assertArrayHasKey('id', $metadata->fieldMappings);
$metadata->associationMappings = \array_change_key_case($metadata->associationMappings, \CASE_LOWER);
$this->assertArrayHasKey('bar', $metadata->associationMappings);
$this->assertType('Doctrine\\ORM\\Mapping\\OneToOneMapping', $metadata->associationMappings['bar']);
}
private function getPortableConnection($portabilityMode = \Doctrine\DBAL\Portability\Connection::PORTABILITY_ALL, $case = \PDO::CASE_LOWER)
{
if (!$this->portableConnection) {
$params = $this->_conn->getParams();
$params['wrapperClass'] = 'Doctrine\\DBAL\\Portability\\Connection';
$params['portability'] = $portabilityMode;
$params['fetch_case'] = $case;
$this->portableConnection = DriverManager::getConnection($params, $this->_conn->getConfiguration(), $this->_conn->getEventManager());
try {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("portability_table");
$table->addColumn('Test_Int', 'integer');
$table->addColumn('Test_String', 'string', array('fixed' => true, 'length' => 32));
$table->addColumn('Test_Null', 'string', array('notnull' => false));
$sm = $this->portableConnection->getSchemaManager();
$sm->createTable($table);
$this->portableConnection->insert('portability_table', array('Test_Int' => 1, 'Test_String' => 'foo', 'Test_Null' => ''));
$this->portableConnection->insert('portability_table', array('Test_Int' => 1, 'Test_String' => 'foo ', 'Test_Null' => null));
} catch (\Exception $e) {
}
}
return $this->portableConnection;
}
public function setUp()
{
parent::setUp();
if (!$this->_conn->getSchemaManager()->tablesExist("ddc1372_foobar")) {
try {
$table = new \Doctrine\DBAL\Schema\Table("ddc1372_foobar");
$table->addColumn('id', 'integer');
$table->addColumn('foo', 'string');
$table->addColumn('bar', 'string');
$table->setPrimaryKey(array('id'));
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
$this->_conn->insert('ddc1372_foobar', array('id' => 1, 'foo' => 1, 'bar' => 1));
$this->_conn->insert('ddc1372_foobar', array('id' => 2, 'foo' => 1, 'bar' => 2));
$this->_conn->insert('ddc1372_foobar', array('id' => 3, 'foo' => 1, 'bar' => 3));
$this->_conn->insert('ddc1372_foobar', array('id' => 4, 'foo' => 1, 'bar' => 4));
$this->_conn->insert('ddc1372_foobar', array('id' => 5, 'foo' => 2, 'bar' => 1));
$this->_conn->insert('ddc1372_foobar', array('id' => 6, 'foo' => 2, 'bar' => 2));
} catch (\Exception $e) {
$this->fail($e->getMessage());
}
}
}
/**
* Return Current Migration Status of the database.
*
* @return MigrationStatus
*/
public function getCurrentStatus()
{
$schemaManager = $this->connection->getSchemaManager();
$tables = $schemaManager->listTableNames();
if (!in_array('changelog', $tables)) {
$table = new \Doctrine\DBAL\Schema\Table('changelog');
$table->addColumn('change_number', 'integer');
$table->addColumn('complete_dt', 'datetime', array('columnDefinition' => 'TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
$table->addColumn('applied_by', 'string', array('length' => 100));
$table->addcolumn('description', 'string', array('length' => 500));
$table->setPrimaryKey(array('change_number'));
$schemaManager->createTable($table);
}
$allMigrations = $this->getAllMigrations($this->schemaDirectory);
$appliedMigrations = $this->getAppliedMigrations();
$applyMigrations = array();
foreach ($allMigrations as $revision => $data) {
if (!isset($appliedMigrations[$revision])) {
$applyMigrations[$revision] = $data;
}
}
return new MigrationStatus($allMigrations, $appliedMigrations, $applyMigrations);
}
public function startTestSuite(PHPUnit_Framework_TestSuite $suite)
{
if (!class_exists($suite->getName())) {
return;
}
if (!self::$booted && self::$logSQL) {
self::$booted = true;
$app = new \Alchemy\Phrasea\Application(\Alchemy\Phrasea\Application::ENV_TEST);
self::$conn = $app['dbal.provider']($app['db.info']($app['db.appbox.info']));
unset($app);
self::$conn->connect();
$schema = self::$conn->getSchemaManager();
$tableTest = new \Doctrine\DBAL\Schema\Table("tests");
/* Add some columns to the table */
$tableTest->addColumn("id", "integer", array("unsigned" => true, "autoincrement" => true));
$tableTest->addColumn("test", "string", array("length" => 256));
$tableTest->addColumn("name", "string", array("length" => 256));
$tableTest->addColumn("status", "string", array("length" => 16));
$tableTest->addColumn("duration", "float");
/* Add a primary key */
$tableTest->setPrimaryKey(array("id"));
$schema->dropAndCreateTable($tableTest);
}
}
protected function setUp()
{
parent::setUp();
if ($this->_conn->getDatabasePlatform()->getName() != 'oracle') {
$this->markTestSkipped('OCI8 only test');
}
if ($this->_conn->getSchemaManager()->tablesExist('DBAL202')) {
$this->_conn->executeQuery('DELETE FROM DBAL202');
} else {
$table = new \Doctrine\DBAL\Schema\Table('DBAL202');
$table->addColumn('id', 'integer');
$table->setPrimaryKey(array('id'));
$this->_conn->getSchemaManager()->createTable($table);
}
}
public function testLoadMetadataWithForeignKeyFromDatabase()
{
if (!$this->_em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) {
$this->markTestSkipped('Platform does not support foreign keys.');
}
$tableB = new \Doctrine\DBAL\Schema\Table("dbdriver_bar");
$tableB->addColumn('id', 'integer');
$tableB->setPrimaryKey(array('id'));
$this->_sm->dropAndCreateTable($tableB);
$tableA = new \Doctrine\DBAL\Schema\Table("dbdriver_baz");
$tableA->addColumn('id', 'integer');
$tableA->setPrimaryKey(array('id'));
$tableA->addColumn('bar_id', 'integer');
$tableA->addForeignKeyConstraint('dbdriver_bar', array('bar_id'), array('id'));
$this->_sm->dropAndCreateTable($tableA);
$metadatas = $this->extractClassMetadata(array("DbdriverBar", "DbdriverBaz"));
$this->assertArrayHasKey('DbdriverBaz', $metadatas);
$bazMetadata = $metadatas['DbdriverBaz'];
$this->assertArrayNotHasKey('barId', $bazMetadata->fieldMappings, "The foreign Key field should not be inflected as 'barId' field, its an association.");
$this->assertArrayHasKey('id', $bazMetadata->fieldMappings);
$bazMetadata->associationMappings = \array_change_key_case($bazMetadata->associationMappings, \CASE_LOWER);
$this->assertArrayHasKey('bar', $bazMetadata->associationMappings);
$this->assertEquals(ClassMetadataInfo::MANY_TO_ONE, $bazMetadata->associationMappings['bar']['type']);
}
public function setUp()
{
parent::setUp();
if ($this->_conn->getDatabasePlatform()->getName() == "sqlite") {
$this->markTestSkipped('Test does not work on sqlite.');
}
try {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("master_slave_table");
$table->addColumn('test_int', 'integer');
$table->setPrimaryKey(array('test_int'));
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
$this->_conn->insert('master_slave_table', array('test_int' => 1));
} catch (\Exception $e) {
}
}
public function setUp()
{
parent::setUp();
if (!self::$tableCreated) {
/* @var $sm \Doctrine\DBAL\Schema\AbstractSchemaManager */
$table = new \Doctrine\DBAL\Schema\Table("modify_limit_table");
$table->addColumn('test_int', 'integer');
$table2 = new \Doctrine\DBAL\Schema\Table("modify_limit_table2");
$table2->addColumn('test_int', 'integer');
$sm = $this->_conn->getSchemaManager();
$sm->createTable($table);
$sm->createTable($table2);
self::$tableCreated = true;
}
$this->_conn->exec($this->_conn->getDatabasePlatform()->getTruncateTableSQL('modify_limit_table'));
$this->_conn->exec($this->_conn->getDatabasePlatform()->getTruncateTableSQL('modify_limit_table2'));
}
