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 = 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('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');
$config['table'] = $this->_tableName;
$config['exprs'] = array('inrange' => new Kwf_Model_Select_Expr_Area(47.8904081, 13.1834356, 50));
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest_childsum_foo_to_bar');
$config['table'] = $this->_tableName;
$this->_referenceMap = array('Foo' => 'foo_id->Kwf_Model_DbWithConnection_ExprChildSum_FooModel', 'Bar' => 'bar_id->Kwf_Model_DbWithConnection_ExprChildSum_BarModel');
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_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('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_parent');
$config['table'] = $this->_tableName;
$this->_dependentModels['Childs'] = 'Kwf_Model_DbWithConnection_ParentParentExpr_MiddleModel';
parent::__construct($config);
}
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('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');
$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 = '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_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');
$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_references_within');
$config['table'] = $this->_tableName;
$this->_referenceMap = array('Parent' => 'parent_id->Kwf_Model_DbWithConnection_ReferencesWithinModel_Model');
$this->_dependentModels['Childs'] = 'Kwf_Model_DbWithConnection_ReferencesWithinModel_Model';
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()
{
$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);
}
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($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);
}
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($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 __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);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest2');
$config['table'] = $this->_tableName;
$config['exprs'] = array();
$config['exprs']['model1_bar'] = new Kwf_Model_Select_Expr_Parent('Model1', 'bar');
$config['exprs']['model1_bar_concat_foo2'] = new Kwf_Model_Select_Expr_Concat(array(new Kwf_Model_Select_Expr_Parent('Model1', 'bar'), 'foo2'));
$config['exprs']['model1_bar_concat_string'] = new Kwf_Model_Select_Expr_Concat(array(new Kwf_Model_Select_Expr_Parent('Model1', 'bar'), new Kwf_Model_Select_Expr_String('_string')));
$config['exprs']['model1_bar_concat_foo2_bar_string'] = new Kwf_Model_Select_Expr_Concat(array(new Kwf_Model_Select_Expr_Parent('Model1', 'bar'), 'foo2', 'bar', new Kwf_Model_Select_Expr_String('_string')));
$config['exprs']['strpad_3_right'] = new Kwf_Model_Select_Expr_StrPad('bar', 3, '0');
$config['exprs']['strpad_4_right'] = new Kwf_Model_Select_Expr_StrPad('bar', 4, '0');
$config['exprs']['strpad_6_right'] = new Kwf_Model_Select_Expr_StrPad('bar', 6, '0');
$config['exprs']['strpad_3_left'] = new Kwf_Model_Select_Expr_StrPad('bar', 3, '0', Kwf_Model_Select_Expr_StrPad::LEFT);
$config['exprs']['strpad_4_left'] = new Kwf_Model_Select_Expr_StrPad('bar', 4, '0', Kwf_Model_Select_Expr_StrPad::LEFT);
$config['exprs']['strpad_6_left'] = new Kwf_Model_Select_Expr_StrPad('bar', 6, '0', Kwf_Model_Select_Expr_StrPad::LEFT);
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_table = new Kwf_Form_CardsRealModels_Model_FirstnameTable();
parent::__construct($config);
}
public function __construct($config = array())
{
$this->_tableName = uniqid('dbtest');
$config['table'] = $this->_tableName;
parent::__construct($config);
}
public function __construct(array $config = array())
{
$this->_referenceMap['User'] = '******' . get_class(Kwf_Registry::get('userModel'));
parent::__construct($config);
}
public function __construct($config = array())
{
$config['table'] = Kwf_Model_Abstract::getInstance('Kwf_Model_DbWithConnection_SelectExpr_Model1')->getTableName();
$config['exprs'] = array('count_model2' => new Kwf_Model_Select_Expr_Child_Count('Model2'));
parent::__construct($config);
}
public function __construct($config = array())
{
$config['table'] = Kwf_Model_Abstract::getInstance('Kwf_Model_DbWithConnection_SelectExpr_Model2')->getTableName();
parent::__construct($config);
}
