sqlite-sample.js

import {Component} from '@angular/core';
import {NavController, Events} from 'ionic-angular';
import {HttpClient} from '@angular/common/http';
import {Observable} from 'rxjs/Rx';
import { SqliteProvider } from '../../providers/sqlite/sqlite';

@Component({
  selector: 'page-home',
  templateUrl: 'home.html',
})
export class Home {
  users: any;

  constructor(
    public navCtrl: NavController,
    public httpClient: HttpClient,
    private sqlite: SqliteProvider,
  ) {

    this.users = []

    try {

      this.getUsers()

    } catch (error) {

      console.log(error)

    }

  }

  getUsers() {

    try {

      this
      .sqlite
      .db
      .executeSql('SELECT * FROM users ORDER BY id DESC', [])
      .then(res => {

        for(var i=0; i<res.rows.length; i++) {
          this.users.push(res.rows.item(i))
        }

      })

    } catch (error) {

      console.log(error)

    }

  }
}