Upgrades
1 week ago
AudioPresets.php
1 year ago
EmailCollection.php
1 year ago
Migrations.php
1 year ago
Presets.php
1 year ago
Table.php
1 week ago
Videos.php
1 year ago
Visits.php
1 year ago
Webhooks.php
1 year ago
Table.php
100 lines
| 1 | <?php |
| 2 | /** |
| 3 | * Database table helper. |
| 4 | * |
| 5 | * @package PrestoPlayer |
| 6 | */ |
| 7 | |
| 8 | namespace PrestoPlayer\Database; |
| 9 | |
| 10 | /** |
| 11 | * Creates, drops and checks for custom database tables. |
| 12 | */ |
| 13 | class Table { |
| 14 | |
| 15 | /** |
| 16 | * Create a database table. |
| 17 | * |
| 18 | * @param string $name Table name (without the WordPress prefix). |
| 19 | * @param string $columns SQL column definitions. |
| 20 | * @param integer $version Schema version used to gate upgrades. |
| 21 | * @param array $opts Optional table options (upgrade_method, table_options). |
| 22 | * @return void |
| 23 | */ |
| 24 | public function create( $name, $columns, $version = 1, $opts = array() ) { |
| 25 | $current_version = get_option( "{$name}_database_version", 0 ); |
| 26 | |
| 27 | if ( $version == $current_version ) { |
| 28 | return; |
| 29 | } |
| 30 | |
| 31 | global $wpdb; |
| 32 | |
| 33 | $full_table_name = $wpdb->prefix . $name; |
| 34 | |
| 35 | $opts = wp_parse_args( |
| 36 | $opts, |
| 37 | array( |
| 38 | 'upgrade_method' => 'dbDelta', |
| 39 | 'table_options' => '', |
| 40 | ) |
| 41 | ); |
| 42 | |
| 43 | $charset_collate = ''; |
| 44 | if ( $wpdb->has_cap( 'collation' ) ) { |
| 45 | if ( ! empty( $wpdb->charset ) ) { |
| 46 | $charset_collate = "DEFAULT CHARACTER SET $wpdb->charset"; |
| 47 | } |
| 48 | if ( ! empty( $wpdb->collate ) ) { |
| 49 | $charset_collate .= " COLLATE $wpdb->collate"; |
| 50 | } |
| 51 | } |
| 52 | |
| 53 | $table_options = $charset_collate . ' ' . $opts['table_options']; |
| 54 | |
| 55 | // Use dbDelta by default. |
| 56 | if ( 'dbDelta' == $opts['upgrade_method'] ) { |
| 57 | require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
| 58 | dbDelta( "CREATE TABLE $full_table_name ( $columns ) $table_options" ); |
| 59 | update_option( "{$name}_database_version", $version ); |
| 60 | return; |
| 61 | } |
| 62 | |
| 63 | if ( 'delete_first' == $opts['upgrade_method'] ) { |
| 64 | $wpdb->query( "DROP TABLE IF EXISTS $full_table_name;" ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- DDL on an internal table name ($wpdb->prefix + schema name); identifiers cannot be bound. |
| 65 | } |
| 66 | |
| 67 | $wpdb->query( "CREATE TABLE IF NOT EXISTS $full_table_name ( $columns ) $table_options;" ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- DDL with internal table name and schema-defined columns; no user input. |
| 68 | |
| 69 | update_option( "{$name}_database_version", $version ); |
| 70 | } |
| 71 | |
| 72 | /** |
| 73 | * Drops the table and database option. |
| 74 | * |
| 75 | * @param string $name Fully qualified table name to drop. |
| 76 | * @return void |
| 77 | */ |
| 78 | public function drop( $name ) { |
| 79 | global $wpdb; |
| 80 | // Table identifiers cannot be bound via $wpdb->prepare(); $name is an internally controlled value. |
| 81 | $wpdb->query( 'DROP TABLE IF EXISTS ' . $name ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter |
| 82 | delete_option( "presto_courses_{$name}_database_version" ); |
| 83 | } |
| 84 | |
| 85 | /** |
| 86 | * Checks whether a table exists. |
| 87 | * |
| 88 | * @param string $name Table name (without the WordPress prefix). |
| 89 | * @return bool True when the table exists, false otherwise. |
| 90 | */ |
| 91 | public function exists( $name ) { |
| 92 | global $wpdb; |
| 93 | $table_name = $wpdb->prefix . $name; |
| 94 | if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $table_name ) ) ) == $table_name ) { |
| 95 | return true; |
| 96 | } |
| 97 | return false; |
| 98 | } |
| 99 | } |
| 100 |