OraclePlatform
Hierarchy
- AbstractSqlPlatform
- OraclePlatform
Index
Constructors
Methods
- allowsComparingTuples
- cloneEmbeddable
- compareUuids
- convertDateToJSValue
- convertIntervalToDatabaseValue
- convertIntervalToJSValue
- convertJsonToDatabaseValue
- convertJsonToJSValue
- convertsJsonAutomatically
- convertUuidToDatabaseValue
- convertUuidToJSValue
- convertVersionValue
- createOutBindings
- denormalizePrimaryKey
- escape
- extractSimpleType
- formatQuery
- generateCustomOrder
- getArrayDeclarationSQL
- getBeginTransactionSQL
- getBigIntTypeDeclarationSQL
- getBlobDeclarationSQL
- getBooleanTypeDeclarationSQL
- getCharTypeDeclarationSQL
- getCommitTransactionSQL
- getConfig
- getCurrentTimestampSQL
- getDateTimeTypeDeclarationSQL
- getDateTypeDeclarationSQL
- getDecimalTypeDeclarationSQL
- getDefaultCharLength
- getDefaultCharset
- getDefaultClientUrl
- getDefaultDateTimeLength
- getDefaultMappedType
- getDefaultPrimaryName
- getDefaultSchemaName
- getDefaultVarcharLength
- getDefaultVersionLength
- getDoubleDeclarationSQL
- getEnumTypeDeclarationSQL
- getExceptionConverter
- getExtension
- getFloatDeclarationSQL
- getFullTextIndexExpression
- getFullTextWhereClause
- getIndexName
- getIntegerTypeDeclarationSQL
- getIntervalTypeDeclarationSQL
- getJsonDeclarationSQL
- getJsonIndexDefinition
- getMappedType
- getMediumIntTypeDeclarationSQL
- getNamingStrategy
- getRegExpOperator
- getRegExpValue
- getReleaseSavepointSQL
- getRepositoryClass
- getRollbackToSavepointSQL
- getRollbackTransactionSQL
- getSavepointSQL
- getSchemaGenerator
- getSchemaHelper
- getSearchJsonPropertyKey
- getSearchJsonPropertySQL
- getSmallIntTypeDeclarationSQL
- getTextTypeDeclarationSQL
- getTimeTypeDeclarationSQL
- getTimezone
- getTinyIntTypeDeclarationSQL
- getUuidTypeDeclarationSQL
- getVarcharTypeDeclarationSQL
- indexForeignKeys
- isAllowedTopLevelOperator
- isBigIntProperty
- isNumericColumn
- isNumericProperty
- isPopulated
- lookupExtensions
- mapRegExpCondition
- mapToOracleType
- marshallArray
- normalizeColumnType
- normalizePrimaryKey
- parseDate
- processDateProperty
- processJsonCondition
- quoteIdentifier
- quoteValue
- setConfig
- shouldHaveColumn
- supportsCreatingFullTextIndex
- supportsCustomPrimaryKeyNames
- supportsDeferredUniqueConstraints
- supportsDownMigrations
- supportsMaterializedViews
- supportsMultipleCascadePaths
- supportsMultipleStatements
- supportsNativeEnums
- supportsOnUpdate
- supportsSchemas
- supportsTransactions
- supportsUnionWhere
- supportsUnsigned
- unmarshallArray
- usesAsKeyword
- usesBatchInserts
- usesBatchUpdates
- usesCascadeStatement
- usesDefaultKeyword
- usesEnumCheckConstraints
- usesImplicitTransactions
- usesOutputStatement
- usesPivotTable
- usesReturningStatement
- validateMetadata
Constructors
constructor
Returns OraclePlatform
Methods
allowsComparingTuples
Returns boolean
inheritedcloneEmbeddable
Parameters
data: T
Returns T
compareUuids
Returns string
inheritedconvertDateToJSValue
Parameters
value: string | Date
Returns string
inheritedconvertIntervalToDatabaseValue
Parameters
value: unknown
Returns unknown
inheritedconvertIntervalToJSValue
Parameters
value: string
Returns unknown
inheritedconvertJsonToDatabaseValue
Parameters
value: unknown
optionalcontext: TransformContext
Returns unknown
inheritedconvertJsonToJSValue
Parameters
value: unknown
optionalcontext: TransformContext
Returns unknown
convertsJsonAutomatically
Returns boolean
convertUuidToDatabaseValue
Parameters
value: string
Returns Buffer<ArrayBufferLike>
convertUuidToJSValue
Parameters
value: Buffer<ArrayBufferLike>
Returns string
inheritedconvertVersionValue
Parameters
value: number | Date
prop: EntityProperty<any, any>
Returns string | number | Date | { $in: (string | number)[] }
createOutBindings
Parameters
map: Dictionary<string>
Returns Dictionary
inheriteddenormalizePrimaryKey
Converts scalar primary key representation to native driver wrapper (e.g. string to mongodb's ObjectId)
Parameters
data: IPrimaryKeyValue
Returns IPrimaryKeyValue
escape
Parameters
value: any
Returns string
inheritedextractSimpleType
Parameters
type: string
Returns string
inheritedformatQuery
Parameters
sql: string
params: readonly any[]
Returns string
inheritedgenerateCustomOrder
Generates a custom order by statement given a set of in order values, eg. ORDER BY (CASE WHEN priority = 'low' THEN 1 WHEN priority = 'medium' THEN 2 ELSE NULL END)
Parameters
escapedColumn: string
values: unknown[]
Returns string
getArrayDeclarationSQL
Returns string
getBeginTransactionSQL
Parameters
optionaloptions: { isolationLevel?: IsolationLevel; readOnly?: boolean }
optionalisolationLevel: IsolationLevel
optionalreadOnly: boolean
Returns string[]
getBigIntTypeDeclarationSQL
Parameters
column: { autoincrement?: boolean; length?: number; unsigned?: boolean }
optionalautoincrement: boolean
optionallength: number
optionalunsigned: boolean
Returns string
getBlobDeclarationSQL
Returns string
getBooleanTypeDeclarationSQL
Returns string
inheritedgetCharTypeDeclarationSQL
Parameters
column: { length?: number }
optionallength: number
Returns string
inheritedgetCommitTransactionSQL
Returns string
inheritedgetConfig
getCurrentTimestampSQL
Returns the SQL specific for the platform to get the current timestamp
Parameters
length: number
Returns string
getDateTimeTypeDeclarationSQL
Parameters
column: { length?: number }
optionallength: number
Returns string
getDateTypeDeclarationSQL
Parameters
optionallength: number
Returns string
getDecimalTypeDeclarationSQL
Parameters
column: { precision?: number; scale?: number }
optionalprecision: number
optionalscale: number
Returns string
inheritedgetDefaultCharLength
Returns number
inheritedgetDefaultCharset
Returns string
getDefaultClientUrl
Returns default client url for given driver (e.g. mongodb://127.0.0.1:27017 for mongodb)
Returns string
getDefaultDateTimeLength
Returns number
getDefaultMappedType
Parameters
type: string
Returns Type<unknown, unknown>
inheritedgetDefaultPrimaryName
Parameters
tableName: string
columns: string[]
Returns string
getDefaultSchemaName
Returns undefined | string
inheritedgetDefaultVarcharLength
Returns number
inheritedgetDefaultVersionLength
Returns number
getDoubleDeclarationSQL
Returns string
getEnumTypeDeclarationSQL
Parameters
column: { autoincrement?: boolean; fieldNames: string[]; items?: unknown[]; length?: number; unsigned?: boolean }
optionalautoincrement: boolean
fieldNames: string[]
optionalitems: unknown[]
optionallength: number
optionalunsigned: boolean
Returns string
inheritedgetExceptionConverter
Returns ExceptionConverter
inheritedgetExtension
Parameters
extensionName: string
extensionKey: string
moduleName: string
em: EntityManager<IDatabaseDriver<Connection>>
Returns T
getFloatDeclarationSQL
Returns string
inheritedgetFullTextIndexExpression
Parameters
indexName: string
schemaName: undefined | string
tableName: string
columns: SimpleColumnMeta[]
Returns string
inheritedgetFullTextWhereClause
Parameters
prop: EntityProperty<any, any>
Returns string
inheritedgetIndexName
Returns the default name of index for the given columns
Parameters
tableName: string
columns: string[]
type: primary | index | unique | foreign | sequence
Returns string
getIntegerTypeDeclarationSQL
Parameters
column: { autoincrement?: boolean; length?: number; unsigned?: boolean }
optionalautoincrement: boolean
optionallength: number
optionalunsigned: boolean
Returns string
inheritedgetIntervalTypeDeclarationSQL
Parameters
column: { length?: number }
optionallength: number
Returns string
getJsonDeclarationSQL
Returns string
inheritedgetJsonIndexDefinition
Parameters
index: IndexDef
Returns string[]
inheritedgetMappedType
Parameters
type: string
Returns Type<unknown, unknown>
getMediumIntTypeDeclarationSQL
Parameters
column: { autoincrement?: boolean; length?: number; unsigned?: boolean }
optionalautoincrement: boolean
optionallength: number
optionalunsigned: boolean
Returns string
inheritedgetNamingStrategy
Returns new () => NamingStrategy
Returns NamingStrategy
getRegExpOperator
Returns string
inheritedgetRegExpValue
Parameters
val: RegExp
Returns { $flags?: string; $re: string }
optional$flags?: string
$re: string
inheritedgetReleaseSavepointSQL
Parameters
savepointName: string
Returns string
inheritedgetRepositoryClass
Returns Constructor<EntityRepository<T>>
getRollbackToSavepointSQL
Parameters
savepointName: string
Returns string
inheritedgetRollbackTransactionSQL
Returns string
getSavepointSQL
Parameters
savepointName: string
Returns string
getSchemaGenerator
Parameters
driver: IDatabaseDriver<Connection>
optionalem: SqlEntityManager<AbstractSqlDriver<AbstractSqlConnection, AbstractSqlPlatform>>
Returns OracleSchemaGenerator
inheritedgetSchemaHelper
Returns undefined | SchemaHelper
getSearchJsonPropertyKey
Parameters
path: string[]
type: string
aliased: boolean
optionalvalue: unknown
Returns string
inheritedgetSearchJsonPropertySQL
Parameters
path: string
type: string
aliased: boolean
Returns string | RawQueryFragment<string>
getSmallIntTypeDeclarationSQL
Parameters
column: { autoincrement?: boolean; length?: number; unsigned?: boolean }
optionalautoincrement: boolean
optionallength: number
optionalunsigned: boolean
Returns string
getTextTypeDeclarationSQL
Parameters
_column: { length?: number }
optionallength: number
Returns string
getTimeTypeDeclarationSQL
Parameters
optionallength: number
Returns string
inheritedgetTimezone
Returns undefined | string
getTinyIntTypeDeclarationSQL
Parameters
column: { autoincrement?: boolean; length?: number; unsigned?: boolean }
optionalautoincrement: boolean
optionallength: number
optionalunsigned: boolean
Returns string
getUuidTypeDeclarationSQL
Parameters
column: { length?: number }
optionallength: number
Returns string
getVarcharTypeDeclarationSQL
Parameters
column: { length?: number }
optionallength: number
Returns string
indexForeignKeys
Returns boolean
inheritedisAllowedTopLevelOperator
Parameters
operator: string
Returns boolean
inheritedisBigIntProperty
Parameters
prop: EntityProperty<any, any>
Returns boolean
inheritedisNumericColumn
Parameters
mappedType: Type<unknown, unknown>
Returns boolean
inheritedisNumericProperty
Parameters
prop: EntityProperty<any, any>
ignoreCustomType: boolean = false
Returns boolean
inheritedisPopulated
Parameters
key: string
populate: boolean | readonly PopulateOptions<T>[]
Returns boolean
lookupExtensions
Allows registering extensions of the driver automatically (e.g.
SchemaGeneratorextension in SQL drivers).Parameters
orm: MikroORM<IDatabaseDriver<Connection>, EntityManager<IDatabaseDriver<Connection>>, (string | EntityClass<Partial<any>> | EntitySchema<any, never, EntityCtor<any>>)[]>
Returns void
mapRegExpCondition
Parameters
mappedKey: string
value: { $flags?: string; $re: string }
optional$flags: string
$re: string
Returns { params: unknown[]; sql: string }
params: unknown[]
sql: string
mapToOracleType
Parameters
type: string
Returns unknown
inheritedmarshallArray
Parameters
values: string[]
Returns string
normalizeColumnType
This should be used only to compare types, it can strip some information like the length.
Parameters
type: string
options: { length?: number; precision?: number; scale?: number }
optionallength: number
optionalprecision: number
optionalscale: number
Returns string
inheritednormalizePrimaryKey
Normalizes primary key wrapper to scalar value (e.g. mongodb's ObjectId to string)
Parameters
data: IPrimaryKeyValue | Primary<T>
Returns T
inheritedparseDate
Parameters
value: string | number
Returns Date
inheritedprocessDateProperty
Parameters
value: unknown
Returns string | number | Date
processJsonCondition
Parameters
o: FilterQuery<T>
value: EntityValue<T>
path: EntityKey<T>[]
alias: boolean
Returns FilterQuery<T>
quoteIdentifier
Parameters
id: string
Returns string
inheritedquoteValue
Parameters
value: any
Returns string
inheritedsetConfig
Parameters
Returns void
inheritedshouldHaveColumn
Parameters
prop: EntityProperty<T, any>
populate: boolean | readonly PopulateOptions<T>[]
optionalexclude: string[]
includeFormulas: boolean = true
ignoreInlineEmbeddables: boolean = true
Returns boolean
inheritedsupportsCreatingFullTextIndex
Returns boolean
inheritedsupportsCustomPrimaryKeyNames
Returns boolean
inheritedsupportsDeferredUniqueConstraints
Returns boolean
inheritedsupportsDownMigrations
Currently not supported due to how knex does complex sqlite diffing (always based on current schema)
Returns boolean
inheritedsupportsMaterializedViews
Returns boolean
supportsMultipleCascadePaths
Returns boolean
supportsMultipleStatements
Returns boolean
inheritedsupportsNativeEnums
for postgres native enums
Returns boolean
supportsOnUpdate
Returns true if the platform supports ON UPDATE foreign key rules. Oracle doesn't support ON UPDATE rules.
Returns boolean
supportsSchemas
Returns boolean
inheritedsupportsTransactions
Returns boolean
inheritedsupportsUnionWhere
Returns boolean
inheritedsupportsUnsigned
Returns boolean
inheritedunmarshallArray
Parameters
value: string
Returns string[]
usesAsKeyword
Returns boolean
inheritedusesBatchInserts
Whether or not the driver supports retuning list of created PKs back when multi-inserting
Returns boolean
inheritedusesBatchUpdates
Whether or not the driver supports updating many records at once
Returns boolean
usesCascadeStatement
Returns boolean
inheritedusesDefaultKeyword
Returns boolean
usesEnumCheckConstraints
for postgres text enums (default)
Returns boolean
inheritedusesImplicitTransactions
Returns boolean
usesOutputStatement
Returns boolean
inheritedusesPivotTable
Returns boolean
usesReturningStatement
Returns boolean
inheritedvalidateMetadata
Parameters
meta: EntityMetadata<any, EntityCtor<any>>
Returns void
Determines how UUID values are compared in the change set tracking. Return
'string'for inline string comparison (fast), or'any'for deep comparison via type methods.