Basic non-SQL RESTful service with mORMot

egold2005 · 2019-01-28 12:17:32

Hello,

I am new to this stuff and I am about to create a kind of proxy RESTful service with mORMot.

I saw some sample code and it always refers TSQLHttpServer component.

Is there a way I can create non-SQL server?

Any suggestions are greatly appreciated.

Thanx a lot.

ab · 2019-01-28 13:07:36

Just use a void model.
That is, call TSQLServerFullMemory.CreateWithOwnModel([],false,'root') for /root URI.

egold2005 · 2019-01-28 13:36:50

I modified the sample code like this. I do not have TSQLServerFullMemory class in my installation it seems...

When I run this, I get Access is denied. I think this is something to do with permissions....

ab · 2019-01-28 13:37:33

It is TSQLRestServerFullMemory from mORMot.pas.

egold2005 · 2019-01-28 13:59:26

Thank you, I got it running.

Now when I hit it at http://127.0.0.1:888/root I get

{
"errorCode":400,
"errorText":"Bad Request"
}

Where do I put the server logic?

Basically what I want to do is, determine the URI part, like "root" or "id1" or "id2" etc, and based on that ID to pass the request to another URL.

How do I go about that?

Thanx once again!

ab · 2019-01-28 14:26:01

See the doc about services, e.g. method-based services or interface-based services.

For your use case, a method-based service may be good, since it gives full access to the HTTP context.

egold2005 · 2019-01-29 09:28:12

Is there any demos/sample code available?

I am studying the docs and determined it would make sense to use TSQLRestServerRemoteDB to create a proxy, but the docs do not give enough information to get into that stuff...

ab · 2019-01-29 09:47:06

TSQLRestServerRemoteDB is for remote SQL/ORM execution, but a RESTful service using high-level parameters, and returning JSON may be a better design.

There are samples of TSQLRestServerRemoteDB in the regression tests - see TestSQLite3.dpr.

egold2005 · 2019-01-29 10:55:23

Okay, so for "better design" I inherit from TSQLRestServerFullMemory then, right?

What method do I override to deal with URI and redirect based on certain keywords found?

Also can I avoid "root" and have it like http://localhost:888/id1 etc?

Thank you.

egold2005 · 2019-01-29 11:15:53

Okay, I have found 04 - HTTP Client-Server sample and I think this will get me started in correct direction.

mORMot Open Source

#1 2019-01-28 12:17:32

Basic non-SQL RESTful service with mORMot

#2 2019-01-28 13:07:36

Re: Basic non-SQL RESTful service with mORMot

#3 2019-01-28 13:36:50

Re: Basic non-SQL RESTful service with mORMot

#4 2019-01-28 13:37:33

Re: Basic non-SQL RESTful service with mORMot

#5 2019-01-28 13:59:26

Re: Basic non-SQL RESTful service with mORMot

#6 2019-01-28 14:26:01

Re: Basic non-SQL RESTful service with mORMot

#7 2019-01-29 09:28:12

Re: Basic non-SQL RESTful service with mORMot

#8 2019-01-29 09:47:06

Re: Basic non-SQL RESTful service with mORMot

#9 2019-01-29 10:55:23

Re: Basic non-SQL RESTful service with mORMot

#10 2019-01-29 11:15:53

Re: Basic non-SQL RESTful service with mORMot

Board footer