Class FirebirdProcessor

Inheritance
object
ProcessorBase
GenericProcessorBase
FirebirdProcessor
Implements
Inherited Members
Namespace: FluentMigrator.Runner.Processors.Firebird
Assembly: FluentMigrator.Runner.Firebird.dll
Syntax
public class FirebirdProcessor : GenericProcessorBase, IMigrationProcessor, IQuerySchema, IDisposable

Constructors

| Edit this page View Source

FirebirdProcessor(FirebirdDbFactory, FirebirdGenerator, FirebirdQuoter, ILogger<FirebirdProcessor>, IOptionsSnapshot<ProcessorOptions>, IConnectionStringAccessor, FirebirdOptions)

Declaration
public FirebirdProcessor(FirebirdDbFactory factory, FirebirdGenerator generator, FirebirdQuoter quoter, ILogger<FirebirdProcessor> logger, IOptionsSnapshot<ProcessorOptions> options, IConnectionStringAccessor connectionStringAccessor, FirebirdOptions fbOptions)
Parameters
Type Name Description
FirebirdDbFactory factory
FirebirdGenerator generator
FirebirdQuoter quoter
ILogger<FirebirdProcessor> logger
IOptionsSnapshot<ProcessorOptions> options
IConnectionStringAccessor connectionStringAccessor
FirebirdOptions fbOptions
| Edit this page View Source

FirebirdProcessor(IDbConnection, IMigrationGenerator, IAnnouncer, IMigrationProcessorOptions, IDbFactory, FirebirdOptions)

Declaration
[Obsolete]
public FirebirdProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory, FirebirdOptions fbOptions)
Parameters
Type Name Description
IDbConnection connection
IMigrationGenerator generator
IAnnouncer announcer
IMigrationProcessorOptions options
IDbFactory factory
FirebirdOptions fbOptions

Fields

| Edit this page View Source

DDLCreatedColumns

Declaration
protected Dictionary<string, List<string>> DDLCreatedColumns
Field Value
Type Description
Dictionary<string, List<string>>
| Edit this page View Source

DDLCreatedTables

Declaration
protected List<string> DDLCreatedTables
Field Value
Type Description
List<string>
| Edit this page View Source

DDLTouchedColumns

Declaration
protected Dictionary<string, List<string>> DDLTouchedColumns
Field Value
Type Description
Dictionary<string, List<string>>
| Edit this page View Source

DDLTouchedTables

Declaration
protected List<string> DDLTouchedTables
Field Value
Type Description
List<string>
| Edit this page View Source

truncator

Declaration
[Obsolete("Use the Truncator property")]
protected readonly FirebirdTruncator truncator
Field Value
Type Description
FirebirdTruncator

Properties

| Edit this page View Source

Announcer

Declaration
[Obsolete]
public IAnnouncer Announcer { get; }
Property Value
Type Description
IAnnouncer
| Edit this page View Source

DatabaseType

Gets the database type

Declaration
public override string DatabaseType { get; }
Property Value
Type Description
string
Overrides
| Edit this page View Source

DatabaseTypeAliases

Gets the database type aliases

Declaration
public override IList<string> DatabaseTypeAliases { get; }
Property Value
Type Description
IList<string>
Overrides
| Edit this page View Source

FBOptions

Declaration
public FirebirdOptions FBOptions { get; }
Property Value
Type Description
FirebirdOptions
| Edit this page View Source

Generator

Declaration
public IMigrationGenerator Generator { get; }
Property Value
Type Description
IMigrationGenerator
| Edit this page View Source

IsFirebird3

Declaration
public bool IsFirebird3 { get; }
Property Value
Type Description
bool
| Edit this page View Source

Truncator

Declaration
public FirebirdTruncator Truncator { get; }
Property Value
Type Description
FirebirdTruncator

Methods

| Edit this page View Source

AutoCommit()

Declaration
public virtual void AutoCommit()
| Edit this page View Source

BeginTransaction()

Begins a transaction

Declaration
public override void BeginTransaction()
Overrides
| Edit this page View Source

CheckColumn(string, IEnumerable<string>)

