![]() OpenOrCreateDatabase(File, SQLiteDatabase+ICursorFactory) OpenDatabase(String, SQLiteDatabase+ICursorFactory, DatabaseOpenFlags, IDatabaseErrorHandler) ![]() OpenDatabase(String, SQLiteDatabase+ICursorFactory, DatabaseOpenFlags) Open the database according to the specified OpenParams parameters OpenDatabase(File, SQLiteDatabase+OpenParams) Returns true if the current thread has a transaction pending.Ĭalled by the garbage collector on an object when garbage collectionĭetermines that there are no more references to the object.Ĭalled when the last reference to the object was released byĪ call to #releaseReferenceFromContainer(). General method for inserting a row into the database. InsertWithOnConflict(String, String, ContentValues, Conflict) InsertOrThrow(String, String, ContentValues) Returns a hash code value for the object.Ĭonvenience method for inserting a row into the database. Or any other SQL statement that returns data.Įxecute a single SQL statement that is NOT a SELECT/INSERT/UPDATE/DELETE.įinds the name of the first table, which is editable. Indicates whether some other object is "equal to" this one.Įxecute the given SQL statement on all connections to this database.Įxecute a single SQL statement that is NOT a SELECT This method enables parallel execution of queries from multiple threads on the This method disables the features enabled by #enableWriteAheadLogging(). That may have been created by the database engine. or- Sets the database version.īeginTransactionWithListener(ISQLiteTransactionListener)īeginTransactionWithListenerNonExclusive(ISQLiteTransactionListener)Ĭreates and returns a copy of this object.Ĭompiles an SQL statement into a reusable pre-compiled statement object.ĬreateInMemory(SQLiteDatabase+OpenParams)Ĭonvenience method for deleting rows in the database.ĭeletes a database including its journal file and other auxiliary files This API supports the Mono for Android infrastructure and is not intended to be used directly from your code. Returns true if the current thread is holding an active connection to the database. Runs 'pragma integrity_check' on the given database (and all the attached databases)Īnd returns true if the given database (and all its attached databases) pass integrity_check, The handle to the underlying Android instance. Returns the runtime class of this Object. In OFF sync mode SQLite continues without syncing as soon as it has handed data off Moments, but less often than in FULL mode. The NORMAL sync mode, the SQLite database engine will still sync at the most critical To ensure that all content is safely written to the disk surface prior to continuing. In FULL sync mode the SQLite database engine will use the xSync method of the VFS The EXTRA sync mode is like FULL sync mode with the addition that theĭirectory containing a rollback journal is synced after that journal is unlinked to commit a The pattern) for certain pathological cases. Of SQLite can exhibit O(N^2) performance (where N is the number of characters in The pattern matching algorithm used in the default LIKE and GLOB implementation The WAL journaling mode uses a write-ahead log instead of a rollback journal toĪbsolute max value that can be set by #setMaxSqlCacheSize(int). ![]() The TRUNCATE journaling mode commits transactions by truncating the rollback journal The PERSIST journaling mode prevents the rollback journal from being deleted at the The OFF journaling mode disables the rollback journal completely. The MEMORY journaling mode stores the rollback journal in volatile RAM. The DELETE journaling mode is the normal behavior. ![]() Thus ending the current transaction, and the command aborts with a When a constraint violation occurs, an immediate ROLLBACK occurs, SQLiteDatabase(IntPtr, JniHandleOwnership)Ī constructor used when creating managed representations of JNI objects called by the runtime. Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License. In addition to SQLite's default BINARY collator, Android supplies two more, LOCALIZED, which changes with the system's current locale, and UNICODE, which is the Unicode Collation Algorithm and not tailored to the current locale. See the Notepad sample application in the SDK for an example of creating and managing a database.ĭatabase names must be unique within an application, not across all applications. SQLiteDatabase has methods to create, delete, execute SQL commands, and perform other common database management tasks. Exposes methods to manage a SQLite database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |