|
5 | 5 | namespace Yiisoft\Db\Oracle; |
6 | 6 |
|
7 | 7 | use Yiisoft\Db\Connection\ServerInfoInterface; |
8 | | -use Yiisoft\Db\Constant\ColumnType; |
9 | | -use Yiisoft\Db\Constant\PseudoType; |
10 | 8 | use Yiisoft\Db\Oracle\Column\ColumnDefinitionBuilder; |
11 | 9 | use Yiisoft\Db\QueryBuilder\AbstractQueryBuilder; |
12 | 10 | use Yiisoft\Db\Schema\QuoterInterface; |
|
19 | 17 | */ |
20 | 18 | final class QueryBuilder extends AbstractQueryBuilder |
21 | 19 | { |
22 | | - /** |
23 | | - * @psalm-var string[] $typeMap Mapping from abstract column types (keys) to physical column types (values). |
24 | | - */ |
25 | | - protected array $typeMap = [ |
26 | | - PseudoType::PK => 'NUMBER(10) GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY', |
27 | | - PseudoType::UPK => 'NUMBER(10) GENERATED BY DEFAULT AS IDENTITY UNSIGNED NOT NULL PRIMARY KEY', |
28 | | - PseudoType::BIGPK => 'NUMBER(20) GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY', |
29 | | - PseudoType::UBIGPK => 'NUMBER(20) GENERATED BY DEFAULT AS IDENTITY UNSIGNED NOT NULL PRIMARY KEY', |
30 | | - ColumnType::CHAR => 'CHAR(1)', |
31 | | - ColumnType::STRING => 'VARCHAR2(255)', |
32 | | - ColumnType::TEXT => 'CLOB', |
33 | | - ColumnType::TINYINT => 'NUMBER(3)', |
34 | | - ColumnType::SMALLINT => 'NUMBER(5)', |
35 | | - ColumnType::INTEGER => 'NUMBER(10)', |
36 | | - ColumnType::BIGINT => 'NUMBER(20)', |
37 | | - ColumnType::FLOAT => 'BINARY_FLOAT', |
38 | | - ColumnType::DOUBLE => 'BINARY_DOUBLE', |
39 | | - ColumnType::DECIMAL => 'NUMBER(10,0)', |
40 | | - ColumnType::DATETIME => 'TIMESTAMP(0)', |
41 | | - ColumnType::TIMESTAMP => 'TIMESTAMP(0)', |
42 | | - ColumnType::TIME => 'INTERVAL DAY(0) TO SECOND(0)', |
43 | | - ColumnType::DATE => 'DATE', |
44 | | - ColumnType::BINARY => 'BLOB', |
45 | | - ColumnType::BOOLEAN => 'NUMBER(1)', |
46 | | - ColumnType::MONEY => 'NUMBER(19,4)', |
47 | | - ColumnType::UUID => 'RAW(16)', |
48 | | - PseudoType::UUID_PK => 'RAW(16) DEFAULT SYS_GUID() PRIMARY KEY', |
49 | | - ]; |
50 | | - |
51 | 20 | public function __construct(QuoterInterface $quoter, SchemaInterface $schema, ServerInfoInterface $serverInfo) |
52 | 21 | { |
53 | 22 | parent::__construct( |
|
0 commit comments