删除

方式一:构造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'      |
|--------------------------------------------------------|

results matching ""

    No results matching ""