package com.example.mysqlinfoapp

import android.content.Context
import android.database.sqlite.SQLiteDatabase
import android.database.sqlite.SQLiteOpenHelper

class MyDBHelper(context: Context): SQLiteOpenHelper(context,
    "USERDB", null, 1)  {

    override fun onCreate(db: SQLiteDatabase?) {
        db?.execSQL("CREATE TABLE USERS(ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
                "NAME TEXT, EMAIL TEXT, AGE INTEGER, NATION TEXT)")

        db?.execSQL("INSERT INTO USERS(NAME, EMAIL, AGE, NATION) " +
                "VALUES('Gabor','gabor@gmail.com','21','magyar')")

        db?.execSQL("INSERT INTO USERS(NAME, EMAIL, AGE, NATION) " +
                "VALUES('Jenna','jenna@gmail.com','22','amerikai')")

        db?.execSQL("INSERT INTO USERS(NAME, EMAIL, AGE, NATION) " +
                "VALUES('Carlos','carlos@gmail.com','23','spanyol')")
    }

    override fun onUpgrade(db: SQLiteDatabase?, oldVersion: Int, newVersion: Int) {
        TODO("Not yet implemented")
    }


}