Newer
Older
sqlmarker / Unit_testing / Customer / BDL_Test_Customer.php
  1. <?php
  2. require_once "Schema.php";
  3.  
  4. abstract class BDL_Test_Customer extends PHPUnit_Extensions_Database_TestCase_CreateTable
  5. {
  6. public function getTableName()
  7. {
  8. return 'CUSTOMER';
  9. }
  10. public function getColumnList()
  11. {
  12. return array(
  13. 'CUSTOMER_ID' => array( 'generic_type' => 'NUMBER',
  14. 'sql_type' => array( 'NUMBER', 'INTEGER' ),
  15. 'min_length' => 7,
  16. 'max_length' => 7,
  17. 'decimals' => 0,
  18. 'nullable' => false,
  19. 'test_value' => "123456", ),
  20. 'NAME' => array( 'generic_type' => 'TEXT',
  21. 'sql_type' => array( 'VARCHAR2', 'VARCHAR' ),
  22. 'min_length' => 50,
  23. 'max_length' => 50,
  24. 'nullable' => false,
  25. 'test_value' => "Globodex", ),
  26. 'CONTACT_PERSON' => array( 'generic_type' => 'TEXT',
  27. 'sql_type' => array( 'VARCHAR2', 'VARCHAR' ),
  28. 'min_length' => 50,
  29. 'max_length' => 50,
  30. 'nullable' => true,
  31. 'test_value' => "Henrietta Bloggs", ),
  32. 'PHONE' => array( 'generic_type' => 'TEXT',
  33. 'sql_type' => array( 'VARCHAR2', 'CHAR', 'VARCHAR' ),
  34. 'min_length' => 11,
  35. 'max_length' => 20,
  36. 'nullable' => false,
  37. 'test_value' => "64613998123",
  38. 'legal_values' => array( "034511010", "2718391780", "+2496391734", "92819209365" )),
  39. 'ADDRESS' => array( 'generic_type' => 'TEXT',
  40. 'sql_type' => array( 'VARCHAR2', 'VARCHAR' ),
  41. 'min_length' => 200,
  42. 'max_length' => 200,
  43. 'nullable' => false,
  44. 'test_value' => "12 Western Way", ),
  45. 'EMAIL' => array( 'generic_type' => 'TEXT',
  46. 'sql_type' => array( 'VARCHAR2', 'VARCHAR' ),
  47. 'min_length' => 50,
  48. 'max_length' => 50,
  49. 'nullable' => true,
  50. 'test_value' => "henrietta@globodex.com", ),
  51. 'COMMENTS' => array( 'generic_type' => 'TEXT',
  52. 'sql_type' => array( 'VARCHAR2', 'CLOB' ),
  53. 'min_length' => 500,
  54. 'nullable' => true,
  55. 'test_value' => "Blah blah blah", ), );
  56. }
  57. public function getPKColumnList()
  58. {
  59. return array( 'CUSTOMER_ID' );
  60. }
  61. public function getFKColumnList()
  62. {
  63. return array();
  64. }
  65. }
  66. ?>