func SoftDeleteByIdAndVersion(DB db.IDb, table *db.Table, id int64, version int64) error { deletion := table.GetDeletionColumn() if deletion == nil { return dbx.NewPersistenceFail("DAOUtils.SoftDeleteByIdAndVersion", "Table "+table.GetName()+" does not have a deletion type column to do a soft delete.") } keyColumn := table.GetKeyColumns().Enumerator().Next().(*db.Column) versionColumn := table.GetVersionColumn() result, err := DB.Update(table). Set(deletion, tk.Milliseconds()). Set(versionColumn, version+1). Where( keyColumn.Matches(id), versionColumn.Matches(version), ). Execute() if err != nil { return err } if result == 0 { return dbx.NewOptimisticLockFail("DAOUtils.removeByIdVersion: Unable to soft delete by id and version for the table " + table.GetName()) } return nil }
func FindAll(DB db.IDb, table *db.Table, instance interface{}) (coll.Collection, error) { logger.CallerAt(1).Debugf("DAOUtils.FetchAll") deletion := table.GetDeletionColumn() q := DB.Query(table).All() if deletion != nil { q.Where(deletion.Matches(NOT_DELETED)) } return q.ListOf(instance) }