v0.0.5

Changes

• New feature! DropColumn, DropConstraint, RenameColumn, RenameConstraint #14
• New feature! CreateIndex and CreateIndexIfNotExists #13
• fix: make PlaceholderFormat not required in #11
• docs: examples in #15

Full Changelog: v0.0.4...v0.0.5

v0.0.4

Changes

• New feature! .DropTable("users").Cascade() to create DROP TABLE users CASCADE and .DropTable("users").Restrict() to create DROP TABLE users RESTRICT queries.
• Micro optimization by using strings.Builder instead of bytes.Buffer

Git Log

4ec5b90 (HEAD -> master, origin/master, origin/HEAD) Merge pull request #9 from aldy505/perf/builder
3e4261d (origin/perf/builder) perf: migrate bytes.Buffer to strings.Builder for micro optimization
f1008bd Merge pull request #7 from aldy505/feat/drop_cascade
8a461fe (origin/feat/drop_cascade) feat: drop cascade & restrict
efa752f test: refactored

v0.0.3

New feature!

Upsert is now a thing now. Available for MySQL, PostgreSQL, SQLite and MSSQL.

sql, args, err := bob.
  Upsert("users", bob.PostgreSQL).
  Columns("name", "email").
  Values("John Doe", "john@doe.com").
  Key("email").
  Replace("name", "John Does").
  PlaceholderFormat(bob.Dollar).
  ToSql()

// sql will results: INSERT INTO "users" ("name", "email") VALUES ($1, $2) ON CONFLICT ("email") DO UPDATE SET "name" = $3;

Git Log

cb9e7b0 (HEAD -> master, origin/master) Merge pull request #3 from aldy505/feat/upsert
b5df4ae (origin/feat/upsert) test: refactor & running fmt
4a02222 docs: documentation for upsert
0f06056 refactor: unexported function & documentation
49cf645 refactor: clean up exported funcs
ecefcdb test: dialect not supported
1b25a09 test: error tests
c59e6ac test: fixed tests
4a75bed feat: upsert (test not working yet)
50c8d98 docs: new features
c9b01ee feat: truncate rename and drop
0d704c8 docs: grammar

v0.0.2

0a8dbef (HEAD -> master, origin/master) Merge pull request #2 from aldy505/feat/definition
4940a22 (origin/feat/definition) docs: column types
b6fad37 fix: atp placeholder conversion
6186e8a docs: thorough documentation
43eb8f4 test: simplify test
4603861 feat: float and real type
9c7a628 docs: correct example with current feature
a72d617 chore: error definition var
a4dd892 test: more tests
ca2d51b feat: initial column definition types

v0.0.1

86eb9e0 (HEAD -> master, origin/master) docs: examples for create table if not exists
ef78c0b fix(breaking): ToSQL > ToSql for compat with Squirrel
e675c80 feat: added CreateTableIfNotExists
724b943 refactor: moved args to util
75547d6 docs: tabs to space
80893d1 docs: decent example
8d6de64 fix: backtick only works with mysql
03e6bdb fix: replacePlaceholder now do things properly
5c112c7 feat: added has query
807f5af docs: added badges :)
18408e8 test: typo on table name
2d720a1 test(create): added more test on errors
6c36822 feat(error): error on empty table name; error on missing primary and unique key in columns;
d9ece27 ci: typo on workflow -> workflows
82c04c6 feat: initial