sqlite3 使用 Node 创建带回调的数据库 [英] sqlite3 create database with callback using Node
问题描述
我搜索了如何在 Node.js 中使用回调创建 sqlite3 数据库,但找不到任何链接.有人可以向我指出文档或提供 2-3 行代码示例以实现以下目标:
I've searched on how to create a sqlite3 database with a callback in Node.js and have not been able to find any links. Can someone point me towards documentation or provide a 2-3 line code sample to achieve the following:
- 创建一个 sqlite3 数据库并在创建失败时捕获错误.
这是我尝试过的:
let dbCreate = new sqlite3.Database("./user1.db", sqlite3.OPEN_CREATE, function(err){
if(!err){
logger.infoLog("Successfully created DB file: " + dbFileForUser + " for user: " + username );
} else {
logger.infoLog("Failed to create DB file: " + dbFileForUser + ". Error: " + err );
}
});
dbHandler[username] = dbCreate;
执行此操作时,出现以下错误:无法创建数据库文件:./database/user1.db.错误:错误:SQLITE_MISUSE:参数错误或其他 API 误用"
When I execute this, I get the following error: "Failed to create DB file: ./database/user1.db. Error: Error: SQLITE_MISUSE: bad parameter or other API misuse"
这个没有回调的调用工作正常.
This call without callback works just fine.
var customDB = new sqlite3.Database("./custom.db", sqlite3.OPEN_READWRITE | sqlite3.OPEN_CREATE);
var customDB = new sqlite3.Database("./custom.db", sqlite3.OPEN_READWRITE | sqlite3.OPEN_CREATE);
但在这里,我不知道在创建数据库时是否遇到任何错误.
But in this, I will not know if I run into any errors while creating the Database.
推荐答案
试试这个:
let userDB = new sqlite3.Database("./user1.db",
sqlite3.OPEN_READWRITE | sqlite3.OPEN_CREATE,
(err) => {
// do your thing
});
示例.
这篇关于sqlite3 使用 Node 创建带回调的数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!