C# Класс CUL.PostgreSQL.Schema.PostgreSQLSchemaGenerator

PostgreSQL schema provider
Наследование: ISchemaGenerator
Показать файл Открыть проект

Открытые методы

Метод Описание
GenerateSchema ( ISource DesiredStructure, ISourceInfo Source ) : IEnumerable

Generates a list of commands used to modify the source. If it does not exist prior, the commands will create the source from scratch. Otherwise the commands will only add new fields, tables, etc. It does not delete old fields.
GetSourceStructure ( ISourceInfo Source ) : ISource

Gets the structure of a source
PostgreSQLSchemaGenerator ( Utilities Provider, Utilities SourceProvider ) : System

Constructor
Setup ( IMapping>.ListMapping Mappings, IDatabase Database, Utilities QueryProvider, Graph Structure ) : void

Sets up the specified database schema
SourceExists ( string Source, ISourceInfo Info ) : bool

Checks if a source exists
StoredProcedureExists ( string StoredProcedure, ISourceInfo Source ) : bool

Checks if a stored procedure exists
TableExists ( string Table, ISourceInfo Source ) : bool

Checks if a table exists
TriggerExists ( string Trigger, ISourceInfo Source ) : bool

Checks if a trigger exists
ViewExists ( string View, ISourceInfo Source ) : bool

Checks if a view exists

Приватные методы

Метод Описание
BuildCommands ( ISource DesiredStructure, ISource CurrentStructure ) : IEnumerable
Exists ( string Command, string Value, ISourceInfo Source ) : bool
GetAlterFunctionCommand ( Function Function, Function CurrentFunction ) : IEnumerable
GetAlterStoredProcedure ( StoredProcedure StoredProcedure, StoredProcedure CurrentStoredProcedure ) : IEnumerable
GetAlterTableCommand ( Utilities Table, ITable CurrentTable ) : IEnumerable
GetAlterTriggerCommand ( Utilities Table, ITable CurrentTable ) : IEnumerable
GetAlterViewCommand ( View View, View CurrentView ) : IEnumerable
GetForeignKeyCommand ( Utilities Table ) : IEnumerable
GetForeignKeyCommand ( Utilities Table, ITable CurrentTable ) : IEnumerable
GetFunctionCommand ( Function Function ) : IEnumerable
GetStoredProcedure ( StoredProcedure StoredProcedure ) : IEnumerable
GetTableCommand ( Utilities Table ) : IEnumerable
GetTables ( ISourceInfo Source, Database Temp ) : void
GetTriggerCommand ( Utilities Table ) : IEnumerable
GetViewCommand ( View View ) : IEnumerable
SetupAuditTables ( ITable Table ) : ITable
SetupAuditTables ( IDatabase Key, Utilities TempDatabase ) : void
SetupColumns ( Utilities Table, IEnumerable Values ) : void
SetupDeleteTrigger ( ITable Table ) : void
SetupFunctions ( ISourceInfo Source, Database Temp ) : void
SetupInsertUpdateTrigger ( ITable Table ) : void
SetupJoiningTables ( IMapping>.ListMapping Mappings, IDatabase Key, Utilities TempDatabase ) : void
SetupJoiningTablesEnumerable ( IMapping>.ListMapping Mappings, IMapping Mapping, IProperty Property, IDatabase Key, Utilities TempDatabase ) : void
SetupProperties ( ITable Table, IMapping Mapping ) : void
SetupStoredProcedures ( ISourceInfo Source, Database Temp ) : void
SetupTables ( ISourceInfo Source, Database Temp ) : void
SetupTables ( IMapping>.ListMapping Mappings, IDatabase Key, Utilities TempDatabase ) : void
SetupTriggers ( ISourceInfo Source, Utilities Table, IEnumerable Values ) : void
SetupViews ( ISourceInfo Source, Database Temp ) : void

Описание методов

GenerateSchema() публичный Метод

Generates a list of commands used to modify the source. If it does not exist prior, the commands will create the source from scratch. Otherwise the commands will only add new fields, tables, etc. It does not delete old fields.
public GenerateSchema ( ISource DesiredStructure, ISourceInfo Source ) : IEnumerable
DesiredStructure ISource Desired source structure
Source ISourceInfo Source to use
Результат IEnumerable

GetSourceStructure() публичный Метод

Gets the structure of a source
public GetSourceStructure ( ISourceInfo Source ) : ISource
Source ISourceInfo Source to use
Результат ISource

PostgreSQLSchemaGenerator() публичный Метод

Constructor
public PostgreSQLSchemaGenerator ( Utilities Provider, Utilities SourceProvider ) : System
Provider Utilities
SourceProvider Utilities
Результат System

Setup() публичный Метод

Sets up the specified database schema
public Setup ( IMapping>.ListMapping Mappings, IDatabase Database, Utilities QueryProvider, Graph Structure ) : void
Mappings IMapping>.ListMapping The mappings.
Database IDatabase The database.
QueryProvider Utilities The query provider.
Structure Graph
Результат void

SourceExists() публичный Метод

Checks if a source exists
public SourceExists ( string Source, ISourceInfo Info ) : bool
Source string Source to check
Info ISourceInfo Source info to use
Результат bool

StoredProcedureExists() публичный Метод

Checks if a stored procedure exists
public StoredProcedureExists ( string StoredProcedure, ISourceInfo Source ) : bool
StoredProcedure string Stored procedure to check
Source ISourceInfo Source to use
Результат bool

TableExists() публичный Метод

Checks if a table exists
public TableExists ( string Table, ISourceInfo Source ) : bool
Table string Table to check
Source ISourceInfo Source to use
Результат bool

TriggerExists() публичный Метод

Checks if a trigger exists
public TriggerExists ( string Trigger, ISourceInfo Source ) : bool
Trigger string Trigger to check
Source ISourceInfo Source to use
Результат bool

ViewExists() публичный Метод

Checks if a view exists
public ViewExists ( string View, ISourceInfo Source ) : bool
View string View to check
Source ISourceInfo Source to use
Результат bool