dm_db_pragma_set Interface

public interface dm_db_pragma_set

Generic PRAGMA set function.

Called by

interface~~dm_db_pragma_set~~CalledByGraph interface~dm_db_pragma_set dm_db_pragma_set proc~dm_db_optimize dm_db_optimize proc~dm_db_optimize->interface~dm_db_pragma_set proc~dm_db_set_application_id dm_db_set_application_id proc~dm_db_set_application_id->interface~dm_db_pragma_set proc~dm_db_set_auto_vacuum dm_db_set_auto_vacuum proc~dm_db_set_auto_vacuum->interface~dm_db_pragma_set proc~dm_db_set_foreign_keys dm_db_set_foreign_keys proc~dm_db_set_foreign_keys->interface~dm_db_pragma_set proc~dm_db_set_journal_mode dm_db_set_journal_mode proc~dm_db_set_journal_mode->interface~dm_db_pragma_set proc~dm_db_set_query_only dm_db_set_query_only proc~dm_db_set_query_only->interface~dm_db_pragma_set proc~dm_db_set_schema_version dm_db_set_schema_version proc~dm_db_set_schema_version->interface~dm_db_pragma_set proc~dm_db_close dm_db_close proc~dm_db_close->proc~dm_db_optimize proc~dm_db_open dm_db_open proc~dm_db_open->proc~dm_db_set_application_id proc~dm_db_open->proc~dm_db_set_foreign_keys proc~dm_db_open->proc~dm_db_set_journal_mode proc~dm_db_open->proc~dm_db_set_schema_version proc~dm_db_backup dm_db_backup proc~dm_db_backup->proc~dm_db_close proc~dm_db_backup->proc~dm_db_open

Module Procedures

private function db_pragma_set(db, name) result(rc)

Executes PRAGMA of name.

The function returns the following error codes:

  • E_DB_PREPARE if statement preparation failed.
  • E_DB_STEP if step execution failed or no write permission.
  • E_READ_ONLY if database is opened read-only.

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.

character(len=*), intent(in) :: name

PRAGMA name.

Return Value integer

private function db_pragma_set_int32(db, name, value) result(rc)

Sets PRAGMA of name to 4-byte integer value.

The function returns the following error codes:

  • E_DB_PREPARE if statement preparation failed.
  • E_DB_STEP if step execution failed or no write permission.
  • E_READ_ONLY if database is opened read-only.

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.

character(len=*), intent(in) :: name

PRAGMA name.

integer(kind=i4), intent(in) :: value

PRAGMA value.

Return Value integer

private function db_pragma_set_int64(db, name, value) result(rc)

Sets PRAGMA of name to 8-byte integer value.

The function returns the following error codes:

  • E_DB_PREPARE if statement preparation failed.
  • E_DB_STEP if step execution failed or no write permission.
  • E_READ_ONLY if database is opened read-only.

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.

character(len=*), intent(in) :: name

PRAGMA name.

integer(kind=i8), intent(in) :: value

PRAGMA value.

Return Value integer

private function db_pragma_set_string(db, name, value) result(rc)

Sets PRAGMA of name to string value.

The function returns the following error codes:

  • E_DB_PREPARE if statement preparation failed.
  • E_DB_STEP if step execution failed or no write permission.

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.

character(len=*), intent(in) :: name

PRAGMA name.

character(len=*), intent(in) :: value

PRAGMA value.

Return Value integer