function flush()
{
$this->db_table->delete();
}
function testRemoveAllDeletesOnlyProperRecordsFromTable()
{
$group1 = $this->_initGroup();
$group2 = $this->_initGroup();
$user = new UserForTestWithSpecialRelationTable();
$user->setFirstName('User' . mt_rand());
$user->save();
$collection = new lmbARManyToManyCollection('groups', $user);
$collection->add($group1);
$collection->add($group2);
$db_table = new lmbTableGateway('extended_user_for_test2group_for_test');
$db_table->insert(array('user_id' => $user->getId(), 'other_id' => 100));
$collection->removeAll();
$this->assertEqual($db_table->select()->count(), 1);
}
protected function _initCmsDocumentTable()
{
$table = new lmbTableGateway('lmb_cms_document');
$root = array('parent_id' => 0, 'identifier' => '', 'uri' => '/');
$table->insert($root);
}
function remove($object)
{
$table = new lmbTableGateway($this->relation_info['table'], $this->conn);
$criteria = new lmbSQLCriteria();
$criteria->addAnd(lmbSQLCriteria::equal($this->relation_info['field'], $this->owner->getId()));
$criteria->addAnd(lmbSQLCriteria::equal($this->relation_info['foreign_field'], $object->getId()));
$table->delete($criteria);
$this->reset();
}
function testFillMetaInfoFromDB()
{
$table = new lmbTableGateway('all_types_test', $this->conn);
$expected = array('field_int' => 'field_int', 'field_varchar' => 'field_varchar', 'field_char' => 'field_char', 'field_date' => 'field_date', 'field_datetime' => 'field_datetime', 'field_time' => 'field_time', 'field_text' => 'field_text', 'field_smallint' => 'field_smallint', 'field_bigint' => 'field_bigint', 'field_blob' => 'field_blob', 'field_float' => 'field_float', 'field_decimal' => 'field_decimal', 'field_tinyint' => 'field_tinyint');
$this->assertEqual($table->getColumnNames(), $expected);
}
