C# Class Azavea.NijPredictivePolicing.Parsers.AccessDBValueWriter

a basic implementation of the IDataWriter interface, so we can simply export tab separated value files

Inheritance: IDataFileWriter

Afficher le fichier Open project: azavea/acs-alchemist

Protected Properties

Свойство	Type	Description
_conn	System.Data.Common.DbConnection
_filename	string
_insertCmd	System.Data.Common.DbCommand
_tablename	string
_tablenames	List

Méthodes publiques

Méthode	Description
AccessDBValueWriter ( ) : System	construct a new blank writer (any writes will throw exceptions if you don't set a stream or a file!)
AccessDBValueWriter ( string filename ) : System	construct a new writer to append to the given file
Close ( ) : bool	closes the underlying stream
CreateTable ( string tablename, IEnumerable columns ) : bool
Flush ( ) : bool	flushes the stream
IsOpen ( ) : bool	returns true if the database connection is open and ready
SetTablename ( string tableName ) : void
SetWriteFile ( string filename ) : bool	Opens or creates an MS Access database file for writing
TableNames ( ) : List	pulls a list of datatable names from the database and caches them. (this list does not refresh, because this reader is read-only)
WriteLine ( IEnumerable values ) : bool	Make sure you have a value for every column! This is really intentionally not thread safe, do not share this class across threads.

Method Details

AccessDBValueWriter() public méthode

construct a new blank writer (any writes will throw exceptions if you don't set a stream or a file!)

public AccessDBValueWriter ( ) : System
Résultat	System

AccessDBValueWriter() public méthode

construct a new writer to append to the given file

public AccessDBValueWriter ( string filename ) : System
filename	string
Résultat	System

Close() public méthode

closes the underlying stream

public Close ( ) : bool
Résultat	bool

CreateTable() public méthode

public CreateTable ( string tablename, IEnumerable columns ) : bool
tablename	string
columns	IEnumerable
Résultat	bool

Flush() public méthode

flushes the stream

public Flush ( ) : bool
Résultat	bool

IsOpen() public méthode

returns true if the database connection is open and ready

public IsOpen ( ) : bool
Résultat	bool

SetTablename() public méthode

public SetTablename ( string tableName ) : void
tableName	string
Résultat	void

SetWriteFile() public méthode

Opens or creates an MS Access database file for writing

public SetWriteFile ( string filename ) : bool
filename	string
Résultat	bool

TableNames() public méthode

pulls a list of datatable names from the database and caches them. (this list does not refresh, because this reader is read-only)

public TableNames ( ) : List
Résultat	List

WriteLine() public méthode

Make sure you have a value for every column! This is really intentionally not thread safe, do not share this class across threads.

public WriteLine ( IEnumerable values ) : bool
values	IEnumerable
Résultat	bool

Property Details

_conn protected_oe property

an open connection to the database (opened when constructed, or from LoadFile)

protected DbConnection,System.Data.Common _conn
Résultat	System.Data.Common.DbConnection

_filename protected_oe property

the ms access database filename

protected string _filename
Résultat	string

_insertCmd protected_oe property

a reusable parameterized insert command to help speed up our writer.

protected DbCommand,System.Data.Common _insertCmd
Résultat	System.Data.Common.DbCommand

_tablename protected_oe property

the currently selected table name in the ms access database

protected string _tablename
Résultat	string

_tablenames protected_oe property

a one-time cached of tables available in the database

protected List _tablenames
Résultat	List