Changeset 3068813

Timestamp:

04/11/2024 07:19:32 AM (4 months ago)

Author:

aristath

Message:

v2.1.8

Location:

sqlite-database-integration/trunk

Files:

• load.php (modified) (1 diff)
• readme.txt (modified) (1 diff)
• wp-includes/sqlite/class-wp-sqlite-pdo-user-defined-functions.php (modified) (2 diffs)
• wp-includes/sqlite/class-wp-sqlite-translator.php (modified) (6 diffs)

sqlite-database-integration/trunk/load.php

@@ -4 +4 @@
  * Description: SQLite database driver drop-in.
  * Author: The WordPress Team
- * Version: 2.1.7
+ * Version: 2.1.
  * Requires PHP: 7.0
  * Textdomain: sqlite-database-integration

sqlite-database-integration/trunk/readme.txt

@@ -5 +5 @@
 Tested up to:      6.4
 Requires PHP:      5.6
-Stable tag:        2.1.7
+Stable tag:        2.1.
 License:           GPLv2 or later
 License URI:       https://www.gnu.org/licenses/gpl-2.0.html

sqlite-database-integration/trunk/wp-includes/sqlite/class-wp-sqlite-pdo-user-defined-functions.php

@@ -77 +77 @@
         'ucase'          => 'ucase',
         'lcase'          => 'lcase',
+
         'inet_ntoa'      => 'inet_ntoa',
         'inet_aton'      => 'inet_aton',
@@ -635 +636 @@
 
     /**
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
      * Method to emulate MySQL INET_NTOA() function.
      *

sqlite-database-integration/trunk/wp-includes/sqlite/class-wp-sqlite-translator.php

@@ -1055 +1055 @@
         $result->mysql_data_type    = $skip_mysql_data_type_parts[1];
 
-        // Look for the NOT NULL and AUTO_INCREMENT flags.
+        // Look for the NOT NULL and AUTO_INCREMENT flags.
         while ( true ) {
             $token = $this->rewriter->skip();
@@ -1123 +1123 @@
         if ( $field->not_null ) {
             $definition .= ' NOT NULL';
+
+
+
+
+
+
+
+
         }
         if ( null !== $field->default ) {
@@ -1825 +1833 @@
             || $this->translate_ungrouped_having( $token )
             || $this->translate_like_escape( $token )
+
         );
     }
@@ -2023 +2032 @@
         $this->rewriter->skip();
         $this->rewriter->add( new WP_SQLite_Token( 'DATETIME', WP_SQLite_Token::TYPE_KEYWORD, WP_SQLite_Token::FLAG_KEYWORD_FUNCTION ) );
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
         return true;
     }
@@ -3025 +3069 @@
             case 'CREATE PROCEDURE':
                 $this->results = true;
+
+
+
+
+
+
+
+
+
+
                 return;
 
@@ -3142 +3196 @@
 
             case 'TABLE STATUS':  // FROM `database`.
-                $this->rewriter->skip();
+                // Match the optional [{FROM | IN} db_name]
+                $database_expression = $this->rewriter->consume();
+                if ( $database_expression->token === 'FROM' || $database_expression->token === 'IN' ) {
+                    $this->rewriter->consume();
+                    $database_expression = $this->rewriter->consume();
+                }
+
+                $pattern = '%';
+                // [LIKE 'pattern' | WHERE expr]
+                if($database_expression->token === 'LIKE') {
+                    $pattern = $this->rewriter->consume()->value;
+                } else if($database_expression->token === 'WHERE') {
+                    // @TODO Support me please.
+                } else if($database_expression->token !== ';') {
+                    throw new Exception( 'Syntax error: Unexpected token ' . $database_expression->token .' in query '. $this->mysql_query );
+                }
+
                 $database_expression = $this->rewriter->skip();
                 $stmt                = $this->execute_sqlite_query(
-                    "SELECT name as `Name`, 'myisam' as `Engine`, 0 as `Data_length`, 0 as `Index_length`, 0 as `Data_free` FROM sqlite_master WHERE type='table' ORDER BY name"
+                    "SELECT
+                        name as `Name`,
+                        'myisam' as `Engine`,
+                        10 as `Version`,
+                        'Fixed' as `Row_format`,
+                        0 as `Rows`,
+                        0 as `Avg_row_length`,
+                        0 as `Data_length`,
+                        0 as `Max_data_length`,
+                        0 as `Index_length`,
+                        0 as `Data_free` ,
+                        0 as `Auto_increment`,
+                        '2024-03-20 15:33:20' as `Create_time`,
+                        '2024-03-20 15:33:20' as `Update_time`,
+                        null as `Check_time`,
+                        null as `Collation`,
+                        null as `Checksum`,
+                        '' as `Create_options`,
+                        '' as `Comment`
+                    FROM sqlite_master
+                    WHERE
+                        type='table'
+                        AND name LIKE :pattern
+                    ORDER BY name",
+
+                    array(
+                        ':pattern' => $pattern,
+                    )
                 );
-
                 $tables = $this->strip_sqlite_system_tables( $stmt->fetchAll( $this->pdo_fetch_mode ) );
                 foreach ( $tables as $table ) {