hasTable method
Check is a given tableName
exists.
Implementation
@override
bool hasTable(TableName tableName) {
checkOpen();
String sql = """
SELECT count(name) FROM sqlite_master WHERE type='table'
and lower(name)=lower(?)
""";
var res = select(sql, [tableName.name]);
if (res.length == 1) {
var row = res.first;
var count = row.getAt(0);
return count == 1;
}
return false;
}