Use value instead of ID for the primary key column

2ndkauboy · 2ndkauboy · commit 1c9b2e862d57 · 2024-04-26T16:34:49.000+02:00
diff --git a/src/DB_Command.php b/src/DB_Command.php
@@ -1301,14 +1301,14 @@ public function prefix() {
 	 *
 	 *     # Search for a string and print the result as a table
 	 *     $ wp db search https://localhost:8889 --format=table
-	 *     +------------+--------------+-----------+----+-----------------------------+
-	 *     | table      | column       | key       | ID | match                       |
-	 *     +------------+--------------+-----------+----+-----------------------------+
-	 *     | wp_options | option_value | option_id | 1  | https://localhost:8889      |
-	 *     | wp_options | option_value | option_id | 2  | https://localhost:8889      |
-	 *     | wp_posts   | guid         | ID        | 1  | https://localhost:8889/?p=1 |
-	 *     | wp_users   | user_url     | ID        | 1  | https://localhost:8889      |
-	 *     +------------+--------------+-----------+----+-----------------------------+
+	 *     +------------+--------------+-----------+-------+-----------------------------+
+	 *     | table      | column       | key       | value | match                       |
+	 *     +------------+--------------+-----------+-------+-----------------------------+
+	 *     | wp_options | option_value | option_id | 1     | https://localhost:8889      |
+	 *     | wp_options | option_value | option_id | 2     | https://localhost:8889      |
+	 *     | wp_posts   | guid         | ID        | 1     | https://localhost:8889/?p=1 |
+	 *     | wp_users   | user_url     | ID        | 1     | https://localhost:8889      |
+	 *     +------------+--------------+-----------+-------+-----------------------------+
 	 *
 	 *     # Search for a string and get only the IDs (only works for a single table)
 	 *     $ wp db search https://localhost:8889 wp_options --format=ids
@@ -1487,7 +1487,7 @@ public function search( $args, $assoc_args ) {
 									'table'  => $table,
 									'column' => $column,
 									'key'    => $primary_key,
-									'ID'     => $result->$primary_key,
+									'value'  => $result->$primary_key,
 									// Remove the colors for the format output.
 									'match'  => str_replace( [ $colors['match'][0], $colors['match'][1] ], [ '', '' ], $col_val ),
 								];
@@ -1504,7 +1504,7 @@ public function search( $args, $assoc_args ) {
 			$formatter_args   = [
 				'format' => $format,
 			];
-			$formatter_fields = [ 'table', 'column', 'key', 'ID', 'match' ];
+			$formatter_fields = [ 'table', 'column', 'key', 'value', 'match' ];
 
 			if ( $fields ) {
 				$fields           = explode( ',', $assoc_args['fields'] );
@@ -1515,7 +1515,7 @@ public function search( $args, $assoc_args ) {
 				if ( count( $tables ) > 1 ) {
 					WP_CLI::error( 'The "ids" format can only be used for a single table.' );
 				}
-				$search_results = array_column( $search_results, 'ID' );
+				$search_results = array_column( $search_results, 'value' );
 			}
 
 			$formatter = new Formatter( $formatter_args, $formatter_fields );
