import { Driver } from "../Driver";
|
import { OracleQueryRunner } from "./OracleQueryRunner";
|
import { ObjectLiteral } from "../../common/ObjectLiteral";
|
import { ColumnMetadata } from "../../metadata/ColumnMetadata";
|
import { Connection } from "../../connection/Connection";
|
import { RdbmsSchemaBuilder } from "../../schema-builder/RdbmsSchemaBuilder";
|
import { OracleConnectionOptions } from "./OracleConnectionOptions";
|
import { MappedColumnTypes } from "../types/MappedColumnTypes";
|
import { ColumnType } from "../types/ColumnTypes";
|
import { DataTypeDefaults } from "../types/DataTypeDefaults";
|
import { TableColumn } from "../../schema-builder/table/TableColumn";
|
import { OracleConnectionCredentialsOptions } from "./OracleConnectionCredentialsOptions";
|
import { EntityMetadata } from "../../metadata/EntityMetadata";
|
/**
|
* Organizes communication with Oracle RDBMS.
|
*/
|
export declare class OracleDriver implements Driver {
|
/**
|
* Connection used by driver.
|
*/
|
connection: Connection;
|
/**
|
* Underlying oracle library.
|
*/
|
oracle: any;
|
/**
|
* Pool for master database.
|
*/
|
master: any;
|
/**
|
* Pool for slave databases.
|
* Used in replication.
|
*/
|
slaves: any[];
|
/**
|
* Connection options.
|
*/
|
options: OracleConnectionOptions;
|
/**
|
* Master database used to perform all write queries.
|
*/
|
database?: string;
|
/**
|
* Indicates if replication is enabled.
|
*/
|
isReplicated: boolean;
|
/**
|
* Indicates if tree tables are supported by this driver.
|
*/
|
treeSupport: boolean;
|
/**
|
* Gets list of supported column data types by a driver.
|
*
|
* @see https://www.techonthenet.com/oracle/datatypes.php
|
* @see https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT012
|
*/
|
supportedDataTypes: ColumnType[];
|
/**
|
* Gets list of spatial column data types.
|
*/
|
spatialTypes: ColumnType[];
|
/**
|
* Gets list of column data types that support length by a driver.
|
*/
|
withLengthColumnTypes: ColumnType[];
|
/**
|
* Gets list of column data types that support precision by a driver.
|
*/
|
withPrecisionColumnTypes: ColumnType[];
|
/**
|
* Gets list of column data types that support scale by a driver.
|
*/
|
withScaleColumnTypes: ColumnType[];
|
/**
|
* Orm has special columns and we need to know what database column types should be for those types.
|
* Column types are driver dependant.
|
*/
|
mappedDataTypes: MappedColumnTypes;
|
/**
|
* Default values of length, precision and scale depends on column data type.
|
* Used in the cases when length/precision/scale is not specified by user.
|
*/
|
dataTypeDefaults: DataTypeDefaults;
|
/**
|
* Max length allowed by Oracle for aliases.
|
* @see https://docs.oracle.com/database/121/SQLRF/sql_elements008.htm#SQLRF51129
|
* > The following list of rules applies to both quoted and nonquoted identifiers unless otherwise indicated
|
* > Names must be from 1 to 30 bytes long with these exceptions:
|
* > [...]
|
*
|
* Since Oracle 12.2 (with a compatible driver/client), the limit has been set to 128.
|
* @see https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/Database-Object-Names-and-Qualifiers.html
|
*
|
* > If COMPATIBLE is set to a value of 12.2 or higher, then names must be from 1 to 128 bytes long with these exceptions
|
*/
|
maxAliasLength: number;
|
constructor(connection: Connection);
|
/**
|
* Performs connection to the database.
|
* Based on pooling options, it can either create connection immediately,
|
* either create a pool and create connection when needed.
|
*/
|
connect(): Promise<void>;
|
/**
|
* Makes any action after connection (e.g. create extensions in Postgres driver).
|
*/
|
afterConnect(): Promise<void>;
|
/**
|
* Closes connection with the database.
|
*/
|
disconnect(): Promise<void>;
|
/**
|
* Creates a schema builder used to build and sync a schema.
|
*/
|
createSchemaBuilder(): RdbmsSchemaBuilder;
|
/**
|
* Creates a query runner used to execute database queries.
|
*/
|
createQueryRunner(mode?: "master" | "slave"): OracleQueryRunner;
|
/**
|
* Replaces parameters in the given sql with special escaping character
|
* and an array of parameter names to be passed to a query.
|
*/
|
escapeQueryWithParameters(sql: string, parameters: ObjectLiteral, nativeParameters: ObjectLiteral): [string, any[]];
|
/**
|
* Escapes a column name.
|
*/
|
escape(columnName: string): string;
|
/**
|
* Build full table name with database name, schema name and table name.
|
* Oracle does not support table schemas. One user can have only one schema.
|
*/
|
buildTableName(tableName: string, schema?: string, database?: string): string;
|
/**
|
* Prepares given value to a value to be persisted, based on its column type and metadata.
|
*/
|
preparePersistentValue(value: any, columnMetadata: ColumnMetadata): any;
|
/**
|
* Prepares given value to a value to be persisted, based on its column type or metadata.
|
*/
|
prepareHydratedValue(value: any, columnMetadata: ColumnMetadata): any;
|
/**
|
* Creates a database type from a given column metadata.
|
*/
|
normalizeType(column: {
|
type?: ColumnType;
|
length?: number | string;
|
precision?: number | null;
|
scale?: number;
|
isArray?: boolean;
|
}): string;
|
/**
|
* Normalizes "default" value of the column.
|
*/
|
normalizeDefault(columnMetadata: ColumnMetadata): string;
|
/**
|
* Normalizes "isUnique" value of the column.
|
*/
|
normalizeIsUnique(column: ColumnMetadata): boolean;
|
/**
|
* Calculates column length taking into account the default length values.
|
*/
|
getColumnLength(column: ColumnMetadata | TableColumn): string;
|
createFullType(column: TableColumn): string;
|
/**
|
* Obtains a new database connection to a master server.
|
* Used for replication.
|
* If replication is not setup then returns default connection's database connection.
|
*/
|
obtainMasterConnection(): Promise<any>;
|
/**
|
* Obtains a new database connection to a slave server.
|
* Used for replication.
|
* If replication is not setup then returns master (default) connection's database connection.
|
*/
|
obtainSlaveConnection(): Promise<any>;
|
/**
|
* Creates generated map of values generated or returned by database after INSERT query.
|
*/
|
createGeneratedMap(metadata: EntityMetadata, insertResult: ObjectLiteral): ObjectLiteral | undefined;
|
/**
|
* Differentiate columns of this table and columns from the given column metadatas columns
|
* and returns only changed.
|
*/
|
findChangedColumns(tableColumns: TableColumn[], columnMetadatas: ColumnMetadata[]): ColumnMetadata[];
|
/**
|
* Returns true if driver supports RETURNING / OUTPUT statement.
|
*/
|
isReturningSqlSupported(): boolean;
|
/**
|
* Returns true if driver supports uuid values generation on its own.
|
*/
|
isUUIDGenerationSupported(): boolean;
|
/**
|
* Creates an escaped parameter.
|
*/
|
createParameter(parameterName: string, index: number): string;
|
/**
|
* Converts column type in to native oracle type.
|
*/
|
columnTypeToNativeParameter(type: ColumnType): any;
|
/**
|
* Loads all driver dependencies.
|
*/
|
protected loadDependencies(): void;
|
/**
|
* Creates a new connection pool for a given database credentials.
|
*/
|
protected createPool(options: OracleConnectionOptions, credentials: OracleConnectionCredentialsOptions): Promise<any>;
|
/**
|
* Closes connection pool.
|
*/
|
protected closePool(pool: any): Promise<void>;
|
}
|
