如何在Cucumber-JS步骤定义中使用Node-mysql连接到MySQL
How to connect to MySQL using Node-mysql in a Cucumber-JS step definition?
我试图连接到MySQL数据库在我的黄瓜- js stepDefinition文件,使用node-mysql,通过在world.js中定义的连接方法。不幸的是,它不会连接并返回我的查询结果,我也不能让它向我显示一个错误消息,这将帮助我找出我错在哪里。
我过去使用过Cucumber-JVM,但我是JavaScript和node.js的新手。我用相同的方法创建了一个独立的js文件(模拟世界.js),并从另一个测试脚本成功地调用它(模拟stepDefinitions.js);它连接并愉快地返回记录,所以这可能归结于我对JavaScript中上下文的误解,或者在Cucumber-JS使用世界的方式中,也许……
stepDefinitons.js:
'use strict';
var ImportStepDefinitions = function() {
this.World = require('../support/world.js').World;
this.Given(/^I have a clean Magento database$/, function (callback) {
this.connectToDatabase();
//this.clearDatabase();
callback();
});
this.When(/^I import the test data file "([^"]*)"$/, function (testDataFile, callback) {
//this.importTestFile();
callback.pending();
});
this.Then(/^an attribute set is created called "([^"]*)"$/, function (attributeSetName, callback) {
//this.validateAttributeSet();
callback.pending();
});
};
module.exports = ImportStepDefinitions;
world.js:
'use strict';
var World = function World(callback) {
var mysql = require('mysql');
var host = 'localhost';
var user = 'user';
var password = 'password';
var database = 'magento';
var connection = mysql.createConnection({
host: host,
user: user,
password: password,
database: database
});
this.connectToDatabase = function () {
connection.connect(function(err){
if(err) {
console.error("Connection error: " + err.stack);
return;
}
console.log("Connection state 1 = ", connection);
});
connection.query('SELECT * FROM admin_user', function (err, rows, fields) {
if (err) {
console.error("Query error: " + err.stack);
return;
}
console.log("ROWS ====== ", rows[0]);
recordDetail = rows[0];
});
console.log("Connection state 2 = ", connection);
connection.end();
};
this.clearDatabase = function(scriptName) {
//Run import script in sql so starting with a fresh magento database
};
this.importTestFile = function(testFileName) {
//Need to call import.php with file location
};
this.validateAttributeSet = function(attributeSetName) {
//Use magento object (?) to check attribute set exists as expected
};
callback();
};
module.exports.World = World;
当我执行代码时,我没有从connection.connect()中得到任何回报,既没有错误也没有日志,没有记录从connection.query()中注销,并且连接在'连接状态2 ='显示(在底部)_connectCalled值为true,但状态为断开连接,threadId为null:
Connection state 2 = { domain:
{ domain: null,
_events: { error: [Function: handleScenarioException] },
_maxListeners: undefined,
members: [],
id: 'domain-1437457225974' },
_events: {},
_maxListeners: undefined,
config:
{ host: 'localhost',
port: 3306,
localAddress: undefined,
socketPath: undefined,
user: 'user',
password: 'password',
database: 'magento',
connectTimeout: 10000,
insecureAuth: false,
supportBigNumbers: false,
bigNumberStrings: false,
dateStrings: false,
debug: undefined,
trace: true,
stringifyObjects: false,
timezone: 'local',
flags: '',
queryFormat: undefined,
pool: undefined,
ssl: false,
multipleStatements: false,
typeCast: true,
maxPacketSize: 0,
charsetNumber: 33,
clientFlags: 455631 },
_socket:
{ _connecting: true,
_hadError: false,
_handle:
{ fd: -1,
reading: false,
owner: [Circular],
onread: [Function: onread],
onconnection: null,
writeQueueSize: 0 },
_parent: null,
_host: 'localhost',
_readableState:
{ objectMode: false,
highWaterMark: 16384,
buffer: [],
length: 0,
pipes: null,
pipesCount: 0,
flowing: true,
ended: false,
endEmitted: false,
reading: false,
sync: true,
needReadable: false,
emittedReadable: false,
readableListening: false,
defaultEncoding: 'utf8',
ranOut: false,
awaitDrain: 0,
readingMore: false,
decoder: null,
encoding: null,
resumeScheduled: true },
readable: false,
domain:
{ domain: null,
_events: [Object],
_maxListeners: undefined,
members: [],
id: 'domain-1437457225974' },
_events:
{ end: [Object],
finish: [Function: onSocketFinish],
_socketEnd: [Function: onSocketEnd],
data: [Function],
error: [Function],
connect: [Object],
timeout: [Object] },
_maxListeners: undefined,
_writableState:
{ objectMode: false,
highWaterMark: 16384,
needDrain: false,
ending: false,
ended: false,
finished: false,
decodeStrings: false,
defaultEncoding: 'utf8',
length: 0,
writing: false,
corked: 0,
sync: true,
bufferProcessing: false,
onwrite: [Function],
writecb: null,
writelen: 0,
bufferedRequest: null,
lastBufferedRequest: null,
pendingcb: 0,
prefinished: false,
errorEmitted: false },
writable: true,
allowHalfOpen: false,
destroyed: false,
bytesRead: 0,
_bytesDispatched: 0,
_pendingData: null,
_pendingEncoding: '',
_idleTimeout: 10000,
_idleNext: { _idleNext: [Circular], _idlePrev: [Circular] },
_idlePrev: { _idleNext: [Circular], _idlePrev: [Circular] },
_idleStart: 2735419 },
_protocol:
{ domain:
{ domain: null,
_events: [Object],
_maxListeners: undefined,
members: [],
id: 'domain-1437457225974' },
_events:
{ data: [Function],
end: [Object],
handshake: [Function],
unhandledError: [Function],
drain: [Function],
enqueue: [Function] },
_maxListeners: undefined,
readable: true,
writable: true,
_config:
{ host: 'localhost',
port: 3306,
localAddress: undefined,
socketPath: undefined,
user: 'user',
password: 'password',
database: 'magento',
connectTimeout: 10000,
insecureAuth: false,
supportBigNumbers: false,
bigNumberStrings: false,
dateStrings: false,
debug: undefined,
trace: true,
stringifyObjects: false,
timezone: 'local',
flags: '',
queryFormat: undefined,
pool: undefined,
ssl: false,
multipleStatements: false,
typeCast: true,
maxPacketSize: 0,
charsetNumber: 33,
clientFlags: 455631 },
_connection: [Circular],
_callback: null,
_fatalError: null,
_quitSequence: null,
_handshakeSequence:
{ domain: [Object],
_events: [Object],
_maxListeners: undefined,
_callback: [Object],
_callSite: [Error],
_ended: false,
_timeout: undefined,
_idleNext: null,
_idlePrev: null,
_idleStart: null,
_idleTimeout: undefined,
_repeat: null,
_config: [Object],
_handshakeInitializationPacket: null },
_handshaked: false,
_ended: false,
_destroyed: false,
_queue: [ [Object], [Object] ],
_handshakeInitializationPacket: null,
_parser:
{ _supportBigNumbers: false,
_buffer: <Buffer >,
_longPacketBuffers: [],
_offset: 0,
_packetEnd: null,
_packetHeader: null,
_packetOffset: null,
_onError: [Function],
_onPacket: [Function],
_nextPacketNumber: 0,
_encoding: 'utf-8',
_paused: false } },
_connectCalled: true,
state: 'disconnected',
threadId: null }
好吧,我相信我已经找到了一个解决方案,所以在这里张贴其他人在类似的方式挣扎。如果你有的话,请随意发布一个更好的解释,解释为什么会发生这样的事情!
我没有正确地实现回调,如cucumber.js文档所述;我需要将它传递给被调用的函数,并使用它来表示被调用的函数何时完成:
StepDefinitions.js:
...
this.Given(/^I have a clean Magento database$/, function (callback) {
//callback passed into function
this.connectToDatabase(callback);
...
world.js:
...
//callback now passed into function
this.connectToDatabase = function(callback) {
var host = 'localhost';
var user = 'user';
var password = 'password';
var database = 'magento';
var connection = mysql.createConnection({
host: host,
user: user,
password: password,
database: database
});
connection.connect(function(err){
if(err) {
console.error("Connection error: " + err.stack);
return;
}
});
connection.query('SELECT * FROM admin_user', function (err, rows) {
if (err) {
console.error("Query error: " + err.stack);
} else {
console.log(rows[0]);
}
});
/*callback used to signify end of function, ensuring all actions are
actually completed before the rest of the scenario steps are completed
by cucumber.js*/
connection.end(callback);
};
....
相关文章:
- 使用 Node-MYSQL 检索 MYSQl 数据库中最新的 X 个条目量?节点.js
- Express - 将 mysql 连接传递给脚本
- 如何将相同的MySQL连接用于我的整个Node.js应用程序
- node-mysql connection.query() returns undefined
- 如何在node.js中设置mysql连接,以在带无符号整数的算术上抛出超出范围的错误
- ES6-Promises在使用Node MySQL时出现故障
- 通过Ajax调用PHP文件中的MySQL连接singleton对象
- 为什么尝试释放此Node MySQL池会导致错误
- Node.js连接中间件限制不起作用
- 在 NODE-MYSQL 中选择 WHERE 的位置
- node-mysql timing
- module.exports scope and node-mysql
- 最佳数据库连接数(node-mysql)
- 插入数据库(node.js)时Mysql连接超时
- 如何保持mysql连接活在node.js
- Openshift和外部mysql数据库与node-mysql(错误:连接ECONNREFUSED)
- felix /Node-Mysql独立连接文件
- 连接Node-mysql异常
- Node.js MySQL连接问题
- Express.JS + Node-Mysql 和每个 http 请求 1 个连接