Question

145

angular js model relationships

rated 0 times [ 151] [ 6] / answers: 1 / hits: 17126 / 12 Years ago, fri, january 25, 2013, 12:00:00

I've been trying out Angular JS for the past couple of days and one thing I can't figure out is how to work with relationships between models.

The project I'm working on has a Users model and an Accounts model. I have it set up on my database that each Account has a field called 'ownedBy' which is a foreign key reference to the id of the user that owns that account.

In Angular I have the following set up in a file called main.js

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



var Users = myApp.factory('Users', function($resource) {

    var User = $resource('http://api.mydomain.ca/users/:id',

        {id:'@id'},

    {});

    return User;

});



var Accounts = myApp.factory('Accounts', function($resource) {

    var Accounts = $resource('http://api.mydomain.ca/accounts/:id',

        {id:'@id'},

    {});

    return Accounts;

});





function UsersCtrl($scope, Users) {

    $scope.users = Users.query();

}



function AccountsCtrl($scope, Accounts) {

    $scope.accounts = Accounts.query();

}

and the following template

<!DOCTYPE html>

<html lang=en>

<head>

  <meta charset=UTF-8>

  <meta http-equiv=X-UA-Compatible content=IE=edge,chrome=1>

  <title>Angular Test</title>

  <meta name=viewport content=width=device-width, initial-scale=1.0>



  <link rel=stylesheet href=/bootstrap/css/bootstrap.min.css?v=2.2.1>

</head>

<body>

<div ng-app=myApp>

    <div ng-controller=UsersCtrl>

        <table class=table table-striped>

            <thead>

                <tr>

                    <th>ID</th>

                    <th>First Name</th>

                    <th>Last Name</th>

                </tr>

            </thead>

            <tbody>

                <tr ng-repeat=user in users>

                    <td>{{user.id}}</td>

                    <td>{{user.firstName}}</td>

                    <td>{{user.lastName}}</td>

                </tr>

            </tbody>

        </table>

    </div>

    <div ng-controller=AccountsCtrl>

        <table class=table table-striped>

            <thead>

                <tr>

                    <th>ID</th>

                    <th>Owned By</th>

                </tr>

            </thead>

            <tbody>

                <tr ng-repeat=account in accounts>

                    <td>{{account.id}}</td>

                    <td>{{account.ownedBy}}</td>

                </tr>

            </tbody>

        </table>

    </div>

</div>

<script src=http://code.jquery.com/jquery-latest.js></script>

<script src=http://ajax.googleapis.com/ajax/libs/angularjs/1.0.4/angular.min.js></script>

<script src=http://ajax.googleapis.com/ajax/libs/angularjs/1.0.4/angular-resource.min.js></script>

<script src=/bootstrap/js/bootstrap.min.js?v=2.2.1></script>

<script src=js/main.js></script>

</body>

</html>

and this is working. It pulls a JSON resource from my REST server and displays it in a table. What's the next step I need to take to end up with one table that shows users and their account numbers? (the equivalent of a database JOIN?) Is there a different way to do it for a one to many relationship? (ie... an account has many transactions)

Thanks for the help :)

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

bradenc

Add To Favorites

Follow

Total Points: 75

Total Questions: 96

Total Answers: 129

Location: Burundi

Member since Thu, Feb 10, 2022

2 Years ago

answered 12 Years ago raymondd · Accepted Answer

$resource doesn't contain any way to deal with relationships that aren't handled by the server, but it's pretty simply with $http:

module.factory( 'UserService', function ( $http, $q ) {

  return {

    get: function getUser( id ) {

      // We create our own promise to return

      var deferred = $q.defer();



      $http.get('/users/'+id).then( function ( user ) {

        $http.get('/accounts/'+user.id).then( function ( acct ) {



          // Add the account info however you want

          user.account = acct;



          // resolve the promise

          deferred.resolve( user );



        }, function getAcctError() { deferred.reject(); } );

      }, function getUserError() { deferred.reject(); } );



      return deferred.promise;

    }

  };

});

And then in your controller, you can just use it like any other promise:

UserService.get( $scope.userId ).then( function ( user ) {

  $scope.user = user;

});

And it's available for your template!

<div>

    User: {{user.firstName}} {{user.lastName}} with Acct ID {{user.acct.id}}.

</div>