package com.i2m.sqliteeval2;

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

public class MaBaseSQLite extends SQLiteOpenHelper
{
    private static final String TABLE_EVAL = "tableeval";
    private static final String COL_ID = "ID";
    private static final String COL_NOM = "Nom";
    private static final String COL_PRENOM = "Prenom";
    private static final String COL_AGE = "Age";
    private static final String COL_PROF = "Profession";

    private static final String CREATE_BDD = "CREATE TABLE " + TABLE_EVAL + " (" + COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COL_NOM + " TEXT NOT NULL, " + COL_PRENOM + " TEXT NOT NULL, " + COL_AGE + " INTEGER, " + COL_PROF + "TEXT NOT NULL);";

    public MaBaseSQLite(Context context, String name, CursorFactory factory, int version)
    {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db)
    {
        // On crŽe la table ˆ partir de la requ�te Žcrite dans la variable CREATE_BDD
        db.execSQL(CREATE_BDD);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
        // On peut faire ce qu'on veut ici, comme supprimer et recrŽer la table, comme �a lorsqu'on change la version les id partent de 0
        db.execSQL("DROP TABLE " + TABLE_EVAL + ";");
        onCreate(db);
    }
}