Class SnowflakeGenerator

Inheritance

object

GeneratorBase

GenericGenerator

SnowflakeGenerator

Implements

IMigrationGenerator

Inherited Members

GenericGenerator.compatabilityMode

GenericGenerator.CompatibilityMode

GenericGenerator.CreateTable

GenericGenerator.DropTable

GenericGenerator.DropTableIfExists

GenericGenerator.AddColumn

GenericGenerator.DropColumn

GenericGenerator.RenameColumn

GenericGenerator.RenameTable

GenericGenerator.CreateSchema

GenericGenerator.AlterSchema

GenericGenerator.DropSchema

GenericGenerator.CreateIndex

GenericGenerator.DropIndex

GenericGenerator.InsertData

GenericGenerator.UpdateData

GenericGenerator.DeleteData

GenericGenerator.CreateConstraint

GenericGenerator.DeleteConstraint

GenericGenerator.CreateForeignKeyConstraint

GenericGenerator.GetUniqueString(CreateIndexExpression)

GenericGenerator.GetClusterTypeString(CreateIndexExpression)

GenericGenerator.Generate(CreateTableExpression)

GenericGenerator.Generate(CreateColumnExpression)

GenericGenerator.Generate(DeleteColumnExpression)

GenericGenerator.Generate(RenameColumnExpression)

GenericGenerator.Generate(CreateForeignKeyExpression)

GenericGenerator.Generate(CreateConstraintExpression)

GenericGenerator.Generate(DeleteConstraintExpression)

GenericGenerator.GenerateForeignKeyName(ForeignKeyDefinition)

GenericGenerator.Generate(DeleteForeignKeyExpression)

GenericGenerator.Generate(InsertDataExpression)

GenericGenerator.AppendSqlStatementEndToken(StringBuilder)

GenericGenerator.GenerateColumnNamesAndValues(InsertDataExpression)

GenericGenerator.ValidateAdditionalFeatureCompatibility(IEnumerable<KeyValuePair<string, object>>)

GenericGenerator.Generate(UpdateDataExpression)

GenericGenerator.Generate(DeleteDataExpression)

GenericGenerator.Generate(DeleteSequenceExpression)

GeneratorBase.IsAdditionalFeatureSupported(string)

GeneratorBase.Generate(AlterTableExpression)

GeneratorBase.Column

GeneratorBase.Quoter

GeneratorBase.DescriptionGenerator

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: FluentMigrator.Runner.Generators.Snowflake

Assembly: FluentMigrator.Runner.Snowflake.dll

Syntax

public class SnowflakeGenerator : GenericGenerator, IMigrationGenerator

Constructors

SnowflakeGenerator(SnowflakeQuoter, SnowflakeOptions, IOptions<GeneratorOptions>)

Declaration

public SnowflakeGenerator(SnowflakeQuoter quoter, SnowflakeOptions sfOptions, IOptions<GeneratorOptions> generatorOptions)

Parameters

Type	Name	Description
SnowflakeQuoter	quoter
SnowflakeOptions	sfOptions
IOptions<GeneratorOptions>	generatorOptions

SnowflakeGenerator(SnowflakeOptions)

Declaration

public SnowflakeGenerator(SnowflakeOptions sfOptions)

Parameters

Type	Name	Description
SnowflakeOptions	sfOptions

SnowflakeGenerator(SnowflakeOptions, IOptions<GeneratorOptions>)

Declaration

public SnowflakeGenerator(SnowflakeOptions sfOptions, IOptions<GeneratorOptions> generatorOptions)

Parameters

Type	Name	Description
SnowflakeOptions	sfOptions
IOptions<GeneratorOptions>	generatorOptions

Properties

AlterColumn

Declaration

public override string AlterColumn { get; }

Property Value

Type	Description
string

Overrides

GenericGenerator.AlterColumn

Methods

Generate(AlterColumnExpression)

Generates a ALTER TABLE ALTER COLUMN SQL statement

Declaration

public override string Generate(AlterColumnExpression expression)

Parameters

Type	Name	Description
AlterColumnExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(AlterColumnExpression)

Generate(AlterDefaultConstraintExpression)

Generates an SQL statement to alter a DEFAULT constraint

Declaration

public override string Generate(AlterDefaultConstraintExpression expression)

Parameters

Type	Name	Description
AlterDefaultConstraintExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GeneratorBase.Generate(AlterDefaultConstraintExpression)

Generate(AlterSchemaExpression)

Generates an SQL statement to move a table from one schema to another

Declaration

public override string Generate(AlterSchemaExpression expression)

Parameters

Type	Name	Description
AlterSchemaExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(AlterSchemaExpression)

Generate(CreateIndexExpression)

Generates an SQL statement to create an index

Declaration

public override string Generate(CreateIndexExpression expression)

Parameters

Type	Name	Description
CreateIndexExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(CreateIndexExpression)

Generate(CreateSchemaExpression)

Generates a CREATE SCHEMA SQL statement

Declaration

public override string Generate(CreateSchemaExpression expression)

Parameters

Type	Name	Description
CreateSchemaExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(CreateSchemaExpression)

Generate(CreateSequenceExpression)

Generates a CREATE SEQUENCE SQL statement

Declaration

public override string Generate(CreateSequenceExpression expression)

Parameters

Type	Name	Description
CreateSequenceExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(CreateSequenceExpression)

Generate(DeleteDefaultConstraintExpression)

Generates an SQL statement to drop a default constraint

Declaration

public override string Generate(DeleteDefaultConstraintExpression expression)

Parameters

Type	Name	Description
DeleteDefaultConstraintExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GeneratorBase.Generate(DeleteDefaultConstraintExpression)

Generate(DeleteIndexExpression)

Generates an SQL statement to drop an index

Declaration

public override string Generate(DeleteIndexExpression expression)

Parameters

Type	Name	Description
DeleteIndexExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(DeleteIndexExpression)

Generate(DeleteSchemaExpression)

Generates a DROP SCHEMA SQL statement

Declaration

public override string Generate(DeleteSchemaExpression expression)

Parameters

Type	Name	Description
DeleteSchemaExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(DeleteSchemaExpression)

Generate(DeleteTableExpression)

Generates a DROP TABLE SQL statement

Declaration

public override string Generate(DeleteTableExpression expression)

Parameters

Type	Name	Description
DeleteTableExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(DeleteTableExpression)

Generate(RenameTableExpression)

Generates an SQL statement to rename a table

Declaration

public override string Generate(RenameTableExpression expression)

Parameters

Type	Name	Description
RenameTableExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(RenameTableExpression)

Implements

IMigrationGenerator