Migrating Between Versions

v7 to v8

A major change the the API was made in v8 to seperate concerns between the different SQL statement types.

Why the change?

  1. There were feature requests that could not be cleanly implemented with everything in a single dataset.
  2. Too much functionality was encapsulated in a single datastructure.
    • It was unclear what methods could be used for each SQL statement type.
    • Changing a feature for one statement type had the possiblity of breaking another statement type.
    • Test coverage was decent but was almost solely concerned about SELECT statements, breaking them up allowed for focused testing on each statement type.
    • Most the SQL generation methods (ToInsertSQL, ToUpdateSQL etc.) took arguments which lead to an ugly API that was not uniform for each statement type, and proved to be inflexible.

What Changed

There are now five dataset types, SelectDataset, InsertDataset, UpdateDataset, DeleteDataset and TruncateDataset

Each dataset type has its own entry point.

ToInsertSQL, ToUpdateSQL, ToDeleteSQL, and ToTruncateSQL (and variations of them) methods have been removed from the SelectDataset. Instead use the ToSQL methods on each dataset type.

Each dataset type will have an Executor and ToSQL method so a common interface can be created for each type.

How to insert.

In older versions of goqu there was ToInsertSQL method on the Dataset in the latest version there is a new entry point to create INSERTS.

// old way
goqu.From("test").ToInsertSQL(...rows)

// new way
goqu.Insert("test").Rows(...rows).ToSQL()
goqu.From("test").Insert().Rows(...rows).ToSQL()

In older versions of goqu there was Insert method on the Dataset to execute an insert in the latest version there is a new Exectutor method.

// old way
db.From("test").Insert(...rows).Exec()

// new way
db.Insert("test").Rows(...rows).Executor().Exec()
// or
db.From("test").Insert().Rows(...rows).Executor().Exec()

The new InsertDataset also has an OnConflict method that replaces the ToInsertConflictSQL and ToInsertIgnoreSQL

// old way
goqu.From("test").ToInsertIgnoreSQL(...rows)

// new way
goqu.Insert("test").Rows(...rows).OnConflict(goqu.DoNothing()).ToSQL()
// OR
goqu.From("test").Insert().Rows(...rows).OnConflict(goqu.DoNothing()).ToSQL()

// old way
goqu.From("items").ToInsertConflictSQL(
    goqu.DoUpdate("key", goqu.Record{"updated": goqu.L("NOW()")}),
    goqu.Record{"name": "Test1", "address": "111 Test Addr"},
    goqu.Record{"name": "Test2", "address": "112 Test Addr"},
)
fmt.Println(sql, args)

// new way
goqu.Insert("test").
  Rows(
    goqu.Record{"name": "Test1", "address": "111 Test Addr"},
    goqu.Record{"name": "Test2", "address": "112 Test Addr"},
  ).
  OnConflict(goqu.DoUpdate("key", goqu.Record{"updated": goqu.L("NOW()")})).
  ToSQL()
// OR
goqu.From("test").
  Insert().
  Rows(
    goqu.Record{"name": "Test1", "address": "111 Test Addr"},
    goqu.Record{"name": "Test2", "address": "112 Test Addr"},
  ).
  OnConflict(goqu.DoUpdate("key", goqu.Record{"updated": goqu.L("NOW()")})).
  ToSQL()

How to update.

In older versions of goqu there was ToUpdateSQL method on the Dataset in the latest version there is a new entry point to create UPDATEs.

// old way
goqu.From("items").ToUpdateSQL(
    goqu.Record{"name": "Test", "address": "111 Test Addr"},
)

// new way
goqu.Update("items").
  Set(goqu.Record{"name": "Test", "address": "111 Test Addr"}).
  ToSQL()
// OR
goqu.From("items").
  Update()
  Set(goqu.Record{"name": "Test", "address": "111 Test Addr"}).
  ToSQL()

In older versions of goqu there was Insert method on the Dataset to execute an insert in the latest version there is a new Exectutor method.

// old way
db.From("items").Update(
    goqu.Record{"name": "Test", "address": "111 Test Addr"},
).Exec()

// new way
db.Update("items").
  Set(goqu.Record{"name": "Test", "address": "111 Test Addr"}).
  Executor().Exec()
// OR
db.From("items").
  Update().
  Set(goqu.Record{"name": "Test", "address": "111 Test Addr"}).
  Executor().Exec()

How to delete.

In older versions of goqu there was ToDeleteSQL method on the Dataset in the latest version there is a new entry point to create DELETEs.

// old way
goqu.From("items").
  Where(goqu.Ex{"id": goqu.Op{"gt": 10}}).
  ToDeleteSQL()

// new way
goqu.Delete("items").
  Where(goqu.Ex{"id": goqu.Op{"gt": 10}}).
  ToSQL()
// OR
goqu.From("items").
  Delete()
  Where(goqu.Ex{"id": goqu.Op{"gt": 10}}).
  ToSQL()

In older versions of goqu there was Delete method on the Dataset to execute an insert in the latest version there is a new Exectutor method.

// old way
db.From("items").
  Where(goqu.Ex{"id": goqu.Op{"gt": 10}}).
  Delete().Exec()

// new way
db.Delete("items").
  Where(goqu.Ex{"id": goqu.Op{"gt": 10}}).
  Executor().Exec()
// OR
db.From("items").
  Delete()
  Where(goqu.Ex{"id": goqu.Op{"gt": 10}}).
  Executor().Exec()

How to truncate.

In older versions of goqu there was ToTruncateSQL method on the Dataset in the latest version there is a new entry point to create TRUNCATEs.

// old way
goqu.From("items").ToTruncateSQL()

// new way
goqu.Truncate("items").ToSQL()

<v7 to v7