public void checkDB() {
if (!db.isOpen()) {
OpenHelper openHelper = new OpenHelper(this.context);
this.db = openHelper.getWritableDatabase();
}
}
/**
* Instantiates a new data helper.
*
* @param context the context
*/
public DataHelper(Context context) {
this.context = context;
OpenHelper openHelper = new OpenHelper(this.context);
this.db = openHelper.getWritableDatabase();
this.insertChatter = this.db.compileStatement(INSERT_CHATTER);
this.insertComment = this.db.compileStatement(INSERT_COMMENT);
}
@Override
public boolean onCreate() {
Context context = getContext();
openHelper = new OpenHelper(context);
mDB = openHelper.getWritableDatabase();
return (mDB == null) ? false : true;
}
public void closeConnection() {
try {
db.close();
openHelper.close();
} catch (Exception e) {
e.printStackTrace();
}
}
@Override
public int delete(Uri uri, String selection, String[] selectionArgs) {
int uriType = ContentDescriptor.uriMatcher.match(uri);
String tableName = ContentDescriptor.getTableName(uriType);
SQLiteDatabase db = dbHelper.getWritableDatabase();
int result = db.delete(tableName, selection, selectionArgs);
getContext().getContentResolver().notifyChange(uri, null);
return result;
}
@Override
public Cursor query(
Uri uri, String[] projection, String selection, String[] selectionArgs, String orderBy) {
int uriType = ContentDescriptor.uriMatcher.match(uri);
String tableName = ContentDescriptor.getTableName(uriType);
SQLiteDatabase db = dbHelper.getReadableDatabase();
Cursor cursor = db.query(tableName, projection, selection, selectionArgs, null, null, orderBy);
cursor.setNotificationUri(getContext().getContentResolver(), uri);
return cursor;
}
private SQLiteDatabase getDatabase() {
if (mDb == null) {
mDb = mOpenHelper.getWritableDatabase();
// Initialize the insert helpers
mStopsInserter = new DatabaseUtils.InsertHelper(mDb, ObaContract.Stops.PATH);
mRoutesInserter = new DatabaseUtils.InsertHelper(mDb, ObaContract.Routes.PATH);
mTripsInserter = new DatabaseUtils.InsertHelper(mDb, ObaContract.Trips.PATH);
mTripAlertsInserter = new DatabaseUtils.InsertHelper(mDb, ObaContract.TripAlerts.PATH);
mFilterInserter = new DatabaseUtils.InsertHelper(mDb, ObaContract.StopRouteFilters.PATH);
mServiceAlertsInserter = new DatabaseUtils.InsertHelper(mDb, ObaContract.ServiceAlerts.PATH);
mRegionsInserter = new DatabaseUtils.InsertHelper(mDb, ObaContract.Regions.PATH);
mRegionBoundsInserter = new DatabaseUtils.InsertHelper(mDb, ObaContract.RegionBounds.PATH);
}
return mDb;
}
@Override
public Uri insert(Uri uri, ContentValues contentValues) {
int uriType = ContentDescriptor.uriMatcher.match(uri);
String tableName = ContentDescriptor.getTableName(uriType);
SQLiteDatabase db = dbHelper.getWritableDatabase();
long id =
db.insertWithOnConflict(tableName, null, contentValues, SQLiteDatabase.CONFLICT_IGNORE);
getContext().getContentResolver().notifyChange(uri, null);
if (TextUtils.equals(tableName, ContentDescriptor.Toys.TABLE_NAME)) {
return Uri.parse(ContentDescriptor.Toys.TABLE_URI + "/" + id);
} else {
return null;
}
}
@Override
public int update(
Uri uri, ContentValues contentValues, String selection, String[] selectionArgs) {
int uriType = ContentDescriptor.uriMatcher.match(uri);
String tableName = ContentDescriptor.getTableName(uriType);
SQLiteDatabase db = dbHelper.getWritableDatabase();
int result;
try {
result = db.update(tableName, contentValues, selection, selectionArgs);
} catch (Throwable e) {
Log.e(MyContentProvider.class.getSimpleName(), "Unable to update SQLiteDatabase");
result = 0;
}
return result;
}
@Override
public boolean onCreate() {
dbHelper = OpenHelper.getInstance(getContext());
return true;
}
public SqlHelper(Context context) {
this.context = context;
OpenHelper openHelper = new OpenHelper(this.context);
this.db = openHelper.getWritableDatabase();
}
private DataHelper(Context context) {
OpenHelper openHelper = new OpenHelper(context);
this.db = openHelper.getWritableDatabase();
}
public BancoDeDadosDao(Context context) {
OpenHelper auxBd = new OpenHelper(context);
bd = auxBd.getWritableDatabase();
}
//
// Closes the database
//
public void closeDB() {
mOpenHelper.close();
mDb = null;
}
public void CreateDB() {
OpenHelper openHelper = new OpenHelper(this.context);
this.db = openHelper.getWritableDatabase();
}
public SqliteManager(Context context) {
this.context = context;
OpenHelper oh = new OpenHelper(context);
db = oh.getWritableDatabase();
}
public Database(Context c) {
this.context = c;
OpenHelper o = new OpenHelper(this.context);
db = o.getWritableDatabase();
}
