DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

Welcome! Log In Create A New Profile

Advanced

stored procedure or stored functions

Posted by avasi 
stored procedure or stored functions
July 12, 2016 04:22AM
Hi,

there is a way to easily invoke stored proc or stored functions straight from dadabik?
Re: stored procedure or stored functions
July 12, 2016 04:27AM
Hi,
not at the moment; could you describe better your use case? We might add this to DaDaBIK 8.

best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: stored procedure or stored functions
July 12, 2016 07:46AM
I have a database (mysql) that has some stored procedures defined within. I wish to have a way to include those procedures and exeute them without write any code.
Re: stored procedure or stored functions
July 12, 2016 09:26AM
Ok but I don't understand how would you like to integrate them in DaDaBIK, you want to execute them when a specific DaDaBIK event occurs?

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: stored procedure or stored functions
July 12, 2016 11:11AM
I don't have a clear idea about that, maybe an event fired by user or automatically by dadabik under some circumstances...
Re: stored procedure or stored functions
July 12, 2016 11:19AM
DaDaBIK 8 will have more "hooks" to add custom code when an event occurs (e.g. insertion of a new record in table X); I think this is where a stored procedure might be useful.

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: stored procedure or stored functions
July 12, 2016 11:20AM
You can do the same now, but you have to manually add the code at the end of each function (e.g. insert_record, update_record, ...)

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: stored procedure or stored functions
July 13, 2016 03:07AM
ah ok that sounds good to me! when do you plan to release v.8?
Re: stored procedure or stored functions
July 13, 2016 03:08AM
Hopefully in Autumn 2016, to celebrate 15 years from the first public release of DaDaBIK smiling smiley but it could be sooner or later.

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: stored procedure or stored functions
July 13, 2016 03:53AM
great! hope it will be sooner than autumn thumbs up
Sorry, only registered users may post in this forum.

Click here to login