Declaration
public void CheckColumn(string tableName, IEnumerable<string> columns)
Parameters
Type Name Description
string tableName
IEnumerable<string> columns
| Edit this page View Source

CheckColumn(string, string)

Declaration
public void CheckColumn(string tableName, string columnName)
Parameters
Type Name Description
string tableName
string columnName
| Edit this page View Source

CheckTable(string)

Declaration
public void CheckTable(string tableName)
Parameters
Type Name Description
string tableName
| Edit this page View Source

ClearDDLFollowers()

Declaration
protected void ClearDDLFollowers()
| Edit this page View Source

ClearLocks()

Declaration
protected void ClearLocks()
| Edit this page View Source

ColumnExists(string, string, string)

Tests if a column exists

Declaration
public override bool ColumnExists(string schemaName, string tableName, string columnName)
Parameters
Type Name Description
string schemaName

The schema name
string tableName

The table name
string columnName

The column name
Returns
Type Description
bool

true when it exists
Overrides
| Edit this page View Source

CommitRetaining()

Declaration
public virtual void CommitRetaining()
| Edit this page View Source

CommitTransaction()

Commits a transaction

Declaration
public override void CommitTransaction()
Overrides
| Edit this page View Source

ConstraintExists(string, string, string)

Tests if a constraint exists

Declaration
public override bool ConstraintExists(string schemaName, string tableName, string constraintName)
Parameters
Type Name Description
string schemaName

The schema name
string tableName

The table name
string constraintName

The constraint name
Returns
Type Description
bool

true when it exists
Overrides
| Edit this page View Source

CreateTriggerExpression(string, TriggerInfo)

Declaration
public PerformDBOperationExpression CreateTriggerExpression(string tableName, TriggerInfo trigger)
Parameters
Type Name Description
string tableName
TriggerInfo trigger
Returns
Type Description
PerformDBOperationExpression
| Edit this page View Source

CreateTriggerExpression(string, string, bool, TriggerEvent, string)

Declaration
public PerformDBOperationExpression CreateTriggerExpression(string tableName, string triggerName, bool onBefore, TriggerEvent onEvent, string triggerBody)
Parameters
Type Name Description
string tableName
string triggerName
bool onBefore
TriggerEvent onEvent
string triggerBody
Returns
Type Description
PerformDBOperationExpression
| Edit this page View Source

DefaultValueExists(string, string, string, object)

Tests if a default value for a column exists

Declaration
public override bool DefaultValueExists(string schemaName, string tableName, string columnName, object defaultValue)
Parameters
Type Name Description
string schemaName

The schema name
string tableName

The table name
string columnName

The column name
object defaultValue

The default value
Returns
Type Description
bool

true when it exists
Overrides
| Edit this page View Source

DeleteTriggerExpression(string, string)

Declaration
public PerformDBOperationExpression DeleteTriggerExpression(string tableName, string triggerName)
Parameters
Type Name Description
string tableName
string triggerName
Returns
Type Description
PerformDBOperationExpression
| Edit this page View Source

Execute(string, params object[])

Execute an SQL statement

Declaration
public override void Execute(string template, params object[] args)
Parameters
Type Name Description
string template

The SQL statement
object[] args

The arguments to replace in the SQL statement
Overrides
| Edit this page View Source

Exists(string, params object[])

Returns true if data could be found for the given SQL query

Declaration
public override bool Exists(string template, params object[] args)
Parameters
Type Name Description
string template

The SQL query
object[] args

The arguments of the SQL query
Returns
Type Description
bool

true when the SQL query returned data
Overrides
| Edit this page View Source

IndexExists(string, string, string)

Tests if an index exists

Declaration
public override bool IndexExists(string schemaName, string tableName, string indexName)
Parameters
Type Name Description
string schemaName

The schema name
string tableName

The table name
string indexName

The index name
Returns
Type Description
bool

true when it exists
Overrides
| Edit this page View Source

InternalProcess(string)

Declaration
protected void InternalProcess(string sql)
Parameters
Type Name Description
string sql
| Edit this page View Source

IsColumnCreated(string, string)

Declaration
protected bool IsColumnCreated(string tableName, string columnName)
Parameters
Type Name Description
string tableName
string columnName
Returns
Type Description
bool
| Edit this page View Source

