X0NnWGgQ

1public class PromocaoDAO  {
2
3private static final String DATABASE_NAME = "app_promocoes.db";
4private static final int VERSAO_BANCO = 2;
5
6private static final String TABLE_PROMOCOES = "fs_promocoes";
7
8public static final String PROMO_ID = "id";
9public static final String PROMO_DESCRICAO = "descricao";
10public static final String PROMO_STATUS = "status";
11public static final String PROMO_INICIO = "inicio";
12public static final String PROMO_TERMINO = "termino";
13
14private DatabaseHelper dbHelper;
15private SQLiteDatabase db;
16
17private final Context mCtx;
18
19private static final String TABELA_PROMO =
20        "CREATE TABLE if not exists " + TABLE_PROMOCOES + " (" +
21                PROMO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
22                PROMO_DESCRICAO + "," +
23                PROMO_INICIO + "," +
24                PROMO_TERMINO + "," +
25                PROMO_STATUS + "," +
26                " UNIQUE (" + PROMO_ID +"));";
27
28
29private static class DatabaseHelper extends SQLiteOpenHelper {
30
31    public DatabaseHelper(Context context) {
32        super(context, DATABASE_NAME, null, VERSAO_BANCO);
33    }
34
35    @Override
36    public void onCreate(SQLiteDatabase db) {
37        db.execSQL(TABELA_PROMO);
38    }
39
40    @Override
41    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
42        db.execSQL("DROP TABLE IF EXISTS " + TABLE_PROMOCOES);
43        onCreate(db);
44    }
45}
46
47public PromocaoDAO(Context ctx){
48    this.mCtx = ctx;
49}
50
51public PromocaoDAO open() throws SQLException{
52    dbHelper = new DatabaseHelper(mCtx);
53    db = dbHelper.getWritableDatabase();
54    return this;
55}
56
57public void close(){
58    if(dbHelper != null){
59        dbHelper.close();
60    }
61}
62
63public long inserirPromocao(String descricapo, String inicio, String termino){
64
65    ContentValues values = new ContentValues();
66    values.put(PROMO_DESCRICAO, descricapo);
67    values.put(PROMO_INICIO, inicio);
68    values.put(PROMO_TERMINO, termino);
69    values.put(PROMO_STATUS, 1);
70
71    return db.insert(TABLE_PROMOCOES, null, values);
72}
73
74public Cursor buscarTodasPromocoes(){
75
76    Cursor mCursor;
77    mCursor = db.query(TABLE_PROMOCOES, new String[] {PROMO_DESCRICAO, PROMO_INICIO, PROMO_TERMINO},null,null,null,null,null);
78    if (mCursor != null){
79        mCursor.moveToFirst();
80    }
81    return mCursor;
82}
83
84public void testeInsertPromocao(){
85    inserirPromocao("PROMOCAO DE NATAL", "10/11/2016", "31/12/2016");
86    inserirPromocao("PROMOCAO DE PESCOA", "10/11/2016", "31/12/2016");
87}