Commit Graph

Select branches

Hide Pull Requests

master

Mono Color

• 344455e409 deprecated db.transaction master Riccardo Berto 2022-03-28 17:40:43 +02:00
• 654f580fc5 new python code formatter Riccardo Berto 2022-03-28 17:05:30 +02:00
• 107e1241d7 typos Riccardo Berto 2021-09-13 13:52:56 +02:00
• 110f18a62f perf improvements on parco_monza_classico view Riccardo Berto 2021-09-13 13:51:08 +02:00
• ddd2daf8cf monticello view Riccardo Berto 2021-09-13 13:48:23 +02:00
• 1b8674a6c0 removed unrelated comment Riccardo Berto 2021-09-13 11:25:54 +02:00
• ca69ec961e parco_monza_classico e arcore classico views Riccardo Berto 2021-09-13 11:24:49 +02:00
• d711766571 comment on what resolve_geo_location really is Riccardo Berto 2021-09-12 14:20:41 +02:00
• cdd6418c79 merge training_duration and training_info into 1 view Riccardo Berto 2021-09-12 14:18:27 +02:00
• 364329dc0e more generous Trezzo sull'Adda radius Riccardo Berto 2021-09-12 11:51:25 +02:00
• 81551b4890 added more places in the resolve_geo_location lut Riccardo Berto 2021-09-12 11:51:03 +02:00
• 868dcb89f2 resolve_geo_location(1) immutable lut function Riccardo Berto 2021-09-12 11:26:28 +02:00
• 2d802b67d5 training_duration with the "distinct on" paradigm Riccardo Berto 2021-09-12 11:25:30 +02:00
• 64c4938c88 btree Riccardo Berto 2021-09-12 09:50:03 +02:00
• 4fd00bc8fd hash index on training_data.training_id Riccardo Berto 2021-09-12 09:31:40 +02:00
• 2c45db029d don't print stats after execution Riccardo Berto 2021-09-11 17:19:16 +02:00
• b9a575219a overall stats as training_info view Riccardo Berto 2021-03-02 09:00:57 +01:00
• aa792ce33a training_info view Riccardo Berto 2021-03-02 09:00:13 +01:00
• 320123ad74 print all training stats after GPX processing Riccardo Berto 2021-03-01 15:45:46 +01:00
• ff2dbd8906 tabulate for output prettyprinting Riccardo Berto 2021-03-01 15:28:03 +01:00
• d9a02155b4 sqlparse for prettyprinting Riccardo Berto 2021-03-01 15:23:33 +01:00
• 7d16e29cab exclude __pycache__ dir Riccardo Berto 2021-03-01 15:21:47 +01:00
• 228a4e64f4 enclose db ops in a transaction Riccardo Berto 2021-03-01 15:14:05 +01:00
• 841fac5634 remove GPX if it's already in the database, too Riccardo Berto 2021-03-01 15:11:59 +01:00
• 2c19532e1b start_location and end_location for training_duration view Riccardo Berto 2021-03-01 13:55:11 +01:00
• a257a08760 training_duration view Riccardo Berto 2021-03-01 13:38:11 +01:00
• 6422fff894 training_data(t) btree index Riccardo Berto 2021-03-01 12:33:26 +01:00
• 9f01bcafdb drop idx_training_data_training_id Riccardo Berto 2021-03-01 11:58:40 +01:00
• 5fc5add5c6 delete GPX file after processing Riccardo Berto 2021-03-01 10:45:43 +01:00
• 00fd7cbeeb added java reference code for calories calc Riccardo Berto 2021-02-25 08:15:24 +01:00
• 04cac0b1f3 license Riccardo Berto 2021-02-25 08:00:28 +01:00
• ca3080e2b8 typo Riccardo Berto 2021-02-24 21:38:05 +01:00
• f8448f1b1f added README Riccardo Berto 2021-02-24 21:02:21 +01:00
• e7cd4ce1e4 don't create unnecessary IMAP directories Riccardo Berto 2021-02-24 19:22:04 +01:00
• 0dc4fa0f52 added informative prints Riccardo Berto 2021-02-24 18:12:30 +01:00
• 3141922d6f os.mkdir() into main() Riccardo Berto 2021-02-24 17:39:47 +01:00
• 2cf3df6ae0 _get_sender() helper func Riccardo Berto 2021-02-24 17:39:23 +01:00
• 1456ddc2e5 removed unused imports Riccardo Berto 2021-02-24 17:22:14 +01:00
• de7b3e5fb2 fixed typo (double col name on index decl) Riccardo Berto 2021-02-24 17:21:32 +01:00
• 533fb098e3 extrapolate owner from filename Riccardo Berto 2021-02-24 17:20:27 +01:00
• a141403536 sender name in GPX filename Riccardo Berto 2021-02-24 17:12:39 +01:00
• 74a0e12e9c ensure inbox is closed Riccardo Berto 2021-02-24 17:05:02 +01:00
• 41767c044e remove parenthesis from ALL IMAP filter Riccardo Berto 2021-02-24 17:04:30 +01:00
• bdf2b8ccab delete mail from mailserver after done processing Riccardo Berto 2021-02-24 17:03:41 +01:00
• 595d29ef01 BeautifulSoup for raw XML parsing Riccardo Berto 2021-02-24 16:59:40 +01:00
• c60a497285 GIST index on geog col Riccardo Berto 2021-02-24 16:55:06 +01:00
• 8389d49e71 inserts as dict Riccardo Berto 2021-02-24 16:51:57 +01:00
• b9bb919b96 geog not null and speed can be null Riccardo Berto 2021-02-24 16:51:46 +01:00
• 69d73b4f6f PostGIS Riccardo Berto 2021-02-24 16:38:49 +01:00
• e4df2727e6 type instead of medium Riccardo Berto 2021-02-24 16:08:21 +01:00
• 7ec35edcaf insert gpx points Riccardo Berto 2021-02-24 15:58:52 +01:00
• 800d5151b6 removed distance & kcal col from training_data Riccardo Berto 2021-02-24 14:00:37 +01:00
• 6c103d512c elevation col instead of altitude Riccardo Berto 2021-02-24 13:52:35 +01:00
• d6c3e6b738 insert data in training table Riccardo Berto 2021-02-24 11:38:34 +01:00
• 0bf8deff30 moving_distance and stopped_distance col Riccardo Berto 2021-02-24 11:35:39 +01:00
• 35f2794d5f moving_time and stopped_time col Riccardo Berto 2021-02-24 11:32:12 +01:00
• 8fbdc77656 new mail filter case Riccardo Berto 2021-02-24 11:27:47 +01:00
• 2e133fdb3e gpxpy parsing and DB transaction Riccardo Berto 2021-02-24 11:27:19 +01:00
• b2364b6252 owner column Riccardo Berto 2021-02-24 11:18:27 +01:00
• 6084a79b3c rename comment col into description Riccardo Berto 2021-02-24 11:13:40 +01:00
• a123a02ff0 remove duplicate col in training_data table Riccardo Berto 2021-02-24 11:05:49 +01:00
• ecd763dad2 filename column in training table to prevent duplicates Riccardo Berto 2021-02-24 10:36:04 +01:00
• 4943a2a3c0 speed col on training_data table Riccardo Berto 2021-02-24 10:30:31 +01:00
• f5f2b60700 index on training_data(training_id) Riccardo Berto 2021-02-24 10:27:18 +01:00
• b22ce1392d training and training_data Riccardo Berto 2021-02-24 10:26:09 +01:00
• 8868421671 download gpx file attachments Riccardo Berto 2021-02-24 10:13:54 +01:00
• 184e13b698 mail login starttls Riccardo Berto 2021-02-23 17:13:33 +01:00
• b1012d2ce3 dict-like config access Riccardo Berto 2021-02-23 17:10:13 +01:00
• ce7b59fe6e fix configparser initialization Riccardo Berto 2021-02-23 17:09:07 +01:00
• e81c81c190 ignore gpx files dir Riccardo Berto 2021-02-23 17:05:36 +01:00
• 6a19ae637b training table Riccardo Berto 2021-02-23 16:49:24 +01:00
• e767149802 connect on db obj creation Riccardo Berto 2021-02-23 16:45:58 +01:00
• df277f4548 init_database() Riccardo Berto 2021-02-23 16:45:41 +01:00
• 3f0f292ded indexes instead of keys to address the ini content Riccardo Berto 2021-02-23 16:45:23 +01:00
• ec6f64dcea DDL file Riccardo Berto 2021-02-23 16:31:06 +01:00
• 871d9abf98 mail login Riccardo Berto 2021-02-23 16:27:03 +01:00
• 2f8085109f removed unused files Riccardo Berto 2021-02-23 16:22:42 +01:00
• 0272dffbbf create_engine() Riccardo Berto 2021-02-23 16:21:54 +01:00
• 6198feeb6f requirements.txt Riccardo Berto 2021-02-23 16:21:46 +01:00
• f33627fed6 First Commit Riccardo Berto 2021-02-23 16:10:28 +01:00