test/libraries/common/PMA_extractFieldSpec_test.php

   1
   2 <?php
   3 /* vim: set expandtab sw=4 ts=4 sts=4: */
   4 /**
   5  * Test for PMA_extractFieldSpec from common.lib.php
   6  *
   7  * @package phpMyAdmin-test
   8  * @group common.lib-tests
   9  */
  10
  11 /*
  12  * Include to test.
  13  */
  14 require_once 'libraries/common.lib.php';
  15
  16 /**
  17  * Test for PMA_extractFieldSpec function.
  18  */
  19 class PMA_extractFieldSpec_test extends PHPUnit_Extensions_OutputTestCase
  20 {
  21     /**
  22      * Test case for parsing SHOW COLUMNS output
  23      *
  24      * @dataProvider provider
  25      */
  26     public function testParsing($in, $out)
  27     {
  28         $this->assertEquals($out, PMA_extractFieldSpec($in));
  29     }
  30
  31     /**
  32      * Data provider
  33      *
  34      * @return array
  35      */
  36     public function provider()
  37     {
  38         return array(
  39             array(
  40                 "SET('a','b')",
  41                 array(
  42                     'type' => 'set',
  43                     'print_type' => "set('a', 'b')",
  44                     'binary' => false,
  45                     'unsigned' => false,
  46                     'zerofill' => false,
  47                     'spec_in_brackets' => "'a','b'",
  48                     'enum_set_values' => array('a', 'b'),
  49                     'attribute' => ' ',
  50                     ),
  51                 ),
  52             array(
  53                 "SET('\'a','b')",
  54                 array(
  55                     'type' => 'set',
  56                     'print_type' => "set('\'a', 'b')",
  57                     'binary' => false,
  58                     'unsigned' => false,
  59                     'zerofill' => false,
  60                     'spec_in_brackets' => "'\'a','b'",
  61                     'enum_set_values' => array("'a", 'b'),
  62                     'attribute' => ' ',
  63                     ),
  64                 ),
  65             array(
  66                 "SET('''a','b')",
  67                 array(
  68                     'type' => 'set',
  69                     'print_type' => "set('''a', 'b')",
  70                     'binary' => false,
  71                     'unsigned' => false,
  72                     'zerofill' => false,
  73                     'spec_in_brackets' => "'''a','b'",
  74                     'enum_set_values' => array("'a", 'b'),
  75                     'attribute' => ' ',
  76                     ),
  77                 ),
  78             array(
  79                 "INT UNSIGNED zerofill",
  80                 array(
  81                     'type' => 'int unsigned zerofill',
  82                     'print_type' => 'int',
  83                     'binary' => false,
  84                     'unsigned' => true,
  85                     'zerofill' => true,
  86                     'spec_in_brackets' => '',
  87                     'enum_set_values' => array(),
  88                     'attribute' => 'UNSIGNED ZEROFILL',
  89                     ),
  90                 ),
  91             array(
  92                 "VARCHAR(255)",
  93                 array(
  94                     'type' => 'varchar',
  95                     'print_type' => 'varchar(255)',
  96                     'binary' => false,
  97                     'unsigned' => false,
  98                     'zerofill' => false,
  99                     'spec_in_brackets' => '255',
 100                     'enum_set_values' => array(),
 101                     'attribute' => ' ',
 102                     ),
 103                 ),
 104             array(
 105                 "VARBINARY(255)",
 106                 array(
 107                     'type' => 'varbinary',
 108                     'print_type' => 'varbinary(255)',
 109                     'binary' => false,
 110                     'unsigned' => false,
 111                     'zerofill' => false,
 112                     'spec_in_brackets' => '255',
 113                     'enum_set_values' => array(),
 114                     'attribute' => ' ',
 115                     ),
 116                 ),
 117             );
 118     }
 119 }