public function testIt()
{
$m = $this->_model;
$r = $m->getRow(1);
$this->assertEquals('aaabbbccc', $r->foo);
$this->assertEquals('abcd', $r->bar);
$this->assertEquals('aha', $r->baz);
$r = $m->getRow(2);
$this->assertEquals('bam', $r->foo);
$this->assertEquals('bum', $r->bar);
$this->assertEquals(null, $r->baz);
$r = $m->getRow($m->select()->whereEquals('baz', 'aha'));
$this->assertNotNull($r);
$this->assertEquals(1, $r->id);
$r = $m->getRow($m->select()->whereNull('baz'));
$this->assertNotNull($r);
$this->assertEquals(2, $r->id);
$r = $m->getRows($m->select()->order('baz'));
$this->assertEquals(2, count($r));
$r = $m->createRow();
$r->foo = 'xxy';
$r->baz = 'xxz';
$r->save();
$tableName = Kwf_Model_Abstract::getInstance('Kwf_Model_DbWithConnection_DbSiblingProxy_DbModel')->getTable()->info(Zend_Db_Table_Abstract::NAME);
$m = new Kwf_Model_Db(array('table' => $tableName));
$r = $m->getRow(3);
$this->assertEquals('xxy', $r->foo);
$this->assertEquals(null, $r->bar);
$tableName = Kwf_Model_Abstract::getInstance('Kwf_Model_DbWithConnection_DbSiblingProxy_SiblingModel')->getTable()->info(Zend_Db_Table_Abstract::NAME);
$m = new Kwf_Model_Db(array('table' => $tableName));
$r = $m->getRow(3);
$this->assertEquals('xxz', $r->baz);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
$config['exprs'] = array('sum_field_int' => new Kwf_Model_Select_Expr_SumFields(array('value2', 10)), 'sum_int_int' => new Kwf_Model_Select_Expr_SumFields(array(100, 10, 99)), 'sum_field_field' => new Kwf_Model_Select_Expr_SumFields(array('value2', 'id')));
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
$config['exprs'] = array('date_year' => new Kwf_Model_Select_Expr_Date_Year('date'), 'date_year_two_digits' => new Kwf_Model_Select_Expr_Date_Year('date', Kwf_Model_Select_Expr_Date_Year::FORMAT_DIGITS_TWO), 'date_format' => new Kwf_Model_Select_Expr_Date_Format('date'), 'date_format2' => new Kwf_Model_Select_Expr_Date_Format('date', 'd.m.Y'));
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest_child');
$config['table'] = $this->_tableName;
$this->_referenceMap = array('Parent' => 'parent_id->Kwf_Model_DbWithConnection_ParentExpr_ParentModel');
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = 'import' . uniqid();
$config['table'] = $this->_tableName;
Kwf_Registry::get('db')->query("CREATE TABLE {$this->_tableName} (\n `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n `foo` VARCHAR( 200 ) NOT NULL ,\n `bar` VARCHAR( 200 ) NOT NULL\n ) ENGINE = INNODB");
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest_childsum_foo');
$config['table'] = $this->_tableName;
$this->_dependentModels['FooTooBar'] = 'Kwf_Model_DbWithConnection_ExprChildSum_FooToBarModel';
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
$config['exprs'] = array('foo1' => new Kwf_Model_Select_Expr_Child_GroupConcat('Children', 'id'), 'foo2' => new Kwf_Model_Select_Expr_Child_GroupConcat('Children', 'id', ', '));
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
$config['exprs'] = array('age' => new Kwf_Model_Select_Expr_Date_Age('birth'), 'age2' => new Kwf_Model_Select_Expr_Sql("SELECT expr{age} + expr{age}"));
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest_parent');
$config['table'] = $this->_tableName;
$this->_dependentModels['Childs'] = 'Kwf_Model_DbWithConnection_ParentParentExpr_MiddleModel';
parent::__construct($config);
}
protected function _init()
{
parent::_init();
$this->_exprs['name'] = new Kwf_Model_Select_Expr_Concat(array(new Kwf_Model_Select_Expr_Field('date'), new Kwf_Model_Select_Expr_String(': '), new Kwf_Model_Select_Expr_Field('title')));
$this->_exprs['date_year'] = new Kwf_Model_Select_Expr_Date_Year('date');
$this->_exprs['is_top'] = new Kwf_Model_Select_Expr_If(new Kwf_Model_Select_Expr_And(array(new Kwf_Model_Select_Expr_Equal('is_top_checked', 1), new Kwf_Model_Select_Expr_Or(array(new Kwf_Model_Select_Expr_IsNull('is_top_expire'), new Kwf_Model_Select_Expr_HigherEqual('is_top_expire', new Kwf_Date(mktime())))))), new Kwf_Model_Select_Expr_String(1), new Kwf_Model_Select_Expr_String(0));
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
$config['exprs'] = array('price' => new Kwf_Model_Select_Expr_Integer(100), 'amount' => new Kwf_Model_Select_Expr_Integer('3'), 'total' => new Kwf_Model_Select_Expr_Multiply(array(new Kwf_Model_Select_Expr_Field('price'), new Kwf_Model_Select_Expr_Field('amount'))));
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
$config['exprs'] = array('position' => new Kwf_Model_Select_Expr_Position('points', array('gr')), 'position_dir' => new Kwf_Model_Select_Expr_Position('points', array('gr'), 'asc'));
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest_parent2');
$config['table'] = $this->_tableName;
$this->_dependentModels['Childs'] = 'Kwf_Model_DbWithConnection_ProxyReferences_ChildModel';
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
$config['exprs'] = array('inrange' => new Kwf_Model_Select_Expr_Area(47.8904081, 13.1834356, 50));
parent::__construct($config);
}
protected function _init()
{
parent::_init();
$this->_exprs['category_name'] = new Kwf_Model_Select_Expr_Parent('Category', 'name');
if (!count($this->_referenceMap['Item'])) {
throw new Kwf_Exception("Reference 'Item' must be set in model '" . get_class($this) . "' and set in component as setting 'categoryToItemModelName'");
}
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
$s = new Kwf_Model_Select();
$config['exprs'] = array('foo1' => new Kwf_Model_Select_Expr_Child_GroupConcat('Children', 'id'), 'foo2' => new Kwf_Model_Select_Expr_Child_GroupConcat('Children', 'id', ', '), 'foo3' => new Kwf_Model_Select_Expr_Child_GroupConcat('Children', 'id', ', ', $s, 'sort_field'), 'foo4' => new Kwf_Model_Select_Expr_Child_GroupConcat('Children', 'id', ', ', $s, array('field' => 'sort_field', 'direction' => 'DESC')));
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest_child');
$config['table'] = $this->_tableName;
$this->_referenceMap = array('Parent' => 'parent_id->Kwf_Model_DbWithConnection_ParentExprDeletedFlag_ParentModel');
$this->_exprs['parent_foo'] = new Kwf_Model_Select_Expr_Parent('Parent', 'foo');
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest_childstart');
$config['table'] = $this->_tableName;
$this->_dependentModels['Childs'] = 'Kwf_Model_DbWithConnection_ProxyReferences_ParentModel';
$this->_referenceMap = array('StartParent' => 'parent_id->Kwf_Model_DbWithConnection_ProxyReferences_ParentModel');
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = 'sibling' . uniqid();
$config['table'] = $this->_tableName;
Kwf_Registry::get('db')->query("CREATE TABLE {$this->_tableName} (\n `master_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n `baz` VARCHAR( 200 ) NOT NULL\n ) ENGINE = INNODB");
Kwf_Registry::get('db')->query("INSERT INTO {$this->_tableName}\n (master_id, baz) VALUES ('1', 'aha')");
parent::__construct($config);
}
public function __construct($config = array())
{
$today = date('Y-m-d');
$tomorrow = date('Y-m-d', strtotime("{$today} +1 day"));
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
$config['exprs'] = array('age' => new Kwf_Model_Select_Expr_Date_Age('birth'), 'age_ref' => new Kwf_Model_Select_Expr_Date_Age('birth', new Kwf_Date($tomorrow)));
parent::__construct($config);
}
public function __construct()
{
$this->_tableName = 'relation_sibling' . uniqid();
$config['table'] = $this->_tableName;
Kwf_Registry::get('db')->query("CREATE TABLE {$this->_tableName} (\n `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n `foo` INT NOT NULL\n ) ENGINE = INNODB");
Kwf_Registry::get('db')->query("INSERT INTO {$this->_tableName}\n (id, foo) VALUES ('1', 123)");
Kwf_Registry::get('db')->query("INSERT INTO {$this->_tableName}\n (id, foo) VALUES ('2', 321)");
parent::__construct($config);
}
public function __construct()
{
$this->_tableName = 'master' . uniqid();
$config['table'] = $this->_tableName;
Kwf_Registry::get('db')->query("CREATE TABLE {$this->_tableName} (\n `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY\n ) ENGINE = INNODB");
Kwf_Registry::get('db')->query("INSERT INTO {$this->_tableName}\n (id) VALUES ('1')");
Kwf_Registry::get('db')->query("INSERT INTO {$this->_tableName}\n (id) VALUES ('2')");
parent::__construct($config);
}
protected function _init()
{
parent::_init();
$this->_referenceMap['User'] = '******' . Kwf_Registry::get('config')->user->model;
$this->_exprs['component_id'] = new Kwf_Model_Select_Expr_Parent('ComponentToTag', 'component_id');
$this->_exprs['tag_count_used'] = new Kwf_Model_Select_Expr_Parent('ComponentToTag', 'tag_count_used');
$this->_exprs['tag_name'] = new Kwf_Model_Select_Expr_Parent('ComponentToTag', 'tag_name');
$this->_exprs['user_email'] = new Kwf_Model_Select_Expr_Parent('User', 'email');
}
public function __construct($config = array())
{
$this->_tableName = 'master' . uniqid();
$config['table'] = $this->_tableName;
Kwf_Registry::get('db')->query("CREATE TABLE {$this->_tableName} (\n `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n `foo` VARCHAR( 200 ) NOT NULL ,\n `bar` VARCHAR( 200 ) NOT NULL\n ) ENGINE = INNODB");
Kwf_Registry::get('db')->query("INSERT INTO {$this->_tableName}\n (id, foo, bar) VALUES ('1', 'aaabbbccc', 'abcd')");
Kwf_Registry::get('db')->query("INSERT INTO {$this->_tableName}\n (id, foo, bar) VALUES ('2', 'bam', 'bum')");
parent::__construct($config);
}
protected function _init()
{
parent::_init();
$this->_exprs['expr_bar'] = new Kwf_Model_Select_Expr_Field('bar');
$this->_exprs['expr_bar2'] = new Kwf_Model_Select_Expr_Field('bar2');
$this->_exprs['expr_foo'] = new Kwf_Model_Select_Expr_Field('foo');
$this->_exprs['expr_bar_compare'] = new Kwf_Model_Select_Expr_Equals('expr_bar', new Kwf_Model_Select_Expr_Field('bar2'));
$this->_exprs['expr_foo_bar_higher'] = new Kwf_Model_Select_Expr_HigherEqual('expr_bar', new Kwf_Model_Select_Expr_Field('expr_foo'));
}
protected function _init()
{
parent::_init();
$s = $this->select();
$s->limit(1);
$s->order('valid_from', 'DESC');
$s->where(new Kwf_Model_Select_Expr_Lower('valid_from', new Kwf_DateTime(time())));
$this->_exprs['current_price'] = new Kwf_Model_Select_Expr_Child('Prices', new Kwf_Model_Select_Expr_Field('price'), $s);
$this->_exprs['current_price_id'] = new Kwf_Model_Select_Expr_Child('Prices', new Kwf_Model_Select_Expr_Field('id'), $s);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest_middle');
$config['table'] = $this->_tableName;
$this->_referenceMap = array('Parent' => 'parent_id->Kwf_Model_DbWithConnection_ParentParentExpr_ParentModel');
$this->_dependentModels['Childs'] = 'Kwf_Model_DbWithConnection_ParentParentExpr_ChildModel';
$this->_exprs['parent_foo'] = new Kwf_Model_Select_Expr_Parent('Parent', 'foo');
$this->_exprs['child_count'] = new Kwf_Model_Select_Expr_Child_Count('Childs', null);
parent::__construct($config);
}
public function hasColumn($col)
{
if ($col == 'visible') {
return false;
}
if ($col == 'component_id') {
return false;
}
return parent::hasColumn($col);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest_child');
$config['table'] = $this->_tableName;
$this->_referenceMap = array('Parent' => 'parent_id->Kwf_Model_DbWithConnection_ParentExprIf_ParentModel');
$this->_exprs['bar_is_null'] = new Kwf_Model_Select_Expr_IsNull('bar');
$this->_exprs['if_field'] = new Kwf_Model_Select_Expr_If(new Kwf_Model_Select_Expr_Field('bar_is_null'), new Kwf_Model_Select_Expr_Parent('Parent', 'id'), new Kwf_Model_Select_Expr_Parent('Parent', 'parent_value'));
$this->_exprs['if_field_sibling'] = new Kwf_Model_Select_Expr_If(new Kwf_Model_Select_Expr_Field('bar_is_null'), new Kwf_Model_Select_Expr_Parent('Parent', 'id'), new Kwf_Model_Select_Expr_Parent('Parent', 'sibling_value'));
$this->_exprs['parent_value'] = new Kwf_Model_Select_Expr_Parent('Parent', 'parent_value');
$this->_exprs['sibling_value'] = new Kwf_Model_Select_Expr_Parent('Parent', 'sibling_value');
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
$config['exprs'] = array();
$config['exprs']['count_model2'] = new Kwf_Model_Select_Expr_Child_Count('Model2');
$config['exprs']['count_model2_field'] = new Kwf_Model_Select_Expr_Child('Model2', new Kwf_Model_Select_Expr_Count('foo2'));
$config['exprs']['count_model2_distinct'] = new Kwf_Model_Select_Expr_Child('Model2', new Kwf_Model_Select_Expr_Count('foo2', true));
$config['exprs']['sum_model2'] = new Kwf_Model_Select_Expr_Child('Model2', new Kwf_Model_Select_Expr_Sum('foo2'));
$select = new Kwf_Model_Select();
$select->whereEquals('bar', 'bam');
$config['exprs']['count_model2_bam'] = new Kwf_Model_Select_Expr_Child('Model2', new Kwf_Model_Select_Expr_Count(), $select);
$config['exprs']['count_model2_bam_distinct'] = new Kwf_Model_Select_Expr_Child('Model2', new Kwf_Model_Select_Expr_Count('foo2', true), $select);
$config['exprs']['sum_model2_bam'] = new Kwf_Model_Select_Expr_Child('Model2', new Kwf_Model_Select_Expr_Sum('foo2'), $select);
parent::__construct($config);
}
