node.js - TypeError: Cannot read property 'createConnection' of null when trying to connect node js to mysql for a zendesk app -


i'm new node, , i'm trying create zendesk app connects mysql when user inputs value. here's code app.js.

( function() {   return {      events: {       // framework events       'app.created':'checklocalstorage', // call 'checklocalstorage' function below        // request events (none)        // dom events       'keyup #input-value-id': function(event){ // user clicked 'enter'/'return' button store value in localstorage         if(event.keycode === 13) {            return this.processinputvalue();         }       },       'click .reset': 'resetvalue' // call 'resetvalue' function below     },      checklocalstorage: function () { // in localstorage if value present 'examplestring'         if (this.store('examplestring') === null) {            services.notify('localstorage value not set', 'alert', 500); // services notification            this.switchto('input_value'); // display input field user set value of localstorage          } else { // there value set 'examplestring' in localstorage            services.notify('localstorage value found', 'notice', 500); // services notification            var value = this.store('examplestring'); // instantiate variable 'value' set value in localstorage 'examplestring'            this.switchto('display_value', { // switch 'displayvalue' template             value: value // set handlebars.js placeholder 'value' equal variable 'value' above           });          }     },      processinputvalue: function() { // handle value entered input field in 'inputvalue' template       var examplestring = this.$('input#input-value-id').val(); // variable set value entered input field       this.store('examplestring', examplestring); // value of examplestring future use        examplestring = this.$('input#input-value-id').val(''); // empty input field - visual ux enhancement        services.notify('localstorage value set', 'notice', 500); // services notification        var value = this.store('examplestring');       this.switchto('display_value', {         value: value       });           var mysql = require('mysql');           var con = mysql.createconnection({               host: "localhost",               user: "root",               password: "waypass123"           });           con.connect(function(err) {               if (err) throw err;               console.log("connected!");               con.query("select * way0608.user_info", function (err, result, fields) {                   if (err) throw err;                     console.log(result);               });           });      },      resetvalue: function() {        this.store('examplestring', null); // set value of 'examplestring' in localstorage 'empty' variable (null)        services.notify('localstorage value reset', 'notice', 500); // services notification        this.switchto('input_value'); // display input field user set value of localstorage      }    };  }());

when run mysql portion of code in own js file, below, works fine.

var mysql = require('mysql');  var con = mysql.createconnection({   host: "localhost",   user: "root",   password: "pass" });  con.connect(function(err) {   if (err) throw err;   console.log("connected!");   con.query("select * test.user_info", function (err, result, fields) {     if (err) throw err;     console.log(result);   }); });

however, the typeerror while running app.js on zendesk. tested out running sample app on zendesk, worked fine. means sometime wrong mysql connection code.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more