sql_realm/regex.js at master · mggin/sql_realm · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
const sqlite3 = require('sqlite3').verbose();
var Realm = require('realm');
var Regex = require('regex')


let db = new sqlite3.Database('../data/sqlite/phatnalabu.sqlite', (err) => {
  if (err) {
    console.error(err.message)
  } else {
    console.log('success')
  }
  //console.log('success')
})

const Labu = {
  name: 'Labu',
  properties: {
    id:  'int',
    title: 'string',
    key: 'string',
    verse1: 'string',
    chorus: 'string',
    verse2: 'string',
    verse3: 'string',
    verse4: 'string',
    verse5: 'string',
    verse6: 'string',
    verse7: 'string',
    verse8: 'string',
    bridge: 'string',
    favorite: 'bool'
  }
};

db.serialize(() => {
  db.each('SELECT * FROM PhatNa', (err, row) => {
    if (err) {
      console.error(err.message);
    }
    console.log();
    //typeof(row)
    //let list = []
    //list.push(row)
    //console.log(list)
    //console.log(typeof(row))
   var raw_result = Object.values(row)
   var result = raw_result.map(function(item) {
      if (item === null) {
        item = ''
      }
      return item
    });
   //var rawKey = result[2]

   var str = result[2];
    //var res = str.replace("Key", "Key: ");
    //console.log(res)
   //console.log(result)
   //console.log(typeof(result[6]))
    /*
   Realm.open({path: '../data/realm/phatnalabu1.realm'})
      .then(realm => {
        //console.log(result)
      // Create Realm objects and write to local storage
      // console.log('realm')
      //console.log(realm.objects('Labu'))

      realm.write(() => {
        //let Labu = realm.objects('Labu')
        //Labu[0].title = 'hello'
        //console.log(Labu[0].title)
        //Labu.id = result[0]
        //Labu.title = result[1]
        //Labu.key = result[2]
        //console.log(Labu)

        var rawKey = result[2]
        console.log(rawKey)

        realm.create('Labu', {
          id: result[0],
          title: result[1],
          // key: result[2],
          verse1: result[3],
          chorus: result[4],
          verse2: result[6],
          verse3: result[7],
          verse4: result[8],
          verse5: result[9],
          verse6: result[10],
          verse7: result[11],
          verse8: result[12],
          favorite: false,
          bridge: '',
        });


      })

    })
    */

  })

});

db.close((err) => {
  if (err) {
    console.error(err.message);
  }
  console.log('Close the database connection.');
});