Results for non-public schemas about rails-pg-extras HOT 4 CLOSED

@andyatkinson thanks for pointing out. I've added a way to specify default schema via ENV here: pawurb/ruby-pg-extras@43f2d2b it's now out as 5.3.1. Please confirm if it resolves the issue.

from rails-pg-extras.

Hi @pawurb Nice, that fixes it. Here's my sample app for the book with a PR related to this gem update, and then invocations of the commands with the updated gem version:
andyatkinson/rideshare#162

I had hoped I could add the ENV var to the .env file and it would "just work", but that wasn't the case. I imagine that would need some more work? Setting the env var in the terminal though before I invoke the commands works fine.

This fixes it for diagnose too, we can see the schema is included in the generated SQL queries. Here's an example:

SELECT
....
FROM pg_stat_user_indexes ui
....
AND schemaname = 'rideshare'
...

Thanks!

from rails-pg-extras.

Ooh, I found the ruby-pg-extras gem, and figured out I can pass args: {schema: "other_schema"} to the various helpers.

RailsPgExtras.cache_hit(args: {schema: "other_schema"})

I'll create a PR for this for the docs.

from rails-pg-extras.

@pawurb @drnic Hello! For Rideshare, it uses a custom rideshare schema. I see I can run this code that @drnic mentioned (and hat tip @DanielaBaron for noticing this), but is there a way to make this the default via an initializer option? I am digging into the initializer now but didn't immediately see how to set a schema. I did configure an ENV var for rails-pg-extras. Unfortunately even though the default schema for the PostgreSQL user I'm connecting as (which is rideshare) wasn't used, and public was still used. I've removed the public schema from that application database following "Safe schema patterns" best practices.

Expected: The default schema for the PostgreSQL user is used. I've removed
Actual: Queries use the public schema when running bin/rails pg_extras:cache_hit regardless of user's default schema

bin/rails runner 'RailsPgExtras.table_cache_hit(args: { schema: "rideshare" })'

from rails-pg-extras.