X-Git-Url: https://vcs.fsf.org/?p=rainbowstream.git;a=blobdiff_plain;f=rainbowstream%2Ftable_def.py;h=fda3948dfbe0ad06d8bf77e08c1d296fbca93862;hp=b6d14c56699d7fbedf35efdbf1609554c773594e;hb=77f1d210dfd44f5b6c33cc58150b633643621bb0;hpb=18cab06ae81a383f8eaf3117d3377c0424b86782

diff --git a/rainbowstream/table_def.py b/rainbowstream/table_def.py
index b6d14c5..fda3948 100644
--- a/rainbowstream/table_def.py
+++ b/rainbowstream/table_def.py
@@ -4,9 +4,10 @@ from sqlalchemy.ext.declarative import declarative_base
 engine = create_engine('sqlite:///rainbow.db', echo=False)
 Base = declarative_base()
 
-class Map(Base):
 
-    __tablename__ = "map"
+class Tweet(Base):
+
+    __tablename__ = "tweet"
 
     rainbow_id = Column(Integer, primary_key=True)
     tweet_id = Column(Integer)
@@ -14,4 +15,28 @@ class Map(Base):
     def __init__(self, tweet_id):
         self.tweet_id = tweet_id
 
-Base.metadata.create_all(engine)
\ No newline at end of file
+
+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
+
+
+def init_db():
+    Base.metadata.create_all(engine)