← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:07 | mbridge joined #koha | |
| 00:34 | mbridge | [mattermost] <rudy.hinojosa> I'd like to request to get an endpoint added to the Koha REST-API for a specific table `used_sql` |
| 00:35 | [mattermost] <rudy.hinojosa> or is there a script that might create a CRUD type endpoint for a specific table(s)? | |
| 00:35 | [mattermost] <rudy.hinojosa> I'd like to request to get an endpoint added to the Koha REST-API for a specific table `saved_sql` | |
| 01:07 | mbridge joined #koha | |
| 02:07 | mbridge joined #koha | |
| 03:07 | mbridge joined #koha | |
| 04:07 | mbridge joined #koha | |
| 05:07 | mbridge joined #koha | |
| 06:07 | mbridge joined #koha | |
| 07:07 | mbridge joined #koha | |
| 07:46 | mbridge | [mattermost] <jpahd> Nah, no code generation. |
| 07:46 | [mattermost] <jpahd> Why do you want an endpoint to request sql | |
| 07:46 | [mattermost] <jpahd> ? | |
| 08:07 | mbridge joined #koha | |
| 09:07 | mbridge joined #koha | |
| 10:07 | mbridge joined #koha | |
| 11:07 | mbridge joined #koha | |
| 11:59 | mbridge | [mattermost] <ashimema> I'm also interested in the use case your considering.. not against the endpoint just wondering about it's use and thus how to prioritise it. |
| 12:07 | mbridge joined #koha | |
| 13:07 | mbridge joined #koha | |
| 14:07 | mbridge joined #koha | |
| 15:07 | mbridge joined #koha | |
| 16:07 | mbridge joined #koha | |
| 17:07 | mbridge joined #koha | |
| 18:07 | mbridge joined #koha | |
| 19:07 | mbridge joined #koha | |
| 19:12 | mbridge | [mattermost] <rudy.hinojosa> I want to be able to add custom reports for a project I'm working on. I'm planning releasing by end of 3rd qtr. It deals with custom reports. [Koha-Jasper: Advanced Reporting Utility (lightwavelibrary.com)](https://lightwavelibrary.com/jasper/) |
| 19:12 | [mattermost] <jpahd> Ah I read about that in the newsletter. Alright. | |
| 19:13 | [mattermost] <jpahd> Well If you just want to read and wirkte this shouldn't be too hard. | |
| 19:13 | [mattermost] <jpahd> Well If you just want to read and write this shouldn't be too hard. | |
| 19:14 | [mattermost] <rudy.hinojosa> I already have a writing solution, but it's via mysql commands, but I'm not a fan of having port 3306 open to the public. There are ways to restrict access to port 3306, but many libraries don't have the pleasure of a static IP address, and even less libraries have decent network knowledgebase. | |
| 19:15 | [mattermost] <jpahd> Yeah this could definitely be done via API. | |
| 19:15 | [mattermost] <jpahd> Have you thought about a plugin? | |
| 19:16 | [mattermost] <rudy.hinojosa> That is my preference for sure. custom report paks could be downloaded from lightwavelibrary.com and users just import them, and it will auto build the sql statement and columns etc. | |
| 19:16 | [mattermost] <rudy.hinojosa> jasper reports can handle subquery and complex reporting. | |
| 19:17 | [mattermost] <jpahd> It sounds like you are capable of doing this yourself. | |
| 19:17 | [mattermost] <rudy.hinojosa> I've created a workaround solution using loopback.io | |
| 19:18 | [mattermost] <rudy.hinojosa> but it becomes pretty large when you tokenization routines, which is a must for an API | |
| 19:18 | [mattermost] <rudy.hinojosa> but it becomes pretty large when you usetokenization routines, which is a must for an API | |
| 19:18 | [mattermost] <rudy.hinojosa> but it becomes pretty large when you use tokenization routines, which is a must for an API | |
| 19:19 | [mattermost] <rudy.hinojosa> I may revisit the Koha API again. | |
| 19:19 | [mattermost] <jpahd> Maybe you can just port your OpenAPI spec over to a Koha plugin: https://github.com/bywatersolu[…]ugin-kitchen-sink | |
| 19:19 | [mattermost] <jpahd> This is a place to start. | |
| 19:20 | [mattermost] <rudy.hinojosa> I would love to see a script written buildendpoint.pl <tablename> CRUD (Create,Read,Update,Delete) parameters. | |
| 19:22 | [mattermost] <jpahd> Maybe but we're not big on codegen | |
| 19:22 | [mattermost] <jpahd> I'm working on something in that space. | |
| 19:22 | [mattermost] <jpahd> But this will still take a while. | |
| 20:07 | mbridge joined #koha | |
| 21:07 | mbridge joined #koha | |
| 22:07 | mbridge joined #koha | |
| 23:07 | mbridge joined #koha |
← Previous day | Today | Next day → | Search | Index