Class MySqlProcessor

Inheritance

MySqlProcessor

MySql4Processor

MySql5Processor

MySql8Processor

Implements

IMigrationProcessor

IQuerySchema

IDisposable

Inherited Members

GenericProcessorBase.ConnectionString

GenericProcessorBase.Connection

GenericProcessorBase.Factory

GenericProcessorBase.Transaction

GenericProcessorBase.DbProviderFactory

GenericProcessorBase.EnsureConnectionIsOpen()

GenericProcessorBase.EnsureConnectionIsClosed()

GenericProcessorBase.BeginTransaction()

GenericProcessorBase.RollbackTransaction()

GenericProcessorBase.CommitTransaction()

GenericProcessorBase.Dispose(bool)

GenericProcessorBase.CreateCommand(string)

GenericProcessorBase.CreateCommand(string, IDbConnection, IDbTransaction)

ProcessorBase.Generator

ProcessorBase.Announcer

ProcessorBase.WasCommitted

ProcessorBase.Logger

ProcessorBase.Options

ProcessorBase.Process(CreateSchemaExpression)

ProcessorBase.Process(DeleteSchemaExpression)

ProcessorBase.Process(CreateTableExpression)

ProcessorBase.Process(AlterTableExpression)

ProcessorBase.Process(AlterColumnExpression)

ProcessorBase.Process(CreateColumnExpression)

ProcessorBase.Process(DeleteTableExpression)

ProcessorBase.Process(DeleteColumnExpression)

ProcessorBase.Process(CreateForeignKeyExpression)

ProcessorBase.Process(DeleteForeignKeyExpression)

ProcessorBase.Process(CreateIndexExpression)

ProcessorBase.Process(DeleteIndexExpression)

ProcessorBase.Process(RenameTableExpression)

ProcessorBase.Process(InsertDataExpression)

ProcessorBase.Process(DeleteDataExpression)

ProcessorBase.Process(AlterDefaultConstraintExpression)

ProcessorBase.Process(UpdateDataExpression)

ProcessorBase.Process(AlterSchemaExpression)

ProcessorBase.Process(CreateSequenceExpression)

ProcessorBase.Process(DeleteSequenceExpression)

ProcessorBase.Process(CreateConstraintExpression)

ProcessorBase.Process(DeleteConstraintExpression)

ProcessorBase.Process(DeleteDefaultConstraintExpression)

ProcessorBase.Execute(string)

ProcessorBase.Dispose()

ProcessorBase.ReThrowWithSql(Exception, string)

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: FluentMigrator.Runner.Processors.MySql

Assembly: FluentMigrator.Runner.MySql.dll

Syntax

public class MySqlProcessor : GenericProcessorBase, IMigrationProcessor, IQuerySchema, IDisposable

Constructors

MySqlProcessor(MySqlDbFactory, IMigrationGenerator, ILogger<MySqlProcessor>, IOptionsSnapshot<ProcessorOptions>, IConnectionStringAccessor)

Declaration

protected MySqlProcessor(MySqlDbFactory factory, IMigrationGenerator generator, ILogger<MySqlProcessor> logger, IOptionsSnapshot<ProcessorOptions> options, IConnectionStringAccessor connectionStringAccessor)

Parameters

Type	Name	Description
MySqlDbFactory	factory
IMigrationGenerator	generator
ILogger<MySqlProcessor>	logger
IOptionsSnapshot<ProcessorOptions>	options
IConnectionStringAccessor	connectionStringAccessor

MySqlProcessor(IDbConnection, IMigrationGenerator, IAnnouncer, IMigrationProcessorOptions, IDbFactory)

Declaration

[Obsolete]
public MySqlProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)

Parameters

Type	Name	Description
IDbConnection	connection
IMigrationGenerator	generator
IAnnouncer	announcer
IMigrationProcessorOptions	options
IDbFactory	factory

Properties

DatabaseType

Gets the database type

Declaration

public override string DatabaseType { get; }

Property Value

Type	Description
string

Overrides

ProcessorBase.DatabaseType

DatabaseTypeAliases

Gets the database type aliases

Declaration

public override IList<string> DatabaseTypeAliases { get; }

Property Value

Type	Description
IList<string>

Overrides

ProcessorBase.DatabaseTypeAliases

Methods

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

ProcessorBase.ColumnExists(string, string, string)

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

ProcessorBase.ConstraintExists(string, string, string)

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

ProcessorBase.DefaultValueExists(string, string, string, object)

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

ProcessorBase.Execute(string, params object[])

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

ProcessorBase.Exists(string, params object[])

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

ProcessorBase.IndexExists(string, string, string)

Process(PerformDBOperationExpression)

Executes a DB operation

Declaration

public override void Process(PerformDBOperationExpression expression)

Parameters

Type	Name	Description
PerformDBOperationExpression	expression	The expression to execute

Overrides

ProcessorBase.Process(PerformDBOperationExpression)

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

ProcessorBase.Process(RenameColumnExpression)

Process(string)

Declaration

protected override void Process(string sql)

Parameters

Type	Name	Description
string	sql

Overrides

ProcessorBase.Process(string)

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

ProcessorBase.Read(string, params object[])

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

ProcessorBase.ReadTableData(string, string)

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

ProcessorBase.SchemaExists(string)

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

ProcessorBase.SequenceExists(string, string)

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

ProcessorBase.TableExists(string, string)

Implements

IMigrationProcessor

IQuerySchema

IDisposable