javascript - sqlite.get() results in TypeError: Cannot read property 'get' of null -


when trying execute sql.get() call works in places, not in others , can't seem figure out what's difference.
database sucessfully opened or @ least never got error , never gets closed. use discord.js in second (working example), not sure if relevant, though.
in example doesn't work.
test.js:

const sql = require("sqlite"); sql.open("./data.sqlite");  exports.getitemid = function(item) {     return new promise(function (fulfill, reject){         sql.get(`select * items name="${item}"`).then(row => {             console.log(`do stuff`);         }).catch((e) => {             console.error;             reject(e);         })     }); }  exports.getitemid("coins").then(itemid => {     console.log(itemid); }).catch((e) => {     console.log(e); });

stacktrace: 

$ node test.js  typeerror: cannot read property 'get' of null     @ promise (/users/julianveerkamp/node_modules/sqlite/main.js:225:18)     @ promise (<anonymous>)     @ database.get (/users/julianveerkamp/node_modules/sqlite/main.js:224:12)     @ /users/julianveerkamp/workspace/test-bot/test.js:6:13     @ promise (<anonymous>)     @ object.exports.getitemid (/users/julianveerkamp/workspace/test-bot/test.js:5:12)     @ object.<anonymous> (/users/julianveerkamp/workspace/test-bot/test.js:15:9)     @ module._compile (module.js:573:30)     @ object.module._extensions..js (module.js:584:10)     @ module.load (module.js:507:32)

but when call function 

const sql = require("sqlite"); sql.open("./data.sqlite"); // other stuff let commandfile = require(`./commands/command.js`); commandfile.run(client, message, args); // other stuff

it works fine.

command.js:

const sql = require("sqlite"); sql.open("./data.sqlite");  exports.run = (client, message, args) => {     sql.get(`select * scores userid ="${message.author.id}"`).then(row => {         // stuff row     }).catch(() => {         console.error;     }); }

this might bug in sqlite went ahead , used sqlite3 instead , wrapped/promisified functions myself util.promisify().

const util = require('util'); const sqlite3 = require('sqlite3');  var db = new sqlite3.database('./data.sqlite');  db.get = util.promisify(db.get); db.run = util.promisify(db.run);  exports.getitemid = function(item) {     return new promise(function (fulfill, reject){         db.get(`select * items name="${item}"`).then(row => {             console.log(`do stuff`);         }).catch((e) => {             console.error;             reject(e);         });     }); }  exports.getitemid("coins").then(itemid => {     console.log(itemid); }).catch((e) => {     console.log(e); });

note: new promise inside function not necessary. 1 return promise function.


Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

go - golang pprof for c library code -

i have been trying profile golang application pprof, seems details of c code(linked static library) missed in output result. flame graph from frame graph can see c code time consuming reported within "runtime._externalcode", no details @ all. , sure static library compiled debug enable. so there way make pprof details(like stack trace) of 3rd party c code? or there other golang profiling tool this?
Read more