Using / calling Mariadb Stored procedures in Frappe

Frappe Framework
1

We want to create a stored procedure in Maria DB and want to execute it through the frappe framework. Can we use or call stored procedures in Frappe? , then how?

Thanks.

2

I would try

frappe.db.sql("CALL sp_TEST;");
3

I tried, but not able to call the stored procedure, in my serverside python script. we are calling frappe.db.sql(“CALL sp_TEST;”); and after that line, we are showing an alert message.

After executing python code we are getting alert message but the stored procedure is never called.
While at the database level, this stored procedure can be called perfectly.

4

I tried, but not able to call the stored procedure, in my serverside python script. we are calling frappe.db.sql(“CALL sp_TEST;”); and after that line, we are showing an alert message.

After executing python code we are getting alert message but the stored procedure is never called.
While at the database level, this stored procedure can be called perfectly.

5

We have add frappe.db.commit also, after that it is working

1 Like
6

Great to hear that.

Also we want to inform you that we have a VIEW in MariaDB. It backups perfectly but it throws error when restoring. bench restore: Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation · Issue #1215 · frappe/bench · GitHub

I am not sure if this is still the case. Good luck.