diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-10-05 19:52:12 +1100 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-10-05 19:52:12 +1100 |
| commit | df14a1112e28597483de86619dcbd57dc5b15db7 (patch) | |
| tree | d16c438d6164606f2b6706f6c4d5009a9e18b159 /backend/hist_data/gen_pop_data.py | |
| parent | b1d4c709cb2793745e61d85c337514b9c6c85603 (diff) | |
Add data serving scripts
Add histplorer.py, implementing the http query interface
Add unit test
Add server.py as a simple backend dev server
Update documentation
Diffstat (limited to 'backend/hist_data/gen_pop_data.py')
| -rwxr-xr-x | backend/hist_data/gen_pop_data.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/hist_data/gen_pop_data.py b/backend/hist_data/gen_pop_data.py index 46c9c68..8eaa142 100755 --- a/backend/hist_data/gen_pop_data.py +++ b/backend/hist_data/gen_pop_data.py @@ -35,6 +35,7 @@ def genData(pageviewsDb: str, dbFile: str) -> None: # print(f'Result: {len(titleToViews)} out of {len(titleToId)}') dbCur.execute('CREATE TABLE pop (id INT PRIMARY KEY, pop INT)') + dbCur.execute('CREATE INDEX pop_idx ON pop(pop)') for title, views in titleToViews.items(): dbCur.execute('INSERT INTO pop VALUES (?, ?)', (titleToId[title], views)) # |