Help me help me . i need a function get save json into sqllite database

Ionic Framework ionic-v3
1 
exp: json 
{
  "data": [{
    "type": "articles",
    "id": "1",
    "attributes": {
      "title": "JSON API paints my bikeshed!",
      "body": "The shortest article. Ever.",
      "created": "2015-05-22T14:56:29.000Z",
      "updated": "2015-05-22T14:56:28.000Z"
    },
    "relationships": {
      "author": {
        "data": {"id": "42", "type": "people"}
      }
    }
  }],
  "included": [
    {
      "type": "people",
      "id": "42",
      "attributes": {
        "name": "John",
        "age": 80,
        "gender": "male"
      }
    }
  ]
}

**

> database.ts :

**


import { Injectable } from '@angular/core';
import { Platform } from 'ionic-angular';
import { SQLite, SQLiteObject } from '@ionic-native/sqlite';
import { SQLitePorter } from '@ionic-native/sqlite-porter';
import { Http } from '@angular/http';
import 'rxjs/add/operator/map';
import { BehaviorSubject } from 'rxjs/Rx';
import { Storage } from '@ionic/storage';
import { CheckdomainProvider } from '../checkdomain/checkdomain';

/*
  Generated class for the DatabaseProvider provider.

  See https://angular.io/guide/dependency-injection for more info on providers
  and Angular DI.
*/
@Injectable()
export class DatabaseProvider {
  database: SQLiteObject;
  private databaseReady: BehaviorSubject<boolean>;
 
  constructor(public sqlitePorter: SQLitePorter,
     private storage: Storage, 
     private sqlite: SQLite,
      private platform: Platform,
      public domain:CheckdomainProvider,
       private http: Http) {
    this.databaseReady = new BehaviorSubject(false);
    this.platform.ready().then(() => {
      this.sqlite.create({
        name: 'developers.db',
        location: 'default'
      })
        .then((db: SQLiteObject) => {
          this.database = db;
        }
        ) .catch(e => console.error(e));
    });
  }

  fillDatabase() {
    this.http.get('assets/dummyDump.sql')
      .map(res => res.text())
      .subscribe(sql => {
        this.sqlitePorter.importSqlToDb(this.database, sql)
          .then(data => {
            this.databaseReady.next(true);
            this.storage.set('database_filled', true);
          })
          .catch(e => console.error(e));
      });
  }
  
 
  getDatabaseState() {
    return this.databaseReady.asObservable();
  }
}
2

Hi, @nguyentrunghieutcu

You have to create a dummyDump.sql file in ‘assets/’ folder like this,

CREATE TABLE IF NOT EXISTS developer(id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,skill TEXT,yearsOfExperience INTEGER);
INSERT INTO developer(name, skill, yearsOfExperience) VALUES ('Simon', 'Ionic', '4');
INSERT INTO developer(name, skill, yearsOfExperience) VALUES ('Jorge', 'Firebase', '2');
INSERT INTO developer(name, skill, yearsOfExperience) VALUES ('Max', 'Startup', '5');

Thanks.

3

yep. i have create it. but i want to save json from server into database

4

@nguyentrunghieutcu This case you have to define SQLite table data structure according to json data field.

Here is demo code of SQLite Query structure in ionic,

First, you create table according to your required field like this,

this.database.executeSql('CREATE TABLE IF NOT EXISTS developer(id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,skill TEXT,yearsOfExperience INTEGER)', {})
.then(res => console.log('table Created Successfully'))
.catch(e => console.log('table create err',e));

Now, you insert your json data in table like this,

this.database.executeSql("INSERT INTO developer(name, skill, yearsOfExperience) VALUES ('Simon', 'Ionic', '4')",{});

5

You can say more in detail insert json to database