Enable `RenameTable`, `RenameColumn` and `DropColumn` in the sqlite builder

go-ozzo / ozzo-dbx

A Go (golang) package that enhances the standard database/sql package by providing powerful data retrieval methods as well as DB-agnostic query building capabilities.

MIT License

636 stars 91 forks source link

Enable `RenameTable`, `RenameColumn` and `DropColumn` in the sqlite builder #98

Closed ganigeorgiev closed 2 years ago

ganigeorgiev commented 2 years ago

SQLite 3 has ALTER TABLE support for most of the schema modify operations - https://www.sqlite.org/lang_altertable.html

This PR enables in the builder_sqlite.go:

RenameTable
RenameColumn (the same syntax as the default builder)
DropColumn (the same syntax as the default builder)

ganigeorgiev commented 2 years ago

Because I created this PR from my master it got "polluted" with other changes. I've create a new PR #100 that contains only the sqlite builder updates.