Does Prefect with MySQL support this type of stored procedure? I got an error when the code runs fin...

Jason Motley

02/16/2022, 8:11 PM

Does Prefect with MySQL support this type of stored procedure? I got an error when the code runs fine querying our database directly -- ``SET @Date1 := MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL QUARTER(CURDATE()) QUARTER - INTERVAL 1 QUARTER;`

SET procedure2 := bla bla

etc..

Kevin Kho

02/16/2022, 8:12 PM

I guess the question is if

pymysql

does. What is your error?

Jason Motley

02/16/2022, 8:15 PM

Copy code

pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @includeLostPipeline := FALSE' at line 2")

Kevin Kho

02/16/2022, 8:15 PM

You stored proc has no parameters right?

Jason Motley

02/16/2022, 8:17 PM

We later pass through the things defined up front (e.x. "Date1") into where clauses

Jason Motley

02/16/2022, 8:18 PM

e.x. ``, @thing:= IF(@thing2= s.Id, @thing + 1, 1) AS ranking``

Kevin Kho

02/16/2022, 8:20 PM

I think this question is better for pymysql. I would suggest you create an issue there cuz they’d be able to help you way better

Kevin Kho

02/16/2022, 8:21 PM

Under the hood we just do this if you are using our task

Jason Motley

02/16/2022, 8:22 PM

Okay that's great, I'll ping them. Thank you!

36 Views

Open in Slack

Previous Next

Prefect Community

Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.