[JS] SQL LITE CLASS (EXAMPLE)

import SQL from './SQL.js'

// 1. Membuat instance database
const db = new SQL('example.db')

async function main() {
   try {
      // 2. Membuat tabel
      await db.createTable('users', [
         { name: 'id', type: 'INTEGER PRIMARY KEY AUTOINCREMENT' },
         { name: 'name', type: 'TEXT' },
         { name: 'email', type: 'TEXT' },
         { name: 'age', type: 'INTEGER' }
      ])

      // 3. Menambahkan data ke tabel
      await db.insert('users', { name: 'Wildan Izzudin', email: '[email protected]', age: 20 })
      await db.insert('users', { name: 'Andi Sanjaya', email: '[email protected]', age: 33 })
      await db.insert('users', { name: 'Lisa An', email: '[email protected]', age: 21 })

      // 4. Membaca data dari tabel
      const users = await db.select('users')
      console.log('All Users:', users)

      // Membaca data dengan kondisi
      const filteredUsers = await db.select('users', '*', 'age > 25')
      console.log('Filtered Users (age > 25):', filteredUsers)

      // 5. Memperbarui data
      await db.update('users', { email: '[email protected]' }, 'name = "WIldan Izzudin"')
      const updatedUser = await db.select('users', '*', 'name = "Wildan Izzudin"')
      console.log('Updated User:', updatedUser)

      // 6. Menghapus data
      await db.delete('users', 'name = ?', ['Wildan Izzudin'])
      const remainingUsers = await db.select('users')
      console.log('Remaining Users:', remainingUsers)

      // 7. Menghapus tabel
      await db.dropTable('users')

      // 8. Menutup koneksi
      await db.close()
   } catch (error) {
      console.error('Error in main:', error.message)
   }
}

main()