Class PostgresGenerator
Inheritance
PostgresGenerator
Assembly: FluentMigrator.Runner.Postgres.dll
Syntax
public class PostgresGenerator : GenericGenerator, IMigrationGenerator
Constructors
PostgresGenerator(IColumn, PostgresQuoter, IOptions<GeneratorOptions>)
Declaration
protected PostgresGenerator(IColumn column, PostgresQuoter quoter, IOptions<GeneratorOptions> generatorOptions)
Parameters
PostgresGenerator(PostgresQuoter)
Declaration
public PostgresGenerator(PostgresQuoter quoter)
Parameters
PostgresGenerator(PostgresQuoter, IOptions<GeneratorOptions>)
Declaration
public PostgresGenerator(PostgresQuoter quoter, IOptions<GeneratorOptions> generatorOptions)
Parameters
PostgresGenerator(PostgresQuoter, IOptions<GeneratorOptions>, ITypeMap)
Declaration
protected PostgresGenerator(PostgresQuoter quoter, IOptions<GeneratorOptions> generatorOptions, ITypeMap typeMap)
Parameters
Properties
AddColumn
Declaration
public override string AddColumn { get; }
Property Value
Overrides
AlterColumn
Declaration
public override string AlterColumn { get; }
Property Value
Overrides
CreateTable
Declaration
public override string CreateTable { get; }
Property Value
Overrides
DropColumn
Declaration
public override string DropColumn { get; }
Property Value
Overrides
DropTable
Declaration
public override string DropTable { get; }
Property Value
Overrides
RenameColumn
Declaration
public override string RenameColumn { get; }
Property Value
Overrides
Methods
Generate(AlterColumnExpression)
Generates a ALTER TABLE ALTER COLUMN
SQL statement
Declaration
public override string Generate(AlterColumnExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(AlterDefaultConstraintExpression)
Generates an SQL statement to alter a DEFAULT constraint
Declaration
public override string Generate(AlterDefaultConstraintExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(AlterSchemaExpression)
Generates an SQL statement to move a table from one schema to another
Declaration
public override string Generate(AlterSchemaExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(AlterTableExpression)
Generates a ALTER TABLE
SQL statement
Declaration
public override string Generate(AlterTableExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(CreateColumnExpression)
Generates a ALTER TABLE ADD COLUMN
SQL statement
Declaration
public override string Generate(CreateColumnExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(CreateConstraintExpression)
Generates an SQL statement to create a constraint
Declaration
public override string Generate(CreateConstraintExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(CreateForeignKeyExpression)
Generates an SQL statement to create a foreign key
Declaration
public override string Generate(CreateForeignKeyExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(CreateIndexExpression)
Generates an SQL statement to create an index
Declaration
public override string Generate(CreateIndexExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(CreateSchemaExpression)
Generates a CREATE SCHEMA
SQL statement
Declaration
public override string Generate(CreateSchemaExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(CreateSequenceExpression)
Generates a CREATE SEQUENCE
SQL statement
Declaration
public override string Generate(CreateSequenceExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(CreateTableExpression)
Outputs a create table string
Declaration
public override string Generate(CreateTableExpression expression)
Parameters
Returns
Overrides
Generate(DeleteColumnExpression)
Generates a ALTER TABLE DROP COLUMN
SQL statement
Declaration
public override string Generate(DeleteColumnExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(DeleteConstraintExpression)
Generates an SQL statement to drop a constraint
Declaration
public override string Generate(DeleteConstraintExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(DeleteDataExpression)
Generates an SQL statement to DELETE data
Declaration
public override string Generate(DeleteDataExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(DeleteDefaultConstraintExpression)
Generates an SQL statement to drop a default constraint
Declaration
public override string Generate(DeleteDefaultConstraintExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(DeleteForeignKeyExpression)
Generates an SQL statement to delete a foreign key
Declaration
public override string Generate(DeleteForeignKeyExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(DeleteIndexExpression)
Generates an SQL statement to drop an index
Declaration
public override string Generate(DeleteIndexExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(DeleteSchemaExpression)
Generates a DROP SCHEMA
SQL statement
Declaration
public override string Generate(DeleteSchemaExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(DeleteSequenceExpression)
Generates a DROP SEQUENCE
SQL statement
Declaration
public override string Generate(DeleteSequenceExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(DeleteTableExpression)
Generates a DROP TABLE
SQL statement
Declaration
public override string Generate(DeleteTableExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(InsertDataExpression)
Generates an SQL statement to INSERT data
Declaration
public override string Generate(InsertDataExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(RenameColumnExpression)
Generates an SQL statement to rename a column
Declaration
public override string Generate(RenameColumnExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(RenameTableExpression)
Generates an SQL statement to rename a table
Declaration
public override string Generate(RenameTableExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
Generate(UpdateDataExpression)
Generates an SQL statement to UPDATE data
Declaration
public override string Generate(UpdateDataExpression expression)
Parameters
Returns
Type |
Description |
string |
The generated SQL
|
Overrides
GetAllowIndexStorageParameters()
Declaration
protected virtual HashSet<string> GetAllowIndexStorageParameters()
Returns
GetAsConcurrently(CreateIndexExpression)
Declaration
protected virtual string GetAsConcurrently(CreateIndexExpression expression)
Parameters
Returns
GetAsOnly(CreateIndexExpression)
Declaration
protected virtual string GetAsOnly(CreateIndexExpression expression)
Parameters
Returns
GetColumnList(IEnumerable<string>)
Declaration
protected string GetColumnList(IEnumerable<string> columns)
Parameters
Returns
GetDataList(List<object>)
Declaration
protected string GetDataList(List<object> data)
Parameters
Returns
GetFilter(CreateIndexExpression)
Declaration
protected virtual string GetFilter(CreateIndexExpression expression)
Parameters
Returns
GetIncludeString(CreateIndexExpression)
Declaration
protected virtual string GetIncludeString(CreateIndexExpression column)
Parameters
Returns
GetIndexMethod(CreateIndexExpression)
Declaration
protected virtual Algorithm GetIndexMethod(CreateIndexExpression expression)
Parameters
Returns
GetNullsSort(IndexColumnDefinition)
Declaration
protected virtual string GetNullsSort(IndexColumnDefinition column)
Parameters
Returns
GetOverridingIdentityValuesString(InsertDataExpression)
Declaration
protected virtual string GetOverridingIdentityValuesString(InsertDataExpression expression)
Parameters
Returns
GetTablespace(CreateIndexExpression)
Declaration
protected virtual string GetTablespace(CreateIndexExpression expression)
Parameters
Returns
GetWithIndexStorageParameters(CreateIndexExpression)
Declaration
protected virtual string GetWithIndexStorageParameters(CreateIndexExpression expression)
Parameters
Returns
GetWithNullsDistinctString(IndexDefinition)
Declaration
public virtual string GetWithNullsDistinctString(IndexDefinition index)
Parameters
Returns
IsAdditionalFeatureSupported(string)
Declaration
public override bool IsAdditionalFeatureSupported(string feature)
Parameters
Type |
Name |
Description |
string |
feature |
|
Returns
Overrides
Implements