PHP MDB2_TestCase Examples

Example #1

File: MDB2_manager_testcase.php Project: quangbt2005/vhost-kis

 function setUp()
 {
     parent::setUp();
     $this->db->loadModule('Manager', null, true);
     $this->fields = array('id' => array('type' => 'integer', 'unsigned' => true, 'notnull' => true, 'default' => 0), 'somename' => array('type' => 'text', 'length' => 12), 'somedescription' => array('type' => 'text', 'length' => 12), 'sex' => array('type' => 'text', 'length' => 1, 'default' => 'M'));
     if (!$this->tableExists($this->table)) {
         $this->db->manager->createTable($this->table, $this->fields);
     }
 }

Example #2

File: MDB2_datatype_testcase.php Project: ookwudili/chisimba

 function setUp()
 {
     parent::setUp();
     $this->db->loadModule('Manager', null, true);
     $this->fields = array('id' => array('type' => 'integer', 'unsigned' => true, 'notnull' => true, 'default' => 0), 'textfield' => array('type' => 'text', 'length' => 12), 'booleanfield' => array('type' => 'boolean'), 'decimalfield' => array('type' => 'decimal'), 'floatfield' => array('type' => 'float'), 'datefield' => array('type' => 'date'), 'timefield' => array('type' => 'time'), 'timestampfield' => array('type' => 'timestamp'));
     if (!$this->tableExists($this->table)) {
         $this->db->manager->createTable($this->table, $this->fields);
     }
 }

Example #3

File: MDB2_manager_testcase.php Project: Alphenus/ilmomasiina-php

 function setUp()
 {
     parent::setUp();
     $this->db->loadModule('Manager', null, true);
     $this->fields = array('id' => array('type' => 'integer', 'unsigned' => true, 'notnull' => true, 'default' => 0), 'somename' => array('type' => 'text', 'length' => 12), 'somedescription' => array('type' => 'text', 'length' => 12), 'sex' => array('type' => 'text', 'length' => 1, 'default' => 'M'));
     $options = array();
     if ('mysql' == substr($this->db->phptype, 0, 5)) {
         $options['type'] = 'innodb';
     }
     if (!$this->tableExists($this->table)) {
         $result = $this->db->manager->createTable($this->table, $this->fields, $options);
         $this->assertFalse(PEAR::isError($result), 'Error creating table');
         $this->assertEquals(MDB2_OK, $result, 'Invalid return value for createTable()');
     }
 }

Example #4

File: MDB2_reverse_testcase.php Project: Alphenus/ilmomasiina-php

 function setUp()
 {
     parent::setUp();
     $this->db->loadModule('Reverse', null, true);
     $this->db->loadModule('Manager', null, true);
     //Table structure
     $this->fields = array('id' => array('type' => 'integer', 'unsigned' => 1, 'notnull' => 1, 'default' => 0, 'length' => 4), 'id2' => array('type' => 'integer', 'unsigned' => 1, 'notnull' => 1, 'default' => 0), 'id3' => array('type' => 'integer', 'unsigned' => 1, 'notnull' => 1, 'default' => 0), 'id4' => array('type' => 'integer', 'unsigned' => 1, 'notnull' => 1, 'default' => 0), 'somename' => array('type' => 'text', 'length' => 12), 'somedescription' => array('type' => 'text', 'length' => 12), 'sex' => array('type' => 'text', 'length' => 1, 'default' => 'M'));
     $options = array();
     if ('mysql' == substr($this->db->phptype, 0, 5)) {
         $options['type'] = 'innodb';
     }
     if (!$this->tableExists($this->table)) {
         $this->db->manager->createTable($this->table, $this->fields, $options);
     }
     //Table2 structure
     $this->fields2 = array('ext_id' => array('type' => 'integer', 'unsigned' => 1, 'notnull' => 1, 'default' => 0), 'ext_id2' => array('type' => 'integer', 'unsigned' => 1, 'notnull' => 1, 'default' => 0), 'ext_id3' => array('type' => 'integer', 'unsigned' => 1, 'notnull' => 1, 'default' => 0));
     if (!$this->tableExists($this->table2)) {
         $this->db->manager->createTable($this->table2, $this->fields2, $options);
     }
 }

Example #5

File: MDB2_function_testcase.php Project: Spark-Eleven/revive-adserver

 function setUp()
 {
     parent::setUp();
     $this->db->loadModule('Function', null, true);
 }