How to executed custom SQL statements? (In ORM)

acid · 2016-03-25 06:14:23

Hello,

Create a web appliction with mORMot Framework. (MVC + ORM)
I want to executed custom SQL ,get some record from external DB . (Select)

In TMVCApplication,

var
res:ISQLDBRows;
begin
res:=RestModel.Execute(...) ?
...
end;

What should I do?

ab · 2016-03-25 08:27:44

Which statement do you expect to execute?
Are you sure the ORM is not able to create this query?
See http://synopse.info/files/html/Synopse% … #TITLE_115

acid · 2016-03-25 08:53:18

i.e.

select * from table1 order by fld1 asc,fld2 desc,fld3

Multiple fields, sort

I found ,mormot ORM only one sort field is supported . (in mssql 2008)

ab · 2016-03-25 09:27:21

You then have to access directly the TSQLDBConnectionProperties of the external database definition.

acid · 2016-03-26 02:52:52

In TMVCApplication or it's derivative class ,
Is it possible to get instance of TSQLDBConnectionProperties (or TSQLDBConnection)?

i.e.
type
TMvcApp = class(TMVCApplication, IMyIntf)
public
procedure MyMethod ();
end;

-------impl--------
procedure TMvcApp.MyMethod ();
var
props:TSQLDBConnectionProperties ;
begin

//get TSQLDBConnectionProperties
props:=Self.RestModel.GetDBConnectionProperties;

..... do something......

end;

ab · 2016-03-26 16:36:39

You just need to store it in TMvcApp when you initialize the external database.

mORMot Open Source