Go/migrate - Revision history

Tacoball: /* Taskfile.yaml */

2026-07-31T01:21:21Z

Taskfile.yaml

← Older revision		Revision as of 01:21, 31 July 2026
Line 33:		Line 33:
	desc: "Use golang-migrate to upgrade db"		desc: "Use golang-migrate to upgrade db"
	env:		env:
	PGPASSWORD: '{{.~~PASSWORD~~}}'		PGPASSWORD: '{{.MYDB_PASSWORD}}'
	cmds:		cmds:
	- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" up		- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" up
Line 40:		Line 40:
	desc: "Use golang-migrate to downgrade db"		desc: "Use golang-migrate to downgrade db"
	env:		env:
	PGPASSWORD: '{{.~~PASSWORD~~}}'		PGPASSWORD: '{{.MYDB_PASSWORD}}'
	cmds:		cmds:
	- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" down		- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" down

2026-07-31T01:21:05Z

Taskfile.yaml

← Older revision		Revision as of 01:21, 31 July 2026
Line 33:		Line 33:
	desc: "Use golang-migrate to upgrade db"		desc: "Use golang-migrate to upgrade db"
	env:		env:
	PGPASSWORD: '{{.~~EMR_ADMIN_PASSWORD~~}}'		PGPASSWORD: '{{.PASSWORD}}'
	cmds:		cmds:
	- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" up		- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" up
Line 40:		Line 40:
	desc: "Use golang-migrate to downgrade db"		desc: "Use golang-migrate to downgrade db"
	env:		env:
	PGPASSWORD: '{{.~~EMR_ADMIN_PASSWORD~~}}'		PGPASSWORD: '{{.PASSWORD}}'
	cmds:		cmds:
	- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" down		- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" down

2026-07-31T01:20:49Z

Taskfile.yaml

← Older revision		Revision as of 01:20, 31 July 2026
Line 32:		Line 32:
	mig-up:		mig-up:
	desc: "Use golang-migrate to upgrade db"		desc: "Use golang-migrate to upgrade db"
			env:
			PGPASSWORD: '{{.EMR_ADMIN_PASSWORD}}'
	cmds:		cmds:
	- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" up		- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" up
Line 37:		Line 39:
	mig-down:		mig-down:
	desc: "Use golang-migrate to downgrade db"		desc: "Use golang-migrate to downgrade db"
			env:
			PGPASSWORD: '{{.EMR_ADMIN_PASSWORD}}'
	cmds:		cmds:
	- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" down		- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" down

2026-07-31T01:20:22Z

Taskfile.yaml

← Older revision		Revision as of 01:20, 31 July 2026
Line 23:		Line 23:

	<syntaxhighlight lang="yaml">		<syntaxhighlight lang="yaml">
			dotenv: ['.env']

			# ...

			tasks:
			# ...

	mig-up:		mig-up:
	desc: "Use golang-migrate to upgrade db"		desc: "Use golang-migrate to upgrade db"

2026-07-31T01:19:18Z

Best practice

← Older revision		Revision as of 01:19, 31 July 2026
Line 11:		Line 11:
	\| up \|\|		\| up \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	migrate -path assets/migrations -database ~~{{.DSN}}~~ up		migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" up
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-
	\| down \|\|		\| down \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	migrate -path assets/migrations -database ~~{{.DSN}}~~ down		migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" down
	</syntaxhighlight>		</syntaxhighlight>
	\|}		\|}

2026-07-31T01:18:54Z

Best practice

← Older revision		Revision as of 01:18, 31 July 2026
Line 11:		Line 11:
	\| up \|\|		\| up \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	migrate -path assets/migrations -database ~~"postgres://sysop:mypass@localhost:45432/mydb"~~ up		migrate -path assets/migrations -database {{.DSN}} up
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-
	\| down \|\|		\| down \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	migrate -path assets/migrations -database ~~"postgres://sysop:mypass@localhost:45432/mydb"~~ down		migrate -path assets/migrations -database {{.DSN}} down
	</syntaxhighlight>		</syntaxhighlight>
	\|}		\|}

2026-07-31T01:18:04Z

Taskfile.yaml

← Older revision		Revision as of 01:18, 31 July 2026
Line 26:		Line 26:
	desc: "Use golang-migrate to upgrade db"		desc: "Use golang-migrate to upgrade db"
	cmds:		cmds:
	- migrate -path assets/migrations -database "postgres://sysop~~:mypass~~@localhost:45432/mydb" up		- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" up

	mig-down:		mig-down:
	desc: "Use golang-migrate to downgrade db"		desc: "Use golang-migrate to downgrade db"
	cmds:		cmds:
	- migrate -path assets/migrations -database "postgres://sysop~~:mypass~~@localhost:45432/mydb" down		- migrate -path assets/migrations -database "postgres://sysop@localhost:45432/mydb" down

	mig-create:		mig-create:
Line 38:		Line 38:
	cmds:		cmds:
	# by date		# by date
	# - migrate create -ext sql -dir assets/migrations -format "~~20060102~~" -tz "Asia/Taipei" {{.CLI_ARGS}}		# - migrate create -ext sql -dir assets/migrations -format "060102" -tz "Asia/Taipei" {{.CLI_ARGS}}
	# by sequence number		# by sequence number
	- migrate create -ext sql -dir assets/migrations -seq {{.CLI_ARGS}}		- migrate create -ext sql -dir assets/migrations -seq {{.CLI_ARGS}}
	</syntaxhighlight>		</syntaxhighlight>

2026-07-31T01:17:44Z

DSN Problem

← Older revision		Revision as of 01:17, 31 July 2026
Line 42:		Line 42:
	- migrate create -ext sql -dir assets/migrations -seq {{.CLI_ARGS}}		- migrate create -ext sql -dir assets/migrations -seq {{.CLI_ARGS}}
	</syntaxhighlight>		</syntaxhighlight>

	~~== DSN Problem ==~~

2026-07-28T10:30:33Z

Best practice

@@ Line 19: / Line 19: @@
 </syntaxhighlight>
 |}
 == DSN Problem ==

2026-07-28T10:27:39Z

Best practice

← Older revision		Revision as of 10:27, 28 July 2026
Line 18:		Line 18:
	migrate -path assets/migrations -database "postgres://sysop:mypass@localhost:45432/mydb" down		migrate -path assets/migrations -database "postgres://sysop:mypass@localhost:45432/mydb" down
	</syntaxhighlight>		</syntaxhighlight>
	}		\|}

	== DSN Problem ==		== DSN Problem ==