Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 14 of 14 total
Thread EWB + EWS + EDB + Cookie Authentication + HTTPS
Wed, May 4 2016 4:09 AMPermanent Link

Matthew Jones

Pasquale wrote:

> I developed this platform for the my company
>
> https://www.mbspay.it
>
> i have use EWB + php (for the server side) and MySql database

Looks nice - I like the animated selector thingies.

--

Matthew Jones
Wed, May 4 2016 7:03 AMPermanent Link

Mark Brooks

Slikware

Avatar

To All On This Thread

Have really appreciated your explanations, examples, thoughts and ideas. Really useful.

It strikes me that maybe "true REST" might only be applicable at a later stage when I potentially open the platform to 3rd party clients. That would likely be a subset of the functionality anyway so could be handled via a different mechanism.

So, in the meantime, one final query remains. I will still need to encapsulate some logic operations on my data, for example the previous scenario whereby adding an item to a table will, behind the scenes, do something in another table. This should not be the responsibility of the client, but should be automatically enforced server-side.

What is the best approach to achieve this, assuming EDB + EWS + EWB? Currently I have almost zero experience of queries, views, stored procs and modules :-|

Thanks all, in advance - Mark
Wed, May 4 2016 1:24 PMPermanent Link

Uli Becker

Mark,

> whereby adding an item to a table will, behind the scenes, do something in another table. This should not be the responsibility of the client, but should be automatically enforced server-side.
>
> What is the best approach to achieve this, assuming EDB + EWS + EWB? Currently I have almost zero experience of queries, views, stored procs and modules :-|

I think you are looking for triggers. Very powerful to change values in
another table depending of changes in a table.
You can call also execute procedures within a trigger - everything is
possible Smile

If that's useful for you and you need more help, just post it here or in
the EDB ng.

Regards Uli

Wed, May 4 2016 4:24 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mark,

<< So, in the meantime, one final query remains. I will still need to encapsulate some logic operations on my data, for example the previous scenario whereby adding an item to a table will, behind the scenes, do something in another table. This should not be the responsibility of the client, but should be automatically enforced server-side. >>

Uli is correct, triggers are what you want.  Please see here for more information:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=CREATE_TRIGGER

Triggers use the ElevateDB SQL/PSM dialect (slightly different from standard SQL/PSM), and the statements/functions you can use are here:

http://www.elevatesoft.com/manual?action=topics&id=edb2sql&section=sql_psm_statements

http://www.elevatesoft.com/manual?action=topics&id=edb2sql&section=sql_psm_functions

Tim Young
Elevate Software
www.elevatesoft.com
« Previous PagePage 2 of 2
Jump to Page:  1 2
Image