IsRunningOutOfMigrationScope()

Declaration
public bool IsRunningOutOfMigrationScope()
Returns
Type Description
bool
| Edit this page View Source

IsTableCreated(string)

Declaration
protected bool IsTableCreated(string tableName)
Parameters
Type Name Description
string tableName
Returns
Type Description
bool
| Edit this page View Source

LockColumn(string, IEnumerable<string>)

Declaration
public void LockColumn(string tableName, IEnumerable<string> columns)
Parameters
Type Name Description
string tableName
IEnumerable<string> columns
| Edit this page View Source

LockColumn(string, string)

Declaration
public void LockColumn(string tableName, string columnName)
Parameters
Type Name Description
string tableName
string columnName
| Edit this page View Source

LockTable(string)

Declaration
public void LockTable(string tableName)
Parameters
Type Name Description
string tableName
| Edit this page View Source

Process(AlterColumnExpression)

Executes a ALTER TABLE ALTER COLUMN SQL expression

Declaration
public override void Process(AlterColumnExpression expression)
Parameters
Type Name Description
AlterColumnExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(AlterDefaultConstraintExpression)

Executes an SQL expression to alter a default constraint

Declaration
public override void Process(AlterDefaultConstraintExpression expression)
Parameters
Type Name Description
AlterDefaultConstraintExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(AlterSchemaExpression)

Executes a ALTER SCHEMA SQL expression

Declaration
public override void Process(AlterSchemaExpression expression)
Parameters
Type Name Description
AlterSchemaExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(AlterTableExpression)

Executes a ALTER TABLE SQL expression

Declaration
public override void Process(AlterTableExpression expression)
Parameters
Type Name Description
AlterTableExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(CreateColumnExpression)

Executes a ALTER TABLE ADD COLUMN SQL expression

Declaration
public override void Process(CreateColumnExpression expression)
Parameters
Type Name Description
CreateColumnExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(CreateConstraintExpression)

Executes an SQL expression to create a constraint

Declaration
public override void Process(CreateConstraintExpression expression)
Parameters
Type Name Description
CreateConstraintExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(CreateForeignKeyExpression)

Executes an SQL expression to create a foreign key

Declaration
public override void Process(CreateForeignKeyExpression expression)
Parameters
Type Name Description
CreateForeignKeyExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(CreateIndexExpression)

Executes an SQL expression to create an index

Declaration
public override void Process(CreateIndexExpression expression)
Parameters
Type Name Description
CreateIndexExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(CreateSchemaExpression)

Executes a CREATE SCHEMA SQL expression

Declaration
public override void Process(CreateSchemaExpression expression)
Parameters
Type Name Description
CreateSchemaExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(CreateSequenceExpression)

Executes a CREATE SEQUENCE SQL expression

Declaration
public override void Process(CreateSequenceExpression expression)
Parameters
Type Name Description
CreateSequenceExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(CreateTableExpression)

Executes a CREATE TABLE SQL expression

Declaration
public override void Process(CreateTableExpression expression)
Parameters
Type Name Description
CreateTableExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(DeleteColumnExpression)

Executes a ALTER TABLE DROP COLUMN SQL expression

Declaration
public override void Process(DeleteColumnExpression expression)
Parameters
Type Name Description
DeleteColumnExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(DeleteConstraintExpression)

Executes an SQL expression to drop a constraint

Declaration
public override void Process(DeleteConstraintExpression expression)
Parameters
Type Name Description
DeleteConstraintExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(DeleteDataExpression)

Executes an SQL expression to DELETE data

Declaration
public override void Process(DeleteDataExpression expression)
Parameters
Type Name Description
DeleteDataExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(DeleteDefaultConstraintExpression)

Executes an SQL expression to drop a default constraint

Declaration
public override void Process(DeleteDefaultConstraintExpression expression)
Parameters
Type Name Description
DeleteDefaultConstraintExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(DeleteForeignKeyExpression)

Executes an SQL expression to drop a foreign key

