Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How can I call MySQL stored procedure in ecto(=> 0.11)?

Tags:

mysql

elixir

ecto

I am looking for a way to use call stored procedure, there was no found. Is it possible in an elixir's ecto lib?

like image 254
aposto Avatar asked May 06 '15 03:05

aposto

People also ask

How do I execute a stored procedure in MySQL?

Create a simple stored procedure. DELIMITER ; To create the MySQL Stored Procedure, open the MySQL workbench Connect to the MySQL Database copy-paste the code in the query editor window click on Execute. You can view the procedure under stored procedures.

Can I call a stored procedure from a view in MySQL?

No, you cannot. Views are typically read-only operations; and that behavior cannot be guaranteed if stored-procedures are invoked. Related question: How to call Stored Procedure in a View?

1 Answers

You can go directly through the SQL adapter API:

Ecto.Adapters.SQL.query(YourRepo, "stored_procedure(?, ?)", [param1, param2])

More info here: https://hexdocs.pm/ecto/#!Ecto.Adapters.SQL.html

like image 176
José Valim Avatar answered Sep 24 '22 00:09

José Valim
Sign in to Comment

Related questions

MAMP Python-MySQLdb issue: Path to libssl.1.0.0.dylib changing once Python file called
PHPStorm warnings on placeholders in WordPress plugin queries
Is there any tool to migrate data from MySQL (or mongodb) to Aerospike?
python 5x slower than perl mySql query
Running rake db:migrate in Rails fails (table already exists) using mysql
Finding the sum of time for overlapping values
Convert this query into CDbCriteria format in Yii
MySql query takes too long when sleep() is used in where clause
Custom json response in sequelize.js
HAProxy for MySQL Master-Slave Replication
ERROR 1878 (HY000): Temporary file write failure in mysql
Better way of storing translations in MySQL
MySQL Table Adding Double Value
Unbuffered result set in MySQL golang driver
MySQL if row exists update else insert
Installing MySQL 5.6 in Ubuntu 14.04 triggers removal of needed packages
How to join models in Laravel 5?
How to set group_concat_max_len with MySQL and Hibernate
Mysql Stored Procedure: how to handle empty result set
How to change a string to a date during import using Sequel Pro?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!