- <?php
- require_once "Schema.php";
-
- abstract class BDL_Test_Component extends PHPUnit_Extensions_Database_TestCase_CreateTable
- {
- public function getTableName()
- {
- return 'COMPONENT';
- }
-
-
- public function getColumnList()
- {
- return array(
- 'COMPONENT_CODE' => array( 'type' => array( 'NUMBER', 'INTEGER' ),
- 'min_length' => 8,
- 'max_length' => 8,
- 'decimals' => 0,
- // 'underflow' => -1,
- 'nullable' => false,
- 'test_value' => "87654321", ),
- 'SUPPLIERS_CODE' => array( 'type' => array( 'VARCHAR2', 'VARCHAR' ),
- 'min_length' => 25,
- 'max_length' => 25,
- 'nullable' => false,
- 'test_value' => "'B87654321'", ),
- 'DESCRIPTION' => array( 'type' => array( 'VARCHAR2', 'VARCHAR' ),
- 'min_length' => 100,
- 'max_length' => 100,
- 'nullable' => false,
- 'test_value' => "'Some component'", ),
- 'STOCK_COUNT' => array( 'type' => array( 'NUMBER', 'INTEGER' ),
- 'min_length' => 7,
- 'max_length' => 7,
- 'decimals' => 0,
- 'underflow' => -1,
- 'overflow' => 10000000,
- 'nullable' => false,
- 'test_value' => "456", ),
- 'SUPPLIER_ID' => array( 'type' => array( 'NUMBER', 'INTEGER' ),
- 'min_length' => 7,
- 'max_length' => 7,
- 'decimals' => 0,
- 'nullable' => false,
- 'test_value' => "1", ), );
- }
-
-
- public function getPKColumnList()
- {
- return array( 'COMPONENT_CODE', 'SUPPLIERS_CODE' );
- }
-
-
- public function getFKColumnList()
- {
- return array( 'SUPPLIER' => array ( 'SUPPLIER_ID' ) );
- }
- }
- ?>