AngularJS: Retrieve mysql data in electron and publish it to AngularJS scope

Question

I'm trying to retrieve a list of data from mysql database by using electron and bind it to a list in the controllers scope. I'm using mysql2. Here is my controller:

$scope.carList = [];
mysql.execute("SELECT * FROM cars").spread(function(results){
    $scope.carList = results;
    console.log(results);
})

I do get the results back, but the in the view carList remains empty. How can I solve this problem?

I just added a button to my view and bound it to a check function like this:

$scope.check = function(){
    console.log($scope.carList);
}

After I click on the button, my list in the views gets populated. Now my question would be how can I have my list populated on the start of the controller rather than wait for an event ro make it happen?

How can you access your msql database via client application directly? — lin
– lin, Commented Mar 1, 2018 at 12:35
@lin, I'm using electron to build a desktop app. I just added this information to the question — Ayoub.A
– Ayoub.A, Commented Mar 1, 2018 at 12:42
You're trying to run a node module on the client and access your database from there. You can't do that, it's a node module and user's shouldn't be able to do whatever they want with your DB.. think about it! — nanobar
– nanobar, Commented Mar 1, 2018 at 12:51
@DominicTobias nope he is right. Please check electronjs.org/docs — lin
– lin, Commented Mar 1, 2018 at 12:51
@Dominic Tobias, For now I'm onlny getting a list of cars from local database. Later on, I will use a remote database, so your comment is appreciated. — Ayoub.A
– Ayoub.A, Commented Mar 1, 2018 at 13:59

marc_s · Accepted Answer · 2019-01-26 22:08:57Z

1

I think mysql.execute("").spread(fn) promise is not a part of the AngularJS digest cycle. You did not provide enough code to fully reproduce your problem but I think by triggering a new digest cycle it should work for you. E.g. try it with $timeout which triggers a new digest cycle.

$scope.carList = [];

mysql.execute("SELECT * FROM cars").spread(function(results){
     $timeout(function () {
        $scope.carList = results;
     });
})

I would prefer to create a AngularJS service which handles your electron mysql in a nice way. You could globally apply your $scopes in it, right after finishing your mysql procedures which are not a part of your digest cycle.

Approach by using AngularJS promises

var myApp = angular.module('myApp', []);

myApp.controller('MyCtrl', function($scope, $q) {


  $scope.carList = [];

  getCars.then(function(cars) {
    $scope.carList = cars;
  });


  function getCars() {

    var deferred = $q.defer();

    mysql.execute("SELECT * FROM cars").spread(function(results) {
      deferred.resolve(results);
    });

    return deferred.promise;
  }

});

edited Jan 26, 2019 at 22:08

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Mar 1, 2018 at 12:50

lin

18.5k4 gold badges66 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ayoub.A Over a year ago

Yes I do want to create a service only for database procedures. and your answer was quite helpful. Thank you

Ayoub.A Over a year ago

I'm getting an error that getCars.then is not a function

Collectives™ on Stack Overflow

AngularJS: Retrieve mysql data in electron and publish it to AngularJS scope

1 Answer 1

Approach by using AngularJS promises

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Approach by using AngularJS promises

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related