SQL exercises in {learnr} return only errors... still

[russm]

Following from this post: [SQL exercises in {learnr} return only errors]

SQL exercises in {learnr} return only errors

hey y'all, after seeing Mine's presentation at rstudio::conf about the {learner} package I decided to try and whip up some test content for teaching SQL. I can't figure out how to get an exercise block to work with SQL. Here's what I tried: In the preamble I set up a connection called db like so: db <- DBI::dbConnect( RPostgreSQL::PostgreSQL(), dbname = "mydb", port = 5439, host = "mydb.yada.yada", user = "userid", password = "topsecretpassword" ) then I test to make sure it is working by doing this: ```{sql sql_chunk1, connection=db} select * from mytable; ```' Ignore the trailing ', I can't recall how to make the fences show right, I'll edit …

I'm creating a {learnr} tutorial and looking to include SQL exercises. However, I'm getting a " The 'connection' option (DBI connection) is required for sql chunks." if I pass the connection variable in the RMarkdown with quotes. If I try to pass the connection variable without quotes, the app crashes with an unexpected symbol error.

I've attempted the test example given by @grrrck in the linked post and I'm using the latest GitHub version. Is there something else I'm missing or could give a try to get it working?

Thanks!

[grrrck]

Thanks @russm, this is definitely a bug in learnr. I opened an issue to track this problem and hopefully will be able to resolve it soon.

Chunk options aren't preserved for SQL exercise chunks

[grrrck]

Thanks again for reporting this @russm! I've fixed the underlying bug and along the way improved learnr's support for SQL-based interactive exercises. For anyone who is interested in using SQL in exercises, I also added a new example tutorial that explains how to create and use SQL exercises: learnr Tutorial Examples • learnr