Newer
Older
sqlmarker / Unit_testing / BDL_Test_Sale_line_structure.php
  1. <?php
  2. require_once "BDL_Test_Sale_line.php";
  3.  
  4. class BDL_Test_Sale_line_structure extends BDL_Test_Sale_line
  5. {
  6. /**
  7. * Return fixture data set for current database connection.
  8. *
  9. * @access protected
  10. * @return PHPUnit_Extensions_Database_DataSet_IDataSet
  11. * @todo Parameterise the fixture filename.
  12. */
  13. protected function getDataSet()
  14. {
  15. return $this->createXMLDataSet("BDL_Fixture_Empty.xml");
  16. }
  17. public function testTableExists()
  18. {
  19. $this->assertTableExists();
  20. }
  21. /**
  22. * @dataProvider provideColumnNames
  23. */
  24. public function testColumnExists( $columnName )
  25. {
  26. $this->assertColumnExists( $columnName );
  27. }
  28. /**
  29. * @dataProvider provideColumnTypes
  30. */
  31. public function testColumnDataType( $columnName, $columnTypeList )
  32. {
  33. $this->assertColumnDataType( $columnName, $columnTypeList );
  34. }
  35. /**
  36. * @dataProvider provideColumnLengths
  37. */
  38. public function testColumnLength( $columnName, $columnType, $minLength, $maxLength, $numDecimals )
  39. {
  40. $this->assertColumnLength( $columnName, $columnType, $minLength, $maxLength, $numDecimals );
  41. }
  42. /**
  43. * @dataProvider provideColumnNullabilities
  44. */
  45. public function testColumnNullability( $columnName, $columnNullability )
  46. {
  47. $this->assertColumnNullability( $columnName, $columnNullability );
  48. }
  49. public function testPKExists()
  50. {
  51. return $this->assertPKExists();
  52. }
  53. /**
  54. * @depends testPKExists
  55. */
  56. public function testPKColumns( $constraintName )
  57. {
  58. $this->assertPKColumns( $constraintName );
  59. }
  60. /**
  61. * @dataProvider provideFKReferencedTables
  62. */
  63. public function testFKsExist( $referencedTableName )
  64. {
  65. return $this->assertFKsExist( $referencedTableName );
  66. }
  67. /**
  68. * @dataProvider provideFKReferencedTables
  69. */
  70. public function testFKColumns( $referencedTableName )
  71. {
  72. $this->assertFKColumns( $referencedTableName );
  73. }
  74. /**
  75. * @dataProvider provideConstraintNames
  76. */
  77. public function testConstraintsNamed( $constraintName, $constraintType )
  78. {
  79. $this->assertConstraintNamed( $constraintName, $constraintType );
  80. }
  81. }
  82. ?>