Class MySqlProcessor

Inheritance

MySqlProcessor

MySql4Processor

MySql5Processor

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()

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

| Edit this page View Source

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

| Edit this page View Source

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

| Edit this page View Source

DatabaseType

Gets the database type

Declaration

public override string DatabaseType { get; }

Property Value

Type	Description
string

Overrides

ProcessorBase.DatabaseType

| 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

ProcessorBase.DatabaseTypeAliases

Methods

| 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

ProcessorBase.ColumnExists(string, string, string)

| 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

ProcessorBase.ConstraintExists(string, string, string)

| 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

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

| 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

ProcessorBase.Execute(string, params object[])

| 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

ProcessorBase.Exists(string, params object[])

| 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

ProcessorBase.IndexExists(string, string, string)

| 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

ProcessorBase.Process(PerformDBOperationExpression)

| 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

ProcessorBase.Process(RenameColumnExpression)

| Edit this page View Source

Process(string)

Declaration

protected override void Process(string sql)

Parameters

Type	Name	Description
string	sql

Overrides

ProcessorBase.Process(string)

| 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

ProcessorBase.Read(string, params object[])

| 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

ProcessorBase.ReadTableData(string, string)

| 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

ProcessorBase.SchemaExists(string)

| 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

ProcessorBase.SequenceExists(string, string)

| 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

ProcessorBase.TableExists(string, string)

Implements

IMigrationProcessor

IQuerySchema

IDisposable