search

supabase / postgres

Unmodified Postgres with some useful plugins
https://supabase.com
PostgreSQL License
1.38k stars 139 forks source link

fix: we need to produce a series of migration files on pkg build #1113

Closed samrose closed 2 months ago

samrose commented 2 months ago

although they are all a copy of the latest

What kind of change does this PR introduce?

we need to produce a series of migration files on pkg build, although they are all a copy of the latest

The goal is to emulate what happened in the release gh action for https://github.com/supabase/wrappers

We need to fetch the release tags from github (in this case in a preBuild phase before we start building) write to file, and use the file to copy the latest wrappers--$current_version.sql to a wrappers--$prev_version-$current_version.sql and writing that into the nix store.

The outcome should be that all of those identical files end up at 

/nix/store/postressqlbundle-hash/share/postgresql/extension/

rwxrwxrwx  4 root root   100 Dec 31  1969 vector.control -> /nix/store/3zk1d03nrg9d01hpb7x5jdcs3w5d15yg-pgvector-0.7.4/share/postgresql/extension/vector.control
lrwxrwxrwx  4 root root    96 Dec 31  1969 vector.sql -> /nix/store/3zk1d03nrg9d01hpb7x5jdcs3w5d15yg-pgvector-0.7.4/share/postgresql/extension/vector.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.1.0--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.0--0.4.1.sql
lrwxrwxrwx  4 root root   122 Dec 31  1969 wrappers--0.1.10--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.10--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.1.1--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.1--0.4.1.sql
lrwxrwxrwx  4 root root   122 Dec 31  1969 wrappers--0.1.11--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.11--0.4.1.sql
lrwxrwxrwx  4 root root   122 Dec 31  1969 wrappers--0.1.12--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.12--0.4.1.sql
lrwxrwxrwx  4 root root   122 Dec 31  1969 wrappers--0.1.14--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.14--0.4.1.sql
lrwxrwxrwx  4 root root   122 Dec 31  1969 wrappers--0.1.15--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.15--0.4.1.sql
lrwxrwxrwx  4 root root   122 Dec 31  1969 wrappers--0.1.16--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.16--0.4.1.sql
lrwxrwxrwx  4 root root   122 Dec 31  1969 wrappers--0.1.17--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.17--0.4.1.sql
lrwxrwxrwx  4 root root   122 Dec 31  1969 wrappers--0.1.18--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.18--0.4.1.sql
lrwxrwxrwx  4 root root   122 Dec 31  1969 wrappers--0.1.19--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.19--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.1.4--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.4--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.1.5--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.5--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.1.6--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.6--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.1.7--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.7--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.1.8--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.8--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.1.9--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.1.9--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.2.0--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.2.0--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.3.0--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.3.0--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.3.1--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.3.1--0.4.1.sql
lrwxrwxrwx  4 root root   121 Dec 31  1969 wrappers--0.4.0--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.4.0--0.4.1.sql
lrwxrwxrwx  4 root root   114 Dec 31  1969 wrappers--0.4.1.sql -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers--0.4.1.sql
lrwxrwxrwx  4 root root   111 Dec 31  1969 wrappers.control -> /nix/store/px3wvdr1wjy642spm653x713zfydmqyn-supabase-wrappers-0.4.1/share/postgresql/extension/wrappers.control

for example. This PR has tested and verified this is working

samrose commented 2 months ago

going to do another branch against release/15.6-lw12