Capitulo 40 ➜ Creación de la DB dbpizza

Base de datos para el carrito de compra

package codea.app.pizzeria9.database;

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

import androidx.annotation.Nullable;

public class DbHelper extends SQLiteOpenHelper {
    // DB
    private  static  final  String DB_NAME = "dbpizza";
    private  static  final  int DB_VERSION = 1;

    //tabla atributos
    public static final String TABLE = "carrito";
    public static final String ID = "_id";
    public static final String NOMBRE = "nombre";
    public static final String PRECIO = "precio";
    public static final String CANTIDAD = "cantidad";
    public static final String TAMANO = "tamano";
    public static final String IMPORTE = "importe";
    public static final String FOTO = "foto";
    public static final String PRODUCTO_ID = "producto_id";
    // create table
    public static final String TABLE_CREATE=
            "CREATE TABLE "+TABLE+"("+
                    ID+" integer primary key autoincrement,"+
                    NOMBRE+" text not null,"+
                    PRECIO+" real not null,"+
                    CANTIDAD+" integer not null,"+
                    TAMANO+" text null,"+
                    IMPORTE+" real not null,"+
                    FOTO+" text not null,"+
                    PRODUCTO_ID+" integer not null);";

    public DbHelper(@Nullable Context context) {
        super(context, DB_NAME, null, DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        sqLiteDatabase.execSQL(TABLE_CREATE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
        sqLiteDatabase.execSQL(" DROP TABLE IF EXISTS "+TABLE);
    }
}