create all upsert functions in a dedicated schema so they can be dropped all at once

[seamusabshere]

for example, schema name "upsert_VERSION"

since we control the invocation of the function, we could always invoke it with the upsert_VERSION schema prefix

[searls]

👍 my app has enough postgres magic in it that I need to use structure.sql instead of schema.rb for tracking changes, and the rather dense generated upsert functions add quite a lot of churn. Would this help that?

[pnomolos]

I created a “clean_upsert” task that runs before the structure is dumped, which would probably help you for the time being :). If I remember on Monday to post it I will.

…

On Sun, Jan 6, 2019 at 07:22 Justin Searls ***@***.***> wrote: 👍 my app has enough postgres magic in it that I need to use structure.sql instead of schema.rb for tracking changes, and the rather dense generated upsert functions add quite a lot of churn. Would this help that? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#106 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AACNf7WLVjs2BG8WZhF31FLqmVpBh_9Zks5vAhTSgaJpZM4TLEGm> .

[mkaplan9]

@pnomolos if you're still willing, would love to see that code :)

[pnomolos]

@mkaplan9 @searls I use Sequel, so you'll need to tweak to fit whatever DB adapter you use, but basically you just need to change the Upsert identifier:

Upsert::MergeFunction::NAME_PREFIX = "upsert"
DB.synchronize do |conn|
  Upsert.clear_database_functions(conn)
end

[mkaplan9]

Thanks, I found that on this issue yesterday and got it to work. I still don't really understand what Upsert::MergeFunction::NAME_PREFIX = "upsert" does, is there a place I can learn more about it?

[pnomolos]

@mkaplan9 Normally the upsert functions are versioned (for example: "upsert_1_2"). This just removes that versioning and since it's checking against a regular expression it just removes all the functions called "upsert.*"

[mkaplan9]

Ah ok that makes sense. Thanks!