add list support and seperate help

[rainbowstream.git] / rainbowstream / table_def.py

diff --git a/rainbowstream/table_def.py b/rainbowstream/table_def.py
index c312bde02a8313303f3feede9255ee7164b7da24..28bbfc9000fa8658f7bd39285e30bd53e4760702 100644 (file)
--- a/rainbowstream/table_def.py
+++ b/rainbowstream/table_def.py
@@ -5,9 +5,9 @@ engine = create_engine('sqlite:///rainbow.db', echo=False)
 Base = declarative_base()
 
 
-class Map(Base):
+class Tweet(Base):
 
-    __tablename__ = "map"
+    __tablename__ = "tweet"
 
     rainbow_id = Column(Integer, primary_key=True)
     tweet_id = Column(Integer)
@@ -16,5 +16,40 @@ class Map(Base):
         self.tweet_id = tweet_id
 
 
+class Message(Base):
+
+    __tablename__ = "message"
+
+    rainbow_id = Column(Integer, primary_key=True)
+    message_id = Column(Integer)
+
+    def __init__(self, message_id):
+        self.message_id = message_id
+
+
+class Theme(Base):
+
+    __tablename__ = "theme"
+
+    theme_id = Column(Integer, primary_key=True)
+    theme_name = Column(String(20))
+
+    def __init__(self, theme_name):
+        self.theme_name = theme_name
+
+
+class List(Base):
+
+    __tablename__ = "list"
+
+    list_rid = Column(Integer, primary_key=True)
+    list_id = Column(Integer)
+    list_name = Column(String(50))
+
+    def __init__(self, list_id, list_name):
+        self.list_id = list_id
+        self.list_name = list_name
+
+
 def init_db():
     Base.metadata.create_all(engine)