62 commits

Author	SHA1	Message	Date
Ahmad Ansori Palembani	f13f98f19a	feat: Add the ability to save search queries ... I got tired of putting the same tag over and over, so...	2025-04-14 21:02:12 +07:00
Ahmad Ansori Palembani	c09c4045e2	refactor: Rework buildSrc ... Co-authored-by: AntsyLich <59261191+antsylich@users.noreply.github.com>	2024-12-25 10:37:47 +07:00
Ahmad Ansori Palembani	301acb9f4d	fix(history): Remove unnecessary JOIN statement	2024-12-16 09:12:49 +07:00
Ahmad Ansori Palembani	4fc18b4913	fix(recents): Missing ON statement	2024-12-16 09:00:40 +07:00
Ahmad Ansori Palembani	e5b8ed9e9d	fix(recents): Find unread from SQL instead of code	2024-12-16 08:27:17 +07:00
Ahmad Ansori Palembani	247ed3bca7	revert: "revert: "revert: "fix(sql): Use UNION ALL instead of UNION""" ... That only made it worse...	2024-12-15 20:24:26 +07:00
Ahmad Ansori Palembani	c7b6e8ee00	revert: "revert: "fix(sql): Use UNION ALL instead of UNION"" ... This reverts commit 37535d3bcf.	2024-12-15 19:53:43 +07:00
Ahmad Ansori Palembani	e604c951ed	refactor: ifnull no longer needed	2024-12-14 19:02:10 +07:00
Ahmad Ansori Palembani	37535d3bcf	revert: "fix(sql): Use UNION ALL instead of UNION" ... This reverts commit 39775ea308.	2024-12-12 21:53:53 +07:00
Ahmad Ansori Palembani	39775ea308	fix(sql): Use UNION ALL instead of UNION	2024-12-12 21:40:33 +07:00
Ahmad Ansori Palembani	1cb635999e	docs(sql): Documentate this insanity of a query [skip ci]	2024-12-10 09:34:36 +07:00
Ahmad Ansori Palembani	d3c98fb897	fix(recents): Can't open chapters from Grouped and All ... id column name for mangas and chapter is both _id causing it conflict when doing 'Rn.*'. In fact, 'Rn.*' is not even needed for union, it just needs to be on the same order, same type, and have the same number of columns.	2024-12-09 21:57:17 +07:00
Ahmad Ansori Palembani	22978ab8bf	refactor(recents): Some adjustments	2024-12-09 20:20:12 +07:00
Ahmad Ansori Palembani	106737371f	chore: Flow version of firstOrNull	2024-12-04 12:05:19 +07:00
Ahmad Ansori Palembani	30d7b389a5	fix: Fix Komga unread count (again)	2024-12-03 16:22:44 +07:00
Ahmad Ansori Palembani	7f05d16039	fix(sqldelight): Custom query function ... Basically the same as "executeAsOneOrNull" but without the result count check	2024-12-02 13:20:55 +07:00
Ahmad Ansori Palembani	e8054855ac	refactor(db): Migrate mangaCategory queries (that can be migrated) to SQLDelight	2024-11-29 19:11:29 +07:00
Ahmad Ansori Palembani	726613e6d7	refactor(db): Migrate track queries (that can be migrated) to SQLDelight	2024-11-29 18:02:45 +07:00
Ahmad Ansori Palembani	17b07cd836	refactor(db): Migrate last history queries (that can be migrated) to SQLDelight	2024-11-29 17:05:59 +07:00
Ahmad Ansori Palembani	e25f330118	refactor(db): Migrate getChapters query to SQLDelight	2024-11-29 15:08:42 +07:00
Ahmad Ansori Palembani	83cb898068	refactor(db): Migrate deleteTrack query to SQLDelight	2024-11-29 14:44:13 +07:00
Ahmad Ansori Palembani	aae9a68c8b	refactor(db): Migrate getManga queries to SQLDelight	2024-11-29 14:21:16 +07:00
Ahmad Ansori Palembani	da1f60c5c5	refactor(db): Migrate clear database queries to SQLDelight	2024-11-29 13:46:37 +07:00
Ahmad Ansori Palembani	cf06ebdb8b	fix(library): Accidentally swap global open random manga with non-global	2024-11-29 13:13:21 +07:00
Ahmad Ansori Palembani	ca41e02fe1	refactor(db): Migrate some more category queries to SQLDelight	2024-11-29 11:28:38 +07:00
Ahmad Ansori Palembani	97eacbbaea	refactor(db): Handle the addition from SQL directly instead from code	2024-11-29 08:07:01 +07:00
Ahmad Ansori Palembani	291d4ffc35	fix(db): Fix incorrect query	2024-11-28 21:12:46 +07:00
Ahmad Ansori Palembani	c183802096	refactor(db): Migrate GetTrack to SQLDelight	2024-11-28 20:53:26 +07:00
Ahmad Ansori Palembani	a199ff326d	refactor(db): Replace deleteHistoryNoLastRead StorIO with SQLDelight eqv	2024-11-26 09:05:36 +07:00
Ahmad Ansori Palembani	4f9e5bfe62	refactor(db): Replace some more StorIO queries with SQLDelight	2024-11-24 19:08:42 +07:00
Ahmad Ansori Palembani	bf7c7f79cb	revert: "fix(chapter): Scanlator is nullable" ... This reverts commit 0f44474596.	2024-11-23 20:10:08 +07:00
Ahmad Ansori Palembani	5378d2a99b	refactor(db): Replace some more StorIO queries with SQLDelight ... - Manga: db.getManga -> getManga.await* - History - Chapter: db.updateChapter* -> updateChapter.await; db.getChapter -> getChapter.await*	2024-11-23 19:28:59 +07:00
Ahmad Ansori Palembani	e27c527ad9	fix(chapter): Scanlator is nullable	2024-11-19 08:25:55 +07:00
Ahmad Ansori Palembani	9b45767667	refactor(backup): Retrieve manga with SQLDelight	2024-10-13 19:09:15 +07:00
Ahmad Ansori Palembani	a27c0edf13	refactor(recents): Fully migrate recents to use SQLDelight, for real this time	2024-08-27 13:47:18 +07:00
Ahmad Ansori Palembani	0d9ffc2206	fix(recents): Partially revert SQLDelight migration ... getAllRecentsTypes query is too cursed, will need some refactoring	2024-08-27 10:01:17 +07:00
Ahmad Ansori Palembani	6e3eaad481	fix(sql): Union issue ... It doesn't like history.*	2024-08-27 09:50:32 +07:00
Ahmad Ansori Palembani	a19b767aff	fix(sql): Remove alias	2024-08-27 08:52:17 +07:00
Ahmad Ansori Palembani	354ed7ce8a	refactor(recents): Fully migrate recents to use SQLDelight	2024-08-27 08:23:11 +07:00
Ahmad Ansori Palembani	61e43e047f	chore: Preparing to migrate History to SQLDelight	2024-08-24 07:27:33 +07:00
Ahmad Ansori Palembani	c9b302ab21	refactor: Add cover_last_modified	2024-08-17 14:26:57 +07:00
Ahmad Ansori Palembani	1e68e55cf7	refactor(chapter): Migrate more queries to SQLDelight	2024-08-17 07:59:39 +07:00
Ahmad Ansori Palembani	16a51f00c4	fix(recents): Fix get recent chapters query	2024-08-16 20:07:22 +07:00
Ahmad Ansori Palembani	ce94bd2ad6	refactor(reader): Use SQLDelight to load chapter url	2024-08-16 20:01:00 +07:00
Ahmad Ansori Palembani	a6ef46a90f	refactor(recents): Migrate getRecentChapters to SQLDelight	2024-08-16 19:46:14 +07:00
Ahmad Ansori Palembani	6c8bd82d41	fix: Unread badge wont show up for some sources ... Always happened on Komga apparently, but not as frequent on other sources Fixes GH-95	2024-08-12 18:07:54 +07:00
Ahmad Ansori Palembani	e1ccfeeb0a	refactor: Simplify SQL	2024-08-10 11:30:42 +07:00
Ahmad Ansori Palembani	7e1b532f83	fix: Scanlator filter not working properly	2024-08-10 11:10:52 +07:00
Ahmad Ansori Palembani	49ecfc51b1	refactor: Move source-api to source directory ... Preparing to split local source to its own module	2024-07-28 11:38:33 +07:00
Ahmad Ansori Palembani	a149d5aeec	chore(deps): Converted more gradle plugins to use version catalog	2024-06-27 19:13:26 +07:00