Newer
Older
sqlmarker / UsedCars / Test_classes / Car / UsedCars_Test_Car.php
  1. <?php
  2. require_once "Schema.php";
  3.  
  4. abstract class UsedCars_Test_Car extends PHPUnit_Extensions_Database_TestCase_CreateTable
  5. {
  6. public function getTableName()
  7. {
  8. return 'CAR';
  9. }
  10. public function getColumnList()
  11. {
  12. return array(
  13. 'VIN' => array( 'generic_type' => 'TEXT',
  14. 'sql_type' => array( 'CHAR', 'VARCHAR2', 'VARCHAR' ),
  15. 'min_length' => 17,
  16. 'max_length' => 17,
  17. 'nullable' => false,
  18. 'test_value' => '7AT0DH1EX09123456', ),
  19. 'REGISTRATION' => array( 'generic_type' => 'TEXT',
  20. 'sql_type' => array( 'VARCHAR2', 'VARCHAR' ),
  21. 'min_length' => 6,
  22. 'max_length' => 6,
  23. 'nullable' => false,
  24. 'test_value' => 'ABC123', ),
  25. 'MAKE' => array( 'generic_type' => 'TEXT',
  26. 'sql_type' => array( 'VARCHAR2', 'VARCHAR' ),
  27. 'min_length' => 20,
  28. 'nullable' => false,
  29. 'test_value' => 'Toyota', ),
  30. 'MODEL' => array( 'generic_type' => 'TEXT',
  31. 'sql_type' => array( 'VARCHAR2', 'VARCHAR' ),
  32. 'min_length' => 30,
  33. 'nullable' => false,
  34. 'test_value' => 'Camry', ),
  35. 'YEAR' => array( 'generic_type' => 'NUMBER',
  36. 'sql_type' => array( 'NUMBER', 'INTEGER', 'SMALLINT' ),
  37. 'min_length' => 4,
  38. 'max_length' => 4,
  39. 'nullable' => false,
  40. 'underflow' => 1994,
  41. 'legal_values' => array( 1995 ),
  42. 'test_value' => '2012', ),
  43. 'COLOUR' => array( 'generic_type' => 'TEXT',
  44. 'sql_type' => array( 'VARCHAR2', 'VARCHAR' ),
  45. 'min_length' => 20,
  46. 'nullable' => false,
  47. 'test_value' => 'Purple', ),
  48. 'ODOMETER' => array( 'generic_type' => 'NUMBER',
  49. 'sql_type' => array( 'NUMBER', 'DECIMAL' ),
  50. 'min_length' => 7,
  51. 'decimals' => 1,
  52. 'underflow' => -0.1,
  53. 'overflow' => 1000000,
  54. 'legal_values' => array( 0, 1234.5, 88765, 210000.4, 999999.9 ),
  55. 'nullable' => false,
  56. 'test_value' => '80000', ),
  57. 'FIRST_REGISTERED' => array( 'generic_type' => 'DATE',
  58. 'sql_type' => array( 'DATE' ),
  59. 'nullable' => false,
  60. 'test_value' => "TO_DATE( '2014-03-28', 'YYYY-MM-DD' )" ),
  61. 'LAST_SERVICED' => array( 'generic_type' => 'DATE',
  62. 'sql_type' => array( 'DATE' ),
  63. 'nullable' => true,
  64. 'underflow' => "TO_DATE( '2014-03-27', 'YYYY-MM-DD' )",
  65. 'legal_values' => array( "TO_DATE( '2014-03-29', 'YYYY-MM-DD' )", "TO_DATE( '2014-04-01', 'YYYY-MM-DD' )" ),
  66. 'test_value' => "TO_DATE( '2014-03-28', 'YYYY-MM-DD' )" ),
  67. 'PRICE' => array( 'generic_type' => 'NUMBER',
  68. 'sql_type' => array( 'NUMBER', 'INTEGER' ),
  69. 'min_length' => 6,
  70. 'decimals' => 0,
  71. 'underflow' => -1,
  72. 'legal_values' => array( 0, 1234, 88765, 210000, 999999 ),
  73. 'nullable' => false,
  74. 'test_value' => '25000', ),
  75. 'FLAT_RATE' => array( 'generic_type' => 'NUMBER',
  76. 'sql_type' => array( 'NUMBER', 'INTEGER', 'SMALLINT' ),
  77. 'min_length' => 4,
  78. 'decimals' => 0,
  79. 'underflow' => 0,
  80. 'legal_values' => array( 1, 10, 100, 1000, 10000 ),
  81. 'nullable' => false,
  82. 'test_value' => '150', ),
  83. );
  84. }
  85. public function getPKColumnList()
  86. {
  87. return array( 'VIN' );
  88. }
  89. public function getFKColumnList()
  90. {
  91. return array();
  92. }
  93. public function getUniqueColumnList()
  94. {
  95. return array();
  96. }
  97. }
  98. ?>