public function setUp()
{
parent::setUp();
$this->db = new \Amiss\Test\Helper\TestConnector('sqlite::memory:');
$this->mapper = new \Amiss\Test\Helper\TestMapper();
$this->manager = new \Amiss\Sql\Manager($this->db, $this->mapper);
}
public function setUp()
{
parent::setUp();
$this->connector = new \Amiss\Test\Helper\TestConnector('mysql:xx');
$this->mapper = \Amiss\Sql\Factory::createMapper();
$this->manager = new \Amiss\Sql\Manager($this->connector, $this->mapper);
$this->class = __NAMESPACE__ . '\\TestCreateWithCustomType';
}
public function setUp()
{
parent::setUp();
\Amiss\Sql\ActiveRecord::_reset();
$this->connector = new \Amiss\Test\Helper\TestConnector('mysql:xx');
$this->mapper = \Amiss\Sql\Factory::createMapper(array());
$this->manager = new \Amiss\Sql\Manager($this->connector, $this->mapper);
\Amiss\Sql\ActiveRecord::setManager($this->manager);
$this->class = __NAMESPACE__ . '\\TestCreateCustomTypeWithEmptyColumnTypeRecord';
}
public function setUp()
{
parent::setUp();
$mapper = $this->mapper = new \Amiss\Mapper\Note();
$translator = new \Amiss\Name\CamelToUnderscore();
$this->mapper->defaultTableNameTranslator = function ($objectName) use($mapper, $translator) {
return 'yep_' . $mapper->convertUnknownTableName($objectName);
};
$this->manager = new \Amiss\Sql\Manager(array(), $this->mapper);
}
public function setUp()
{
parent::setUp();
$this->connector = new \PDOK\Connector('sqlite::memory:');
$this->connector->exec("ATTACH DATABASE ':memory:' AS schema_one;");
$this->connector->exec("ATTACH DATABASE ':memory:' AS schema_two;");
$this->connector->exec("CREATE TABLE schema_one.table_one(id INTEGER PRIMARY KEY AUTOINCREMENT, oneName STRING, twoId INTEGER)");
$this->connector->exec("CREATE TABLE schema_two.table_two(id INTEGER PRIMARY KEY AUTOINCREMENT, twoName STRING)");
$this->manager = \Amiss\Sql\Factory::createManager($this->connector);
$this->mapper = $this->manager->mapper;
}
function setUp()
{
parent::setUp();
$mappings = ['foo' => ['table' => 'foo', 'class' => 'stdClass', 'fields' => ['fooId' => true, 'foo' => true]], 'bar' => ['table' => 'bar', 'class' => 'stdClass', 'fields' => ['barId' => true, 'fooId' => true, 'bar' => true]]];
$this->deps = Factory::managerArraysModelCustom($mappings);
$this->deps->mapper->mappings['baz'] = ['table' => 'baz', 'class' => 'stdClass', 'fields' => ['fooId' => true, 'barId' => true, 'foo' => true, 'bar' => true]];
$this->deps->connector->query("\n CREATE VIEW baz AS\n SELECT bar.fooId, bar.barId, foo.foo, bar.bar FROM bar\n INNER JOIN foo ON foo.fooId = bar.fooId\n ");
$this->deps->manager->insertTable('foo', ['fooId' => 1, 'foo' => 'a']);
$this->deps->manager->insertTable('foo', ['fooId' => 2, 'foo' => 'b']);
$this->deps->manager->insertTable('bar', ['fooId' => 1, 'barId' => 1, 'bar' => 'a']);
$this->deps->manager->insertTable('bar', ['fooId' => 1, 'barId' => 2, 'bar' => 'b']);
}
public function setUp()
{
parent::setUp();
$this->deps = Test\Factory::managerArraysModelCustom(['Parent' => ['class' => 'stdClass', 'table' => 't1', 'fields' => ['id' => ['primary' => true], 'orderedId' => ['index' => true]], 'relations' => ['ordered' => ['one', 'of' => 'Ordered', 'from' => 'orderedId']]], 'Ordered' => ['class' => 'stdClass', 'table' => 't2', 'primary' => 'id', 'fields' => ['id' => true, 'yep' => true, 'sort' => true], 'defaultOrder' => 'sort']]);
$this->manager = $this->deps->manager;
$this->manager->insertTable('Ordered', ['id' => 1, 'yep' => 2, 'sort' => 3]);
$this->manager->insertTable('Ordered', ['id' => 2, 'yep' => 2, 'sort' => 2]);
$this->manager->insertTable('Ordered', ['id' => 3, 'yep' => 2, 'sort' => 1]);
$this->manager->insertTable('Parent', ['id' => 1, 'orderedId' => 2]);
$this->manager->insertTable('Parent', ['id' => 2, 'orderedId' => 1]);
$this->manager->insertTable('Parent', ['id' => 3, 'orderedId' => 3]);
}
public function setUp()
{
parent::setUp();
$this->mapper = new \Amiss\Test\Helper\TestMapper();
$this->db = $this->getMockBuilder('PDOK\\Connector')->disableOriginalConstructor()->getMock();
$this->manager = $this->getMockBuilder('Amiss\\Sql\\Manager')->setConstructorArgs(array($this->db, $this->mapper))->setMethods(array('getList', 'get', 'getRelated'))->getMock();
$this->relator = new \Amiss\Sql\Relator\OneMany($this->manager);
if (!class_exists('DummyParent')) {
eval('
class DummyParent { public $id; public $parentId; }
class DummyChild { public $id; }
');
}
}
public function tearDown()
{
$this->manager = null;
$this->deps = null;
parent::tearDown();
}
public function setUp()
{
parent::setUp();
$this->manager = new \Amiss\Sql\Manager(new \PDOK\Connector('sqlite::memory:'), new \Amiss\Mapper\Note());
}
public function tearDown()
{
\Amiss\Sql\ActiveRecord::_reset();
$this->deps = null;
parent::tearDown();
}
public function setUp()
{
parent::setUp();
$this->mapper = $this->getMockBuilder('Amiss\\Mapper\\Base')->disableOriginalConstructor()->getMockForAbstractClass();
}
