1 """alter nodes add column latest version
3 Revision ID: 230f8ce9c90f
5 Create Date: 2012-07-17 20:32:54.466145
9 # revision identifiers, used by Alembic.
10 revision = '230f8ce9c90f'
11 down_revision = '8320b1c62d9'
13 from alembic import op, context
14 from sqlalchemy.sql import table, column
15 from alembic import op
17 import sqlalchemy as sa
20 op.add_column('nodes', sa.Column('latest_version', sa.INTEGER))
23 column('node', sa.Integer),
24 column('latest_version', sa.Integer)
27 column('node', sa.Integer),
28 column('mtime', sa.Integer),
29 column('serial', sa.Integer),
32 s = sa.select([v.c.serial]).where(n.c.node == v.c.node).order_by(v.c.mtime).limit(1)
35 values({'latest_version':s})
39 op.drop_column('nodes', 'latest_version')