Example #1
0
 function Test_of_get_and_get_Id()
 {
     $AkTestField = new AkTestField();
     $this->assertEqual($AkTestField->getId(), null);
     $AkTestField->setId(123);
     $this->assertEqual($AkTestField->getId(), 123);
     $AkTestField->incrementAttribute($AkTestField->getPrimaryKey());
     $this->assertEqual($AkTestField->getId(), 124);
 }
Example #2
0
 function Test_of_binary_data_on_database()
 {
     $long_string = file_get_contents(AK_LIB_DIR . DS . 'AkActiveRecord.php');
     $_tmp_file = fopen(AK_LIB_DIR . DS . 'AkActiveRecord.php', "rb");
     $binary_data = fread($_tmp_file, fileSize(AK_LIB_DIR . DS . 'AkActiveRecord.php'));
     $i = 1;
     $details = array('varchar_field' => "{$i} string ", 'longtext_field' => $long_string, 'text_field' => "{$i} text", 'logblob_field' => $binary_data, 'date_field' => "2005/05/{$i}", 'datetime_field' => "2005/05/{$i}", 'tinyint_field' => $i, 'integer_field' => $i, 'smallint_field' => $i, 'bigint_field' => $i, 'double_field' => "{$i}.{$i}", 'numeric_field' => $i, 'bytea_field' => $binary_data, 'timestamp_field' => "2005/05/{$i} {$i}:{$i}:{$i}", 'boolean_field' => !($i % 2), 'int2_field' => "{$i}", 'int4_field' => $i, 'int8_field' => $i, 'foat_field' => "{$i}.{$i}", 'varchar4000_field' => "{$i} text", 'clob_field' => "{$i} text", 'nvarchar2000_field' => "{$i} text", 'blob_field' => $binary_data, 'nvarchar_field' => "{$i}", 'decimal1_field' => "{$i}", 'decimal3_field' => $i, 'decimal5_field' => $i, 'decimal10_field' => "{$i}", 'decimal20_field' => $i, 'decimal_field' => $i);
     $AkTestField = new AkTestField($details);
     $this->assertEqual($long_string, $binary_data);
     $this->assertTrue($AkTestField->save());
     $AkTestField = new AkTestField($AkTestField->getId());
     $this->assertEqual($AkTestField->longtext_field, $long_string);
     $this->assertEqual($AkTestField->bytea_field, $binary_data);
     $this->assertEqual($AkTestField->blob_field, $binary_data);
     $this->assertEqual($AkTestField->logblob_field, $binary_data);
     //Now we add some more records for next tests
     foreach (range(2, 10) as $i) {
         $details = array('varchar_field' => "{$i} string", 'text_field' => "{$i} text", 'date_field' => "2005/05/{$i}", 'datetime_field' => "2005/05/{$i}", 'tinyint_field' => $i, 'integer_field' => $i, 'smallint_field' => $i, 'bigint_field' => $i, 'double_field' => "{$i}.{$i}", 'numeric_field' => $i, 'timestamp_field' => "2005/05/{$i} {$i}:{$i}:{$i}", 'boolean_field' => !($i % 2), 'int2_field' => "{$i}", 'int4_field' => $i, 'int8_field' => $i, 'foat_field' => "{$i}.{$i}", 'varchar4000_field' => "{$i} text", 'clob_field' => "{$i} text", 'nvarchar2000_field' => "{$i} text", 'nvarchar_field' => "{$i}", 'decimal3_field' => $i, 'decimal5_field' => $i, 'decimal10_field' => "{$i}", 'decimal20_field' => $i, 'decimal_field' => $i);
         $AkTestField = new AkTestField($details);
         $this->assertTrue($AkTestField->save());
     }
 }
Example #3
0
 public function Test_of_binary_data_on_database()
 {
     $ar_path = AK_FRAMEWORK_DIR . DS . 'active_record' . DS . 'base.php';
     $long_string = file_get_contents($ar_path);
     $_tmp_file = fopen($ar_path, "rb");
     $binary_data = fread($_tmp_file, fileSize($ar_path));
     $i = 1;
     $details = array('varchar_field' => "{$i} string ", 'longtext_field' => $long_string, 'text_field' => "{$i} text", 'logblob_field' => $binary_data, 'date_field' => "2005/05/{$i}", 'datetime_field' => "2005/05/{$i}", 'tinyint_field' => $i, 'integer_field' => $i, 'smallint_field' => $i, 'bigint_field' => $i, 'double_field' => "{$i}.{$i}", 'numeric_field' => $i, 'bytea_field' => $binary_data, 'timestamp_field' => "2005/05/{$i} {$i}:{$i}:{$i}", 'boolean_field' => !($i % 2), 'int2_field' => "{$i}", 'int4_field' => $i, 'int8_field' => $i, 'foat_field' => "{$i}.{$i}", 'varchar4000_field' => "{$i} text", 'clob_field' => "{$i} text", 'nvarchar2000_field' => "{$i} text", 'blob_field' => $binary_data, 'nvarchar_field' => "{$i}", 'decimal1_field' => "{$i}", 'decimal3_field' => $i, 'decimal5_field' => $i, 'decimal10_field' => "{$i}", 'decimal20_field' => $i, 'decimal_field' => $i);
     $AkTestField = new AkTestField($details);
     $this->assertEqual($long_string, $binary_data);
     $this->assertTrue($AkTestField->save());
     $AkTestField = new AkTestField($AkTestField->getId());
     $this->assertEqual($AkTestField->longtext_field, $long_string);
     $this->assertEqual($AkTestField->bytea_field, $binary_data);
     $this->assertEqual($AkTestField->blob_field, $binary_data);
     $this->assertEqual($AkTestField->logblob_field, $binary_data);
 }