Hi Michael, I am digging into your SQLDBRestBridge component. Very useful code.
I could fix and run both the server part and the client part (I used the BufDataset client). My code (with very few changes applied to the original one) can be downloaded from this link: https://mega.nz/file/Gxx3FBya#LbvDvuFnH5rUDVAdPoGyuUCnkNE761A62SZ1MYX8oFQ I hope it be helpful for somebody. I have 2 questions: 1. the client needs to know the name of the primary key (PK) of each table. Is there a way to ask the server for the name of the PK of table A? Or to have the PK listed in the metadata? 2. the client needs to periodically refresh the visible rows in the event that another client applied changes to the DB. How is this done? I reckon that the client will remember the last command like BASEURL/resourcename?limit=10&Offset=50 and reissue it. Right? Thank you Peppe On Fri, Nov 4, 2022 at 9:05 AM Michael Van Canneyt <mich...@freepascal.org> wrote: > > > > On Thu, 3 Nov 2022, duilio foschi wrote: > > >> Please look at the intercept example > > > > could you please expand on this? > > In the http request router, you can register global handlers which are > executed > for every request. You can choose if the handler is executed before or after > the normal handler for the request. > > > > > > Where do I find the intercept example? > > https://gitlab.com/freepascal.org/fpc/source/-/blob/main/packages/fcl-web/examples/intercept/simpleserver.pas > > This example shows both kind of handlers, before and after request. The > before request handler just logs the URL, just what you need. > > Michael. -- _______________________________________________ lazarus mailing list lazarus@lists.lazarus-ide.org https://lists.lazarus-ide.org/listinfo/lazarus
