package com.example.weverton.myproject.dao;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import com.example.weverton.myproject.model.Area;
import java.util.ArrayList;
import java.util.List;
public class AreaDAO extends SQLiteOpenHelper {
public AreaDAO(Context context) {
super(context, "AreaPi", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
String sql = "CREATE TABLE Area(id INTEGER PRIMARY KEY, nome TEXT NOT NULL);";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int i, int i1) {
String sql = "DROP TABLE IF EXISTS Area";
db.execSQL(sql);
onCreate(db);
}
public void insereArea(Area area) {
SQLiteDatabase db = getWritableDatabase();
ContentValues dados = new ContentValues();
dados.put("nome",area.getNome());
db.insert("Area",null, dados);
}
public List<Area> buscaArea() {
String sql = "SELECT * FROM Area;";
SQLiteDatabase db = getReadableDatabase();
Cursor c = db.rawQuery(sql,null);
List<Area> areas = new ArrayList<Area>();
while (c.moveToNext()){
Area area = new Area();
area.setId(c.getLong(c.getColumnIndex("id")));
area.setNome(c.getString(c.getColumnIndex("nome")));
areas.add(area);
}
c.close();
return areas;
}
}
