Angular 2 how to return array of objects from nested promise

Question

I am trying to write an service to get the list of customers but i don't know to return the list of customers from nested promose.

Please help me on this thanks in advance.

import { Injectable } from '@angular/core';
import { SQLite } from 'ionic-native';

@Injectable()
export class CustomerService {
    private sDBName:string;
    private db;
    private isDBExist:boolean = false;

    constructor() {}

    setDBName(sDBName:string) {
        this.sDBName = sDBName;
    }

    connect():Promise<any> {        
        this.db = new SQLite();
        return this.db.openDatabase({
            name: this.sDBName,
            location: 'default'
        });
    }
    getCustomersList():Promise<any> {
        return Promise.resolve(()=>{            
            return this.connect().then(()=>{                
                this.isDBExist = true;
                let sql = 'SELECT * FROM customer ORDER BY customer_id DESC LIMIT 10';
                return this.db.executeSql(sql, {}).then((result)=>{ 
                    let customers = [];             
                    for(let i=0; i<result.rows.length; i++) {
                        customers.push(result.rows.item(i));
                    }
                    return customers;
                },(err)=>{
                    this.debug('Unable to select customers', err);
                    return [];
                });
            },(err)=>{
                this.debug('Unable to open database', err);
                return [];
            });
        });
    }
}

What's the problem? Where and how do you call getCustomerList()? — Günter Zöchbauer
– Günter Zöchbauer, Commented Nov 19, 2016 at 16:58
i don't know how to return the customers list getCustomersList() is this code has some issues inside the getCustomersList() i couldn't figure it out — Sundar
– Sundar, Commented Nov 19, 2016 at 17:00
return Promise.resolve(()=>{ ... }) resolves with a function, it doesn't call it. Is there a reason why it shouldn't be return this.connect()...? — Estus Flask
– Estus Flask, Commented Nov 19, 2016 at 20:55
return statement is not waiting to resolve the promise. It's returns empty. How to make return statement wait — Sundar
– Sundar, Commented Nov 20, 2016 at 5:03

Günter Zöchbauer · Accepted Answer · 2016-11-19 16:59:32Z

3

You need to chain the call with .then(...) like

this.getCustomerList().then(result => this.myArray = result);

answered Nov 19, 2016 at 16:59

Günter Zöchbauer

662k235 gold badges2.1k silver badges1.6k bronze badges

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

3 Comments

Sundar Over a year ago

can you clarify me only one thing is the getCustomerList() function is right

Sundar Over a year ago

angular 2 return statement will wait for the promise to be completed

Sundar Over a year ago

this question is related to this only stackoverflow.com/questions/37841721/… .

Collectives™ on Stack Overflow

Angular 2 how to return array of objects from nested promise

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related