Newer
Older
sqlmarker / Unit_testing / BDL_Test_Sale_head.php
  1. <?php
  2. require_once "Schema.php";
  3.  
  4. abstract class BDL_Test_Sale_head extends PHPUnit_Extensions_Database_TestCase_CreateTable
  5. {
  6. public function getTableName()
  7. {
  8. return 'SALE_HEAD';
  9. }
  10. public function getColumnList()
  11. {
  12. return array(
  13. 'SALE_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' => "8765432109", ),
  20. 'SALE_DATE' => array( 'generic_type' => 'DATE-FUNCTION',
  21. 'sql_type' => array( 'DATE' ),
  22. 'nullable' => false,
  23. 'overflow' => "SYSDATE + 1",
  24. 'test_value' => "TO_DATE( '2012-09-22', 'YYYY-MM-DD')", ),
  25. 'STATUS' => array( 'generic_type' => 'TEXT',
  26. 'sql_type' => array( 'VARCHAR2', 'VARCHAR' ),
  27. 'min_length' => 11,
  28. 'max_length' => 15,
  29. 'nullable' => false,
  30. 'legal_values' => array( "pending", "in progress", "cancelled", "backordered", "shipped" ),
  31. 'illegal_values' => array( "Pending", "PENDING", "foobar", "blurk", " " ),
  32. 'test_value' => "pending", ),
  33. 'CUSTOMER_ID' => array( 'generic_type' => 'NUMBER',
  34. 'sql_type' => array( 'NUMBER', 'INTEGER' ),
  35. 'min_length' => 7,
  36. 'max_length' => 7,
  37. 'decimals' => 0,
  38. 'nullable' => false,
  39. 'test_value' => "303", ),
  40. 'STAFF_ID' => array( 'generic_type' => 'NUMBER',
  41. 'sql_type' => array( 'NUMBER', 'INTEGER' ),
  42. 'min_length' => 7,
  43. 'max_length' => 7,
  44. 'decimals' => 0,
  45. 'nullable' => false,
  46. 'test_value' => "326", ),
  47. 'COMMENTS' => array( 'generic_type' => 'TEXT',
  48. 'sql_type' => array( 'VARCHAR2', 'CLOB' ),
  49. 'min_length' => 500,
  50. 'nullable' => true,
  51. 'test_value' => "Blah blah blah", ), );
  52. }
  53. public function getPKColumnList()
  54. {
  55. return array( 'SALE_NUM' );
  56. }
  57. public function getFKColumnList()
  58. {
  59. return array(
  60. 'STAFF' => array( 'STAFF_ID' ),
  61. 'CUSTOMER' => array( 'CUSTOMER_ID' ),
  62. );
  63. }
  64. }
  65. ?>