How to create stored procedures in DreamFactory API


Problem :

I have added MySQL tables in the DreamFactory schema (Local Database) and trying to add a stored procedure. I see URLs for listing the existing stored procedures and calling them, but how to create them or add them into Local Database of DreamFactory?



Solution :

DreamFactory's REST API currently does not allow manipulation of stored procedures (CRUD operations), only calling them. This is partially due to the complexity across the various database platforms and partially due to security.

We will consider this as a feature request for future versions.


Mysql Tutorials

Mysql Howto..

Mysql show data in Pivot View

How to create snippet in MySQL Workbench?

(SQL) How to set column names of MySQL table as the delimited first line of my infile?

mySQL How to alter column to have foreign key?

How to create multiple jquery form fields and insert in mysql database, without using mysql_real_escape_string

How to calculate % of total in MySQL

How to export MySQL works that works in all version

MySQL joins: how to simplyfy the given query?

How do I add a reference to the MySQL connector for .NET?

How to query to display pairing field in MySQL ( for Hierarchical data )

How to update sno ascending order in mysql?

How to ORDER MySQL results while excluding a string from the order title

How to write mysql stored procedure using like operator

MySQL How to use value of variable in a Query in its own Subquery

PHP how to quote string array values

How to find a parent with a child excluding another in mysql?

How do I decrypt and encrypt Joomla user password for Java program?

How to limit result returned to 1 of each (MySQL+C#)

How to append a select result columns to anther select result in mysql

how to auto-increment column value starting from value other than one in mysql?

PHP Mysql Check the row and how many have the same email

How does PDO know last inserted id in MySQL?

How do I specify to include a specific zip code in this MySQL query?

How is utf8 data supposed to look when stored in a database?

How to print out a table from mySQL database inside a html/php page

How to make comment system display back with proper text formatting [closed]

MySQL - How to concatenate columns that contain at least one alphabetic character

How can my PHP script tell whether the server is busy?

REPLACE in mysql can't work with free space. how to rename free space?

SQL Function that uses a time-stamp to output how old a question is