QurlFixture.php 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
  1. <?php
  2. /**
  3. * QurlFixture
  4. *
  5. */
  6. class QurlFixture extends CakeTestFixture {
  7. /**
  8. * Fields
  9. *
  10. * @var array
  11. */
  12. public $fields = array(
  13. 'id' => array('type' => 'integer', 'null' => false, 'default' => null, 'length' => 10, 'key' => 'primary'),
  14. 'key' => array('type' => 'string', 'null' => false, 'default' => null, 'length' => 60, 'collate' => 'utf8_unicode_ci', 'charset' => 'utf8'),
  15. 'url' => array('type' => 'string', 'null' => false, 'default' => null, 'collate' => 'utf8_unicode_ci', 'comment' => 'for external urls', 'charset' => 'utf8'),
  16. 'title' => array('type' => 'string', 'null' => false, 'default' => null, 'collate' => 'utf8_unicode_ci', 'charset' => 'utf8'),
  17. 'content' => array('type' => 'text', 'null' => false, 'default' => null, 'collate' => 'utf8_unicode_ci', 'comment' => 'can transport some information', 'charset' => 'utf8'),
  18. 'note' => array('type' => 'string', 'null' => false, 'default' => null, 'collate' => 'utf8_unicode_ci', 'comment' => 'internal', 'charset' => 'utf8'),
  19. 'comment' => array('type' => 'string', 'null' => false, 'default' => null, 'collate' => 'utf8_unicode_ci', 'comment' => 'for the user as flash message', 'charset' => 'utf8'),
  20. 'used' => array('type' => 'integer', 'null' => false, 'default' => '0', 'length' => 10),
  21. 'last_used' => array('type' => 'datetime', 'null' => true, 'default' => null),
  22. 'active' => array('type' => 'boolean', 'null' => false, 'default' => '1'),
  23. 'created' => array('type' => 'datetime', 'null' => false, 'default' => null),
  24. 'indexes' => array(
  25. 'PRIMARY' => array('column' => 'id', 'unique' => 1)
  26. ),
  27. 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_unicode_ci', 'engine' => 'MyISAM')
  28. );
  29. /**
  30. * Records
  31. *
  32. * @var array
  33. */
  34. public $records = array(
  35. array(
  36. 'id' => 1,
  37. 'key' => 'Lorem ipsum dolor sit amet',
  38. 'url' => 'Lorem ipsum dolor sit amet',
  39. 'title' => 'Lorem ipsum dolor sit amet',
  40. 'content' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
  41. 'note' => 'Lorem ipsum dolor sit amet',
  42. 'comment' => 'Lorem ipsum dolor sit amet',
  43. 'used' => 1,
  44. 'last_used' => '2012-05-22 13:50:19',
  45. 'active' => 1,
  46. 'created' => '2012-05-22 13:50:19'
  47. ),
  48. array(
  49. 'id' => 2,
  50. 'key' => 'Lorem ipsum dolor sit amet',
  51. 'url' => 'Lorem ipsum dolor sit amet',
  52. 'title' => 'Lorem ipsum dolor sit amet',
  53. 'content' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
  54. 'note' => 'Lorem ipsum dolor sit amet',
  55. 'comment' => 'Lorem ipsum dolor sit amet',
  56. 'used' => 2,
  57. 'last_used' => '2012-05-22 13:50:19',
  58. 'active' => 1,
  59. 'created' => '2012-05-22 13:50:19'
  60. ),
  61. array(
  62. 'id' => 3,
  63. 'key' => 'Lorem ipsum dolor sit amet',
  64. 'url' => 'Lorem ipsum dolor sit amet',
  65. 'title' => 'Lorem ipsum dolor sit amet',
  66. 'content' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
  67. 'note' => 'Lorem ipsum dolor sit amet',
  68. 'comment' => 'Lorem ipsum dolor sit amet',
  69. 'used' => 3,
  70. 'last_used' => '2012-05-22 13:50:19',
  71. 'active' => 1,
  72. 'created' => '2012-05-22 13:50:19'
  73. ),
  74. array(
  75. 'id' => 4,
  76. 'key' => 'Lorem ipsum dolor sit amet',
  77. 'url' => 'Lorem ipsum dolor sit amet',
  78. 'title' => 'Lorem ipsum dolor sit amet',
  79. 'content' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
  80. 'note' => 'Lorem ipsum dolor sit amet',
  81. 'comment' => 'Lorem ipsum dolor sit amet',
  82. 'used' => 4,
  83. 'last_used' => '2012-05-22 13:50:19',
  84. 'active' => 1,
  85. 'created' => '2012-05-22 13:50:19'
  86. ),
  87. array(
  88. 'id' => 5,
  89. 'key' => 'Lorem ipsum dolor sit amet',
  90. 'url' => 'Lorem ipsum dolor sit amet',
  91. 'title' => 'Lorem ipsum dolor sit amet',
  92. 'content' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
  93. 'note' => 'Lorem ipsum dolor sit amet',
  94. 'comment' => 'Lorem ipsum dolor sit amet',
  95. 'used' => 5,
  96. 'last_used' => '2012-05-22 13:50:19',
  97. 'active' => 1,
  98. 'created' => '2012-05-22 13:50:19'
  99. ),
  100. array(
  101. 'id' => 6,
  102. 'key' => 'Lorem ipsum dolor sit amet',
  103. 'url' => 'Lorem ipsum dolor sit amet',
  104. 'title' => 'Lorem ipsum dolor sit amet',
  105. 'content' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
  106. 'note' => 'Lorem ipsum dolor sit amet',
  107. 'comment' => 'Lorem ipsum dolor sit amet',
  108. 'used' => 6,
  109. 'last_used' => '2012-05-22 13:50:19',
  110. 'active' => 1,
  111. 'created' => '2012-05-22 13:50:19'
  112. ),
  113. array(
  114. 'id' => 7,
  115. 'key' => 'Lorem ipsum dolor sit amet',
  116. 'url' => 'Lorem ipsum dolor sit amet',
  117. 'title' => 'Lorem ipsum dolor sit amet',
  118. 'content' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
  119. 'note' => 'Lorem ipsum dolor sit amet',
  120. 'comment' => 'Lorem ipsum dolor sit amet',
  121. 'used' => 7,
  122. 'last_used' => '2012-05-22 13:50:19',
  123. 'active' => 1,
  124. 'created' => '2012-05-22 13:50:19'
  125. ),
  126. array(
  127. 'id' => 8,
  128. 'key' => 'Lorem ipsum dolor sit amet',
  129. 'url' => 'Lorem ipsum dolor sit amet',
  130. 'title' => 'Lorem ipsum dolor sit amet',
  131. 'content' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
  132. 'note' => 'Lorem ipsum dolor sit amet',
  133. 'comment' => 'Lorem ipsum dolor sit amet',
  134. 'used' => 8,
  135. 'last_used' => '2012-05-22 13:50:19',
  136. 'active' => 1,
  137. 'created' => '2012-05-22 13:50:19'
  138. ),
  139. array(
  140. 'id' => 9,
  141. 'key' => 'Lorem ipsum dolor sit amet',
  142. 'url' => 'Lorem ipsum dolor sit amet',
  143. 'title' => 'Lorem ipsum dolor sit amet',
  144. 'content' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
  145. 'note' => 'Lorem ipsum dolor sit amet',
  146. 'comment' => 'Lorem ipsum dolor sit amet',
  147. 'used' => 9,
  148. 'last_used' => '2012-05-22 13:50:19',
  149. 'active' => 1,
  150. 'created' => '2012-05-22 13:50:19'
  151. ),
  152. array(
  153. 'id' => 10,
  154. 'key' => 'Lorem ipsum dolor sit amet',
  155. 'url' => 'Lorem ipsum dolor sit amet',
  156. 'title' => 'Lorem ipsum dolor sit amet',
  157. 'content' => 'Lorem ipsum dolor sit amet, aliquet feugiat. Convallis morbi fringilla gravida, phasellus feugiat dapibus velit nunc, pulvinar eget sollicitudin venenatis cum nullam, vivamus ut a sed, mollitia lectus. Nulla vestibulum massa neque ut et, id hendrerit sit, feugiat in taciti enim proin nibh, tempor dignissim, rhoncus duis vestibulum nunc mattis convallis.',
  158. 'note' => 'Lorem ipsum dolor sit amet',
  159. 'comment' => 'Lorem ipsum dolor sit amet',
  160. 'used' => 10,
  161. 'last_used' => '2012-05-22 13:50:19',
  162. 'active' => 1,
  163. 'created' => '2012-05-22 13:50:19'
  164. ),
  165. );
  166. }