Changeset 33175

Timestamp:

07/12/2015 05:28:15 PM (9 years ago)

Author:

jorbin

Message:

Add dbDelta insert test

Test to make sure that dbDelta properly inserts a value into the DB.

Props tryon, jtsternberg, ebinnion, JPry, avnarun, kevkoeh, salcode.
Fixes #29020.

File:

• trunk/tests/phpunit/tests/dbdelta.php (modified) (1 diff)

trunk/tests/phpunit/tests/dbdelta.php

@@ -231 +231 @@
     }
 
+    /**
+     * Test inserting into the database
+     */
+    public function test_insert_into_table(){
+        global $wpdb;
+
+        $insert = dbDelta(
+            "INSERT INTO {$wpdb->prefix}dbdelta_test (column_1) VALUES ('wcphilly2015')"
+        );
+
+        $this->assertEquals(
+            array( )
+            , $insert
+        );
+
+        $this->assertTableRowHasValue( 'column_1', 'wcphilly2015',  $wpdb->prefix . 'dbdelta_test' );
+
+    }
+    
     //
     // Assertions.
     //
+
+    /**
+     * Assert that a table has a row with a value in a field.
+     *
+     * @param string $column The field name.
+     * @param string $value  The field value.
+     * @param string $table  The database table name.
+     */
+    protected function assertTableRowHasValue( $column, $value, $table ) {
+
+        global $wpdb;
+
+        $table_row = $wpdb->get_row( "select $column from {$table} where $column = '$value'" );
+
+        $expected = (object) array(
+            $column => $value
+        );
+
+        $this->assertEquals( $expected, $table_row );
+    }
 
     /**