1 回答

TA貢獻(xiàn)1834條經(jīng)驗(yàn) 獲得超8個(gè)贊
完全按照你的建議去做。將代碼的上半部分移動(dòng)到db.js并公開(kāi)db和collection使用exports:
數(shù)據(jù)庫(kù).js:
const {
Database
} = require("arangojs");
var db = new Database({
url: "http://localhost:8529"
});
const database_name = "cool_database";
db.useBasicAuth("username", "password123");
db.listDatabases()
.then(names => {
if (names.indexOf(database_name) > -1) {
db.useDatabase(database_name);
db.get();
} else {
db.createDatabase(database_name)
.then(() => {
db.useDatabase(database_name);
db.collection("my-collection").create();
});
}
});
exports.collection = db.collection("my-collection");
exports.db = db;
索引.js:
const {
db,
collection
} = require("./db");
const getJobFromQueue = () => {
return db.query({
query: "FOR el IN @@collection FILTER DATE_TIMESTAMP(el.email.sendAfter) < DATE_NOW() AND el.status != 'processed' AND el.status != 'failed' SORT el.email.sendAfter LIMIT 1 RETURN el",
bindVars: {
"@collection": "my-collection"
}
})
.then(cursor => cursor.all());
}
警告:
請(qǐng)記住,您的代碼中存在潛在的競(jìng)爭(zhēng)條件。在它們被初始化之前,您可能最終會(huì)使用dband 。collection
添加回答
舉報(bào)