On Wed, Mar 26, 2025, 03:58 Eugen Konkov ***@***.***> wrote: Upgrade is correct: diff --git a/share/migrations/PostgreSQL/upgrade/4-5/001-auto.sql b/share/migrations/Post> new file mode 100644 index 000000000..69d445035--- /dev/null+++ b/share/migrations/PostgreSQL/upgrade/4-5/001-auto.sql@@ -0,0 +1,15 @@+-- Convert schema '/home/kes/work/projects/bot/app/share/migrations/_source/deploy/4/001>++;+BEGIN;++;+ALTER TABLE "tracker" RENAME COLUMN "me_id" TO "tracker_user_xid";++;+ALTER TABLE "user" RENAME COLUMN "telegram_xid" TO "telegram_user_xid";++;++COMMIT;+ For downgrade I also expect RENAME COLUMN but DROP is used, which cause data loss. diff --git a/share/migrations/PostgreSQL/downgrade/5-4/001-auto.sql b/share/migrations/Po> new file mode 100644 index 000000000..7ee5f5780--- /dev/null+++ b/share/migrations/PostgreSQL/downgrade/5-4/001-auto.sql@@ -0,0 +1,21 @@+-- Convert schema '/home/kes/work/projects/bot/app/share/migrations/_source/deploy/5/001>++;+BEGIN;++;+ALTER TABLE "tracker" DROP COLUMN "tracker_user_xid";++;+ALTER TABLE "tracker" ADD COLUMN "me_id" integer NOT NULL;++;+ALTER TABLE "user" DROP COLUMN "telegram_user_xid";++;+ALTER TABLE "user" ADD COLUMN "telegram_xid" integer NOT NULL;++;++COMMIT;+ How to reproduce: diff --git a/lib/Db/Result/Tracker.pm b/lib/Db/Result/Tracker.pm index 7f082852a..3f933fbab 100644--- a/lib/Db/Result/Tracker.pm+++ b/lib/Db/Result/Tracker.pm@@ -34,8 +34,11 @@ $X->add_columns( data_type => 'text', }, # User id at tracker- me_id => {+ tracker_user_xid => { data_type => 'int',+ extra => {+ renamed_from => 'me_id',+ }, }, options => { data_type => 'json',diff --git a/lib/Db/Result/User.pm b/lib/Db/Result/User.pm index a5b92e7bd..d5db08b08 100644--- a/lib/Db/Result/User.pm+++ b/lib/Db/Result/User.pm@@ -22,8 +22,11 @@ $X->add_columns( passw => { data_type => 'text', },- telegram_xid => {+ telegram_user_xid => { data_type => 'int',+ extra => {+ renamed_from => 'telegram_xid',+ }, }, ); — Reply to this email directly, view it on GitHub <#183>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFURPKUZEJKGQTTV5HIYCD32WICWDAVCNFSM6AAAAABZZCR4XCVHI2DSMVQWIX3LMV43ASLTON2WKOZSHE2DQMJYHAYDSNA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***> [image: KES777]*KES777* created an issue (dbsrgits/sql-translator#183) <#183> Upgrade is correct: diff --git a/share/migrations/PostgreSQL/upgrade/4-5/001-auto.sql b/share/migrations/Post> new file mode 100644 index 000000000..69d445035--- /dev/null+++ b/share/migrations/PostgreSQL/upgrade/4-5/001-auto.sql@@ -0,0 +1,15 @@+-- Convert schema '/home/kes/work/projects/bot/app/share/migrations/_source/deploy/4/001>++;+BEGIN;++;+ALTER TABLE "tracker" RENAME COLUMN "me_id" TO "tracker_user_xid";++;+ALTER TABLE "user" RENAME COLUMN "telegram_xid" TO "telegram_user_xid";++;++COMMIT;+ For downgrade I also expect RENAME COLUMN but DROP is used, which cause data loss. diff --git a/share/migrations/PostgreSQL/downgrade/5-4/001-auto.sql b/share/migrations/Po> new file mode 100644 index 000000000..7ee5f5780--- /dev/null+++ b/share/migrations/PostgreSQL/downgrade/5-4/001-auto.sql@@ -0,0 +1,21 @@+-- Convert schema '/home/kes/work/projects/bot/app/share/migrations/_source/deploy/5/001>++;+BEGIN;++;+ALTER TABLE "tracker" DROP COLUMN "tracker_user_xid";++;+ALTER TABLE "tracker" ADD COLUMN "me_id" integer NOT NULL;++;+ALTER TABLE "user" DROP COLUMN "telegram_user_xid";++;+ALTER TABLE "user" ADD COLUMN "telegram_xid" integer NOT NULL;++;++COMMIT;+ How to reproduce: diff --git a/lib/Db/Result/Tracker.pm b/lib/Db/Result/Tracker.pm index 7f082852a..3f933fbab 100644--- a/lib/Db/Result/Tracker.pm+++ b/lib/Db/Result/Tracker.pm@@ -34,8 +34,11 @@ $X->add_columns( data_type => 'text', }, # User id at tracker- me_id => {+ tracker_user_xid => { data_type => 'int',+ extra => {+ renamed_from => 'me_id',+ }, }, options => { data_type => 'json',diff --git a/lib/Db/Result/User.pm b/lib/Db/Result/User.pm index a5b92e7bd..d5db08b08 100644--- a/lib/Db/Result/User.pm+++ b/lib/Db/Result/User.pm@@ -22,8 +22,11 @@ $X->add_columns( passw => { data_type => 'text', },- telegram_xid => {+ telegram_user_xid => { data_type => 'int',+ extra => {+ renamed_from => 'telegram_xid',+ }, }, ); — Reply to this email directly, view it on GitHub <#183>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFURPKUZEJKGQTTV5HIYCD32WICWDAVCNFSM6AAAAABZZCR4XCVHI2DSMVQWIX3LMV43ASLTON2WKOZSHE2DQMJYHAYDSNA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

On Wed, Mar 26, 2025, 18:51 Eugen Konkov ***@***.***> wrote: I do not have that repo at that moment, but I would be happy to work with you and implement reproduction step or even test case for that. Give me please a couple of days. Thanks. — Reply to this email directly, view it on GitHub <#183 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFURPKUTYNQLVMJDZMQXRHD2WLLH7AVCNFSM6AAAAABZZCR4XCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDONJVGA4DKOBTGE> . You are receiving this because you commented.Message ID: ***@***.***> [image: KES777]*KES777* left a comment (dbsrgits/sql-translator#183) <#183 (comment)> I do not have that repo at that moment, but I would be happy to work with you and implement reproduction step or even test case for that. Give me please a couple of days. Thanks. — Reply to this email directly, view it on GitHub <#183 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFURPKUTYNQLVMJDZMQXRHD2WLLH7AVCNFSM6AAAAABZZCR4XCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDONJVGA4DKOBTGE> . You are receiving this because you commented.Message ID: ***@***.***>