Java Code Examples for android.database.sqlite.SQLiteDatabase#isReadOnly()
The following examples show how to use
android.database.sqlite.SQLiteDatabase#isReadOnly() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: DataProvider.java From callmeter with GNU General Public License v3.0 | 6 votes |
/** * Run RuleMatcher.unmatch locally. * * @param db {@link SQLiteDatabase} */ private static void unmatch(final SQLiteDatabase db) { Log.d(TAG, "unmatch()"); if (db.isReadOnly()) { Log.e(TAG, "Database is readonly, can not unmatch on upgrade!"); return; } ContentValues cv = new ContentValues(); cv.put(DataProvider.Logs.PLAN_ID, DataProvider.NO_ID); cv.put(DataProvider.Logs.RULE_ID, DataProvider.NO_ID); // reset all but manually set plans db.update(DataProvider.Logs.TABLE, cv, DataProvider.Logs.RULE_ID + " is null or NOT (" + DataProvider.Logs.RULE_ID + " = " + DataProvider.NOT_FOUND + " AND " + DataProvider.Logs.PLAN_ID + " != " + DataProvider.NOT_FOUND + ")", null); cv.clear(); cv.put(DataProvider.Plans.NEXT_ALERT, 0); db.update(DataProvider.Plans.TABLE, cv, null, null); }
Example 2
Source File: Storage.java From NoiseCapture with GNU General Public License v3.0 | 5 votes |
@Override public void onOpen(SQLiteDatabase db) { super.onOpen(db); if (!db.isReadOnly()) { // Enable foreign key constraints db.execSQL(ACTIVATE_FOREIGN_KEY); } }
Example 3
Source File: DbAdapter.java From Onosendai with Apache License 2.0 | 5 votes |
@Override public void onOpen (final SQLiteDatabase db) { super.onOpen(db); if (!db.isReadOnly()) { db.execSQL("PRAGMA foreign_keys=ON;"); this.log.i("foreign_keys=ON"); } }
Example 4
Source File: PacketDatabaseHelper.java From sniffer154 with GNU General Public License v3.0 | 5 votes |
@Override public void onOpen(SQLiteDatabase db) { super.onOpen(db); if (!db.isReadOnly()) { // Enable foreign key constraints db.execSQL("PRAGMA foreign_keys=ON;"); } }
Example 5
Source File: WifiAuthDatabase.java From WiFiAfterConnect with Apache License 2.0 | 5 votes |
@Override public void onOpen(SQLiteDatabase db) { super.onOpen(db); if (!db.isReadOnly()) { // Enable foreign key constraints db.execSQL("PRAGMA foreign_keys=ON;"); } }
Example 6
Source File: LocalyticsProvider.java From ExtensionsPack with MIT License | 5 votes |
@Override public void onOpen(final SQLiteDatabase db) { super.onOpen(db); if (Constants.IS_LOGGABLE) { Log.v(Constants.LOG_TAG, String.format("SQLite library version is: %s", DatabaseUtils.stringForQuery(db, "select sqlite_version()", null))); //$NON-NLS-1$//$NON-NLS-2$ } if (!db.isReadOnly()) { /* * Enable foreign key support */ db.execSQL("PRAGMA foreign_keys = ON;"); //$NON-NLS-1$ // if (Constants.IS_LOGGABLE) // { // try // { // final String result1 = DatabaseUtils.stringForQuery(db, "PRAGMA foreign_keys;", null); //$NON-NLS-1$ // Log.v(Constants.LOG_TAG, String.format("Foreign keys support result was: %s", result1)); //$NON-NLS-1$ // } // catch (final SQLiteDoneException e) // { // Log.w(Constants.LOG_TAG, e); // } // } } }
Example 7
Source File: LocalyticsProvider.java From Beats with BSD 3-Clause "New" or "Revised" License | 5 votes |
@Override public void onOpen(final SQLiteDatabase db) { super.onOpen(db); if (Constants.IS_LOGGABLE) { Log.v(Constants.LOG_TAG, String.format("SQLite library version is: %s", DatabaseUtils.stringForQuery(db, "select sqlite_version()", null))); //$NON-NLS-1$//$NON-NLS-2$ } if (!db.isReadOnly()) { /* * Enable foreign key support */ db.execSQL("PRAGMA foreign_keys = ON;"); //$NON-NLS-1$ // if (Constants.IS_LOGGABLE) // { // try // { // final String result1 = DatabaseUtils.stringForQuery(db, "PRAGMA foreign_keys;", null); //$NON-NLS-1$ // Log.v(Constants.LOG_TAG, String.format("Foreign keys support result was: %s", result1)); //$NON-NLS-1$ // } // catch (final SQLiteDoneException e) // { // Log.w(Constants.LOG_TAG, e); // } // } } }
Example 8
Source File: CPOrmDatabase.java From CPOrm with MIT License | 5 votes |
@TargetApi(Build.VERSION_CODES.JELLY_BEAN) @Override public void onConfigure(SQLiteDatabase db) { super.onConfigure(db); if (!db.isReadOnly()) { db.enableWriteAheadLogging(); } }
Example 9
Source File: DbHelper.java From Material-Movies with Apache License 2.0 | 5 votes |
@Override public void onCreate(SQLiteDatabase db) { if (db.isReadOnly()) { db = getWritableDatabase(); } db.execSQL(DbConstants.Movies.CREATE_SQL); }
Example 10
Source File: QuantumFluxDatabase.java From QuantumFlux with Apache License 2.0 | 5 votes |
@TargetApi(Build.VERSION_CODES.JELLY_BEAN) @Override public void onConfigure(SQLiteDatabase db) { super.onConfigure(db); if (!db.isReadOnly()) { db.enableWriteAheadLogging(); } }
Example 11
Source File: KeyValDatabase.java From GodotSQL with Apache License 2.0 | 5 votes |
@Override public void onCreate(SQLiteDatabase sqLiteDatabase) { if (!sqLiteDatabase.isReadOnly()){ sqLiteDatabase.execSQL("PRAGMA foreign_key=ON"); } // sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS " + // KEYVAL_TABLE_NAME + "(" + KEYVAL_COLUMN_KEY + " TEXT PRIMARY KEY, " + // KEYVAL_COLUMN_VAL + " TEXT)"); sqLiteDatabase.execSQL(CREATE_TABLE_KEYVAL); }
Example 12
Source File: Storage.java From NoiseCapture with GNU General Public License v3.0 | 4 votes |
@Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // Upgrade queries // Do not use static table and column names if(oldVersion == 1) { // Upgrade from 1 to version 2 // Add record length attribute if (!db.isReadOnly()) { db.execSQL("ALTER TABLE record ADD COLUMN time_length INTEGER"); } oldVersion = 2; } if(oldVersion == 2) { // Add gps speed and bearing attribute if (!db.isReadOnly()) { db.execSQL("ALTER TABLE leq ADD COLUMN speed FLOAT"); db.execSQL("ALTER TABLE leq ADD COLUMN bearing FLOAT"); } oldVersion = 3; } if(oldVersion == 3) { if(db.isReadOnly()) { // New feature, user input db.execSQL("ALTER TABLE leq ADD COLUMN description TEXT"); db.execSQL("ALTER TABLE leq ADD COLUMN pleasantness SMALLINT DEFAULT 2"); db.execSQL("ALTER TABLE leq ADD COLUMN photo_miniature BLOB"); db.execSQL("ALTER TABLE leq ADD COLUMN photo_uri TEXT"); db.execSQL( "CREATE TABLE record_tag(tag_id INTEGER PRIMARY KEY, record_id INTEGER, " + "PRIMARY KEY(tag_id, record_id) " + "FOREIGN KEY(record_id) REFERENCES record(record_id) ON DELETE CASCADE);"); } oldVersion = 4; } if(oldVersion == 4) { db.execSQL("ALTER TABLE record_tag ADD COLUMN tag_system_name TEXT"); oldVersion = 5; } if(oldVersion == 5) { // Copy content to new table db.execSQL("ALTER TABLE record rename to record_old;"); db.execSQL( "CREATE TABLE record(record_id INTEGER PRIMARY KEY, record_utc LONG," + " upload_id TEXT, leq_mean FLOAT, time_length INTEGER, description TEXT," + " photo_uri TEXT, pleasantness SMALLINT DEFAULT 2);"); db.execSQL("INSERT INTO record SELECT record_id , record_utc ,upload_id , leq_mean ," + " time_length , description ,photo_uri , pleasantness from record_old;"); db.execSQL("DROP TABLE IF EXISTS record_old;"); oldVersion = 6; } if(oldVersion == 6) { if (!db.isReadOnly()) { db.execSQL("ALTER TABLE record ADD COLUMN calibration_gain FLOAT DEFAULT 0"); } oldVersion = 7; } if(oldVersion == 7) { if(!db.isReadOnly()) { // Up to version 7, there was a swapping of speed and bearing db.execSQL("UPDATE leq SET bearing=speed, speed=bearing;"); } oldVersion = 8; } if(oldVersion == 8) { if(!db.isReadOnly()) { db.execSQL("ALTER TABLE record add column "+Record.COLUMN_NOISEPARTY_TAG + " TEXT"); } oldVersion = 9; } }
Example 13
Source File: Service.java From Twire with GNU General Public License v3.0 | 4 votes |
private static boolean isDbSafe(SQLiteDatabase db) { return db.isOpen() && !db.isReadOnly() && !db.isDbLockedByCurrentThread(); }
Example 14
Source File: DbHelperUtils.java From q-municate-android with Apache License 2.0 | 4 votes |
public static void onOpen(SQLiteDatabase db) { if (!db.isReadOnly()) { // Enable foreign key constraints db.execSQL("PRAGMA foreign_keys=ON;"); } }
Example 15
Source File: DbHelperUtils.java From q-municate-android with Apache License 2.0 | 4 votes |
public static void onOpen(SQLiteDatabase db) { if (!db.isReadOnly()) { // Enable foreign key constraints db.execSQL("PRAGMA foreign_keys=ON;"); } }
Example 16
Source File: SQLiteSDCardHelper.java From android-sdcard-helper with Apache License 2.0 | 4 votes |
private SQLiteDatabase getDatabaseLocked(boolean writable){ if (mDatabase != null) { if (!mDatabase.isOpen()) { // Darn! The user closed the database by calling mDatabase.close(). mDatabase = null; } else if (!writable || !mDatabase.isReadOnly()) { // The database is already open for business. return mDatabase; } } if (mIsInitializing) { throw new IllegalStateException("getDatabase called recursively"); } // If we have a read-only database open, someone could be using it // (though they shouldn't), which would cause a lock to be held on // the file, and our attempts to open the database read-write would // fail waiting for the file lock. To prevent that, we acquire the // lock on the read-only database, which shuts out other users. SQLiteDatabase db = mDatabase; try { mIsInitializing = true; if (db != null) { //close read-only databases, create a new writable if (writable && db.isReadOnly()) { db.close(); } } try { db = openDatabase(SQLiteDatabase.OPEN_READWRITE); } catch (SQLiteException e) { // Couldn't open the DB, let's try to create it. Log.e(TAG, "Couldn't open " + mName + " for writing (will try read-only):", e); // Here if we fail, we propagate the exception to our user. db = openDatabase(SQLiteDatabase.OPEN_READONLY); } onConfigure(db); final int version = db.getVersion(); if (version != mNewVersion) { if (db.isReadOnly()) { throw new SQLiteException("Can't upgrade read-only database from version " + db.getVersion() + " to " + mNewVersion + ": " + mName); } db.beginTransaction(); try { if (version == 0) { onCreate(db); } else { if (version > mNewVersion) { onDowngrade(db, version, mNewVersion); } else { onUpgrade(db, version, mNewVersion); } } db.setVersion(mNewVersion); db.setTransactionSuccessful(); } finally { db.endTransaction(); } } onOpen(db); if (db.isReadOnly()) { Log.w(TAG, "Opened " + mName + " in read-only mode"); } mDatabase = db; return db; }finally { mIsInitializing = false; if (db != null && db != mDatabase) { db.close(); } } }
Example 17
Source File: Service.java From Pocket-Plays-for-Twitch with GNU General Public License v3.0 | 4 votes |
private static boolean isDbSafe(SQLiteDatabase db) { return db.isOpen() && !db.isReadOnly() && !db.isDbLockedByCurrentThread(); }