swift-判断SQLite表(name)是否存在

2020-01-02  本文已影响0人  HappyJiuOk

Github地址:SQLite.swift

    func tableExists() -> Bool{
        let result = try? db?.scalar("SELECT count(*) FROM sqlite_master WHERE type = 'table' AND name = 'TableName'")
or /*
let result = try? db?.scalar("SELECT count(*) FROM sqlite_master WHERE type = 'table' AND name = ? ","tableName")
*/
        let count = Int.fromDatatypeValue(result as! Int64) (刚学swift,我不晓得这里是不是这样用的,但测试没问题)
        return count == 1
    }
上一篇 下一篇

猜你喜欢

热点阅读