RDB
Overview
The relational database (RDB) store manages data based on relational models. The RDB store provides a complete mechanism for managing local databases based on the underlying SQLite. It provides a series of methods for performing operations, such as adding, deleting, modifying, and querying data, and supports direct execution of SQL statements to satisfy different needs in complicated scenarios.
System capability: SystemCapability.DistributedDataManager.RelationalStore.Core
Since: 10
Summary
Files
Name | Description |
---|---|
oh_cursor.h | Defines APIs for accessing the result set obtained by querying the RDB store. File to include: <database/rdb/oh_cursor.h> Library: libnative_rdb_ndk.z.so |
oh_predicates.h | Defines the predicates for RDB stores. File to include: <database/rdb/oh_predicates.h> Library: libnative_rdb_ndk.z.so |
oh_value_object.h | Defines the APIs for type conversion. File to include: <database/rdb/oh_value_object.h> Library: libnative_rdb_ndk.z.so |
oh_values_bucket.h | Defines the types of the key and value in a key-value (KV) pair. File to include: <database/rdb/oh_values_bucket.h> Library: libnative_rdb_ndk.z.so |
relational_store.h | Defines APIs for managing an RDB store. File to include: <database/rdb/relational_store.h> Library: libnative_rdb_ndk.z.so |
relational_store_error_code.h | Defines the error codes used for RDB stores. File to include: <database/rdb/relational_store_error_code.h> Library: libnative_rdb_ndk.z.so |
Structs
Name | Description |
---|---|
OH_Cursor | Defines a result set. |
OH_Predicates | Defines a predicates object. |
OH_VObject | Defines the allowed data field types. |
OH_VBucket | Defines the types of the key and value in a KV pair. |
OH_Rdb_Config | Defines the RDB store configuration. |
OH_Rdb_Store | Defines the RDB store type. |
Rdb_DistributedConfig | Defines the distributed configuration of a table. |
Rdb_KeyInfo | Defines the primary key or row number of the row that changes. |
Rdb_KeyInfo::Rdb_KeyData | Defines the changed data. |
Rdb_ChangeInfo | Defines the details about the device-cloud sync process. |
Rdb_SubscribeCallback | Defines a callback used to return the subscribed event. |
Rdb_DataObserver | Defines the data observer. |
Rdb_Statistic | Defines the device-cloud sync statistics of a database table. |
Rdb_TableDetails | Defines the statistics of device-cloud upload and download tasks of a database table. |
Rdb_ProgressDetails | Defines the statistics of the overall device-cloud sync (upload and download) tasks of an RDB store. |
Rdb_ProgressObserver | Defines the observer of the device-cloud sync progress. |
Macros
Name | Description |
---|---|
DISTRIBUTED_CONFIG_VERSION 1 | Version of Rdb_DistributedConfig. |
DISTRIBUTED_CHANGE_INFO_VERSION 1 | Version of Rdb_ChangeInfo. |
DISTRIBUTED_PROGRESS_DETAIL_VERSION 1 | Version of Rdb_ProgressDetails. |
Types
Name | Description |
---|---|
OH_ColumnType | Defines an enum for the field types in an RDB store. |
OH_Cursor | Defines a struct for a result set. |
OH_OrderType | Defines an enum for sorting types. |
OH_Predicates | Defines a predicates object. |
OH_VObject | Defines a struct for allowed data field types. |
OH_VBucket | Defines a struct for the types of the key and value in a KV pair. |
OH_Rdb_SecurityLevel | Defines an enum for RDB store security levels. |
Rdb_SecurityArea | Defines an enum for security area levels of an RDB store. |
Rdb_DistributedType | Defines an enum for distributed types. |
Rdb_DistributedConfig | Defines a struct for distributed configuration of a table. |
Rdb_ChangeType | Defines an enum for data change types. |
Rdb_KeyInfo | Defines a struct for the primary key or row number of the row that changes. |
Rdb_ChangeInfo | Defines a struct for the details about the device-cloud sync process. |
Rdb_SubscribeType | Defines an enum for subscription types. |
Rdb_BriefObserver | Defines a callback used to return the device-cloud data change event. |
Rdb_DetailsObserver | Defines a callback used to return the details about the device-cloud data change. |
Rdb_SubscribeCallback | Defines a callback used to return the subscribed event. |
Rdb_DataObserver | Defines a struct for the data observer. |
Rdb_SyncMode | Defines an enum for RDB store sync modes. |
Rdb_Statistic | Defines a struct for the device-cloud sync statistics of a database table. |
Rdb_TableDetails | Defines a struct for statistics of device-cloud upload and download tasks of a database table. |
Rdb_Progress | Defines an enum for device-cloud sync progresses. |
Rdb_ProgressCode | Defines an enum for device-cloud sync states. |
Rdb_ProgressDetails | Defines a struct for statistics of the overall device-cloud sync (upload and download) tasks of an RDB store. |
Rdb_ProgressCallback | Defines a callback used to return the device-cloud sync progress. |
Rdb_SyncCallback | Defines a callback for device-cloud sync. |
Rdb_ProgressObserver | Defines the observer of the device-cloud sync progress. |
OH_Rdb_ErrCode | Defines an enum for error codes. |
Enums
Name | Description |
---|---|
OH_ColumnType { TYPE_NULL = 0, TYPE_INT64, TYPE_REAL, TYPE_TEXT, TYPE_BLOB, TYPE_ASSET, TYPE_ASSETS } |
Enumerates the types of the fields in an RDB store. |
OH_OrderType { ASC = 0, DESC = 1 } | Enumerates the sorting types. |
OH_Rdb_SecurityLevel { S1 = 1, S2, S3, S4 } | Enumerates the RDB store security levels. |
Rdb_SecurityArea { RDB_SECURITY_AREA_EL1 = 1, RDB_SECURITY_AREA_EL2, RDB_SECURITY_AREA_EL3, RDB_SECURITY_AREA_EL4 } | Enumerates the security area levels of an RDB store. |
Rdb_DistributedType { RDB_DISTRIBUTED_CLOUD } | Enumerates the distributed types. |
Rdb_ChangeType { RDB_DATA_CHANGE, RDB_ASSET_CHANGE } | Enumerates the data change types. |
Rdb_SubscribeType { RDB_SUBSCRIBE_TYPE_CLOUD, RDB_SUBSCRIBE_TYPE_CLOUD_DETAILS } | Enumerates the subscription types. |
Rdb_SyncMode { RDB_SYNC_MODE_TIME_FIRST, RDB_SYNC_MODE_NATIVE_FIRST, RDB_SYNC_MODE_CLOUD_FIRST } | Enumerates the RDB sync modes. |
Rdb_Progress { RDB_SYNC_BEGIN, RDB_SYNC_IN_PROGRESS, RDB_SYNC_FINISH } | Enumerates the device-cloud sync progresses. |
Rdb_ProgressCode { RDB_SUCCESS, RDB_UNKNOWN_ERROR, RDB_NETWORK_ERROR, RDB_CLOUD_DISABLED, RDB_LOCKED_BY_OTHERS, RDB_RECORD_LIMIT_EXCEEDED, RDB_NO_SPACE_FOR_ASSET } |
Enumerates the device-cloud sync states. |
OH_Rdb_ErrCode { RDB_ERR = -1, RDB_OK = 0, E_BASE = 14800000, RDB_E_NOT_SUPPORTED = 801, RDB_E_ERROR = E_BASE, RDB_E_INVALID_ARGS = (E_BASE + 1), RDB_E_CANNOT_UPDATE_READONLY = (E_BASE + 2), RDB_E_REMOVE_FILE = (E_BASE + 3), RDB_E_EMPTY_TABLE_NAME = (E_BASE + 5), RDB_E_EMPTY_VALUES_BUCKET = (E_BASE + 6), RDB_E_EXECUTE_IN_STEP_QUERY = (E_BASE + 7), RDB_E_INVALID_COLUMN_INDEX = (E_BASE + 8), RDB_E_INVALID_COLUMN_TYPE = (E_BASE + 9), RDB_E_EMPTY_FILE_NAME = (E_BASE + 10), RDB_E_INVALID_FILE_PATH = (E_BASE + 11), RDB_E_TRANSACTION_IN_EXECUTE = (E_BASE + 12), RDB_E_INVALID_STATEMENT = (E_BASE + 13), RDB_E_EXECUTE_WRITE_IN_READ_CONNECTION = (E_BASE + 14), RDB_E_BEGIN_TRANSACTION_IN_READ_CONNECTION = (E_BASE + 15), RDB_E_NO_TRANSACTION_IN_SESSION = (E_BASE + 16), RDB_E_MORE_STEP_QUERY_IN_ONE_SESSION = (E_BASE + 17), RDB_E_NO_ROW_IN_QUERY = (E_BASE + 18), RDB_E_INVALID_BIND_ARGS_COUNT = (E_BASE + 19), RDB_E_INVALID_OBJECT_TYPE = (E_BASE + 20), RDB_E_INVALID_CONFLICT_FLAG = (E_BASE + 21), RDB_E_HAVING_CLAUSE_NOT_IN_GROUP_BY = (E_BASE + 22), RDB_E_NOT_SUPPORTED_BY_STEP_RESULT_SET = (E_BASE + 23), RDB_E_STEP_RESULT_SET_CROSS_THREADS = (E_BASE + 24), RDB_E_STEP_RESULT_QUERY_NOT_EXECUTED = (E_BASE + 25), RDB_E_STEP_RESULT_IS_AFTER_LAST = (E_BASE + 26), RDB_E_STEP_RESULT_QUERY_EXCEEDED = (E_BASE + 27), RDB_E_STATEMENT_NOT_PREPARED = (E_BASE + 28), RDB_E_EXECUTE_RESULT_INCORRECT = (E_BASE + 29), RDB_E_STEP_RESULT_CLOSED = (E_BASE + 30), RDB_E_RELATIVE_PATH = (E_BASE + 31), RDB_E_EMPTY_NEW_ENCRYPT_KEY = (E_BASE + 32), RDB_E_CHANGE_UNENCRYPTED_TO_ENCRYPTED = (E_BASE + 33), RDB_E_CHANGE_ENCRYPT_KEY_IN_BUSY = (E_BASE + 34), RDB_E_STEP_STATEMENT_NOT_INIT = (E_BASE + 35), RDB_E_NOT_SUPPORTED_ATTACH_IN_WAL_MODE = (E_BASE + 36), RDB_E_CREATE_FOLDER_FAIL = (E_BASE + 37), RDB_E_SQLITE_SQL_BUILDER_NORMALIZE_FAIL = (E_BASE + 38), RDB_E_STORE_SESSION_NOT_GIVE_CONNECTION_TEMPORARILY = (E_BASE + 39), RDB_E_STORE_SESSION_NO_CURRENT_TRANSACTION = (E_BASE + 40), RDB_E_NOT_SUPPORT = (E_BASE + 41), RDB_E_INVALID_PARCEL = (E_BASE + 42), RDB_E_QUERY_IN_EXECUTE = (E_BASE + 43), RDB_E_SET_PERSIST_WAL = (E_BASE + 44), RDB_E_DB_NOT_EXIST = (E_BASE + 45), RDB_E_ARGS_READ_CON_OVERLOAD = (E_BASE + 46), RDB_E_WAL_SIZE_OVER_LIMIT = (E_BASE + 47), RDB_E_CON_OVER_LIMIT = (E_BASE + 48) } |
Enumerates the RDB store error codes. |
Functions
Name | Description |
---|---|
OH_VBucket_PutAsset (OH_VBucket *bucket, const char *field, OH_Asset *value) | Puts an OH_Asset object into the OH_VBucket object with the given column name. |
OH_VBucket_PutAssets (OH_VBucket *bucket, const char *field, OH_Asset **value, int count) | Puts an array of OH_Asset objects into the OH_VBucket object with the given column name. |
OH_Rdb_CreateValueObject () | Creates an OH_VObject instance. |
OH_Rdb_CreateValuesBucket () | Creates an OH_VBucket instance. |
OH_Rdb_CreatePredicates (const char *table) | Creates an OH_Predicates instance. |
OH_Rdb_GetOrOpen (const OH_Rdb_Config *config, int *errCode) | Obtains an OH_Rdb_Store instance for RDB store operations. |
OH_Rdb_CloseStore (OH_Rdb_Store *store) | Closes an OH_Rdb_Store object to reclaim the memory occupied. |
OH_Rdb_DeleteStore (const OH_Rdb_Config *config) | Deletes an RDB store with the specified database file configuration. |
OH_Rdb_Insert (OH_Rdb_Store *store, const char *table, OH_VBucket *valuesBucket) | Inserts a row of data into a table. |
OH_Rdb_Update (OH_Rdb_Store *store, OH_VBucket *valuesBucket, OH_Predicates *predicates) | Updates data in an RDB store based on specified conditions. |
OH_Rdb_Delete (OH_Rdb_Store *store, OH_Predicates *predicates) | Deletes data from an RDB store based on specified conditions. |
OH_Rdb_Query (OH_Rdb_Store *store, OH_Predicates *predicates, const char *const *columnNames, int length) | Queries data in an RDB store based on specified conditions. |
OH_Rdb_Execute (OH_Rdb_Store *store, const char *sql) | Executes an SQL statement but returns no value. |
OH_Rdb_ExecuteQuery (OH_Rdb_Store *store, const char *sql) | Executes the SQL statement to query data in an RDB store. |
OH_Rdb_BeginTransaction (OH_Rdb_Store *store) | Starts the transaction before executing the SQL statement. |
OH_Rdb_RollBack (OH_Rdb_Store *store) | Rolls back the SQL statements executed. |
OH_Rdb_Commit (OH_Rdb_Store *store) | Commits the executed SQL statements. |
OH_Rdb_Backup (OH_Rdb_Store *store, const char *databasePath) | Backs up an RDB store in the specified directory. |
OH_Rdb_Restore (OH_Rdb_Store *store, const char *databasePath) | Restores an RDB store from the specified database backup file. |
OH_Rdb_GetVersion (OH_Rdb_Store *store, int *version) | Obtains the RDB store version. |
OH_Rdb_SetVersion (OH_Rdb_Store *store, int version) | Sets the RDB store version. |
OH_Rdb_SetDistributedTables (OH_Rdb_Store *store, const char *tables[], uint32_t count, Rdb_DistributedType type, const Rdb_DistributedConfig *config) | Sets distributed database tables. |
OH_Rdb_FindModifyTime (OH_Rdb_Store *store, const char *tableName, const char *columnName, OH_VObject *values) | Obtains the last modification time of a table in an RDB store. |
OH_Rdb_Subscribe (OH_Rdb_Store *store, Rdb_SubscribeType type, const Rdb_DataObserver *observer) | Register an observer for an RDB store. When data in the RDB store changes, a callback will be invoked to return the data changes. |
OH_Rdb_Unsubscribe (OH_Rdb_Store *store, Rdb_SubscribeType type, const Rdb_DataObserver *observer) | Unregisters the observer of the specified type. |
OH_Rdb_GetTableDetails (Rdb_ProgressDetails *progress, int32_t version) | Obtains the device-cloud sync statistics of a table. |
OH_Rdb_CloudSync (OH_Rdb_Store *store, Rdb_SyncMode mode, const char *tables, int count, const Rdb_ProgressObserver *observer) | Performs device-cloud sync. |
OH_Rdb_SubscribeAutoSyncProgress (OH_Rdb_Store *store, const Rdb_ProgressObserver *observer) | Subscribes to the automatic sync progress of an RDB store. The registered callback will be invoked to return the automatic sync progress. |
OH_Rdb_UnsubscribeAutoSyncProgress (OH_Rdb_Store *store, const Rdb_ProgressObserver *observer) | Unsubscribes from the automatic sync process of an RDB store. |
Variables
Name | Description |
---|---|
OH_Cursor::id | Unique identifier of the OH_Cursor struct. |
OH_Cursor::getColumnCount | Pointer to the function used to obtain the number of columns in the result set. |
OH_Cursor::getColumnType | Pointer to the function used to obtain the column type based on the specified column index. |
OH_Cursor::getColumnIndex | Pointer to the function used to obtain the column index based on the specified column name. |
OH_Cursor::getColumnName | Pointer to the function used to obtain the column name based on the specified column index. |
OH_Cursor::getRowCount | Pointer to the function used to obtain the number of rows in the result set. |
OH_Cursor::goToNextRow | Pointer to the function used to go to the next row of the result set. |
OH_Cursor::getSize | Pointer to the function used to obtain information about the memory required when the column data type in the result set is BLOB or TEXT. |
OH_Cursor::getText | Pointer to the function used to obtain the value of the string type based on the specified column and the current row. |
OH_Cursor::getInt64 | Pointer to the function used to obtain the value of the int64_t type based on the specified column and the current row. |
OH_Cursor::getReal | Pointer to the function used to obtain the value of the double type based on the specified column and the current row. |
OH_Cursor::getBlob | Pointer to the function used to obtain the values in the form of a byte array based on the specified column and the current row. |
OH_Cursor::isNull | Pointer to the function used to check whether the value in the specified column is null. |
OH_Cursor::destroy | Pointer to the function used to destroy a result set. |
OH_Cursor::getAsset | Pointer to the function used to obtain the value of the asset type based on the specified column and the current row. |
OH_Cursor::getAssets | Pointer to the function used to obtain the values in the form of an asset array based on the specified column and the current row. |
OH_Predicates::id | Unique identifier of the OH_Predicates struct. |
OH_Predicates::equalTo | Pointer to the function used to set a predicates object to match the field whose value is equal to the specified value. |
OH_Predicates::notEqualTo | Pointer to the function used to set a predicates object to match the field whose value is not equal to the specified value. |
OH_Predicates::beginWrap | Pointer to the function used to add a left parenthesis to the predicates. |
OH_Predicates::endWrap | Pointer to the function used to add a right parenthesis to the predicates. |
OH_Predicates::orOperate | Pointer to the function used to add the OR operator to the predicates. |
OH_Predicates::andOperate | Pointer to the function used to add the AND operator to the predicates. |
OH_Predicates::isNull | Pointer to the function used to set a predicates object to match the field whose value is null. |
OH_Predicates::isNotNull | Pointer to the function used to set a predicates object to match the field whose value is not null. |
OH_Predicates::like | Pointer to the function used to set a predicates object to match a string that is similar to the specified value. |
OH_Predicates::between | Pointer to the function used to set a predicates object to match the field whose value is within the specified range. |
OH_Predicates::notBetween | Pointer to the function used to set a predicates object to match the field whose value is out of the specified range. |
OH_Predicates::greaterThan | Pointer to the function used to set a predicates object to match the field with value greater than the specified value. |
OH_Predicates::lessThan | Pointer to the function used to set a predicates object to match the field with value less than the specified value. |
OH_Predicates::greaterThanOrEqualTo | Pointer to the function used to set a predicates object to match the field with value greater than or equal to the specified value. |
OH_Predicates::lessThanOrEqualTo | Pointer to the function used to set a predicates object to match the field with value less than or equal to the specified value. |
OH_Predicates::orderBy | Pointer to the function used to set a predicates object to sort the values in a column in ascending or descending order. |
OH_Predicates::distinct | Pointer to the function used to set a predicates object to filter out duplicate records. |
OH_Predicates::limit | Pointer to the function used to set a predicates object to specify the maximum number of records. |
OH_Predicates::offset | Pointer to the function used to set a predicates object to specify the start position of the returned result. |
OH_Predicates::groupBy | Pointer to the function used to set a predicates object to group rows that have the same value into summary rows. |
OH_Predicates::in | Pointer to the function used to set a predicates object to match the field with the value within the specified range. |
OH_Predicates::notIn | Pointer to the function used to set a predicates object to match the field with the value out of the specified range. |
OH_Predicates::clear | Pointer to the function used to clear a predicates instance. |
OH_Predicates::destroy | Pointer to the function used to destroy an OH_Predicates object to reclaim the memory occupied. |
OH_VObject::id | Unique identifier of the OH_VObject struct. |
OH_VObject::putInt64 | Pointer to the function used to convert a single parameter or an array of the int64 type into a value of the OH_VObject type. |
OH_VObject::putDouble | Pointer to the function used to convert a single parameter or an array of the double type into a value of the OH_VObject type. |
OH_VObject::putText | Pointer to the function used to convert a character array of the char type to a value of the OH_VObject type. |
OH_VObject::putTexts | Pointer to the function used to convert a string array of the char type to a value of the OH_VObject type. |
OH_VObject::destroy | Pointer to the function used to destroy an OH_VObject object to reclaim the memory occupied. |
OH_VBucket::id | Unique identifier of the OH_VBucket struct. |
OH_VBucket::capability | Number of the KV pairs in the struct. |
OH_VBucket::putText | Pointer to the function used to put a char value into the OH_VBucket object in the given column. |
OH_VBucket::putInt64 | Pointer to the function used to put an int64_t value into the OH_VBucket object in the given column. |
OH_VBucket::putReal | Pointer to the function used to put a double value into the {OH_VBucket} object in the given column. |
OH_VBucket::putBlob | Pointer to the function used to put a const uint8_t value into the OH_VBucket object in the given column. |
OH_VBucket::putNull | Pointer to the function used to put a null value into the OH_VBucket object in the given column. |
OH_VBucket::clear | Pointer to the function used to clear an OH_VBucket object. |
OH_VBucket::destroy | Pointer to the function used to destroy an OH_VBucket object to reclaim the memory occupied. |
OH_Rdb_Config::selfSize | Size of the struct. |
OH_Rdb_Config::dataBaseDir | Path of the database file. |
OH_Rdb_Config::storeName | Name of the RDB store. |
OH_Rdb_Config::bundleName | Bundle name. |
OH_Rdb_Config::moduleName | Module name. |
OH_Rdb_Config::isEncrypt | Whether to encrypt the RDB store. |
OH_Rdb_Config::securityLevel | RDB store security level. For details, see OH_Rdb_SecurityLevel. |
OH_Rdb_Config::area | Security area level. For details, see Rdb_SecurityArea. |
OH_Rdb_Store::id | Unique identifier of the OH_Rdb_Store struct. |
Rdb_DistributedConfig::version | Version of the Rdb_DistributedConfig struct. |
Rdb_DistributedConfig::isAutoSync | Whether the table supports automatic sync. |
Rdb_KeyInfo::count | Number of the changed primary keys or row numbers. |
Rdb_KeyInfo::type | Type (OH_ColumnType) of the primary key. |
Rdb_KeyInfo::Rdb_KeyData::integer | Data of the uint64_t type. |
Rdb_KeyInfo::Rdb_KeyData::real | Data of the double type. |
Rdb_KeyInfo::Rdb_KeyData::text | Data of the char * type. |
Rdb_KeyInfo::data | Changed data. |
Rdb_ChangeInfo::version | Version of the Rdb_DistributedConfig struct. |
Rdb_ChangeInfo::tableName | Name of the table with data changes. |
Rdb_ChangeInfo::ChangeType | Type of the data changed, which can be data or asset. |
Rdb_ChangeInfo::inserted | Location where data is inserted. If the primary key of the table is of the string type, the value is the value of the primary key. Otherwise, the value is the row number of the inserted data. |
Rdb_ChangeInfo::updated | Location where data is updated. If the primary key of the table is of the string type, the value is the value of the primary key. Otherwise, the value is the row number of the updated data. |
Rdb_ChangeInfo::deleted | Location where data is deleted. If the primary key of the table is of the string type, the value is the value of the primary key. Otherwise, the value is the row number of the deleted data. |
Rdb_SubscribeCallback::detailsObserver | Callback used to return the details about the device-cloud data change. |
Rdb_SubscribeCallback::briefObserver | Callback used to return the device-cloud data change event. |
Rdb_DataObserver::context | Context of the data observer. |
Rdb_DataObserver::callback | Callback invoked to return the result. |
Rdb_Statistic::total | Total number of rows to be synchronized between the device and cloud in the database table. |
Rdb_Statistic::successful | Number of rows that are successfully synchronized between the device and cloud in the database table. |
Rdb_Statistic::failed | Number of rows that failed to be synchronized between the device and cloud in the database table. |
Rdb_Statistic::remained | Number of rows that are not executed for device-cloud sync in the database table. |
Rdb_TableDetails::table | Database table name. |
Rdb_TableDetails::upload | Statistics of the device-cloud upload tasks. |
Rdb_TableDetails::download | Statistics of the device-cloud download tasks. |
Rdb_ProgressDetails::version | Version of the OH_TableDetails struct. |
Rdb_ProgressDetails::schedule | Device-cloud sync process. |
Rdb_ProgressDetails::code | Device-cloud sync state. |
Rdb_ProgressDetails::tableLength | Number of the tables synchronized between the device and cloud. |
Rdb_ProgressObserver::context | Context of the device-cloud sync progress observer. |
Rdb_ProgressObserver::callback | Callback invoked to return the device-cloud sync progress. |
Macro Description
DISTRIBUTED_CHANGE_INFO_VERSION
#define DISTRIBUTED_CHANGE_INFO_VERSION 1
Description
Version of Rdb_ChangeInfo.
Since: 11
DISTRIBUTED_CONFIG_VERSION
#define DISTRIBUTED_CONFIG_VERSION 1
Description
Version of Rdb_DistributedConfig.
Since: 11
DISTRIBUTED_PROGRESS_DETAIL_VERSION
#define DISTRIBUTED_PROGRESS_DETAIL_VERSION 1
Description
Version of OH_ProgressDetails.
Since: 11
Type Description
OH_ColumnType
typedef enum OH_ColumnType OH_ColumnType
Description
Defines an enum for the types of the fields in an RDB store.
Since: 10
OH_Cursor
typedef struct OH_Cursor OH_Cursor
Description
Defines a struct for a result set.
APIs are provided to access the result set obtained by querying the RDB store.
Since: 10
OH_OrderType
typedef enum OH_OrderType OH_OrderType
Description
Defines an enum for sorting types.
Since: 10
OH_Predicates
typedef struct OH_Predicates OH_Predicates
Description
Defines a predicates object.
Since: 10
OH_Rdb_ErrCode
typedef enum OH_Rdb_ErrCode OH_Rdb_ErrCode
Description
Defines an enum for error codes.
Since: 10
OH_Rdb_SecurityLevel
typedef enum OH_Rdb_SecurityLevel OH_Rdb_SecurityLevel
Description
Defines an enum for RDB store security levels.
Since: 10
OH_VBucket
typedef struct OH_VBucket OH_VBucket
Description
Defines a struct for the types of the key and value in a KV pair.
Since: 10
OH_VObject
typedef struct OH_VObject OH_VObject
Description
Defines a struct for allowed data types.
Since: 10
Rdb_BriefObserver
typedef void(* Rdb_BriefObserver) (void *context, const char *values[], uint32_t count)
Description
Defines a callback used to return the device-cloud data change event.
Since: 11
Parameters
Name | Description |
---|---|
context | Pointer to the context of the data observer. |
values | Pointer to the accounts whose device-cloud data is changed. |
count | Number of accounts whose device-cloud data is changed. |
Rdb_ChangeInfo
typedef struct Rdb_ChangeInfo Rdb_ChangeInfo
Description
Defines a struct for the details about the device-cloud sync process.
Since: 11
Rdb_ChangeType
typedef enum Rdb_ChangeType Rdb_ChangeType
Description
Defines an enum for data change types.
Since: 11
Rdb_DataObserver
typedef struct Rdb_DataObserver Rdb_DataObserver
Description
Defines a struct for the data observer.
Since: 11
Rdb_DetailsObserver
typedef void(* Rdb_DetailsObserver) (void *context, const Rdb_ChangeInfo **changeInfo, uint32_t count)
Description
Defines a callback used to return the details about the device-cloud data change.
Since: 11
Parameters
Name | Description |
---|---|
context | Pointer to the context of the data observer. |
changeInfo | Pointer to Rdb_ChangeInfo. |
count | Number of changed tables. |
See
Rdb_DistributedConfig
typedef struct Rdb_DistributedConfig Rdb_DistributedConfig
Description
Defines a struct for distributed configuration of a table.
Since: 11
Rdb_DistributedType
typedef enum Rdb_DistributedType Rdb_DistributedType
Description
Defines an enum for distributed types.
Since: 11
Rdb_KeyInfo
typedef struct Rdb_KeyInfo Rdb_KeyInfo
Description
Defines a struct for the primary key or row number of the row that changes.
Since: 11
Rdb_Progress
typedef enum Rdb_Progress Rdb_Progress
Description
Defines an enum for device-cloud sync progresses.
Since: 11
Rdb_ProgressCallback
typedef void(* Rdb_ProgressCallback) (void *context, Rdb_ProgressDetails *progressDetails)
Description
Defines a callback used to return the device-cloud sync progress.
Since: 11
Parameters
Name | Description |
---|---|
progressDetails | Details about the device-cloud sync progress. |
See
Rdb_ProgressCode
typedef enum Rdb_ProgressCode Rdb_ProgressCode
Description
Defines an enum for device-cloud sync states.
Since: 11
Rdb_ProgressDetails
typedef struct Rdb_ProgressDetails Rdb_ProgressDetails
Description
Defines a struct for statistics of the overall device-cloud sync (upload and download) tasks of an RDB store.
Since: 11
Rdb_ProgressObserver
typedef struct Rdb_ProgressObserver Rdb_ProgressObserver
Description
Defines a struct for the observer for the device-cloud sync progress.
Since: 11
Rdb_SecurityArea
typedef enum Rdb_SecurityArea Rdb_SecurityArea
Description
Defines an enum for security area levels of an RDB store.
Since: 11
Rdb_Statistic
typedef struct Rdb_Statistic Rdb_Statistic
Description
Defines a struct for the device-cloud sync statistics of a database table.
Since: 11
Rdb_SubscribeCallback
typedef union Rdb_SubscribeCallback Rdb_SubscribeCallback
Description
Defines a callback used to return the subscribed event.
Since: 11
Rdb_SubscribeType
typedef enum Rdb_SubscribeType Rdb_SubscribeType
Description
Defines an enum for subscription types.
Since: 11
Rdb_SyncCallback
typedef void(* Rdb_SyncCallback) (Rdb_ProgressDetails *progressDetails)
Description
Defines a callback for device-cloud sync.
Since: 11
Parameters
Name | Description |
---|---|
progressDetails | Statistics of device-cloud sync. |
See
Rdb_SyncMode
typedef enum Rdb_SyncMode Rdb_SyncMode
Description
Defines an enum for RDB sync modes.
Since: 11
Rdb_TableDetails
typedef struct Rdb_TableDetails Rdb_TableDetails
Description
Defines a struct for statistics of device-cloud upload and download tasks of a database table.
Since: 11
Enum Description
OH_ColumnType
enum OH_ColumnType
Description
Enumerates the field types in an RDB store.
Since: 10
Value | Description |
---|---|
TYPE_NULL | Null. |
TYPE_INT64 | INT64. |
TYPE_REAL | REAL. |
TYPE_TEXT | TEXT. |
TYPE_BLOB | BLOB. |
TYPE_ASSET11+ | ASSET (asset attachment). This value is supported since API version 11. |
TYPE_ASSETS11+ | ASSETS (multiple asset attachments). This value is supported since API version 11. |
OH_OrderType
enum OH_OrderType
Description
Enumerates the sorting types.
Since: 10
Value | Description |
---|---|
ASC | Ascending order. |
DESC | Descending order. |
OH_Rdb_ErrCode
enum OH_Rdb_ErrCode
Description
Enumerates the error codes.
Since: 10
Value | Description |
---|---|
RDB_ERR | Execution failed. |
RDB_OK | Execution successful. |
E_BASE | Base of the error code. |
RDB_E_NOT_SUPPORTED | The RDB store does not have this capability. |
RDB_E_ERROR | Common exception. |
RDB_E_INVALID_ARGS | Invalid parameter. |
RDB_E_CANNOT_UPDATE_READONLY | Failed to update data because the RDB store is read-only. |
RDB_E_REMOVE_FILE | Failed to delete the file. |
RDB_E_EMPTY_TABLE_NAME | The table name is empty. |
RDB_E_EMPTY_VALUES_BUCKET | The content of the KV pair is empty. |
RDB_E_EXECUTE_IN_STEP_QUERY | The SQL statement executed during the query is incorrect. |
RDB_E_INVALID_COLUMN_INDEX | The column index is invalid. |
RDB_E_INVALID_COLUMN_TYPE | The column type is invalid. |
RDB_E_EMPTY_FILE_NAME | The file name is empty. |
RDB_E_INVALID_FILE_PATH | The file path is invalid. |
RDB_E_TRANSACTION_IN_EXECUTE | Failed to start the transaction. |
RDB_E_INVALID_STATEMENT | Failed to precompile the SQL statements. |
RDB_E_EXECUTE_WRITE_IN_READ_CONNECTION | Failed to perform a write operation in a read connection. |
RDB_E_BEGIN_TRANSACTION_IN_READ_CONNECTION | Failed to start the transaction in a read connection. |
RDB_E_NO_TRANSACTION_IN_SESSION | The transaction to start does not exist in the database session. |
RDB_E_MORE_STEP_QUERY_IN_ONE_SESSION | Multiple queries are executed in a database session. |
RDB_E_NO_ROW_IN_QUERY | The result set does not contain any record. |
RDB_E_INVALID_BIND_ARGS_COUNT | The number of parameters bound in the SQL statement is invalid. |
RDB_E_INVALID_OBJECT_TYPE | The object type is invalid. |
RDB_E_INVALID_CONFLICT_FLAG | The conflict resolution type is invalid. |
RDB_E_HAVING_CLAUSE_NOT_IN_GROUP_BY | The HAVING keyword can be used only after GROUP BY. |
RDB_E_NOT_SUPPORTED_BY_STEP_RESULT_SET | The result set by step is not supported. |
RDB_E_STEP_RESULT_SET_CROSS_THREADS | Failed to obtain the result set. |
RDB_E_STEP_RESULT_QUERY_NOT_EXECUTED | The result set query statement is not executed. |
RDB_E_STEP_RESULT_IS_AFTER_LAST | The cursor of the result set is already in the last row. |
RDB_E_STEP_RESULT_QUERY_EXCEEDED | The number of result set query times exceeds the limit. |
RDB_E_STATEMENT_NOT_PREPARED | The SQL statement is not precompiled. |
RDB_E_EXECUTE_RESULT_INCORRECT | The database execution result is incorrect. |
RDB_E_STEP_RESULT_CLOSED | The result set has been closed. |
RDB_E_RELATIVE_PATH | The file path is a relative path. |
RDB_E_EMPTY_NEW_ENCRYPT_KEY | The new encrypt key is empty. |
RDB_E_CHANGE_UNENCRYPTED_TO_ENCRYPTED | The RDB store is non-encrypted and cannot be changed. |
RDB_E_CHANGE_ENCRYPT_KEY_IN_BUSY | The database does not respond when the database key is updated. |
RDB_E_STEP_STATEMENT_NOT_INIT | The precompiled SQL statement is not initialized. |
RDB_E_NOT_SUPPORTED_ATTACH_IN_WAL_MODE | The WAL mode does not support the ATTACH operation. |
RDB_E_CREATE_FOLDER_FAIL | Failed to create the folder. |
RDB_E_SQLITE_SQL_BUILDER_NORMALIZE_FAIL | Failed to build the SQL statement. |
RDB_E_STORE_SESSION_NOT_GIVE_CONNECTION_TEMPORARILY | The database session does not provide a connection. |
RDB_E_STORE_SESSION_NO_CURRENT_TRANSACTION | The transaction does not exist in the database session. |
RDB_E_NOT_SUPPORT | The current operation is not supported. |
RDB_E_INVALID_PARCEL | The current PARCEL is invalid. |
RDB_E_QUERY_IN_EXECUTE | Failed to execute query. |
RDB_E_SET_PERSIST_WAL | Failed to set the persistence of the database file in WAL mode. |
RDB_E_DB_NOT_EXIST | The database does not exist. |
RDB_E_ARGS_READ_CON_OVERLOAD | The number of read connections to set is greater than the limit. |
RDB_E_WAL_SIZE_OVER_LIMIT | The WAL log file size exceeds the default value. |
RDB_E_CON_OVER_LIMIT | The number of database connections has reached the limit. |
OH_Rdb_SecurityLevel
enum OH_Rdb_SecurityLevel
Description
Enumerates the RDB store security levels.
Since: 10
Value | Description |
---|---|
S1 | The security level of the RDB store is low. If data leakage occurs, minor impact will be caused. |
S2 | The security level of the RDB store is medium. If data leakage occurs, moderate impact will be caused. |
S3 | The security level of the RDB store is high. If data leakage occurs, major impact will be caused. |
S4 | The security level of the RDB store is critical. If data leakage occurs, critical impact will be caused. |
Rdb_ChangeType
enum Rdb_ChangeType
Description
Enumerates the data change types.
Since: 11
Value | Description |
---|---|
RDB_DATA_CHANGE | Data change. |
RDB_ASSET_CHANGE | Asset change. |
Rdb_DistributedType
enum Rdb_DistributedType
Description
Enumerates the distributed types.
Since: 11
Value | Description |
---|---|
RDB_DISTRIBUTED_CLOUD | Distributed database tables for device-cloud sync. |
Rdb_Progress
enum Rdb_Progress
Description
Enumerates the device-cloud sync progresses.
Since: 11
Value | Description |
---|---|
RDB_SYNC_BEGIN | The device-cloud sync starts. |
RDB_SYNC_IN_PROGRESS | The device-cloud sync is in progress. |
RDB_SYNC_FINISH | The device-cloud sync is finished. |
Rdb_ProgressCode
enum Rdb_ProgressCode
Description
Enumerates the device-cloud sync states.
Since: 11
Value | Description |
---|---|
RDB_SUCCESS | The device-cloud sync is successful. |
RDB_UNKNOWN_ERROR | An unknown error occurs during the device-cloud sync. |
RDB_NETWORK_ERROR | A network error occurs during the device-cloud sync. |
RDB_CLOUD_DISABLED | The cloud is unavailable. |
RDB_LOCKED_BY_OTHERS | The device-cloud sync of another device is being performed. |
RDB_RECORD_LIMIT_EXCEEDED | The number of records or size of the data to be synchronized exceeds the maximum. The maximum value is configured on the cloud. |
RDB_NO_SPACE_FOR_ASSET | The remaining cloud space is less than the size of the data to be synchronized. |
Rdb_SecurityArea
enum Rdb_SecurityArea
Description
Enumerates the security area levels of an RDB store.
Since: 11
Value | Description |
---|---|
RDB_SECURITY_AREA_EL1 | Security area level 1. |
RDB_SECURITY_AREA_EL2 | Security area level 2. |
RDB_SECURITY_AREA_EL3 | Security area level 3. |
RDB_SECURITY_AREA_EL4 | Security area level 4. |
Rdb_SubscribeType
enum Rdb_SubscribeType
Description
Enumerates the subscription types.
Since: 11
Value | Description |
---|---|
RDB_SUBSCRIBE_TYPE_CLOUD | Subscription of cloud data changes. |
RDB_SUBSCRIBE_TYPE_CLOUD_DETAILS | Subscription of cloud data change details. |
Rdb_SyncMode
enum Rdb_SyncMode
Description
Enumerates the RDB sync modes.
Since: 11
Value | Description |
---|---|
RDB_SYNC_MODE_TIME_FIRST | Synchronize with the data with the latest modification time. |
RDB_SYNC_MODE_NATIVE_FIRST | Synchronize data from a local device to the cloud. |
RDB_SYNC_MODE_CLOUD_FIRST | Synchronize data from the cloud to a local device. |
Function Description
OH_Rdb_Backup()
int OH_Rdb_Backup (OH_Rdb_Store *store, const char *databasePath )
Description
Backs up an RDB store in the specified directory.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
databasePath | Pointer to the destination directory in which the RDB store is backed up. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_BeginTransaction()
int OH_Rdb_BeginTransaction (OH_Rdb_Store *store)
Description
Starts the transaction before executing the SQL statement.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_CloseStore()
int OH_Rdb_CloseStore (OH_Rdb_Store *store)
Description
Closes an OH_Rdb_Store object to reclaim the memory occupied.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_CloudSync()
int OH_Rdb_CloudSync (OH_Rdb_Store *store, Rdb_SyncMode mode, const char *tables, int count, const Rdb_ProgressObserver *observer )
Description
Performs device-cloud sync.
Since: 11
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
mode | Sync mode Rdb_SyncMode. |
tables | Pointer to the names of the tables to be synchronized. |
count | Number of tables to synchronize. If the value is 0, all tables in the database are synchronized. |
observer | Observer Rdb_ProgressObserver of the device-cloud sync progress. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_Commit()
int OH_Rdb_Commit (OH_Rdb_Store *store)
Description
Commits the executed SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_CreatePredicates()
OH_Predicates* OH_Rdb_CreatePredicates (const char *table)
Description
Creates an OH_Predicates instance.
Since: 10
Parameters
Name | Description |
---|---|
table | Pointer to the name of the database table. |
Returns
Returns the pointer to the OH_Predicates instance created if the operation is successful; returns null otherwise.
See
OH_Rdb_CreateValueObject()
OH_VObject* OH_Rdb_CreateValueObject ()
Description
Creates an OH_VObject instance.
Since: 10
Returns
Returns the pointer to the OH_VObject instance created if the operation is successful; returns null otherwise.
See
OH_Rdb_CreateValuesBucket()
OH_VBucket* OH_Rdb_CreateValuesBucket ()
Description
Creates an OH_VBucket instance.
Since: 10
Returns
Returns the pointer to the OH_VBucket instance created if the operation is successful; returns null otherwise.
See
OH_Rdb_Delete()
int OH_Rdb_Delete (OH_Rdb_Store *store, OH_Predicates *predicates )
Description
Deletes data from an RDB store based on specified conditions.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
predicates | Pointer to the OH_Predicates instance, which specifies the deletion conditions. |
Returns
Returns the number of affected rows if the operation is successful; returns an error code otherwise.
See
OH_Rdb_DeleteStore()
int OH_Rdb_DeleteStore (const OH_Rdb_Config *config)
Description
Deletes an RDB store with the specified database file configuration.
Since: 10
Parameters
Name | Description |
---|---|
config | Pointer to the configuration of the database. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
OH_Rdb_Execute()
int OH_Rdb_Execute (OH_Rdb_Store *store, const char *sql )
Description
Executes an SQL statement but returns no value.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
sql | Pointer to the SQL statement to execute. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_ExecuteQuery()
OH_Cursor* OH_Rdb_ExecuteQuery (OH_Rdb_Store *store, const char *sql )
Description
Executes the SQL statement to query data in an RDB store.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
sql | Pointer to the SQL statement to execute. |
Returns
Returns the pointer to the OH_Cursor instance if the operation is successful; returns null otherwise.
See
OH_Rdb_FindModifyTime()
OH_Cursor* OH_Rdb_FindModifyTime (OH_Rdb_Store *store, const char *tableName, const char *columnName, OH_VObject *values )
Description
Obtains the last modification time of a table in an RDB store.
Since: 11
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
tableName | Pointer to the target distributed database table. |
columnName | Pointer to the column of the database table to query. |
values | Pointer to the primary keys of the rows to query. If the database table has no primary key, rowid must be passed in through columnName. In this case, values specifies the row number of the database table to query. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_GetOrOpen()
OH_Rdb_Store* OH_Rdb_GetOrOpen (const OH_Rdb_Config *config, int *errCode )
Description
Obtains an OH_Rdb_Store instance for RDB store operations.
Since: 10
Parameters
Name | Description |
---|---|
config | Pointer to the OH_Rdb_Config instance, which specifies the database configuration. |
errCode | Function execution status. |
Returns
Returns the pointer to the OH_Rdb_Store instance created if the operation is successful; returns null otherwise.
See
OH_Rdb_GetTableDetails()
Rdb_TableDetails* OH_Rdb_GetTableDetails (Rdb_ProgressDetails *progress, int32_t version )
Description
Obtains the device-cloud sync statistics of a table.
Since: 11
Parameters
Name | Description |
---|---|
progress | Pointer to the OH_ProgressDetails instance. |
version | Version of Rdb_ProgressDetails. |
Returns
Returns a pointer to Rdb_TableDetails if the operation is successful; returns null otherwise.
See
OH_Rdb_GetVersion()
int OH_Rdb_GetVersion (OH_Rdb_Store *store, int *version )
Description
Obtains the RDB store version.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
version | Pointer to the version obtained. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_Insert()
int OH_Rdb_Insert (OH_Rdb_Store *store, const char *table, OH_VBucket *valuesBucket )
Description
Inserts a row of data into a table.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
table | Pointer to the target table. |
valuesBucket | Pointer to the data OH_VBucket to insert. |
Returns
Returns the row ID if the operation is successful; returns an error code otherwise.
See
OH_Rdb_Query()
OH_Cursor* OH_Rdb_Query (OH_Rdb_Store *store, OH_Predicates *predicates, const char *const *columnNames, int length )
Description
Queries data in an RDB store based on specified conditions.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
predicates | Pointer to the OH_Predicates instance, which specifies the query conditions. |
columnNames | Pointer to the columns to query. If this parameter is not specified, data of columns will be queried. |
length | Length of the columnNames array. If length is greater than the length of columnNames array, out-of-bounds access occurs. |
Returns
Returns the pointer to the OH_Cursor instance if the operation is successful; returns null otherwise.
See
OH_Rdb_Store, OH_Predicates, OH_Cursor.
OH_Rdb_Restore()
int OH_Rdb_Restore (OH_Rdb_Store *store, const char *databasePath )
Description
Restores an RDB store from the specified database backup file.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
databasePath | Pointer to the destination directory in which the RDB store is backed up. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_RollBack()
int OH_Rdb_RollBack (OH_Rdb_Store *store)
Description
Rolls back the SQL statements executed.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_SetDistributedTables()
int OH_Rdb_SetDistributedTables (OH_Rdb_Store *store, const char *tables[], uint32_t count, Rdb_DistributedType type, const Rdb_DistributedConfig * config )
Description
Sets distributed database tables.
Since: 11
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
tables | Pointer to the names of the distributed tables to set. |
count | Number of distributed database tables to be set. |
type | Rdb_DistributedType. |
config | Configuration of the distributed mode. For details, see Rdb_DistributedConfig. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_SetVersion()
int OH_Rdb_SetVersion (OH_Rdb_Store *store, int version )
Description
Sets the RDB store version.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
version | Version to set. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_Subscribe()
int OH_Rdb_Subscribe (OH_Rdb_Store *store, Rdb_SubscribeType type, const Rdb_DataObserver *observer )
Description
Register an observer for an RDB store. When data in the RDB store changes, a callback will be invoked to return the data changes.
Since: 11
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
type | Subscription type defined in Rdb_SubscribeType. |
observer | Pointer to the Rdb_DataObserver instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_SubscribeAutoSyncProgress()
int OH_Rdb_SubscribeAutoSyncProgress (OH_Rdb_Store *store, const Rdb_ProgressObserver *observer )
Description
Subscribes to the automatic sync progress of an RDB store. The registered callback will be invoked to return the automatic sync progress.
Since: 11
Parameters
Name | Description |
---|---|
store | Pointer to the target OH_Rdb_Store instance. |
observer | Pointer to the Rdb_ProgressObserver instance, which invokes the callback to return the automatic sync progress. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_Unsubscribe()
int OH_Rdb_Unsubscribe (OH_Rdb_Store *store, Rdb_SubscribeType type, const Rdb_DataObserver *observer )
Description
Unregisters the observer of the specified type.
Since: 11
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
type | Subscription type defined in Rdb_SubscribeType. |
observer | Pointer to the Rdb_DataObserver instance. If this parameter is nullptr, all observers of this type will be unregistered. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_UnsubscribeAutoSyncProgress()
int OH_Rdb_UnsubscribeAutoSyncProgress (OH_Rdb_Store *store, const Rdb_ProgressObserver *observer )
Description
Unsubscribes from the automatic sync process of an RDB store.
Since: 11
Parameters
Name | Description |
---|---|
store | Pointer to the target OH_Rdb_Store instance. |
observer | Pointer to Rdb_ProgressObserver. If the pointer is null, all callbacks for the automatic sync process will be unregistered. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_Rdb_Update()
int OH_Rdb_Update (OH_Rdb_Store *store, OH_VBucket *valuesBucket, OH_Predicates *predicates )
Description
Updates data in an RDB store based on specified conditions.
Since: 10
Parameters
Name | Description |
---|---|
store | Pointer to the OH_Rdb_Store instance. |
valuesBucket | Pointer to the new data OH_VBucket to be updated to the table. |
predicates | Pointer to the OH_Predicates instance, specifying the update conditions. |
Returns
Returns the number of affected rows if the operation is successful; returns an error code otherwise.
See
OH_Rdb_Store, OH_Bucket, OH_Predicates.
OH_VBucket_PutAsset()
int OH_VBucket_PutAsset (OH_VBucket *bucket, const char *field, OH_Asset *value )
Description
Puts an OH_Asset object into the OH_VBucket object with the given column name.
Since: 11
Parameters
Name | Description |
---|---|
bucket | Pointer to the OH_VBucket instance. |
field | Pointer to the column name in the database table. |
value | Pointer to the value to put. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
OH_VBucket_PutAssets()
int OH_VBucket_PutAssets (OH_VBucket *bucket, const char *field, OH_Asset **value, int count )
Description
Puts an array of OH_Asset objects into the OH_VBucket object with the given column name.
Since: 11
Parameters
Name | Description |
---|---|
bucket | Pointer to the OH_VBucket instance. |
field | Pointer to the column name in the database table. |
value | Pointer to the value to put. |
count | Number of elements in the OH_Asset object array. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
Variable Description
andOperate
OH_Predicates *(*andOperate) (OH_Predicates *predicates)
Description
Pointer to the function used to add the AND operator to the predicates.
This method is equivalent to AND in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
Returns
Returns the predicates with the AND operator.
See
area
int OH_Rdb_Config::area
Description
Pointer to the function used to set Rdb_SecurityArea.
Since: 11
beginWrap
OH_Predicates *(*beginWrap) (OH_Predicates *predicates)
Description
Pointer to the function used to add a left parenthesis to the predicates.
This method is equivalent to "(" in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
Returns
Returns the predicates with a left parenthesis.
See
between
OH_Predicates *(*between) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match the field whose value is within the specified range.
This method is equivalent to BETWEEN in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the start and end values. |
Returns
Returns the predicates created.
See
briefObserver
Rdb_BriefObserver Rdb_SubscribeCallback::briefObserver
Description
Callback used to return the device-cloud data change event.
bundleName
const char* OH_Rdb_Config::bundleName
Description
Bundle name.
callback [1/2]
Rdb_SubscribeCallback Rdb_DataObserver::callback
Description
Callback of the data observer.
callback [2/2]
Rdb_ProgressCallback Rdb_ProgressObserver::callback
Description
Callback used to return the device-cloud sync progress.
capability
uint16_t OH_VBucket::capability
Description
Number of the KV pairs in the struct.
ChangeType
int Rdb_ChangeInfo::ChangeType
Description
Type of the data changed, which can be data or asset.
clear [1/2]
OH_Predicates *(*clear) (OH_Predicates *predicates)
Description
Pointer to the function used to clear a predicates instance.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
Returns
Returns the cleared predicates.
See
clear [2/2]
int(*clear) (OH_VBucket *bucket)
Description
Pointer to the function used to clear an OH_VBucket object.
Since: 10
Parameters
Name | Description |
---|---|
bucket | Pointer to the OH_VBucket instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
code
int Rdb_ProgressDetails::code
Description
Device-cloud sync state.
context [1/2]
void* Rdb_DataObserver::context
Description
Context of the data observer.
context [2/2]
void* Rdb_ProgressObserver::context
Description
Context of the device-cloud sync progress observer.
count
int Rdb_KeyInfo::count
Description
Number of changed primary keys or row numbers.
dataBaseDir
const char* OH_Rdb_Config::dataBaseDir
Description
Path of the database file.
deleted
Rdb_KeyInfo Rdb_ChangeInfo::deleted
Description
Location where data is deleted. If the primary key of the table is of the string type, the value is the value of the primary key. Otherwise, the value is the row number of the deleted data.
destroy [1/4]
int(*destroy) (OH_Cursor *cursor)
Description
Pointer to the function used to destroy a result set.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
destroy [2/4]
int(*destroy) (OH_Predicates *predicates)
Description
Pointer to the function used to destroy an OH_Predicates object to reclaim the memory occupied.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
destroy [3/4]
int(*destroy) (OH_VBucket *bucket)
Description
Pointer to the function used to destroy an OH_VBucket object to reclaim the memory occupied.
Since: 10
Parameters
Name | Description |
---|---|
bucket | Pointer to the OH_VBucket instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
destroy [4/4]
int(*destroy) (OH_VObject *valueObject)
Description
Pointer to the function used to destroy an OH_VObject object to reclaim the memory occupied.
Since: 10
Parameters
Name | Description |
---|---|
valueObject | Pointer to the OH_VObject instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
detailsObserver
Rdb_DetailsObserver Rdb_SubscribeCallback::detailsObserver
Description
Callback used to return the details about the device-cloud data change.
distinct
OH_Predicates *(*distinct) (OH_Predicates *predicates)
Description
Pointer to the function used to set a predicates object to filter out duplicate records.
This method is equivalent to DISTINCT in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
Returns
Returns the predicates created.
See
download
Rdb_Statistic Rdb_TableDetails::download
Description
Statistics of the device-cloud download tasks.
endWrap
OH_Predicates *(*endWrap) (OH_Predicates *predicates)
Description
Pointer to the function used to add a right parenthesis to the predicates.
This method is equivalent to ")" in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
Returns
Returns the predicates object with a right parenthesis.
See
equalTo
OH_Predicates *(*equalTo) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match the field whose value is equal to the specified value.
This method is equivalent to "=" in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the value to match. |
Returns
Returns the predicates created.
See
failed
int Rdb_Statistic::failed
Description
Number of rows that failed to be synchronized between the device and cloud in the database table.
getAsset
int(*getAsset) (OH_Cursor *cursor, int32_t columnIndex, Data_Asset *value)
Description
Pointer to the function used to obtain the value of the asset type based on the specified column and the current row.
Since: 11
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
columnIndex | Index of the column. The index value starts from 0. |
value | Pointer to the value obtained. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getAssets
int(*getAssets) (OH_Cursor *cursor, int32_t columnIndex, Data_Asset **value, uint32_t length)
Description
Pointer to the function used to obtain the values in the form of an asset array based on the specified column and the current row.
Since: 11
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
columnIndex | Index of the column. The index value starts from 0. |
value | Pointer to the value obtained. |
length | Length of an asset array. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getBlob
int(*getBlob) (OH_Cursor *cursor, int32_t columnIndex, unsigned char *value, int length)
Description
Pointer to the function used to obtain the values in the form of a byte array based on the specified column and the current row.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
columnIndex | Index of the column. The index value starts from 0. |
value | Pointer to the values in the form of a byte array obtained. |
length | Length of the value, which can be obtained by getSize(). |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getColumnCount
int(*getColumnCount) (OH_Cursor *cursor, int *count)
Description
Pointer to the function used to obtain the number of columns in the result set.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
count | Pointer to the number of columns in the result set obtained. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getColumnIndex
int(*getColumnIndex) (OH_Cursor *cursor, const char *name, int *columnIndex)
Description
Pointer to the function used to obtain the column index based on the specified column name.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
name | Pointer to the column name in the result set. |
columnIndex | Pointer to the column index obtained. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getColumnName
int(*getColumnName) (OH_Cursor *cursor, int32_t columnIndex, char *name, int length)
Description
Pointer to the function used to obtain the column name based on the specified column index.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
columnIndex | Index of the column. The index value starts from 0. |
name | Pointer to the column name obtained. |
length | Length of a column name. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getColumnType
int(*getColumnType) (OH_Cursor *cursor, int32_t columnIndex, OH_ColumnType *columnType)
Description
Pointer to the function used to obtain the column type based on the specified column index.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
columnIndex | Index of the column. The index value starts from 0. |
columnType | Pointer to the OH_ColumnType obtained. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getInt64
int(*getInt64) (OH_Cursor *cursor, int32_t columnIndex, int64_t *value)
Description
Pointer to the function used to obtain the value of the int64_t type based on the specified column and the current row.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
columnIndex | Index of the column. The index value starts from 0. |
value | Pointer to the value obtained. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getReal
int(*getReal) (OH_Cursor *cursor, int32_t columnIndex, double *value)
Description
Pointer to the function used to obtain the value of the double type based on the specified column and the current row.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
columnIndex | Index of the column. The index value starts from 0. |
value | Pointer to the value obtained. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getRowCount
int(*getRowCount) (OH_Cursor *cursor, int *count)
Description
Pointer to the function used to obtain the number of rows in the result set.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
count | Pointer to the number of columns in the result set obtained. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getSize
int(*getSize) (OH_Cursor *cursor, int32_t columnIndex, size_t *size)
Description
Pointer to the function used to obtain information about the memory required when the column data type in the result set is BLOB or TEXT.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
columnIndex | Index of the column. The index value starts from 0. |
size | Pointer to the memory size obtained. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
getText
int(*getText) (OH_Cursor *cursor, int32_t columnIndex, char *value, int length)
Description
Pointer to the function used to obtain the value of the string type based on the specified column and the current row.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
columnIndex | Index of the column. The index value starts from 0. |
value | Pointer to the value of the string type obtained. |
length | Length of the value, which can be obtained by getSize(). |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
goToNextRow
int(*goToNextRow) (OH_Cursor *cursor)
Description
Pointer to the function used to go to the next row of the result set.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
greaterThan
OH_Predicates *(*greaterThan) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match the field with value greater than the specified value.
This method is equivalent to ">" in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the value to match. |
Returns
Returns the predicates created.
See
greaterThanOrEqualTo
OH_Predicates *(*greaterThanOrEqualTo) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match the field with value greater than or equal to the specified value.
This method is equivalent to ">=" in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the value to match. |
Returns
Returns the predicates created.
See
groupBy
OH_Predicates *(*groupBy) (OH_Predicates *predicates, char const *const *fields, int length)
Description
Pointer to the function used to set a predicates object to group rows that have the same value into summary rows.
This method is equivalent to GROUP BY in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
fields | Pointer to the names of the columns by which the records are grouped. |
length | Length of the fields value. |
Returns
Returns the predicates created.
See
id [1/5]
int64_t OH_Cursor::id
Description
Unique identifier of the OH_Cursor struct.
id [2/5]
int64_t OH_Predicates::id
Description
Unique identifier of the OH_Predicates struct.
id [3/5]
int64_t OH_VObject::id
Description
Unique identifier of the OH_VObject struct.
id [4/5]
int64_t OH_VBucket::id
Description
Unique identifier of the OH_VBucket struct.
id [5/5]
int64_t OH_Rdb_Store::id
Description
Unique identifier of the OH_Rdb_Store struct.
in
OH_Predicates *(*in) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match the field with the value within the specified range.
This method is equivalent to IN in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the value range. |
Returns
Returns the predicates created.
See
inserted
Rdb_KeyInfo Rdb_ChangeInfo::inserted
Description
Location where data is inserted. If the primary key of the table is of the string type, the value is the value of the primary key. Otherwise, the value is the row number of the inserted data.
integer
uint64_t Rdb_KeyInfo::Rdb_KeyData::integer
Description
Data of the uint64_t type.
isAutoSync
bool Rdb_DistributedConfig::isAutoSync
Description
Whether the table supports automatic sync.
isEncrypt
bool OH_Rdb_Config::isEncrypt
Description
Whether to encrypt the RDB store.
isNotNull
OH_Predicates *(*isNotNull) (OH_Predicates *predicates, const char *field)
Description
Pointer to the function used to set a predicates object to match the field whose value is not null.
This method is equivalent to IS NOT NULL in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
Returns
Returns the predicates created.
See
isNull [1/2]
int(*isNull) (OH_Cursor *cursor, int32_t columnIndex, bool *isNull)
Description
Pointer to the function used to check whether the value in the specified column is null.
Since: 10
Parameters
Name | Description |
---|---|
cursor | Pointer to the OH_Cursor instance. |
columnIndex | Index of the column. The index value starts from 0. |
isNull | Pointer to the value returned. The value true means the value is null; the value false means the opposite. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
isNull [2/2]
OH_Predicates *(*isNull) (OH_Predicates *predicates, const char *field)
Description
Pointer to the function used to set a predicates object to match the field whose value is null.
This method is equivalent to IS NULL in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
Returns
Returns the predicates created.
See
lessThan
OH_Predicates *(*lessThan) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match the field with value less than the specified value.
This method is equivalent to "<" in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the value to match. |
Returns
Returns the predicates created.
See
lessThanOrEqualTo
OH_Predicates *(*lessThanOrEqualTo) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match the field with value less than or equal to the specified value.
This method is equivalent to "<=" in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the value to match. |
Returns
Returns the predicates created.
See
like
OH_Predicates *(*like) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match a string that is similar to the specified value.
This method is equivalent to LIKE in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the value to match. |
Returns
Returns the predicates created.
See
limit
OH_Predicates *(*limit) (OH_Predicates *predicates, unsigned int value)
Description
Pointer to the function used to set a predicates object to specify the maximum number of records.
This method is equivalent to LIMIT in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
value | Maximum number of data records. |
Returns
Returns the predicates created.
See
moduleName
const char* OH_Rdb_Config::moduleName
Description
Module name.
notBetween
OH_Predicates *(*notBetween) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match the field whose value is out of the specified range.
This method is equivalent to NOT BETWEEN in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the value to match. |
Returns
Returns the predicates created.
See
notEqualTo
OH_Predicates *(*notEqualTo) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match the field whose value is not equal to the specified value.
This method is equivalent to "!=" in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the value to match. |
Returns
Returns the predicates created.
See
notIn
OH_Predicates *(*notIn) (OH_Predicates *predicates, const char *field, OH_VObject *valueObject)
Description
Pointer to the function used to set a predicates object to match the field with the value out of the specified range.
This method is equivalent to NOT IN in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
valueObject | Pointer to the OH_VObject instance, which specifies the value range to match. |
Returns
Returns the predicates created.
See
offset
OH_Predicates *(*offset) (OH_Predicates *predicates, unsigned int rowOffset)
Description
Pointer to the function used to set a predicates object to specify the start position of the returned result.
This method is equivalent to OFFSET in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
rowOffset | Start position of the returned result. The value is a positive integer. |
Returns
Returns the predicates created.
See
orderBy
OH_Predicates *(*orderBy) (OH_Predicates *predicates, const char *field, OH_OrderType type)
Description
Pointer to the function used to set a predicates object to sort the values in a column in ascending or descending order.
This method is equivalent to ORDER BY in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
field | Pointer to the column name in the database table. |
type | Sorting type OH_OrderType. |
Returns
Returns the predicates created.
See
orOperate
OH_Predicates *(*orOperate) (OH_Predicates *predicates)
Description
Pointer to the function used to add the OR operator to the predicates.
This method is equivalent to OR in SQL statements.
Since: 10
Parameters
Name | Description |
---|---|
predicates | Pointer to the OH_Predicates instance. |
Returns
Returns the predicates with the OR operator.
See
putBlob
int(*putBlob) (OH_VBucket *bucket, const char *field, const uint8_t *value, uint32_t size)
Description
Pointer to the function used to put a const uint8_t value into the OH_VBucket object in the given column.
Since: 10
Parameters
Name | Description |
---|---|
bucket | Pointer to the OH_VBucket instance. |
field | Pointer to the column name in the database table. |
value | Pointer to the value to put. |
size | Length of the value. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
putDouble
int(*putDouble) (OH_VObject *valueObject, double *value, uint32_t count)
Description
Pointer to the function used to convert a single parameter or an array of the double type into a value of the OH_VObject type.
Since: 10
Parameters
Name | Description |
---|---|
valueObject | Pointer to the OH_VObject instance. |
value | Pointer to the data to covert. |
count | If value points to a single parameter, count is 1. If value points to an array, count specifies the length of the array. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
putInt64 [1/2]
int(*putInt64) (OH_VBucket *bucket, const char *field, int64_t value)
Description
Pointer to the function used to put an int64_t value into the OH_VBucket object in the given column.
Since: 10
Parameters
Name | Description |
---|---|
bucket | Pointer to the OH_VBucket instance. |
field | Pointer to the column name in the database table. |
value | Value to put. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
putInt64 [2/2]
int(*putInt64) (OH_VObject *valueObject, int64_t *value, uint32_t count)
Description
Pointer to the function used to convert a single parameter or an array of the int64 type into a value of the OH_VObject type.
Since: 10
Parameters
Name | Description |
---|---|
valueObject | Pointer to the OH_VObject instance. |
value | Pointer to the data to covert. |
count | If value points to a single parameter, count is 1. If value points to an array, count specifies the length of the array. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
putNull
int(*putNull) (OH_VBucket *bucket, const char *field)
Description
Pointer to the function used to put a null value into the OH_VBucket object in the given column.
Since: 10
Parameters
Name | Description |
---|---|
bucket | Pointer to the OH_VBucket instance. |
field | Pointer to the column name in the database table. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
putReal
int(*putReal) (OH_VBucket *bucket, const char *field, double value)
Description
Pointer to the function used to put a double value into the OH_VBucket object in the given column.
Since: 10
Parameters
Name | Description |
---|---|
bucket | Pointer to the OH_VBucket instance. |
field | Pointer to the column name in the database table. |
value | Value to put. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
putText [1/2]
int(*putText) (OH_VBucket *bucket, const char *field, const char *value)
Description
Pointer to the function used to put a char value into the OH_VBucket object in the given column.
Since: 10
Parameters
Name | Description |
---|---|
bucket | Pointer to the OH_VBucket instance. |
field | Pointer to the column name in the database table. |
value | Pointer to the value to put. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
putText [2/2]
int(*putText) (OH_VObject *valueObject, const char *value)
Description
Pointer to the function used to convert a character array of the char type to a value of the OH_VObject type.
Since: 10
Parameters
Name | Description |
---|---|
valueObject | Pointer to the OH_VObject instance. |
value | Pointer to the character array to convert. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
putTexts
int(*putTexts) (OH_VObject *valueObject, const char **value, uint32_t count)
Description
Pointer to the function used to convert a string array of the char type to a value of the OH_VObject type.
Since: 10
Parameters
Name | Description |
---|---|
valueObject | Pointer to the OH_VObject instance. |
value | Pointer to the string array to convert. |
count | Length of the string array to convert. |
Returns
Returns RDB_OK if the operation is successful; returns an error code otherwise.
See
real
double Rdb_KeyInfo::Rdb_KeyData::real
Description
Data of the double type.
remained
int Rdb_Statistic::remained
Description
Number of rows that are not executed for device-cloud sync in the database table.
schedule
int Rdb_ProgressDetails::schedule
Description
Device-cloud sync process.
securityLevel
int OH_Rdb_Config::securityLevel
Description
RDB store security level. For details, see OH_Rdb_SecurityLevel.
selfSize
int OH_Rdb_Config::selfSize
Description
Size of the struct.
storeName
const char* OH_Rdb_Config::storeName
Description
Name of the RDB store.
successful
int Rdb_Statistic::successful
Description
Number of rows that are successfully synchronized between the device and cloud in the database table.
table
const char* Rdb_TableDetails::table
Description
Database table name.
tableLength
int32_t Rdb_ProgressDetails::tableLength
Description
Number of the tables synchronized between the device and cloud.
tableName
const char* Rdb_ChangeInfo::tableName
Description
Name of the table with data changes.
text
const char* Rdb_KeyInfo::Rdb_KeyData::text
Description
Data of the char * type.
total
int Rdb_Statistic::total
Description
Total number of rows to be synchronized between the device and cloud in the database table.
type
int Rdb_KeyInfo::type
Description
Type (OH_ColumnType) of the primary key.
updated
Rdb_KeyInfo Rdb_ChangeInfo::updated
Description
Location where data is updated. If the primary key of the table is of the string type, the value is the value of the primary key. Otherwise, the value is the row number of the updated data.
upload
Rdb_Statistic Rdb_TableDetails::upload
Description
Statistics of the device-cloud upload tasks.
version [1/3]
int Rdb_DistributedConfig::version
Description
Version of the Rdb_DistributedConfig struct.
version [2/3]
int Rdb_ChangeInfo::version
Description
Version of the Rdb_DistributedConfig struct.
version [3/3]
int Rdb_ProgressDetails::version
Description
Version of the OH_TableDetails struct.