mirror of
https://github.com/hanzoai/forge.git
synced 2026-10-30 15:00:39 +00:00
zeekayandHanzo Dev
aa87442fdd
Source files keep their SPDX-License-Identifier and Hanzo copyright line; the Gitea, Gogs and LFS Test Server copyrights they used to repeat now live once in NOTICE, alongside LICENSE. The header lint accepts any copyright line above the SPDX line, so it no longer demands an upstream one. Co-authored-by: Hanzo Dev <[email protected]>
32 lines
1001 B
Go
32 lines
1001 B
Go
// Copyright 2026 Hanzo AI, Inc. All rights reserved.
|
|
// SPDX-License-Identifier: MIT
|
|
|
|
package db
|
|
|
|
import (
|
|
"context"
|
|
|
|
"github.com/hanzoai/builder"
|
|
)
|
|
|
|
// CountOrphanedObjects count subjects with have no existing refobject anymore
|
|
func CountOrphanedObjects(ctx context.Context, subject, refObject, joinCond string) (int64, error) {
|
|
return GetEngine(ctx).
|
|
Table("`"+subject+"`").
|
|
Join("LEFT", "`"+refObject+"`", joinCond).
|
|
Where(builder.IsNull{"`" + refObject + "`.id"}).
|
|
Select("COUNT(`" + subject + "`.`id`)").
|
|
Count()
|
|
}
|
|
|
|
// DeleteOrphanedObjects delete subjects with have no existing refobject anymore
|
|
func DeleteOrphanedObjects(ctx context.Context, subject, refObject, joinCond string) error {
|
|
subQuery := builder.Select("`"+subject+"`.id").
|
|
From("`"+subject+"`").
|
|
Join("LEFT", "`"+refObject+"`", joinCond).
|
|
Where(builder.IsNull{"`" + refObject + "`.id"})
|
|
b := builder.Delete(builder.In("id", subQuery)).From("`" + subject + "`")
|
|
_, err := GetEngine(ctx).Exec(b)
|
|
return err
|
|
}
|