删除
方式一:构造OQL
@Test
fun DeleteOQL() {
val book2 = TestBook()
val q = OQL.From(book2).Delete()
.Where {
cmp ->
cmp.Comparer(book2.testName, "=", "abcInsertOQLWidthKeysssssss")
}
.END
val count = getDB().delete(q)
Assert.assertTrue(count > 0)
}
|----------------------------------------------------------------------------|
| finalSql | DELETE FROM `test_book` |
| | WHERE `test_name` = 'abcInsertOQLWidthKeysssssss' |
|----------------------------------------------------------------------------|
方式二:删除Entity
默认按主键删除
@Test
fun deleteEntity() {
val tb = TestBook()
tb.testId = "dd"
getDB().delete(tb)
}
|--------------------------------------------------------|
| finalSql | DELETE FROM `test_book` |
| | |
| | WHERE 1=1 AND `test_id` = 'dd' |
|--------------------------------------------------------|