search

comeara / pillar

Pillar manages migrations for your Cassandra data stores.
https://github.com/comeara/pillar
MIT License
111 stars 64 forks source link

Applied migration table is not ordered by the correct authored_at time #35

Open felixgao opened 8 years ago

felixgao commented 8 years ago 
-- description: V001 - creates experiment table
-- authoredAt: 1370028263000
-- up:
-- stage: 1
create table experiment (
    id uuid,
...
)
-- description: V025 - creates user assignment export 
-- authoredAt: 1370028263024
-- up:

create table user_assignment_export(
...
)
cqlsh:wassabi_experiment_local> select * from applied_migrations  ;

 authored_at              | description                                                                         | applied_at
--------------------------+-------------------------------------------------------------------------------------+--------------------------
 2013-05-31 19:24:23+0000 |                                               V025 - creates user assignment export | 2016-08-05 00:17:01+0000
 2013-05-31 19:24:23+0000 |                                                               V002 - creates bucket | 2016-08-05 00:16:33+0000
 2013-05-31 19:24:23+0000 |                                                        V020 - creates user feedback | 2016-08-05 00:16:56+0000
 2013-05-31 19:24:23+0000 |                                              V004 - creates experiment label lookup | 2016-08-05 00:16:36+0000
 2013-05-31 19:24:23+0000 |                                                            V023 - creates audit log | 2016-08-05 00:16:59+0000
 2013-05-31 19:24:23+0000 |                      V026 - insert admin user to user_roles, app_users, superadmins | 2016-08-05 00:17:01+0000
 2013-05-31 19:24:23+0000 |                                                            V010 - creates exclusion | 2016-08-05 00:16:43+0000
 2013-05-31 19:24:23+0000 |                                                 V007 - creates experiment audit log | 2016-08-05 00:16:40+0000
 2013-05-31 19:24:23+0000 |                                                            V017 - creates app roles | 2016-08-05 00:16:50+0000
 2013-05-31 19:24:23+0000 |                                                              V021 - creates staging | 2016-08-05 00:16:57+0000
 2013-05-31 19:24:23+0000 |                                                     V001 - creates experiment table | 2016-08-05 00:16:32+0000
 2013-05-31 19:24:23+0000 |                                             V022 - creates bucket assingment counts | 2016-08-05 00:16:58+0000
 2013-05-31 19:24:23+0000 |                                                           V016 - creates user roles | 2016-08-05 00:16:49+0000
 2013-05-31 19:24:23+0000 |                                                       V015 - creates app page index | 2016-08-05 00:16:48+0000
 2013-05-31 19:24:23+0000 |                                              V011 - creates experiment user look up | 2016-08-05 00:16:44+0000
 2013-05-31 19:24:23+0000 |                                                      V005 - creates user assignment | 2016-08-05 00:16:37+0000
 2013-05-31 19:24:23+0000 |                                                      V014 - creates experiment page | 2016-08-05 00:16:47+0000
 2013-05-31 19:24:23+0000 |                                                            V019 - creates user info | 2016-08-05 00:16:52+0000
 2013-05-31 19:24:23+0000 |           V007 - creates user bucket lookup by experiment id, context, bucket label | 2016-08-05 00:16:39+0000
 2013-05-31 19:24:23+0000 | V006 - creates user experiment look up by app name, user id, context, experiment id | 2016-08-05 00:16:38+0000
 2013-05-31 19:24:23+0000 |                                                     V027 - creates applicaiton list | 2016-08-05 00:17:02+0000
 2013-05-31 19:24:23+0000 |                                              V003 - creates experiment label lookup | 2016-08-05 00:16:35+0000
 2013-05-31 19:24:23+0000 |                                                          V018 - creates superadmins | 2016-08-05 00:16:51+0000
 2013-05-31 19:24:23+0000 |                                                V013 - creates page experiment index | 2016-08-05 00:16:46+0000
 2013-05-31 19:24:23+0000 |                                               V024 - creates user assingment lookup | 2016-08-05 00:17:00+0000
 2013-05-31 19:24:23+0000 |                                                     V009 - creates bucket audit log | 2016-08-05 00:16:41+0000
 2013-05-31 19:24:23+0000 |                                              V012 - creates experiment label lookup | 2016-08-05 00:16:45+0000