43 Commits

Author	SHA1	Message	Date
norohind	6711b2dd80	use pool	2024-08-27 23:43:24 +02:00
norohind	569e06b8c2	fix column name for timestmap in diffs	2023-05-20 20:51:20 +03:00
norohind	6fa7c1fcf5	add timestamp to diff response	2023-05-20 20:44:15 +03:00
norohind	4574882c70	show percent of score in latest leaderboards	2023-03-08 20:01:21 +03:00
norohind	0247e6616f	fix latest leaderboard: add order by score desc	2022-05-22 21:22:07 +03:00
norohind	f389804558	Implement hook system	2022-05-22 14:54:34 +03:00
norohind	bfd68f9afa	fix: sql req diff displaying deleted squads	2022-05-03 22:47:09 +03:00
norohind	19cec1fa0e	fix: remove hardcoded values from sql queries	2022-04-07 00:11:04 +03:00
norohind	e5e266b8f1	Add note how to sync serial action_id	2022-04-04 18:14:07 +03:00
norohind	6d8d1198d3	sql requests: add static columns as temp solution	2022-04-04 00:27:26 +03:00
norohind	ee575a726a	Migrating to new DB schema (WIP)	2022-04-03 23:41:13 +03:00
norohind	8e82a6aa48	sqlite cache: make key as primary key	2022-04-03 23:40:35 +03:00
norohind	c129c3d1bf	Add get_latest_leaderboard	2022-01-31 20:04:23 +03:00
norohind	c5ae70a5f8	make pretty keys optional	2022-01-31 18:21:29 +03:00
norohind	b9cab7f667	activity request fix: order by action_id in window function	2022-01-31 14:14:26 +03:00
norohind	6d0b78dca1	model fix: rollback transaction on fail	2022-01-31 14:13:51 +03:00
norohind	10db5103da	DB schema: add index by timestamp	2022-01-17 01:30:52 +03:00
norohind	dd8f2754e9	web: optimization	2022-01-17 01:26:01 +03:00
norohind	3d22b716bd	@errors_catcher for model.get_leaderboard_by_action_id	2021-12-19 00:35:35 +03:00
norohind	d1ec8b2b69	fix leaderboard by action_id	2021-12-15 21:31:24 +03:00
norohind	3f1efe0ac7	WIP: leaderboard state by action_id	2021-12-15 12:10:21 +03:00
norohind	5360ab2e31	WIP: model.get_leaderboard_sum_history and all appropriate stuff	2021-12-10 00:56:48 +03:00
norohind	0c64bde728	remove context manager self.db for read request	2021-12-09 01:00:07 +03:00
norohind	f58df5e45f	utils.measure: add name to display	2021-12-08 21:05:27 +03:00
norohind	7b48b5de66	diff: order by coalesced diff	2021-12-01 14:16:26 +03:00
norohind	d37b836975	Fix if null value for lb type and platform in model	2021-12-01 01:38:27 +03:00
norohind	8107895c52	Explicit rename tag to Tag column	2021-12-01 01:34:56 +03:00
norohind	d483040901	Fix new_stats.name for deleted squadrons	2021-12-01 01:30:16 +03:00
norohind	ebefef349d	Autoreconnect on error	2021-11-30 17:33:46 +03:00
norohind	c1678b8d8d	Show entries with Diff < 0 (in theory, deleted squads)	2021-11-30 17:08:20 +03:00
norohind	09d3f86c00	Remove support for sqlite	2021-11-30 16:54:16 +03:00
norohind	36bb3a78eb	fix /diff when squad starts to exists in leaderboard	2021-11-30 16:20:51 +03:00
norohind	fdaa579ec0	Read reqs in postgres should be in transactions ... In order to prevent break whole program instance by one failed request	2021-11-28 18:29:48 +03:00
norohind	e822cd06c9	Return original columns names for postgres	2021-11-28 17:58:13 +03:00
norohind	b056aeba2a	Measure exec time only on DEBUG log level	2021-11-28 17:18:42 +03:00
norohind	3757cc1b07	call open_model must be done by web.py and main.py by themself	2021-11-28 17:11:47 +03:00
norohind	d30bc56c9e	Took out env vars extracting to config.py	2021-11-28 16:57:55 +03:00
norohind	145cb8a19b	Remove more hardcoded secrets	2021-11-28 14:07:39 +03:00
norohind	702ab34154	Add logging for models	2021-11-28 14:03:39 +03:00
norohind	1a692df820	Abstract model for support both DBMS	2021-11-28 03:18:41 +03:00
norohind	bfd2f785a9	sqlite_cache safety	2021-11-28 02:38:56 +03:00
norohind	089451745c	Remove hardcoded values	2021-11-28 02:36:52 +03:00
norohind	b5d0c43b7e	WIP: migration from sqlite to postgres	2021-11-28 02:28:31 +03:00