删除文档 #

DELETE FROM <class>|RID|<query> 
[WHERE <condition>]
[LIMIT <maxRecords>]
[RETURN <return-spec>]

DELETE特点：
├── 支持条件删除
├── 支持批量删除
├── 支持级联删除
├── 返回删除结果
└── 支持事务

DELETE FROM Person WHERE name = 'Tom'

DELETE FROM #12:0
DELETE FROM Person WHERE @rid = #12:0

DELETE FROM Person WHERE name = 'Tom' RETURN @rid, name
DELETE FROM Person WHERE name = 'Tom' RETURN BEFORE @this

DELETE FROM Person

DELETE FROM Person WHERE status = 'inactive' LIMIT 100

DELETE FROM Person WHERE age > 60
DELETE FROM Person WHERE age < 18 OR age > 65
DELETE FROM Log WHERE createdAt < DATE('2023-01-01')

DELETE FROM Person WHERE @rid IN [#12:0, #12:1, #12:2]
DELETE FROM Person WHERE name IN ['Tom', 'Jerry', 'Mike']
DELETE FROM Person WHERE status IN ['deleted', 'inactive']

DELETE FROM Person WHERE email LIKE '%@temp.com'
DELETE FROM Log WHERE message LIKE '%error%'

DELETE FROM Person WHERE email IS NULL
DELETE FROM Person WHERE phone IS NULL AND address IS NULL

DELETE FROM Person WHERE @rid IN (
    SELECT @rid FROM Person WHERE lastLoginAt < DATE('2022-01-01')
)

DELETE FROM Person WHERE employer = (SELECT FROM Company WHERE name = 'Closed Corp')
DELETE FROM Order WHERE customer = (SELECT FROM Customer WHERE status = 'deleted')

DELETE FROM Log WHERE level = 'DEBUG'

LET batch = SELECT FROM Log WHERE createdAt < DATE('2023-01-01') LIMIT 1000;
DELETE FROM $batch

LET total = SELECT COUNT(*) FROM Log WHERE createdAt < DATE('2023-01-01');
LET deleted = 0;
WHILE ($deleted < $total) {
    DELETE FROM Log WHERE createdAt < DATE('2023-01-01') LIMIT 1000;
    LET deleted = $deleted + 1000;
}

LET rids = SELECT @rid FROM Person WHERE status = 'deleted';
FOREACH ($rid IN $rids) {
    DELETE FROM $rid.@rid
}

DELETE VERTEX Person WHERE name = 'Tom'

DELETE FROM Person WHERE name = 'Tom'

DELETE VERTEX Person WHERE @rid = #12:0

DELETE EDGE KNOWS WHERE @rid = #25:0
DELETE EDGE KNOWS WHERE out.name = 'Tom' AND in.name = 'Jerry'

DELETE EDGE KNOWS
DELETE EDGE WHERE @class = 'KNOWS'

DELETE EDGE FROM (SELECT FROM Person WHERE name = 'Tom')
DELETE EDGE TO (SELECT FROM Person WHERE name = 'Tom')

自动级联场景：
├── 删除顶点时自动删除关联边
├── 删除类时可选级联删除记录
└── 需要配置或使用特定语法

BEGIN
DELETE EDGE WORKS_AT WHERE out = #12:0
DELETE FROM Person WHERE @rid = #12:0
COMMIT

LET person = SELECT FROM Person WHERE name = 'Tom';
BEGIN
DELETE FROM Order WHERE customer = $person[0].@rid
DELETE EDGE FROM $person[0].@rid
DELETE FROM $person[0].@rid
COMMIT

UPDATE Person SET deletedAt = sysdate(), isDeleted = true WHERE name = 'Tom'

SELECT FROM Person WHERE isDeleted = false OR isDeleted IS NULL

UPDATE Person SET deletedAt = NULL, isDeleted = false WHERE @rid = #12:0

DELETE FROM Person WHERE isDeleted = true AND deletedAt < sysdate() - 30

BEGIN
DELETE FROM OrderItem WHERE orderId = 'order_001'
DELETE FROM Order WHERE id = 'order_001'
COMMIT

BEGIN
LET order = SELECT FROM Order WHERE id = 'order_001' AND status = 'cancelled';
IF ($order.size() > 0) {
    DELETE FROM OrderItem WHERE orderId = 'order_001'
    DELETE FROM Order WHERE id = 'order_001'
    COMMIT
} ELSE {
    ROLLBACK
    SELECT 'Cannot delete order' AS error
}

BEGIN
DELETE FROM Person WHERE name = 'Tom'
LET count = SELECT COUNT(*) FROM Person WHERE name = 'Tom';
IF ($count = 0) {
    COMMIT
} ELSE {
    ROLLBACK
}

LET count = SELECT COUNT(*) FROM Person WHERE name = 'Tom';
IF ($count > 0) {
    DELETE FROM Person WHERE name = 'Tom' RETURN @rid
} ELSE {
    SELECT 'No records found' AS message
}

DELETE FROM Person WHERE name = 'Tom' RETURN @rid;
SELECT COUNT(*) AS remaining FROM Person WHERE name = 'Tom'

LET before = SELECT COUNT(*) AS total FROM Person WHERE status = 'inactive';
DELETE FROM Person WHERE status = 'inactive' RETURN COUNT(@rid) AS deleted;
SELECT $before.total AS beforeCount, $deleted AS deletedCount

TRUNCATE CLASS Person

TRUNCATE CLUSTER person_cluster

CREATE INDEX Person.email UNIQUE
DELETE FROM Person WHERE email = 'tom@example.com'

LET batchSize = 1000;
LET total = SELECT COUNT(*) FROM Log WHERE createdAt < DATE('2023-01-01');
LET iterations = CEIL($total / $batchSize);

FOR $i IN RANGE(0, $iterations - 1) {
    DELETE FROM Log WHERE createdAt < DATE('2023-01-01') LIMIT $batchSize;
}

ALTER INDEX Person.name DISABLE
DELETE FROM Person WHERE status = 'deleted'
ALTER INDEX Person.name ENABLE

GRANT DELETE ON database.Person TO role_user

LET backup = SELECT FROM Person WHERE name = 'Tom';
INSERT INTO PersonBackup FROM $backup;
DELETE FROM Person WHERE name = 'Tom'

LET record = SELECT FROM Person WHERE @rid = #12:0;
SELECT 'Confirm delete: ' + $record[0].name AS message;
DELETE FROM Person WHERE @rid = #12:0

BEGIN
LET user = SELECT FROM User WHERE id = 'user_001';
DELETE FROM UserSession WHERE userId = $user[0].@rid;
DELETE FROM UserPreference WHERE userId = $user[0].@rid;
DELETE EDGE FROM $user[0].@rid;
DELETE VERTEX User WHERE id = 'user_001';
COMMIT

DELETE FROM Session WHERE expiresAt < sysdate()
DELETE FROM Token WHERE expiresAt < sysdate()
DELETE FROM Log WHERE createdAt < sysdate() - 90

DELETE FROM Person WHERE email LIKE '%@test.com'
DELETE FROM Order WHERE status = 'test'
DELETE FROM Log WHERE environment = 'test'

LET archived = SELECT FROM Log WHERE createdAt < DATE('2023-01-01') LIMIT 10000;
INSERT INTO LogArchive FROM $archived;
DELETE FROM Log WHERE @rid IN (SELECT @rid FROM $archived)

常见错误：
├── 记录不存在
├── 外键约束冲突
├── 权限不足
├── 事务冲突
└── 锁定超时

TRY {
    DELETE FROM Person WHERE @rid = #12:0
} CATCH {
    SELECT 'Delete failed: ' + $error AS message
}