Commit0705217

committed

Add IF EXISTS clause to DROP VIEW statements in order to prevent errors when non-existing views will be dropped in an Alembic version

1 parent99e1e31 commit0705217Copy full SHA for 0705217

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -195,7 +195,7 @@ cython_debug/`
`195`	`195`	`# be found at https://github.com/github/gitignore/blob/main/Global/JetBrains.gitignore`
`196`	`196`	`# and can be added to the global gitignore or merged into this file. For a more nuclear`
`197`	`197`	`# option (not recommended) you can uncomment the following to ignore the entire idea folder.`
`198`		`-#.idea/`
	`198`	`+.idea/`
`199`	`199`
`200`	`200`	`# End of https://www.toptal.com/developers/gitignore/api/python,macos`
`201`	`201`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -154,6 +154,9 @@ def visit_drop_table(self, drop, **kw):`
`154`	`154`
`155`	`155`	`returntext+self.preparer.format_table(drop.element)`
`156`	`156`
	`157`	`+defvisit_drop_view(self,drop,**kw):`
	`158`	`+return"\nDROP VIEW IF EXISTS "+self.preparer.format_table(drop.element)`
	`159`	`+`
`157`	`160`
`158`	`161`	`@compiles(ColumnComment,"databricks")`
`159`	`162`	`defvisit_column_comment(`

Comments

(0)