/** * Test for getColumns */ public function testGetColumns(){ $this->assertEquals( $this->object->getColumns(), array( 'INT', 'VARCHAR', 'TEXT', 'DATE', ) ); }
/** * Test for getColumns */ public function testGetColumns(){ if (! defined('PMA_MYSQL_INT_VERSION')) { define('PMA_MYSQL_INT_VERSION', 20120130); } $this->assertEquals( $this->object->getColumns(), array( 0 => 'INT', 1 => 'VARCHAR', 2 => 'TEXT', 3 => 'DATE', 'Numeric' => array ( 'INTEGER', 'BIGINT', '-', 'DECIMAL', 'DOUBLE', '-', 'BOOLEAN', 'SERIAL', 'UUID', ), 'Date and time' => array ( 'DATE', 'DATETIME', 'TIMESTAMP', 'TIME', ), 'String' => array ( 'VARCHAR', 'TEXT', '-', 'VARBINARY', 'BLOB', '-', 'ENUM', '-', 'IPV6' ), ) ); }
/** * Test for getColumns */ public function testGetColumns() { $this->assertEquals( array( 0 => 'INT', 1 => 'VARCHAR', 2 => 'TEXT', 3 => 'DATE', 'Numeric' => array ( 'INTEGER', 'BIGINT', '-', 'DECIMAL', 'DOUBLE', '-', 'BOOLEAN', 'SERIAL', 'UUID', ), 'Date and time' => array ( 'DATE', 'DATETIME', 'TIMESTAMP', 'TIME', ), 'String' => array ( 'VARCHAR', 'TEXT', '-', 'VARBINARY', 'BLOB', '-', 'ENUM', ), ), $this->object->getColumns() ); }
/** * Returns array of all column types available. * * @return array * */ public function getColumns() { $types_num = array('INTEGER', 'BIGINT', '-', 'DECIMAL', 'DOUBLE', '-', 'BOOLEAN', 'SERIAL', 'UUID'); $types_date = array('DATE', 'DATETIME', 'TIMESTAMP', 'TIME'); $types_string = array('VARCHAR', 'TEXT', '-', 'VARBINARY', 'BLOB', '-', 'ENUM'); if (PMA_MYSQL_INT_VERSION >= 20120130) { $types_string[] = '-'; $types_string[] = 'IPV6'; } $ret = parent::getColumns(); // numeric $ret[_pgettext('numeric types', 'Numeric')] = $types_num; // Date/Time $ret[_pgettext('date and time types', 'Date and time')] = $types_date; // Text $ret[_pgettext('string types', 'String')] = $types_string; return $ret; }
/** * Test for getColumns * * @return void */ public function testGetColumns() { $this->assertEquals(array(0 => 'INT', 1 => 'VARCHAR', 2 => 'TEXT', 3 => 'DATE', 'Numeric' => array('TINYINT', 'SMALLINT', 'MEDIUMINT', 'INT', 'BIGINT', '-', 'DECIMAL', 'FLOAT', 'DOUBLE', 'REAL', '-', 'BIT', 'BOOLEAN', 'SERIAL'), 'Date and time' => array('DATE', 'DATETIME', 'TIMESTAMP', 'TIME', 'YEAR'), 'String' => array('CHAR', 'VARCHAR', '-', 'TINYTEXT', 'TEXT', 'MEDIUMTEXT', 'LONGTEXT', '-', 'BINARY', 'VARBINARY', '-', 'TINYBLOB', 'MEDIUMBLOB', 'BLOB', 'LONGBLOB', '-', 'ENUM', 'SET'), 'Spatial' => array('GEOMETRY', 'POINT', 'LINESTRING', 'POLYGON', 'MULTIPOINT', 'MULTILINESTRING', 'MULTIPOLYGON', 'GEOMETRYCOLLECTION')), $this->object->getColumns()); }
/** * Returns array of all column types available. * * VARCHAR, TINYINT, TEXT and DATE are listed first, based on * estimated popularity. * * @return string[] * */ public function getColumns() { $ret = parent::getColumns(); // numeric $ret[_pgettext('numeric types', 'Numeric')] = array('TINYINT', 'SMALLINT', 'MEDIUMINT', 'INT', 'BIGINT', '-', 'DECIMAL', 'FLOAT', 'DOUBLE', 'REAL', '-', 'BIT', 'BOOLEAN', 'SERIAL'); // Date/Time $ret[_pgettext('date and time types', 'Date and time')] = array('DATE', 'DATETIME', 'TIMESTAMP', 'TIME', 'YEAR'); // Text $ret[_pgettext('string types', 'String')] = array('CHAR', 'VARCHAR', '-', 'TINYTEXT', 'TEXT', 'MEDIUMTEXT', 'LONGTEXT', '-', 'BINARY', 'VARBINARY', '-', 'TINYBLOB', 'MEDIUMBLOB', 'BLOB', 'LONGBLOB', '-', 'ENUM', 'SET'); $ret[_pgettext('spatial types', 'Spatial')] = array('GEOMETRY', 'POINT', 'LINESTRING', 'POLYGON', 'MULTIPOINT', 'MULTILINESTRING', 'MULTIPOLYGON', 'GEOMETRYCOLLECTION'); return $ret; }
public function testUnary() { $this->assertTrue($this->object->isUnaryOperator('IS NULL')); $this->assertFalse($this->object->isUnaryOperator('=')); }