90 retweeted = Column(Boolean) |
90 retweeted = Column(Boolean) |
91 source = Column(String) |
91 source = Column(String) |
92 text = Column(String) |
92 text = Column(String) |
93 truncated = Column(Boolean) |
93 truncated = Column(Boolean) |
94 user_id = Column(Integer, ForeignKey('tweet_user.id')) |
94 user_id = Column(Integer, ForeignKey('tweet_user.id')) |
95 user = relationship("TweetUser", backref="tweets") |
95 user = relationship("User", backref="tweets") |
96 # original_json = Column(String) |
|
97 tweet_source_id = Column(Integer, ForeignKey('tweet_tweet_source.id')) |
96 tweet_source_id = Column(Integer, ForeignKey('tweet_tweet_source.id')) |
98 tweet_source = relationship("TweetSource", backref="tweet") |
97 tweet_source = relationship("TweetSource", backref="tweet") |
99 entity_list = relationship(Entity, backref='tweet') |
98 entity_list = relationship(Entity, backref='tweet') |
100 received_at = Column(DateTime, default=datetime.datetime.now()) |
99 received_at = Column(DateTime, default=datetime.datetime.now()) |
101 |
100 |
102 #user = relationship(User, primaryjoin=user_id == User.id) |
|
103 |
|
104 def __init__(self, **kwargs): |
101 def __init__(self, **kwargs): |
105 for key, value in kwargs.items(): |
102 for key, value in kwargs.items(): |
106 if hasattr(self,key): |
103 if hasattr(self,key): |
107 setattr(self,key,value) |
104 setattr(self,key,value) |
108 |
105 |
109 class UserMessage(Base): |
106 class UserMessage(Base): |
110 __tablename__ = "tweet_user_message" |
107 __tablename__ = "tweet_user_message" |
111 |
108 |
112 id = Column(Integer, primary_key = True) |
109 id = Column(Integer, primary_key = True) |
113 user_id = Column(Integer, ForeignKey('tweet_user.id')) |
110 user_id = Column(Integer, ForeignKey('tweet_user.id')) |
114 user = relationship("TweetUser", backref="messages") |
111 user = relationship("User", backref="messages") |
115 created_at = Column(DateTime, default=datetime.datetime.now()) |
112 created_at = Column(DateTime, default=datetime.datetime.now()) |
116 message_id = Column(Integer, ForeignKey('tweet_message.id')) |
113 message_id = Column(Integer, ForeignKey('tweet_message.id')) |
117 |
114 |
118 class Message(Base): |
115 class Message(Base): |
119 __tablename__ = "tweet_message" |
116 __tablename__ = "tweet_message" |
159 statuses_count = Column(Integer) |
156 statuses_count = Column(Integer) |
160 time_zone= Column(String) |
157 time_zone= Column(String) |
161 url= Column(String) |
158 url= Column(String) |
162 utc_offset = Column(Integer) |
159 utc_offset = Column(Integer) |
163 verified= Column(Boolean) |
160 verified= Column(Boolean) |
164 tweets = relationship(Tweet, backref='user') |
161 #tweets = relationship(Tweet, backref='user') |
165 messages = relationship(UserMessage, backref='user') |
162 #messages = relationship(UserMessage, backref='user') |
166 |
163 |
167 def __init__(self, **kwargs): |
164 def __init__(self, **kwargs): |
168 for key, value in kwargs.items(): |
165 for key, value in kwargs.items(): |
169 if hasattr(self,key): |
166 if hasattr(self,key): |
170 setattr(self,key,value) |
167 setattr(self,key,value) |