C# 클래스 DataTableWriter.DbTableManager

Primary point of access to the functionalities of this library. Provides ability to create dynamic tables on a remote server as well as update existing table schemas to match.

파일 보기 프로젝트 열기: tableau/TabMon

공개 메소드들

메소드	설명
CreateTable ( IDbAdapter adapter, DataTable schema, bool>.IDictionary indexes ) : bool	Creates a table on a remote database server and indexes the table.
InitializeTable ( IDbAdapter adapter, DataTable schema, DbTableInitializationOptions tableInitializationOptions ) : void	Uses an in-memory schema to initialize a database table according to a set of initialization options.
PurgeExpiredData ( IDbAdapter adapter, string tableName, int interval ) : void
UpdateSchemaToMatchTable ( IDbAdapter adapter, DataTable schema ) : bool	Updates a schema to 'match' an existing database table by copying it.
UpdateTableToMatchSchema ( IDbAdapter adapter, DataTable schema ) : bool	Updates an existing database table to 'match' a schema by adding any missing columns.

비공개 메소드들

메소드	설명
AddDbIndexesToMatch ( IDbAdapter adapter, DataTable schema, bool>.IDictionary columns ) : bool	Adds indexes to the database if the existing indexes do not match the dictionary passed in.
BuildIndexName ( string tableName, string columnName ) : string	Builds the index name from the table name and column name.
CreateIndexes ( IDbAdapter adapter, DataTable schema, bool>.IDictionary columns ) : bool	Indexes a set of columns defined by the dictionary that is passed.
RemoveDBIndexesToMatch ( IDbAdapter adapter, DataTable schema, bool>.IDictionary columns ) : bool	Removes indexes from database if indexes are not in the dictionary.
UpdateIndexClusters ( IDbAdapter adapter, DataTable schema, bool>.IDictionary columns ) : bool	Updates whether or not indexes are clustered.

메소드 상세

CreateTable() 공개 정적인 메소드

Creates a table on a remote database server and indexes the table.

public static CreateTable ( IDbAdapter adapter, DataTable schema, bool>.IDictionary indexes ) : bool
adapter	IDbAdapter	Open adapter to a database.
schema	System.Data.DataTable	The schema of the table to create.
indexes	bool>.IDictionary	A dictionary that contains the indexes to create and whether the indexes are clustered.
리턴	bool

InitializeTable() 공개 정적인 메소드

Uses an in-memory schema to initialize a database table according to a set of initialization options.

public static InitializeTable ( IDbAdapter adapter, DataTable schema, DbTableInitializationOptions tableInitializationOptions ) : void
adapter	IDbAdapter	Open adapter to a database.
schema	System.Data.DataTable	The schema to use to initialize.
tableInitializationOptions	DbTableInitializationOptions	A set of options to determine initialization behavior.
리턴	void

PurgeExpiredData() 공개 정적인 메소드

public static PurgeExpiredData ( IDbAdapter adapter, string tableName, int interval ) : void
adapter	IDbAdapter
tableName	string
interval	int
리턴	void

UpdateSchemaToMatchTable() 공개 정적인 메소드

Updates a schema to 'match' an existing database table by copying it.

public static UpdateSchemaToMatchTable ( IDbAdapter adapter, DataTable schema ) : bool
adapter	IDbAdapter	Open adapter to a database.
schema	System.Data.DataTable	The schema to update.
리턴	bool

UpdateTableToMatchSchema() 공개 정적인 메소드

Updates an existing database table to 'match' a schema by adding any missing columns.

public static UpdateTableToMatchSchema ( IDbAdapter adapter, DataTable schema ) : bool
adapter	IDbAdapter	Open adapter to a database.
schema	System.Data.DataTable	The schema to use to update the database.
리턴	bool