function DriverSpecificSchemaTestBase::testUnsignedColumns

Tests creating unsigned columns and data integrity thereof.

File

core/tests/Drupal/KernelTests/Core/Database/DriverSpecificSchemaTestBase.php, line 323

Class

DriverSpecificSchemaTestBase

Tests table creation and modification via the schema API.

Namespace

Code

public function testUnsignedColumns() : void {
    // First create the table with just a serial column.
    $table_name = 'unsigned_table';
    $table_spec = [
        'fields' => [
            'serial_column' => [
                'type' => 'serial',
                'unsigned' => TRUE,
                'not null' => TRUE,
            ],
        ],
        'primary key' => [
            'serial_column',
        ],
    ];
    $this->schema
        ->createTable($table_name, $table_spec);
    // Now set up columns for the other types.
    $types = [
        'int',
        'float',
        'numeric',
    ];
    foreach ($types as $type) {
        $column_spec = [
            'type' => $type,
            'unsigned' => TRUE,
        ];
        if ($type == 'numeric') {
            $column_spec += [
                'precision' => 10,
                'scale' => 0,
            ];
        }
        $column_name = $type . '_column';
        $table_spec['fields'][$column_name] = $column_spec;
        $this->schema
            ->addField($table_name, $column_name, $column_spec);
    }
    // Finally, check each column and try to insert invalid values into them.
    foreach ($table_spec['fields'] as $column_name => $column_spec) {
        $this->assertTrue($this->schema
            ->fieldExists($table_name, $column_name), "Unsigned {$column_spec['type']} column was created.");
        $this->assertFalse($this->tryUnsignedInsert($table_name, $column_name), "Unsigned {$column_spec['type']} column rejected a negative value.");
    }
}