Class WPDA_Dictionary_Lists

author Peter Schulz
since 1.0.0
package WPDataAccess\Data_Dictionary

 Methods

List of available collations

get_collations(string $schema_name = '') : array
Static
since 1.6.0

Parameters

$schema_name

string

Database schema name (default = WordPress schema)

Returns

array

List of columns for a specific table

get_columns() : array
Static

jQuery usage: action=wpda_get_columns

since 1.6.10

Returns

arrayList of column for a specific table.

List of database schemas available to user

get_db_schemas(boolean $incl_remote_dbs = true) : array
Static
since 1.6.0

Parameters

$incl_remote_dbs

boolean

Include remote database connections? (for backward compatibility)

Returns

array

Returns default collation

get_default_collation(string $schema_name = '') : array
Static
since 1.6.0

Parameters

$schema_name

string

Database schema name (default = WordPress schema)

Returns

array

List of available engines

get_engines(string $schema_name = '') : array
Static
since 1.6.0

Parameters

$schema_name

string

Database schema name (default = WordPress schema)

Returns

array

List of columns for a specific table

get_table_columns(string $table_name, string $schema_name) : \WPDataAccess\Data_Dictionary\Column
Static
since 2.0.10

Parameters

$table_name

string

Database table name

$schema_name

string

Database schema name

Returns

\WPDataAccess\Data_Dictionary\Columnin $table_name

List of tables for setting pages

get_tables(boolean $show_views = true, string $schema_name = '') : array
Static

Returns an array including all tables and views in the WordPress database.

Do NOT use table access control here! This list is used in the settings forms and must show ALL tables in the WordPress database.

since 1.0.0

Parameters

$show_views

boolean

TRUE = show views, FALSE = hide views.

$schema_name

string

Database schema name

Returns

arrayList of database tables (and views).

List all table in a specific schema

get_tables_ajax() : array
Static

jQuery usage: action=wpda_get_tables

Returns

array