Declaration
public override void Process(DeleteForeignKeyExpression expression)
Parameters
Type Name Description
DeleteForeignKeyExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(DeleteIndexExpression)

Executes an SQL expression to drop an index

Declaration
public override void Process(DeleteIndexExpression expression)
Parameters
Type Name Description
DeleteIndexExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(DeleteSchemaExpression)

Executes a DROP SCHEMA SQL expression

Declaration
public override void Process(DeleteSchemaExpression expression)
Parameters
Type Name Description
DeleteSchemaExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(DeleteSequenceExpression)

Executes a DROP SEQUENCE SQL expression

Declaration
public override void Process(DeleteSequenceExpression expression)
Parameters
Type Name Description
DeleteSequenceExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(DeleteTableExpression)

Executes a DROP TABLE SQL expression

Declaration
public override void Process(DeleteTableExpression expression)
Parameters
Type Name Description
DeleteTableExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(InsertDataExpression)

Executes an SQL expression to INSERT data

Declaration
public override void Process(InsertDataExpression expression)
Parameters
Type Name Description
InsertDataExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(PerformDBOperationExpression)

Executes a DB operation

Declaration
public override void Process(PerformDBOperationExpression expression)
Parameters
Type Name Description
PerformDBOperationExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(RenameColumnExpression)

Executes an SQL expression to rename a column

Declaration
public override void Process(RenameColumnExpression expression)
Parameters
Type Name Description
RenameColumnExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(RenameTableExpression)

Executes an SQL expression to rename a table

Declaration
public override void Process(RenameTableExpression expression)
Parameters
Type Name Description
RenameTableExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(UpdateDataExpression)

Executes an SQL expression to UPDATE data

Declaration
public override void Process(UpdateDataExpression expression)
Parameters
Type Name Description
UpdateDataExpression expression

The expression to execute
Overrides
| Edit this page View Source

Process(string)

Declaration
protected override void Process(string sql)
Parameters
Type Name Description
string sql
Overrides
| Edit this page View Source

Read(string, params object[])

Executes and returns the result of an SQL query

Declaration
public override DataSet Read(string template, params object[] args)
Parameters
Type Name Description
string template

The SQL query
object[] args

The arguments of the SQL query
Returns
Type Description
DataSet

The data from the specified SQL query
Overrides
| Edit this page View Source

ReadTableData(string, string)

Reads all data from all rows from a table

Declaration
public override DataSet ReadTableData(string schemaName, string tableName)
Parameters
Type Name Description
string schemaName

The schema name of the table
string tableName

The table name
Returns
Type Description
DataSet

The data from the specified table
Overrides
| Edit this page View Source

RegisterColumnCreation(string, string)

Declaration
protected void RegisterColumnCreation(string tableName, string columnName)
Parameters
Type Name Description
string tableName
string columnName
| Edit this page View Source

RegisterTableCreation(string)

Declaration
protected void RegisterTableCreation(string tableName)
Parameters
Type Name Description
string tableName
| Edit this page View Source

RollbackTransaction()

Rollback of a transaction

Declaration
public override void RollbackTransaction()
Overrides
| Edit this page View Source

SchemaExists(string)

Tests if the schema exists

Declaration
public override bool SchemaExists(string schemaName)
Parameters
Type Name Description
string schemaName

The schema name
Returns
Type Description
bool

true when it exists
Overrides
| Edit this page View Source

SequenceExists(string, string)

Tests if a sequence exists

Declaration
public override bool SequenceExists(string schemaName, string sequenceName)
Parameters
Type Name Description
string schemaName

The schema name
string sequenceName

The sequence name
Returns
Type Description
bool

true when it exists
Overrides
| Edit this page View Source

TableExists(string, string)

Tests if the table exists

Declaration
public override bool TableExists(string schemaName, string tableName)
Parameters
Type Name Description
string schemaName

The schema name
string tableName

The table name
Returns
Type Description
bool

true when it exists
Overrides
| Edit this page View Source

TriggerExists(string, string, string)

Declaration
public virtual bool TriggerExists(string schemaName, string tableName, string triggerName)
Parameters
Type Name Description
string schemaName
string tableName
string triggerName
Returns
Type Description
bool

Implements