Newer
Older
sqlmarker / UsedCars / Test_classes / Warranty / UsedCars_Test_Warranty.php
  1. <?php
  2. require_once "Schema.php";
  3.  
  4. abstract class UsedCars_Test_Warranty extends PHPUnit_Extensions_Database_TestCase_CreateTable
  5. {
  6. public function getTableName()
  7. {
  8. return 'WARRANTY';
  9. }
  10. public function getColumnList()
  11. {
  12. return array(
  13. 'W_CODE' => array( 'generic_type' => 'TEXT',
  14. 'sql_type' => array( 'CHAR', 'VARCHAR2', 'VARCHAR' ),
  15. 'min_length' => 1,
  16. 'max_length' => 1,
  17. 'nullable' => false,
  18. 'test_value' => 'A', ),
  19. 'MAX_AGE' => array( 'generic_type' => 'NUMBER',
  20. 'sql_type' => array( 'NUMBER', 'INTEGER', 'SMALLINT' ),
  21. 'min_length' => 1,
  22. 'max_length' => 1,
  23. 'nullable' => true,
  24. 'test_value' => '4', ),
  25. 'MAX_KM' => array( 'generic_type' => 'NUMBER',
  26. 'sql_type' => array( 'NUMBER', 'INTEGER' ),
  27. 'min_length' => 6,
  28. 'max_length' => 6,
  29. 'nullable' => true,
  30. 'test_value' => '50000', ),
  31. 'DURATION' => array( 'generic_type' => 'NUMBER',
  32. 'sql_type' => array( 'NUMBER', 'INTEGER', 'SMALLINT' ),
  33. 'min_length' => 1,
  34. 'max_length' => 1,
  35. 'nullable' => true,
  36. 'test_value' => '3', ),
  37. 'DISTANCE' => array( 'generic_type' => 'NUMBER',
  38. 'sql_type' => array( 'NUMBER', 'INTEGER', 'SMALLINT' ),
  39. 'min_length' => 4,
  40. 'max_length' => 4,
  41. 'nullable' => true,
  42. 'test_value' => '5000', ),
  43. 'NOTES' => array( 'generic_type' => 'TEXT',
  44. 'sql_type' => array( 'VARCHAR2' ),
  45. 'min_length' => 250,
  46. 'nullable' => true,
  47. 'test_value' => 'Category A motor vehicle', ),
  48. );
  49. }
  50. public function getPKColumnList()
  51. {
  52. return array( 'W_CODE' );
  53. }
  54. public function getFKColumnList()
  55. {
  56. return array();
  57. }
  58. public function getUniqueColumnList()
  59. {
  60. return array();
  61. }
  62. }
  63. ?>