function Test_of_resetColumnInformation()
{
$AkTestUser = new AkTestUser();
$AkTestUser->getColumns();
// Loads settings
$AkTestUser->resetColumnInformation();
$this->assertTrue(empty($AkTestUser->_columnNames) && empty($AkTestUser->_columns) && empty($AkTestUser->_columnsSettings) && empty($AkTestUser->_contentColumns));
}
function Test_of_db_inspection()
{
$AkTestUser = new AkTestUser();
$expected = array('id' => array('name' => 'id', 'type' => 'serial', 'primaryKey' => true), 'user_name' => array('name' => 'user_name', 'type' => 'string'), 'first_name' => array('name' => 'first_name', 'type' => 'string'), 'last_name' => array('name' => 'last_name', 'type' => 'string'), 'email' => array('name' => 'email', 'type' => 'string'), 'country' => array('name' => 'country', 'type' => 'integer'), 'password' => array('name' => 'password', 'type' => 'string'), 'created_at' => array('name' => 'created_at', 'type' => 'datetime'), 'updated_at' => array('name' => 'updated_at', 'type' => 'datetime'), 'expires_on' => array('name' => 'expires_on', 'type' => 'date'));
$got = array();
$tmp_got = $AkTestUser->getColumns();
foreach ($tmp_got as $k => $v) {
$got[$k]['name'] = $v['name'];
$got[$k]['type'] = $v['type'];
if (!empty($v['primaryKey'])) {
$got[$k]['primaryKey'] = $v['primaryKey'];
}
}
$this->assertEqual($got, $expected);
//---------------------
$AkTestField = new AkTestField();
$AkTestField->getColumns();
//$AkTestField->debug();
$expected = array('id' => 'serial', 'varchar_field' => 'string', 'longtext_field' => 'text', 'text_field' => 'text', 'logblob_field' => 'binary', 'date_field' => 'date', 'datetime_field' => 'datetime', 'tinyint_field' => 'integer', 'integer_field' => 'integer', 'smallint_field' => 'integer', 'bigint_field' => 'integer', 'double_field' => 'float', 'numeric_field' => 'decimal', 'bytea_field' => 'binary', 'timestamp_field' => 'datetime', 'boolean_field' => 'boolean', 'int2_field' => 'integer', 'int4_field' => 'integer', 'int8_field' => 'integer', 'foat_field' => 'float', 'varchar4000_field' => 'text', 'clob_field' => 'text', 'nvarchar2000_field' => 'text', 'blob_field' => 'binary', 'nvarchar_field' => 'string', 'decimal1_field' => 'boolean', 'decimal5_field' => 'integer', 'decimal10_field' => 'integer', 'decimal20_field' => 'integer', 'decimal_field' => 'decimal', 'created_at' => 'datetime', 'updated_at' => 'datetime', 'expires_on' => 'date');
$got = array();
foreach ($AkTestField->_columnsSettings as $k => $v) {
$got[$k] = $v['type'];
if ($expected[$k] != $got[$k]) {
//Ak::trace("$k => ".$expected[$k].' ::: '.$got[$k],__LINE__,__FILE__);
}
}
$this->assertEqual($got, $expected);
//$AkTestField->debug();
}
