// KidsDb1 Example
// Source Code File: MainActivity.java
package it372.kidsdb1;
import androidx.appcompat.app.AppCompatActivity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.widget.TextView;
import android.widget.Toast;
import java.io.InputStream;
import java.util.Scanner;
public class MainActivity extends AppCompatActivity {

    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        SQLiteOpenHelper dbh = new KidsDbHelper(this);
        try {
            SQLiteDatabase db = dbh.getWritableDatabase( );
db.execSQL("create table kids(name text, gender text, age integer)");
            //  db.execSQL("delete from kids;");
            InputStream is = this.getResources( ).
                    openRawResource(R.raw.kids);
            Scanner s = new Scanner(is);
            // Throw away first line
            s.nextLine( );
            while(s.hasNextLine( )) {
                String line = s.nextLine( );
                String[ ] fields = line.split(" ");
                ContentValues kidValues = new ContentValues( );
                kidValues.put("name", fields[0]);
                kidValues.put("gender", fields[1]);
                kidValues.put("age", Integer.parseInt(fields[2]));
                db.insert("kids", null, kidValues);
            }

            Cursor cursor = db.query("kids",
                    new String[ ] {"name", "gender", "age"},
                    null, null, null, null, null);

            TextView txtOutput = findViewById(R.id.txt_output);
            cursor.moveToFirst( );
            String output = "";
            do {
                String name = cursor.getString(0);
                String gender = cursor.getString(1);
                int age = cursor.getInt(2);
                output += String.format("%s %s %d\n", name, gender, age);
            } while(cursor.moveToNext( ));
            txtOutput.setText(output);
        }
        catch(SQLiteException e) {
            Toast toast = Toast.makeText(this,
                    "Database not created &", Toast.LENGTH_LONG);
            toast.show( );
        }
    }
}