Gecko [ fernandoquevedodop.com ]

Name	Size	Permission
db-check.feature	3.67 KB	-rw-r--r--
db-columns.feature	3.56 KB	-rw-r--r--
db-export.feature	2.49 KB	-rw-r--r--
db-import.feature	4.9 KB	-rw-r--r--
db-prefix.feature	224 B	-rw-r--r--
db-query.feature	3.14 KB	-rw-r--r--
db-search.feature	29.69 KB	-rw-r--r--
db-size.feature	5.96 KB	-rw-r--r--
db-tables.feature	5.95 KB	-rw-r--r--
db.feature	8.63 KB	-rw-r--r--

Code Editor : db-columns.feature

Feature: Display information about a given table.

# This requires conditional tags to target different DB versions, as bigint(20) is only bigint on MySQL 8.
  @require-wp-4.2 @broken
  Scenario: Display information about the wp_posts table
    Given a WP install

When I run `wp db columns wp_posts --format=table`
    Then STDOUT should be a table containing rows:
      |         Field         |        Type         | Null | Key |       Default       |     Extra      |
      | ID                    | bigint(20) unsigned | NO   | PRI |                     | auto_increment |
      | post_author           | bigint(20) unsigned | NO   | MUL | 0                   |                |
      | post_date             | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
      | post_date_gmt         | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
      | post_content          | longtext            | NO   |     |                     |                |
      | post_title            | text                | NO   |     |                     |                |
      | post_excerpt          | text                | NO   |     |                     |                |
      | post_status           | varchar(20)         | NO   |     | publish             |                |
      | comment_status        | varchar(20)         | NO   |     | open                |                |
      | ping_status           | varchar(20)         | NO   |     | open                |                |
      | post_password         | varchar(255)        | NO   |     |                     |                |
      | post_name             | varchar(200)        | NO   | MUL |                     |                |
      | to_ping               | text                | NO   |     |                     |                |
      | pinged                | text                | NO   |     |                     |                |
      | post_modified         | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
      | post_modified_gmt     | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
      | post_content_filtered | longtext            | NO   |     |                     |                |
      | post_parent           | bigint(20) unsigned | NO   | MUL | 0                   |                |
      | guid                  | varchar(255)        | NO   |     |                     |                |
      | menu_order            | int(11)             | NO   |     | 0                   |                |
      | post_type             | varchar(20)         | NO   | MUL | post                |                |
      | post_mime_type        | varchar(100)        | NO   |     |                     |                |
      | comment_count         | bigint(20)          | NO   |     | 0                   |                |

Scenario: Display information about non-existing table
    Given a WP install

When I try `wp db columns wp_foobar`
    Then STDERR should contain:
      """
      Couldn't find any tables matching: wp_foobar
      """

Scenario: Display information about a non default WordPress table
    Given a WP install
    And I run `wp db query "CREATE TABLE not_wp ( date DATE NOT NULL, awesome_stuff TEXT, PRIMARY KEY (date) );;"`

${this.title}

Code Editor : db-columns.feature