tile list. drag items to sort them

2 files changed, 3 insertions, 1 deletions

diff --git a/cli/app/sql/models/page.py b/cli/app/sql/models/page.py
index 2e6bbad..960ffd7 100644
--- a/cli/app/sql/models/page.py
+++ b/cli/app/sql/models/page.py
@@ -22,7 +22,7 @@ class Page(Base):
   created_at = Column(UtcDateTime(), default=utcnow())
   updated_at = Column(UtcDateTime(), onupdate=utcnow())
 
-  tiles = relationship("Tile", foreign_keys="Tile.page_id", lazy='dynamic')
+  tiles = relationship("Tile", foreign_keys="Tile.page_id", lazy='dynamic', order_by="asc(Tile.sort_order)")
 
   def toJSON(self):
     return {
diff --git a/cli/app/sql/models/tile.py b/cli/app/sql/models/tile.py
index 7dfa80b..3f6ce31 100644
--- a/cli/app/sql/models/tile.py
+++ b/cli/app/sql/models/tile.py
@@ -20,6 +20,7 @@ class Tile(Base):
   page_id = Column(Integer, ForeignKey('page.id'), nullable=True)
   target_page_id = Column(Integer, ForeignKey('page.id'), nullable=True)
   type = Column(String(16, convert_unicode=True), nullable=False)
+  sort_order = Column(Integer, default=0)
   settings = Column(JSON, default={}, nullable=True)
   created_at = Column(UtcDateTime(), default=utcnow())
   updated_at = Column(UtcDateTime(), onupdate=utcnow())
@@ -31,6 +32,7 @@ class Tile(Base):
       'page_id': self.page_id,
       'target_page_id': self.target_page_id,
       'type': self.type,
+      'sort_order': self.sort_order,
       'settings': self.settings,
       'created_at': self.created_at,
       'updated_at': self.updated_at,