7e912759589c_.py 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242
  1. """empty message
  2. Revision ID: 7e912759589c
  3. Revises:
  4. Create Date: 2021-02-20 16:42:13.616735
  5. """
  6. from alembic import op
  7. import sqlalchemy as sa
  8. # revision identifiers, used by Alembic.
  9. revision = '7e912759589c'
  10. down_revision = None
  11. branch_labels = None
  12. depends_on = None
  13. def upgrade():
  14. # ### commands auto generated by Alembic - please adjust! ###
  15. op.create_table('bacteria',
  16. sa.Column('sn', sa.Integer(), nullable=False),
  17. sa.Column('datetime', sa.DateTime(), nullable=False),
  18. sa.Column('tank_num', sa.Integer(), nullable=False),
  19. sa.Column('duration', sa.Text(), nullable=False),
  20. sa.Column('start', sa.Text(), nullable=False),
  21. sa.Column('end', sa.Text(), nullable=False),
  22. sa.PrimaryKeyConstraint('sn')
  23. )
  24. op.create_table('bean_valve',
  25. sa.Column('sn', sa.Integer(), nullable=False),
  26. sa.Column('datetime', sa.DateTime(), nullable=False),
  27. sa.Column('duration', sa.Text(), nullable=False),
  28. sa.Column('start', sa.Text(), nullable=False),
  29. sa.Column('end', sa.Text(), nullable=False),
  30. sa.PrimaryKeyConstraint('sn')
  31. )
  32. op.create_table('bottom_valve',
  33. sa.Column('sn', sa.Integer(), nullable=False),
  34. sa.Column('datetime', sa.DateTime(), nullable=False),
  35. sa.Column('tank_num', sa.Integer(), nullable=False),
  36. sa.Column('duration', sa.Text(), nullable=False),
  37. sa.Column('start', sa.Text(), nullable=False),
  38. sa.Column('end', sa.Text(), nullable=False),
  39. sa.PrimaryKeyConstraint('sn')
  40. )
  41. op.create_table('cargo1_disinfect',
  42. sa.Column('sn', sa.Integer(), nullable=False),
  43. sa.Column('datetime', sa.DateTime(), nullable=False),
  44. sa.Column('duration', sa.Text(), nullable=False),
  45. sa.Column('start', sa.Text(), nullable=False),
  46. sa.Column('end', sa.Text(), nullable=False),
  47. sa.PrimaryKeyConstraint('sn')
  48. )
  49. op.create_table('cargo2_disinfect',
  50. sa.Column('sn', sa.Integer(), nullable=False),
  51. sa.Column('datetime', sa.DateTime(), nullable=False),
  52. sa.Column('tank_num', sa.Integer(), nullable=False),
  53. sa.Column('duration', sa.Text(), nullable=False),
  54. sa.Column('start', sa.Text(), nullable=False),
  55. sa.Column('end', sa.Text(), nullable=False),
  56. sa.PrimaryKeyConstraint('sn')
  57. )
  58. op.create_table('color_machine',
  59. sa.Column('sn', sa.Integer(), nullable=False),
  60. sa.Column('datetime', sa.DateTime(), nullable=False),
  61. sa.Column('duration', sa.Text(), nullable=False),
  62. sa.Column('start', sa.Text(), nullable=False),
  63. sa.Column('end', sa.Text(), nullable=False),
  64. sa.PrimaryKeyConstraint('sn')
  65. )
  66. op.create_table('conveyor_belt1',
  67. sa.Column('sn', sa.Integer(), nullable=False),
  68. sa.Column('datetime', sa.DateTime(), nullable=False),
  69. sa.Column('duration', sa.Text(), nullable=False),
  70. sa.Column('start', sa.Text(), nullable=False),
  71. sa.Column('end', sa.Text(), nullable=False),
  72. sa.PrimaryKeyConstraint('sn')
  73. )
  74. op.create_table('conveyor_belt2',
  75. sa.Column('sn', sa.Integer(), nullable=False),
  76. sa.Column('datetime', sa.DateTime(), nullable=False),
  77. sa.Column('duration', sa.Text(), nullable=False),
  78. sa.Column('start', sa.Text(), nullable=False),
  79. sa.Column('end', sa.Text(), nullable=False),
  80. sa.PrimaryKeyConstraint('sn')
  81. )
  82. op.create_table('conveyor_belt3',
  83. sa.Column('sn', sa.Integer(), nullable=False),
  84. sa.Column('datetime', sa.DateTime(), nullable=False),
  85. sa.Column('duration', sa.Text(), nullable=False),
  86. sa.Column('start', sa.Text(), nullable=False),
  87. sa.Column('end', sa.Text(), nullable=False),
  88. sa.PrimaryKeyConstraint('sn')
  89. )
  90. op.create_table('dryer',
  91. sa.Column('sn', sa.Integer(), nullable=False),
  92. sa.Column('datetime', sa.DateTime(), nullable=False),
  93. sa.Column('duration', sa.Text(), nullable=False),
  94. sa.Column('start', sa.Text(), nullable=False),
  95. sa.Column('end', sa.Text(), nullable=False),
  96. sa.PrimaryKeyConstraint('sn')
  97. )
  98. op.create_table('heating',
  99. sa.Column('sn', sa.Integer(), nullable=False),
  100. sa.Column('datetime', sa.DateTime(), nullable=False),
  101. sa.Column('tank_num', sa.Integer(), nullable=False),
  102. sa.Column('duration', sa.Text(), nullable=False),
  103. sa.Column('start', sa.Text(), nullable=False),
  104. sa.Column('end', sa.Text(), nullable=False),
  105. sa.PrimaryKeyConstraint('sn')
  106. )
  107. op.create_table('hoist',
  108. sa.Column('sn', sa.Integer(), nullable=False),
  109. sa.Column('datetime', sa.DateTime(), nullable=False),
  110. sa.Column('duration', sa.Text(), nullable=False),
  111. sa.Column('start', sa.Text(), nullable=False),
  112. sa.Column('end', sa.Text(), nullable=False),
  113. sa.PrimaryKeyConstraint('sn')
  114. )
  115. op.create_table('peeling_machine',
  116. sa.Column('sn', sa.Integer(), nullable=False),
  117. sa.Column('datetime', sa.DateTime(), nullable=False),
  118. sa.Column('duration', sa.Text(), nullable=False),
  119. sa.Column('start', sa.Text(), nullable=False),
  120. sa.Column('end', sa.Text(), nullable=False),
  121. sa.PrimaryKeyConstraint('sn')
  122. )
  123. op.create_table('relay',
  124. sa.Column('sn', sa.Integer(), nullable=False),
  125. sa.Column('datetime', sa.DateTime(), nullable=False),
  126. sa.Column('tank_num', sa.Integer(), nullable=False),
  127. sa.Column('status', sa.Text(), nullable=False),
  128. sa.Column('test4', sa.Text(), nullable=False),
  129. sa.PrimaryKeyConstraint('sn')
  130. )
  131. op.create_table('stir',
  132. sa.Column('sn', sa.Integer(), nullable=False),
  133. sa.Column('datetime', sa.DateTime(), nullable=False),
  134. sa.Column('tank_num', sa.Integer(), nullable=False),
  135. sa.Column('duration', sa.Text(), nullable=False),
  136. sa.Column('start', sa.Text(), nullable=False),
  137. sa.Column('end', sa.Text(), nullable=False),
  138. sa.PrimaryKeyConstraint('sn')
  139. )
  140. op.create_table('tank_co2_sensor',
  141. sa.Column('sn', sa.Integer(), nullable=False),
  142. sa.Column('datetime', sa.DateTime(), nullable=False),
  143. sa.Column('tank_num', sa.Integer(), nullable=False),
  144. sa.Column('co2', sa.Text(), nullable=False),
  145. sa.PrimaryKeyConstraint('sn')
  146. )
  147. op.create_table('tank_ph_sensor',
  148. sa.Column('sn', sa.Integer(), nullable=False),
  149. sa.Column('datetime', sa.DateTime(), nullable=False),
  150. sa.Column('tank_num', sa.Integer(), nullable=False),
  151. sa.Column('ph', sa.Text(), nullable=False),
  152. sa.PrimaryKeyConstraint('sn')
  153. )
  154. op.create_table('tank_tem_sensor',
  155. sa.Column('sn', sa.Integer(), nullable=False),
  156. sa.Column('datetime', sa.DateTime(), nullable=False),
  157. sa.Column('tank_num', sa.Integer(), nullable=False),
  158. sa.Column('tem', sa.Text(), nullable=False),
  159. sa.PrimaryKeyConstraint('sn')
  160. )
  161. op.create_table('temperature',
  162. sa.Column('sn', sa.Integer(), nullable=False),
  163. sa.Column('datetime', sa.DateTime(), nullable=False),
  164. sa.Column('tank_num', sa.Integer(), nullable=False),
  165. sa.Column('duration', sa.Text(), nullable=False),
  166. sa.Column('start', sa.Text(), nullable=False),
  167. sa.Column('end', sa.Text(), nullable=False),
  168. sa.PrimaryKeyConstraint('sn')
  169. )
  170. op.create_table('top_valve',
  171. sa.Column('sn', sa.Integer(), nullable=False),
  172. sa.Column('datetime', sa.DateTime(), nullable=False),
  173. sa.Column('tank_num', sa.Integer(), nullable=False),
  174. sa.Column('duration', sa.Text(), nullable=False),
  175. sa.Column('start', sa.Text(), nullable=False),
  176. sa.Column('end', sa.Text(), nullable=False),
  177. sa.PrimaryKeyConstraint('sn')
  178. )
  179. op.create_table('user',
  180. sa.Column('userID', sa.Integer(), nullable=False),
  181. sa.Column('firstname', sa.String(length=30), nullable=False),
  182. sa.Column('lastname', sa.String(length=30), nullable=False),
  183. sa.Column('mail', sa.String(length=50), nullable=False),
  184. sa.Column('phone', sa.String(length=20), nullable=False),
  185. sa.Column('username', sa.String(length=30), nullable=False),
  186. sa.Column('password', sa.String(length=40), nullable=False),
  187. sa.Column('status', sa.Integer(), nullable=False),
  188. sa.PrimaryKeyConstraint('userID'),
  189. sa.UniqueConstraint('username')
  190. )
  191. op.create_table('wash_machine',
  192. sa.Column('sn', sa.Integer(), nullable=False),
  193. sa.Column('datetime', sa.DateTime(), nullable=False),
  194. sa.Column('duration', sa.Text(), nullable=False),
  195. sa.Column('start', sa.Text(), nullable=False),
  196. sa.Column('end', sa.Text(), nullable=False),
  197. sa.PrimaryKeyConstraint('sn')
  198. )
  199. op.create_table('water_injection',
  200. sa.Column('sn', sa.Integer(), nullable=False),
  201. sa.Column('datetime', sa.DateTime(), nullable=False),
  202. sa.Column('tank_num', sa.Integer(), nullable=False),
  203. sa.Column('duration', sa.Text(), nullable=False),
  204. sa.Column('start', sa.Text(), nullable=False),
  205. sa.Column('end', sa.Text(), nullable=False),
  206. sa.PrimaryKeyConstraint('sn')
  207. )
  208. # ### end Alembic commands ###
  209. def downgrade():
  210. # ### commands auto generated by Alembic - please adjust! ###
  211. op.drop_table('water_injection')
  212. op.drop_table('wash_machine')
  213. op.drop_table('user')
  214. op.drop_table('top_valve')
  215. op.drop_table('temperature')
  216. op.drop_table('tank_tem_sensor')
  217. op.drop_table('tank_ph_sensor')
  218. op.drop_table('tank_co2_sensor')
  219. op.drop_table('stir')
  220. op.drop_table('relay')
  221. op.drop_table('peeling_machine')
  222. op.drop_table('hoist')
  223. op.drop_table('heating')
  224. op.drop_table('dryer')
  225. op.drop_table('conveyor_belt3')
  226. op.drop_table('conveyor_belt2')
  227. op.drop_table('conveyor_belt1')
  228. op.drop_table('color_machine')
  229. op.drop_table('cargo2_disinfect')
  230. op.drop_table('cargo1_disinfect')
  231. op.drop_table('bottom_valve')
  232. op.drop_table('bean_valve')
  233. op.drop_table('bacteria')
  234. # ### end Alembic commands ###