-
Notifications
You must be signed in to change notification settings - Fork 3
/
models.py
128 lines (107 loc) · 4.08 KB
/
models.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
from sqlalchemy import Table, Column, BigInteger, String, Integer, Boolean, MetaData
metadata = MetaData()
core_user = Table(
'core_user', metadata,
Column('id', BigInteger, primary_key=True),
Column('username', String),
Column('info', String),
Column('avatar_url', String),
Column('rating', Integer),
Column('comments_count', Integer),
Column('posts_count', Integer),
Column('hot_posts_count', Integer),
Column('pluses_count', Integer),
Column('minuses_count', Integer),
Column('last_update_timestamp', BigInteger),
Column('subscribers_count', Integer),
Column('is_rating_ban', Boolean),
Column('updating_period', Integer),
Column('is_updated', Boolean),
Column('pikabu_id', BigInteger),
Column('gender', String(1)),
Column('approved', String),
Column('awards', String),
Column('signup_timestamp', BigInteger),
Column('deleted', Boolean),
)
def generate_graph_item_table(table_name):
return Table(
table_name, metadata,
Column('id', BigInteger, primary_key=True),
Column('user_id', BigInteger),
Column('timestamp', BigInteger),
Column('value', Integer),
)
core_userratingentry = generate_graph_item_table('core_userratingentry')
core_usersubscriberscountentry = generate_graph_item_table('core_usersubscriberscountentry')
core_usercommentscountentry = generate_graph_item_table('core_usercommentscountentry')
core_userpostscountentry = generate_graph_item_table('core_userpostscountentry')
core_userhotpostscountentry = generate_graph_item_table('core_userhotpostscountentry')
core_userplusescountentry = generate_graph_item_table('core_userplusescountentry')
core_userminusescountentry = generate_graph_item_table('core_userminusescountentry')
communities_app_community = Table(
'communities_app_community', metadata,
Column('id', BigInteger, primary_key=True),
Column('url_name', String),
Column('name', String),
Column('description', String),
Column('avatar_url', String),
Column('background_image_url', String),
Column('subscribers_count', Integer),
Column('stories_count', Integer),
Column('last_update_timestamp', BigInteger),
)
communities_app_communitycountersentry = Table(
'communities_app_communitycountersentry', metadata,
Column('id', BigInteger, primary_key=True),
Column('timestamp', BigInteger),
Column('community_id', BigInteger),
Column('subscribers_count', Integer),
Column('stories_count', Integer),
)
pikabu_new_year_18_game_app_scoreboardentry = Table(
'pikabu_new_year_18_game_app_scoreboardentry', metadata,
Column('id', BigInteger, primary_key=True),
Column('parse_timestamp', BigInteger),
)
pikabu_new_year_18_game_app_topitem = Table(
'pikabu_new_year_18_game_app_topitem', metadata,
Column('score_entry_id', BigInteger),
)
pikabu_new_year_18_game_app_scoreentry = Table(
'pikabu_new_year_18_game_app_scoreentry', metadata,
Column('id', Integer, primary_key=True),
Column('username', String),
Column('avatar_url', String),
Column('score', Integer),
Column('date', String),
Column('scoreboard_entry_id', Integer),
)
core_pikabuuser = Table(
'core_pikabuuser', metadata,
Column('pikabu_id', Integer, primary_key=True),
Column('username', String),
Column('is_processed', Boolean),
)
comments = Table(
'comments', metadata,
Column('id', BigInteger, primary_key=True),
Column('parent_id', BigInteger),
Column('creation_timestamp', Integer),
Column('first_parsing_timestamp', Integer),
Column('last_parsing_timestamp', Integer),
Column('rating', Integer),
Column('story_id', BigInteger),
Column('user_id', Integer),
Column('author_username', String),
Column('is_hidden', Boolean),
Column('is_deleted', Boolean),
Column('is_author_community_moderator', Boolean),
Column('is_author_pikabu_team', Boolean),
Column('text', String),
)
statistics_users_in_queue_counts = Table(
'statistics_users_in_queue_counts', metadata,
Column('timestamp', BigInteger, primary_key=True),
Column('value', Integer),
)