Class RedshiftGenerator
Implements
Inherited Members
Namespace: FluentMigrator.Runner.Generators.Redshift
Assembly: FluentMigrator.Runner.Redshift.dll
Syntax
public class RedshiftGenerator : GenericGenerator, IMigrationGenerator
Constructors
| Edit this page View SourceRedshiftGenerator()
Declaration
public RedshiftGenerator()
RedshiftGenerator(RedshiftQuoter)
Declaration
public RedshiftGenerator(RedshiftQuoter quoter)
Parameters
Type | Name | Description |
---|---|---|
RedshiftQuoter | quoter |
RedshiftGenerator(RedshiftQuoter, IOptions<GeneratorOptions>)
Declaration
public RedshiftGenerator(RedshiftQuoter quoter, IOptions<GeneratorOptions> generatorOptions)
Parameters
Type | Name | Description |
---|---|---|
RedshiftQuoter | quoter | |
IOptions<GeneratorOptions> | generatorOptions |
Methods
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(AlterTableExpression)
Generates a ALTER TABLE
SQL statement
Declaration
public override string Generate(AlterTableExpression expression)
Parameters
Type | Name | Description |
---|---|---|
AlterTableExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(CreateColumnExpression)
Generates a ALTER TABLE ADD COLUMN
SQL statement
Declaration
public override string Generate(CreateColumnExpression expression)
Parameters
Type | Name | Description |
---|---|---|
CreateColumnExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(CreateConstraintExpression)
Generates an SQL statement to create a constraint
Declaration
public override string Generate(CreateConstraintExpression expression)
Parameters
Type | Name | Description |
---|---|---|
CreateConstraintExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(CreateForeignKeyExpression)
Generates an SQL statement to create a foreign key
Declaration
public override string Generate(CreateForeignKeyExpression expression)
Parameters
Type | Name | Description |
---|---|---|
CreateForeignKeyExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(CreateTableExpression)
Outputs a create table string
Declaration
public override string Generate(CreateTableExpression expression)
Parameters
Type | Name | Description |
---|---|---|
CreateTableExpression | expression |
Returns
Type | Description |
---|---|
string |
Overrides
| Edit this page View SourceGenerate(DeleteColumnExpression)
Generates a ALTER TABLE DROP COLUMN
SQL statement
Declaration
public override string Generate(DeleteColumnExpression expression)
Parameters
Type | Name | Description |
---|---|---|
DeleteColumnExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(DeleteConstraintExpression)
Generates an SQL statement to drop a constraint
Declaration
public override string Generate(DeleteConstraintExpression expression)
Parameters
Type | Name | Description |
---|---|---|
DeleteConstraintExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(DeleteDataExpression)
Generates an SQL statement to DELETE data
Declaration
public override string Generate(DeleteDataExpression expression)
Parameters
Type | Name | Description |
---|---|---|
DeleteDataExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(DeleteForeignKeyExpression)
Generates an SQL statement to delete a foreign key
Declaration
public override string Generate(DeleteForeignKeyExpression expression)
Parameters
Type | Name | Description |
---|---|---|
DeleteForeignKeyExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(DeleteSequenceExpression)
Generates a DROP SEQUENCE
SQL statement
Declaration
public override string Generate(DeleteSequenceExpression expression)
Parameters
Type | Name | Description |
---|---|---|
DeleteSequenceExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(InsertDataExpression)
Generates an SQL statement to INSERT data
Declaration
public override string Generate(InsertDataExpression expression)
Parameters
Type | Name | Description |
---|---|---|
InsertDataExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(RenameColumnExpression)
Generates an SQL statement to rename a column
Declaration
public override string Generate(RenameColumnExpression expression)
Parameters
Type | Name | Description |
---|---|---|
RenameColumnExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGenerate(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
| Edit this page View SourceGenerate(UpdateDataExpression)
Generates an SQL statement to UPDATE data
Declaration
public override string Generate(UpdateDataExpression expression)
Parameters
Type | Name | Description |
---|---|---|
UpdateDataExpression | expression | The expression to create the SQL for |
Returns
Type | Description |
---|---|
string | The generated SQL |
Overrides
| Edit this page View SourceGetColumnList(IEnumerable<string>)
Declaration
protected string GetColumnList(IEnumerable<string> columns)
Parameters
Type | Name | Description |
---|---|---|
IEnumerable<string> | columns |
Returns
Type | Description |
---|---|
string |
GetDataList(List<object>)
Declaration
protected string GetDataList(List<object> data)
Parameters
Type | Name | Description |
---|---|---|
List<object> | data |
Returns
Type | Description |
---|---|
string |