Data Designer
create_table_statement . $this->create_index_statement; // phpcs:ignore WordPress.Security.EscapeOutput ?>
wpda_table_design ) {
// Allow loading table from database into designer (reverse engineering).
$table_list = WPDA_Dictionary_Lists::get_tables( false );
?>
table_exists ) {
// Add reconcile form.
?>
create_table_statement && false === $this->create_table_succeeded ) {
?>
create_table_statement; // phpcs:ignore WordPress.Security.EscapeOutput ?>
wpdb_error ); ?>
|
create_index_failed && 0 < count( $this->create_index_failed ) ) { // phpcs:ignore -- 8.1 proof
?>
create_index_failed as $index_failed ) {
echo "$index_failed
"; // phpcs:ignore WordPress.Security.EscapeOutput
}
?>
|
create_table_statement && false === $this->alter_table_succeeded ) {
?>
create_table_statement; // phpcs:ignore WordPress.Security.EscapeOutput ?>
wpdb_error ); ?>
|
wpda_table_design ) {
// Display table design.
foreach ( $this->wpda_table_design->table as $design_column ) {
if ( ! $this->table_exists ) {
// New table cannot be compared with real table.
$column_changed = '';
} else {
// Check for table structure changes.
if ( isset( $this->table_columns[ $design_column->column_name ] ) ) {
// Check column arguments.
$column_changed = '';
foreach ( $this->real_table as $real_column ) {
if ( $real_column->column_name === $design_column->column_name ) {
if ( $real_column != $design_column ) {
if ( strtolower( $real_column->extra ) === 'auto_increment' && strtolower( $design_column->extra ) === 'auto_increment' ) {
$tmp_real_column = clone $real_column;
$tmp_design_column = clone $design_column;
unset( $tmp_real_column->extra );
unset( $tmp_design_column->extra );
if ( $tmp_real_column != $tmp_design_column ) {
$column_changed = 'u';
$this->table_altered = true;
}
} else {
$column_changed = 'u';
$this->table_altered = true;
}
}
}
}
} else {
// New column.
$column_changed = 'i';
$this->table_altered = true;
}
}
?>
table_exists ) {
// Check for deleted columns.
foreach ( $this->table_columns as $table_column ) {
$column_found = false;
foreach ( $this->wpda_table_design->table as $design_column ) {
if ( $design_column->column_name === $table_column['column_name'] ) {
$column_found = true;
break;
}
}
if ( ! $column_found ) {
break;
}
}
if ( ! $column_found ) {
// Add deleted column(s) to form and mark as readonly.
foreach ( $this->table_columns as $table_column ) {
$column_found = false;
foreach ( $this->wpda_table_design->table as $design_column ) {
if ( $design_column->column_name === $table_column['column_name'] ) {
$column_found = true;
break;
}
}
if ( ! $column_found ) {
foreach ( $this->real_table as $real_column ) {
if ( $real_column->column_name === $table_column['column_name'] ) {
?>
table_altered = true;
$this->deleted_columns_and_indexes = true;
}
}
}
}
}
}
// Display indexes.
$indexes_found = false;
foreach ( $this->wpda_table_design->indexes as $design_index ) {
$index_changed = '';
if ( $this->table_exists ) {
$index_found = false;
// Check if index was changed or new.
foreach ( $this->real_indexes as $real_index ) {
if ( $design_index->index_name === $real_index['index_name'] ) {
$index_found = true;
if (
$real_index['unique'] != $design_index->unique ||
$real_index['column_names'] != $design_index->column_names
) {
$index_changed = 'u';
$this->updated_indexes = true;
}
break;
}
}
if ( ! $index_found ) {
$index_changed = 'i';
$this->updated_indexes = true;
}
}
?>
table_exists ) {
foreach ( $this->real_indexes as $real_index ) {
$real_indexes_found = false;
foreach ( $this->wpda_table_design->indexes as $design_index ) {
if ( $real_index['index_name'] === $design_index->index_name ) {
$real_indexes_found = true;
break;
}
}
if ( ! $real_indexes_found ) {
// Index was dropped.
?>
deleted_columns_and_indexes = true;
$this->updated_indexes = true;
}
}
}
if ( ! $indexes_found ) {
?>
action ) {
?>
is_wp_table ) {
// WP table names are not allowed: disable create table button.
?>
wpda_table_name ) {
return wp_nonce_field( "wpda-design-table-form-" . WPDA_Design_Table_Model::get_base_table_name() );
}
return wp_nonce_field( "wpda-design-table-form-{$this->wpda_table_name}" );
}
/**
* Drop all indexes from database
*
* @since 2.0.14
*/
protected function drop_indexes() {
foreach ( $this->real_indexes as $real_index ) {
$this->drop_index( $real_index['index_name'] );
}
}
/**
* Drop a specific index from database
*
* @param string $index_name Name of index to be dropped
*
* @since 2.0.14
*/
protected function drop_index( $index_name ) {
$wpdadb = WPDADB::get_db_connection( $this->wpda_schema_name );
if ( null === $wpdadb ) {
/* translators: %s = remote database name */
wp_die( esc_attr( sprintf( __( 'ERROR - Remote database %s not available', 'wp-data-access' ), $this->wpda_schema_name ) ) );
}
$suppress = $wpdadb->suppress_errors( true );
// Index is deleted from table design: drop index
$drop_index_statement = 'DROP INDEX `' . str_replace( '`', '', $index_name ) . "` ON `{$this->wpda_table_name}`";
if ( $wpdadb->query( $drop_index_statement ) ) {
// phpcs:disable WordPress.WP.I18n.MissingTranslatorsComment
$msg = new WPDA_Message_Box(
array(
/* translators: %s = index name */
'message_text' => sprintf( __( 'Index `%s` dropped', 'wp-data-access' ), esc_attr( $index_name) ),
)
);
// phpcs:enable WordPress.WP.I18n.MissingTranslatorsComment
$msg->box();
} else {
$msg = new WPDA_Message_Box(
array(
'message_text' => __( 'DROP INDEX failed', 'wp-data-access' ),
'message_type' => 'error',
'message_is_dismissible' => false,
)
);
$msg->box();
$this->create_index_failed[] = $drop_index_statement;
}
$wpdadb->suppress_errors( $suppress );
}
/**
* Create indexes from design
*
* @since 2.0.14
*/
protected function create_index() {
$wpdadb = WPDADB::get_db_connection( $this->wpda_schema_name );
if ( null === $wpdadb ) {
/* translators: %s = remote database name */
wp_die( esc_attr( sprintf( __( 'ERROR - Remote database %s not available', 'wp-data-access' ), $this->wpda_schema_name ) ) );
}
$suppress = $wpdadb->suppress_errors( true );
if ( 'show_create_table_script' !== $this->action2_posted ) {
$this->drop_indexes();
}
// Recreate indexes.
foreach ( $this->wpda_table_design->indexes as $index ) {
if ( '' === $index->index_name || '' === $index->column_names ) {
continue;
}
$unique = '';
if ( 'Yes' === $index->unique ) {
$unique = 'UNIQUE';
} elseif ( 'FULLTEXT' === $index->unique ) {
if ( 'on' === $this->fulltext_support ) {
$unique = 'FULLTEXT';
} else {
$unique = '';
}
}
$column_names_array = explode( ',', ( string ) $index->column_names ); // phpcs:ignore -- 8.1 proof
$column_names = '`' . implode( '`,`', $column_names_array ) . '`';
$create_index_statement =
"CREATE $unique INDEX `" . str_replace( '`', '', $index->index_name ) . "` ON `{$this->wpda_table_name}` ($column_names)";
$this->create_index_statement .= $create_index_statement . ';' . self::NEW_LINE;
if ( 'show_create_table_script' === $this->action2_posted ) {
continue;
}
if ( $wpdadb->query( $create_index_statement ) ) {
// phpcs:disable WordPress.WP.I18n.MissingTranslatorsComment
$msg = new WPDA_Message_Box(
array(
/* translators: %s = index name */
'message_text' => sprintf( __( 'Index `%s` created', 'wp-data-access' ), $index->index_name ),
)
);
// phpcs:enable WordPress.WP.I18n.MissingTranslatorsComment
$msg->box();
} else {
$msg = new WPDA_Message_Box(
array(
'message_text' => __( 'CREATE INDEX failed', 'wp-data-access' ),
'message_type' => 'error',
'message_is_dismissible' => false,
)
);
$msg->box();
$this->create_index_failed[] = $create_index_statement;
}
}
$wpdadb->suppress_errors( $suppress );
}
}
}