| 2790 | return self.sqlite_db_path |
| 2791 | |
| 2792 | def get_sqlite_create_sql(self): |
| 2793 | create_sql = """ |
| 2794 | CREATE TABLE IF NOT EXISTS user ( |
| 2795 | id varchar(64) NOT NULL |
| 2796 | ,nick_name varchar(64) NOT NULL |
| 2797 | ,gender varchar(6) |
| 2798 | ,follower_count integer |
| 2799 | ,follow_count integer |
| 2800 | ,birthday varchar(10) |
| 2801 | ,location varchar(32) |
| 2802 | ,ip_location varchar(32) |
| 2803 | ,edu varchar(32) |
| 2804 | ,company varchar(32) |
| 2805 | ,reg_date DATETIME |
| 2806 | ,main_page_url text |
| 2807 | ,avatar_url text |
| 2808 | ,bio text |
| 2809 | ,PRIMARY KEY (id) |
| 2810 | ); |
| 2811 | |
| 2812 | CREATE TABLE IF NOT EXISTS weibo ( |
| 2813 | id varchar(20) NOT NULL |
| 2814 | ,bid varchar(12) NOT NULL |
| 2815 | ,user_id varchar(20) |
| 2816 | ,screen_name varchar(30) |
| 2817 | ,text varchar(2000) |
| 2818 | ,article_url varchar(100) |
| 2819 | ,topics varchar(200) |
| 2820 | ,at_users varchar(1000) |
| 2821 | ,pics varchar(3000) |
| 2822 | ,video_url varchar(1000) |
| 2823 | ,live_photo_url varchar(1000) |
| 2824 | ,location varchar(100) |
| 2825 | ,created_at DATETIME |
| 2826 | ,source varchar(30) |
| 2827 | ,attitudes_count INT |
| 2828 | ,comments_count INT |
| 2829 | ,reposts_count INT |
| 2830 | ,retweet_id varchar(20) |
| 2831 | ,edited BOOLEAN DEFAULT 0 |
| 2832 | ,edit_count INT DEFAULT 0 |
| 2833 | ,PRIMARY KEY (id) |
| 2834 | ); |
| 2835 | |
| 2836 | CREATE TABLE IF NOT EXISTS bins ( |
| 2837 | id integer PRIMARY KEY AUTOINCREMENT |
| 2838 | ,ext varchar(10) NOT NULL /*file extension*/ |
| 2839 | ,data blob NOT NULL |
| 2840 | ,weibo_id varchar(20) |
| 2841 | ,comment_id varchar(20) |
| 2842 | ,path text |
| 2843 | ,url text |
| 2844 | ); |
| 2845 | |
| 2846 | CREATE TABLE IF NOT EXISTS comments ( |
| 2847 | id varchar(20) NOT NULL |
| 2848 | ,bid varchar(20) NOT NULL |
| 2849 | ,weibo_id varchar(32) NOT NULL |