SQLBoiler extensions

Why?

SQLBoiler generated models don't come with supports for bulk operations such as bulk insert, upsert, delete and they don't provide any mechanism to overcome the RDBMS limitations such as max number of parameters in a query or statement.

Additional functionalities:

• modelSlice.InsertAll
• modelSlice.InsertAllByPage: Use this when len(modelSlice) is bigger than RDBMS limitation, commonly 65535 parameters. If you need ACID, call this function within a transaction. Otherwise multiple calls will be made to the DB.
• modelSlice.InsertIgnoreAll
• modelSlice.InsertIgnoreAllByPage: If you need ACID, call this function within a transaction.
• modelSlice.UpsertAll
• modelSlice.UpsertAllOnConflictColumns: MySQL only. Workaround of issues/328.
• modelSlice.UpsertOnConflictColumns: MySQL only. Workaround of issues/328.
• modelSlice.UpsertAllByPage: If you need ACID, call this function within a transaction.
• modelSlice.UpdateAllByPage: If you need ACID, call this function within a transaction.
• modelSlice.DeleteAll
• modelSlice.DeleteAllByPage: If you need ACID, call this function within a transaction.
• modelSlice.GetLoaded<fk-ref-type>: Collect all objects from model.R.<FK-ref-type>
• modelSlice.Load<fk-ref-type>ByPage: Perform eager loading reference type by page to overcome RDBMS limitation

Additional utility functions:

• model.GetID(): Get ID from the object.
• modelSlice.GetIDs(): Get all IDs from the list.
• modelSlice.ToIDMap(): Convert the list to a map with ID as keys and model object as values.
• modelSlice.ToUniqueItems(): Construct a slice of unique model objects from the list.
• modelSlice.FindItemByID(id): Find item by ID from the list.
• modelSlice.FindMissingItemIDs(checkIDs): Find missing item IDs from the list.

Supported RDBMS:

• MySQL (well-tested)
• Postgres (tested)
• CockroachDB (tested)

How-to

See the demo

Contributing

• You are welcome to make pull requests for new functions and bug fixes.

Authors

• Dao Cong Tien (tiendc)
• Takenaka Kazumasa (ktakenaka)