I ve read the intro docs and went through the tutorial and w

Question

I ve read the intro docs and went through the tutorial and was trying out some Prefect Tasks First off was MySqlFetch because well MySql I feel like I ve got things setup right but I m running into an unexpected error in the task runner trying to do a `MySqlFetch run ` ```ERROR prefect TaskRunner Unexpected error AttributeError enter ``` So I didn t want to get into debugging this because my code could be totally wrong I was hoping to find some examples of using this and other Prefect Tasks Are there examples for how to use this and other tasks

Chris White · Answer

Hi < James Bennett Saxon> I can take a look at the code for that particular task but a large portion of our tasks are community contributed including `MySqlFetch` so the documentation varies

Jeremiah · Answer

Hey there < James Bennett Saxon> looking at the `MySqlFetch` task s code it looks like it attempts to enter two different context managers to open a transaction is it possible that it s failing to connect so `conn` is an object like None That code is

Jeremiah · Answer

I m not sure what pymysql returns as `conn` if the connection fails

James Bennett Saxon · Answer

Thanks guys for the clues It clarifies a lot

James Bennett Saxon · Answer

Yes that is where it s raising the exception So it makes sense that something happened on the connection

James Bennett Saxon · Answer

Okay so sorry for the python question here but if I wanted to go ahead and fork clone develop the package so I can more cleanly debug and maybe contribute back what s the trick

Chris White · Answer

check out these docs on contributing Feel free to ask any questions if you get stuck we also have a channel < C0106HZ1CMS|prefect contributors> dedicated to helping both new and seasoned contributors

James Bennett Saxon · Answer

Heh Thanks Chris I had realized I cloned the whole repo setting up the tutorial So I m off to the races debugging That the one exception is handling both pymysql errors AND any other Exception causes the amgibuity It appears the conn is created just fine but it s got no ` enter ` Why not Maybe I ve got version issues

James Bennett Saxon · Answer

Not looking awesome <https stackoverflow com questions 31214658 can i use pymysql connect with with statement>

James Bennett Saxon · Answer

Lol Commented out the outer context manager and at least with a valid connection it s working

Chris White · Answer

Nice < James Bennett Saxon> Sounds like we need to remove the outer context manager if you d like to make a PR for this let me know

Jeremiah · Answer

yes

James Bennett Saxon · Answer

I can give it a shot My hacking is pretty good my polishing Well that s the hard part slightly smiling face

Chris White · Answer

Haha no worries we can work with you and provide suggestions +1

James Bennett Saxon · Answer

< Chris White> Hey so I m stepping into this very very lightly as I d love to help but I ve got a lot going on I went ahead and forked and branched and tweaked the code a bit I tried to push for more coverage and built dummies rather than mocks for pymysql and I ve run black and mypy on it I also realized that in core you ve got the postgres version which looks identical If you want I can make a PR to what branch or you can review and or take it from here or whatnot If there s no rush then let me know and I ll see when I ve got another shot at responding to comments slightly smiling face Thanks for the nudge