C# Class Migrator.Providers.SQLite.SQLiteTransformationProvider

Summary description for SQLiteTransformationProvider.

Inheritance: TransformationProvider

显示文件 Open project: nats/migratordotnet Class Usage Examples

Public Methods

Method	Description
AddForeignKey ( string name, string primaryTable, string primaryColumns, string refTable, string refColumns, ForeignKeyConstraint constraint ) : void
ChangeColumn ( string table, Migrator.Framework.Column column ) : void
ColumnMatch ( string column, string columnDef ) : bool
ConstraintExists ( string table, string name ) : bool
ExtractNameFromColumnDef ( string columnDef ) : string	Name is the first value before the space.
GetColumnDefs ( string table ) : string[]
GetColumnNames ( string table ) : string[]
GetColumns ( string table ) : Migrator.Framework.Column[]
GetSqlDefString ( string table ) : string
GetTables ( ) : string[]
IndexExists ( string table, string name ) : bool
IsNullable ( string columnDef ) : bool
ParseSqlColumnDefs ( string sqldef ) : string[]
ParseSqlForColumnNames ( string sqldef ) : string[]	Turn something like 'columnName INTEGER NOT NULL' into just 'columnName'
RemoveColumn ( string table, string column ) : void
RemoveForeignKey ( string name, string table ) : void
RenameColumn ( string tableName, string oldColumnName, string newColumnName ) : void
SQLiteTransformationProvider ( Migrator.Framework.Dialect dialect, string connectionString ) : Mono.Data.Sqlite
TableExists ( string table ) : bool

Method Details

AddForeignKey() public method

public AddForeignKey ( string name, string primaryTable, string primaryColumns, string refTable, string refColumns, ForeignKeyConstraint constraint ) : void
name	string
primaryTable	string
primaryColumns	string
refTable	string
refColumns	string
constraint	System.Data.ForeignKeyConstraint
return	void

ChangeColumn() public method

public ChangeColumn ( string table, Migrator.Framework.Column column ) : void
table	string
column	Migrator.Framework.Column
return	void

ColumnMatch() public method

public ColumnMatch ( string column, string columnDef ) : bool
column	string
columnDef	string
return	bool

ConstraintExists() public method

public ConstraintExists ( string table, string name ) : bool
table	string
name	string
return	bool

ExtractNameFromColumnDef() public method

Name is the first value before the space.

public ExtractNameFromColumnDef ( string columnDef ) : string
columnDef	string
return	string

GetColumnDefs() public method

public GetColumnDefs ( string table ) : string[]
table	string
return	string[]

GetColumnNames() public method

public GetColumnNames ( string table ) : string[]
table	string
return	string[]

GetColumns() public method

public GetColumns ( string table ) : Migrator.Framework.Column[]
table	string
return	Migrator.Framework.Column[]

GetSqlDefString() public method

public GetSqlDefString ( string table ) : string
table	string
return	string

GetTables() public method

public GetTables ( ) : string[]
return	string[]

IndexExists() public method

public IndexExists ( string table, string name ) : bool
table	string
name	string
return	bool

IsNullable() public method

public IsNullable ( string columnDef ) : bool
columnDef	string
return	bool

ParseSqlColumnDefs() public method

public ParseSqlColumnDefs ( string sqldef ) : string[]
sqldef	string
return	string[]

ParseSqlForColumnNames() public method

Turn something like 'columnName INTEGER NOT NULL' into just 'columnName'

public ParseSqlForColumnNames ( string sqldef ) : string[]
sqldef	string
return	string[]

RemoveColumn() public method

public RemoveColumn ( string table, string column ) : void
table	string
column	string
return	void

RemoveForeignKey() public method

public RemoveForeignKey ( string name, string table ) : void
name	string
table	string
return	void

RenameColumn() public method

public RenameColumn ( string tableName, string oldColumnName, string newColumnName ) : void
tableName	string
oldColumnName	string
newColumnName	string
return	void

SQLiteTransformationProvider() public method

public SQLiteTransformationProvider ( Migrator.Framework.Dialect dialect, string connectionString ) : Mono.Data.Sqlite
dialect	Migrator.Framework.Dialect
connectionString	string
return	Mono.Data.Sqlite

TableExists() public method

public TableExists ( string table ) : bool
table	string
return	bool