// Source code file: PointsDBHelper.java

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

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

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

    @Override
    // This method is only called if the database
    // does not exist.
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table points(" +
            "id integer, xposition float, yposition float);");
        insertStudent(db, 1, 100.0f, 50.0f);
        insertStudent(db, 2, 75.0f, 130.0f);
        insertStudent(db, 3, 230.0f, 300.0f);
        insertStudent(db, 4, 80.0f, 170.0f);
        insertStudent(db, 5, 30.0f, 30.0f);
    }

    private static void insertStudent(SQLiteDatabase db,
        int id, float xposition, float yposition) {

        ContentValues pointValues = new ContentValues();
        pointValues.put("id", id);
        pointValues.put("xposition", xposition);
        pointValues.put("yposition", yposition);
        db.insert("points", null, pointValues);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db,
        int oldVersion, int newVersion) {

        // This method is required, but not used
        // in this example
    }
}