Newer
Older
sqlmarker / Unit_testing / BDL_Test_Order_line.php
  1. <?php
  2. require_once "Schema.php";
  3.  
  4. abstract class BDL_Test_Order_line extends PHPUnit_Extensions_Database_TestCase_CreateTable
  5. {
  6. public function getTableName()
  7. {
  8. return 'ORDER_LINE';
  9. }
  10. public function getColumnList()
  11. {
  12. return array(
  13. 'ORDER_NUM' => array( 'generic_type' => 'NUMBER',
  14. 'sql_type' => array( 'NUMBER', 'INTEGER' ),
  15. 'min_length' => 10,
  16. 'max_length' => 10,
  17. 'decimals' => 0,
  18. 'nullable' => false,
  19. 'test_value' => "36", ),
  20. 'COMPONENT_CODE' => array( 'generic_type' => 'NUMBER',
  21. 'sql_type' => array( 'NUMBER', 'INTEGER' ),
  22. 'min_length' => 8,
  23. 'max_length' => 8,
  24. 'decimals' => 0,
  25. 'nullable' => false,
  26. 'test_value' => "687", ),
  27. 'QTY_ORDERED' => array( 'generic_type' => 'NUMBER',
  28. 'sql_type' => array( 'NUMBER', 'INTEGER', 'SMALLINT' ),
  29. 'min_length' => 5,
  30. 'max_length' => 5,
  31. 'decimals' => 0,
  32. 'underflow' => 0,
  33. 'overflow' => 100000,
  34. 'nullable' => false,
  35. 'test_value' => "20", ),
  36. 'QTY_RECEIVED' => array( 'generic_type' => 'NUMBER',
  37. 'sql_type' => array( 'NUMBER', 'INTEGER', 'SMALLINT' ),
  38. 'min_length' => 5,
  39. 'max_length' => 6,
  40. 'decimals' => 0,
  41. 'underflow' => -1,
  42. 'overflow' => 1000000,
  43. 'nullable' => false,
  44. 'test_value' => "20", ),
  45. 'PRICE' => array( 'generic_type' => 'NUMBER',
  46. 'sql_type' => array( 'NUMBER', 'DECIMAL' ),
  47. 'min_length' => 6,
  48. 'max_length' => 6,
  49. 'decimals' => 2,
  50. 'underflow' => -0.01,
  51. 'overflow' => 100000.00,
  52. 'nullable' => false,
  53. 'test_value' => "24.99", ), );
  54. }
  55. public function getPKColumnList()
  56. {
  57. return array( 'ORDER_NUM', 'COMPONENT_CODE' );
  58. }
  59. public function getFKColumnList()
  60. {
  61. return array(
  62. 'ORDER_HEAD' => array( 'ORDER_NUM' ),
  63. 'COMPONENT' => array( 'COMPONENT_CODE' ),
  64. );
  65. }
  66. }
  67. ?>