// StudentsDb1 Example
// Source code file: StudentsDbHelper.java

package it372.smiths.studentdb1;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class StudentsDbHelper extends SQLiteOpenHelper {
    private static final String DB_NAME = "students.db";
    private static final int DB_VERSION = 1;

    public StudentsDbHelper(Context context) {
        super(context, DB_NAME, null, DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table students(" +
                "name text, grade integer, gender text);");
        insertStudent(db, "Alice", 6, "female");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db,
                          int oldVersion, int newVersion) {
        // Body to be added later.
    }

    private static void insertStudent(SQLiteDatabase db,
                                      String name, int grade, String gender) {

        ContentValues studentValues = new ContentValues( );
        studentValues.put("name", name);
        studentValues.put("grade", grade);
        studentValues.put("gender", gender);
        db.insert("students", null, studentValues);
    }
}