trying to use a custom DB dataset

BIZ TMS RemoteDB
1

Created a default RemoteDB project, removed TFDConnection, created and installed a new Package with a component based on my connection + IDBConnection, added missing functions: reporting MSSQL dialect and since my dataset is read-only, returning nil in BeginTransaction and for the moment also in CreateStatement. My connection is loosely based on Delphi one in the DB unit. Installed the Package. I also found a reference to and implemented a call to:

TAureliusAdapterRegister.Instance.RegisterAdapter(IAureliusAdapter(
TAureliusAdapter.Create(...

in one unit's initialization, using this new class. And dropped the new component on the connection module too.

But Aurelius would not show me this component as an option at design time. So, Ok, I am setting it at runtime and it does not complain. Moreover, I can see my connection actually connecting, so I'm apparently part way through ;-)

Tried enabling Api in Aurelius, but trying to open /api/databases in a browser prompts me for some credentials, which are apparently not my credentials for the target DB.

And I have a Table class as well. Which would need to go in somewhere too.

Now I need to figure out if I could test some simple query from a URL, initially. And how to add my Table to this picture.

Could not find any clues so far, apart from one I mentioned above.

Anyone tried anything like this? Any suggestions or samples?

2

Basically, we have a custom Delphi dataset that we would like to utilise with RemoteDB, i.e.: to be able to offer it through REST to external consumers.

But it's not a direct plug&play, unfortunately. And yet, it's so close. Besides, RemoteDB does seem to offer some adapter capabilities, so it sounds like what we want to achieve is but a step away, just need some assistance...

3

Alright, I have hammered it in somehow and it seemingly works. I'm just not perfectly certain that I do everything in the perfectly correct way. Wagner, can I privately send you my unit for comment?

4

Hi @Alexander_Pastuhov, sure, you can send it.
It will help understand what you are doing, actually, as I could not figured out from your previous posts.