首页 \ 问答 \ 如何在Dart / Flutter中捕获sqflite DatabaseException(how to catch sqflite DatabaseException in Dart/Flutter)

如何在Dart / Flutter中捕获sqflite DatabaseException(how to catch sqflite DatabaseException in Dart/Flutter)

我在捕获一个引发数据库异常的sqflite SQL错误时失败。 注意:这是一个未来和异步。

示例代码

Future<String> getData() async {

Directory documentsDirectory = await getApplicationDocumentsDirectory();
String path = join(documentsDirectory.path, globals.databaseName);
Database db = await openDatabase(path);

List results = await db.rawQuery("mal formed example of sql on purpose");
}

当我运行上面的代码时,rawQuery会抛出通用的错误SQL。 控制台显示:

E/SQLiteLog( 7908): (1) near "mal": syntax error

我想要做的就是能够捕获SQL错误并处理它们。

我试过.then和.catchError - 但没有得到它的工作。

从我读过的内容来看,普通的try {} catch {}在Futures上不起作用。 (我确实尝试过,以......开始,但它不起作用)。

try {
  List results = await db.rawQuery("mal formed example of sql on purpose");
} catch (e) {
  print(e);
}

导致相同的错误:

E/SQLiteLog( 3148): (1) near "mal": syntax error

I am unsuccessful at catching an sqflite SQL error that throws a database exception. Note: it's a Future and async.

Sample Code

Future<String> getData() async {

Directory documentsDirectory = await getApplicationDocumentsDirectory();
String path = join(documentsDirectory.path, globals.databaseName);
Database db = await openDatabase(path);

List results = await db.rawQuery("mal formed example of sql on purpose");
}

When I run the code above, rawQuery throws the on-purpose bad SQL. The console shows:

E/SQLiteLog( 7908): (1) near "mal": syntax error

What I want to do is be able to catch SQL errors and handle them.

I've tried .then and .catchError - but not getting it to work.

And from what I've read, normal try {} catch {} doesn't work on Futures. (I did try that to start with... and it didn't work).

try {
  List results = await db.rawQuery("mal formed example of sql on purpose");
} catch (e) {
  print(e);
}

results in the same error:

E/SQLiteLog( 3148): (1) near "mal": syntax error

原文:https://stackoverflow.com/questions/48085809
更新时间:2019-11-29 02:16

最满意答案

听起来像问题通过升级到最新版本得到解决(不知道在报告的问题中使用了哪个版本): https//github.com/tekartik/sqflite/issues/17

将SQLException(iOS和Android)传播到Dart,并且可以在使用async / await时使用try / catch将其捕获为DatabaseException,如以下测试中所示: https : //github.com/tekartik/sqflite/blob/master /example/lib/exception_test_page.dart#L89-L94


Sounds like the issue got fixed by upgrading to the latest version (don't know which version was used in the reported issue): https://github.com/tekartik/sqflite/issues/17

The SQLException (iOS and Android) is propagated to Dart and can be caught as a DatabaseException using try/catch when using async/await, as shown in the test here: https://github.com/tekartik/sqflite/blob/master/example/lib/exception_test_page.dart#L89-L94

2018-01-05

相关文章

更多

最新问答

更多
  • jsPlumb draggable element javascript函数(jsPlumb draggable element javascript function)
  • MVC4:ViewModel(带有radiobuttonlist)在HttpPost之后为空(MVC4: ViewModel (with radiobuttonlist) is empty after HttpPost)
  • 如何在同一帐户上设置“Dev repo”(在prod和团队之间)(How to set up a “Dev repo” (between the prod and the team) on the same account)
  • 如何在tcl中将eth0配置为发送方udp端口(how to configure eth0 as a sender udp port in tcl)
  • 如何在datarow []中的列中找到最大值?(How to find max value in a column in a datarow[] ?)
  • 如何使用预定义文本替换来自数据库的部分结果(How do I replace part of result coming from Database with predefined text)
  • Selenium Java注入了新的Javascript函数(Selenium Java inject new Javascript function)
  • 使用.on的多个下拉菜单选择文本仅适用于第一个下拉列表(Multiple Dropdowns Menu Selection text using .on works only on first dropdown)
  • 快速将黄土曲线添加到大型数据集图中的方法(Quick way to add loess curve to large data set graph)
  • FilteringSelect in mvc(FilteringSelect in mvc)
  • 在Delphi XE2中开发Mac或iOS应用程序需要哪些硬件/软件?(What hardware/software is necessary to develop Mac or iOS apps in Delphi XE2?)
  • 在原型的构造函数中初始化属性时获取“未定义”(Getting 'undefined' when a property is initialized in the constructor of a prototype)
  • 通过越狱加载的应用程序的Documents文件夹位置(Location of Documents folder for an app loaded via jailbreak)
  • 在OpenGL中使用可编程和固定管道功能(Using both programmable and fixed pipeline functionality in OpenGL)
  • 将任何用户输入重定向到单独的底层程序(redirect any user input to a separate underlying program)
  • 编辑文本不能正常工作android(Edit texts not working properly android)
  • “user_denied”Facebook应用页面上的Facebook用户区域设置(Facebook user locale on “user_denied” facebook app page)
  • 在大图像中找到小的部分透明图像的坐标(find coordinates of small partially-transparent image within a large image)
  • 我如何在cakephp 3.1中获得完整的相对路径?(How i can get full relative path of image in cakephp 3.1?)
  • 如何保存拖动标记的新本地化?(How to save new localization of dragged marker?)
  • MySQL UPDATE vs INSERT和DELETE(MySQL UPDATE vs INSERT and DELETE)
  • 在执行查询之前,在SQLAlchemy模型中将datetime转换为unix时间戳?(Convert datetime to unix timestamp in SQLAlchemy model before executing query?)
  • OpenCL与OpenGL互操作的优势(Advantage of OpenCL interoperability with OpenGL)
  • 如何解析用点和等分隔的数据然后添加到listview(How to parsing data from delimited with dot and equal then add to listview)
  • 带调试输出的X3解析器段错误(BOOST_SPIRIT_X3_DEBUG)(X3 parser segfaults with debug output (BOOST_SPIRIT_X3_DEBUG))
  • 将文件夹名称添加到fgrep结果(Add folder name to fgrep result)
  • 在MySQL中加载一个表是非常慢的(Loading one table in MySQL is ridiculously slow)
  • 如何将JSON放入PHP变量?(How do I put JSON into a PHP Variable?)
  • 如何绕过Microsoft.Speech.Recognition中的不流畅?(How to bypass disfluencies in Microsoft.Speech.Recognition?)
  • 原点的最后一行是什么?(What is the last row of an origin for?)