package com.example.ronie.client;

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

/**
 * Created by Ronie on 08/01/15.
 */

public class RecettesSQL extends SQLiteOpenHelper {

    private static final String TABLE_RECETTES = "table_recettes";
    private static final String COL_ID = "ID";
    private static final String COL_TYPE = "TYPE";
    private static final String COL_NOM = "NOM";
    private static final String COL_PRIX = "PRIX";

    private static final String CREATE_BDD = "CREATE TABLE " + TABLE_RECETTES + " ("
            + COL_ID + " INTEGER PRIMARY KEY, " + COL_TYPE + " TEXT NOT NULL, "
            + COL_NOM + " TEXT NOT NULL, " + COL_PRIX + " REAL);";

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

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_BDD);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE " + TABLE_RECETTES + ";");
        onCreate(db);
    }
}