1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
"""changed the type of the column 'last_modified' to string.
Revision ID: 17dcb75f3fe
Revises: cde34831ea
Create Date: 2015-03-10 14:20:53.676344
"""
# revision identifiers, used by Alembic.
revision = "17dcb75f3fe"
down_revision = "cde34831ea"
from datetime import datetime
import conf
from alembic import op
import sqlalchemy as sa
def upgrade():
unix_start = datetime(1970, 1, 1)
if "sqlite" not in conf.SQLALCHEMY_DATABASE_URI:
op.drop_column("feed", "last_modified")
op.add_column(
"feed",
sa.Column(
"last_modified",
sa.String(),
nullable=True,
default=unix_start,
server_default=str(unix_start),
),
)
def downgrade():
unix_start = datetime(1970, 1, 1)
if "sqlite" not in conf.SQLALCHEMY_DATABASE_URI:
op.drop_column("feed", "last_modified")
op.add_column(
"feed",
sa.Column(
"last_modified",
sa.DateTime(),
nullable=True,
default=unix_start,
server_default=unix_start,
),
)
|
