search

qrioniclabs / homeassistant-mysql_command

A Home Assistant custom component that creates a Notify service to send commands (e.g. INSERT) to a MySQL server.
8 stars 3 forks source link

Feature Request - Allow Stored Procedures To Work #11

Open ifflanb opened 2 months ago

ifflanb commented 2 months ago

Hi, Thanks for the create components. Works very well and opens up a whole new area of possibilities. One thing that would be good is to allow for calling stored procedures. I have changed my notify.py file to have this line

cursor.callproc(message)

on line 83.

Then I can just put the name of the stored procedure in the message attribute in the service call. Would be good if there was an option to allow this. Thanks