plausible/ecto_ch

support update statements

Closed this issue · 4 comments

jaronoff97 commented

it would be great if this package supported Repo.update by using the correct clickhouse ALTER TABLE statement rather than erroring. Everything else has worked seamlessly, so this would be great :)

ruslandoga commented

👋

I was thinking about adding custom Repo.alter_update and Repo.alter_update_all functions but then forgot. I'll try to add something today: #172

I'd like to reserve Repo.update and Repo.update_all for when or if the real UPDATE statements land in ClickHouse.

  • ❤️2
jaronoff97 commented

Yeah! that'd be great :D thank you! For now, I changed to use a versioned insert approach to avoid doing any table alterations, but this would be great.

ruslandoga commented

I added Repo.alter_update_all in #172 and released it as v0.3.7.

  • ❤️2
jaronoff97 commented

Thank you so much!! Unblocks a bunch of stuff for me. I appreciate the fast turn around and your work here!

  • ❤️2