SQLite

Added in 2.5.0

---

Kotlin |Java

public final class SQLite

---

Summary

Constants
static final int	SQLITE_DATA_BLOB = 4 The data type for a BLOB value, i.e. binary data.
static final int	SQLITE_DATA_FLOAT = 2 The data type for a 64-bit IEEE floating point number.
static final int	SQLITE_DATA_INTEGER = 1 The data type for a 64-bit signed integer.
static final int	SQLITE_DATA_NULL = 5 The data type for a NULL value.
static final int	SQLITE_DATA_TEXT = 3 The data type for a String.

Public methods
static final void	execSQL(@NonNull SQLiteConnection receiver, @NonNull String sql) Executes a single SQL statement that returns no values.
static final void	executeSQL(@NonNull SQLiteConnection receiver, @NonNull String sql) Executes a single SQL statement asynchronously that returns no values.
static final @NonNull SQLiteConnection	open(@NonNull SQLiteDriver receiver, @NonNull String fileName) Opens a new database connection.
static final @NonNull SQLiteStatement	prepare(@NonNull SQLiteConnection receiver, @NonNull String sql) Prepares a new SQL statement asynchronously.
static final boolean	step(@NonNull SQLiteStatement receiver) Executes the statement asynchronously and evaluates the next result row if available.
static final @NonNull Void	throwSQLiteException(int errorCode, String errorMsg) Throws a SQLiteException with its message formed by the given errorCode amd errorMsg.

Constants

SQLITE_DATA_BLOB

Artifact: androidx.sqlite:sqlite

View Source

Added in 2.5.0

public static final int SQLITE_DATA_BLOB = 4

The data type for a BLOB value, i.e. binary data.

SQLITE_DATA_FLOAT

Artifact: androidx.sqlite:sqlite

View Source

Added in 2.5.0

public static final int SQLITE_DATA_FLOAT = 2

The data type for a 64-bit IEEE floating point number.

SQLITE_DATA_INTEGER

Artifact: androidx.sqlite:sqlite

View Source

Added in 2.5.0

public static final int SQLITE_DATA_INTEGER = 1

The data type for a 64-bit signed integer.

SQLITE_DATA_NULL

Artifact: androidx.sqlite:sqlite

View Source

Added in 2.5.0

public static final int SQLITE_DATA_NULL = 5

The data type for a NULL value.

SQLITE_DATA_TEXT

Artifact: androidx.sqlite:sqlite

View Source

Added in 2.5.0

public static final int SQLITE_DATA_TEXT = 3

The data type for a String.

Public methods

execSQL

Artifact: androidx.sqlite:sqlite

View Source

Added in 2.5.0

public static final void execSQL(@NonNull SQLiteConnection receiver, @NonNull String sql)

Executes a single SQL statement that returns no values.

executeSQL

Artifact: androidx.sqlite:sqlite

View Source

Added in 2.7.0-alpha01

public static final void executeSQL(@NonNull SQLiteConnection receiver, @NonNull String sql)

Executes a single SQL statement asynchronously that returns no values.

On web targets this function is asynchronous while for non-web it is synchronous.

open

Artifact: androidx.sqlite:sqlite

View Source

public static final @NonNull SQLiteConnection open(@NonNull SQLiteDriver receiver, @NonNull String fileName)

Opens a new database connection.

On web targets this function is asynchronous while for non-web it is synchronous.

prepare

Artifact: androidx.sqlite:sqlite

View Source

public static final @NonNull SQLiteStatement prepare(@NonNull SQLiteConnection receiver, @NonNull String sql)

Prepares a new SQL statement asynchronously.

On web targets this function is asynchronous while for non-web it is synchronous.

step

Artifact: androidx.sqlite:sqlite

View Source

public static final boolean step(@NonNull SQLiteStatement receiver)

Executes the statement asynchronously and evaluates the next result row if available.

On web targets this function is asynchronous while for non-web it is synchronous.

throwSQLiteException

Artifact: androidx.sqlite:sqlite

View Source

Added in 2.5.0

public static final @NonNull Void throwSQLiteException(int errorCode, String errorMsg)

Throws a SQLiteException with its message formed by the given errorCode amd errorMsg.