UsfYEuEU

1import { openDatabase, enablePromise } from "react-native-sqlite-storage";
2
3export class SiswaDatasource {
4    _executeSql(sql, params = undefined) {
5        enablePromise(true)
6
7        return new Promise((resolve, reject) => {
8            openDatabase({
9                name: 'sekolahku.db',
10                location: 'default'
11            }).then((db) => {
12                let prepareTable = "CREATE TABLE IF NOT EXISTS siswa(" +
13                    "id INTEGER PRIMARY KEY AUTOINCREMENT, " +
14                    "nama_depan TEXT, " +
15                    "nama_belakang TEXT, " +
16                    "no_hp TEXT, " +
17                    "email TEXT, " +
18                    "tgl_lahir TEXT, " +
19                    "gender TEXT, " +
20                    "jenjang TEXT, " +
21                    "hobi TEXT, " +
22                    "alamat TEXT)"
23                db.executeSql(prepareTable).then(() => {
24                    db.executeSql(sql, params).then((result) => {
25                        resolve(result)
26                        console.log("Hasil Query: " + JSON.stringify(result));
27                    }).catch(error => reject(error))
28                }).catch(error => reject(error))
29            }).catch((onRejected) => {
30                reject(onRejected)
31            })
32        })
33    }
34}