C# 클래스 Azavea.Open.DAO.PostgreSQL.PostgreSqlDescriptor

This class is a ConnectionDescriptor implementation for using FastDAO to communicate with a PostGreSQL / PostGIS database. Thought it is named "PostGreSqlDescriptor", it supports spatial queries and data if you have PostGIS installed.
상속: Azavea.Open.DAO.SQL.AbstractSqlConnectionDescriptor, ITransactionalConnectionDescriptor
파일 보기 프로젝트 열기: azavea/net-dao-postgresql 1 사용 예제들

공개 프로퍼티들

프로퍼티 타입 설명
DEFAULT_ENCODING string
DEFAULT_PORT string

공개 메소드들

메소드 설명
BeginTransaction ( ) : ITransaction

Begins the transaction. Returns a transaction object that you should use for operations you wish to be part of the transaction. NOTE: You MUST call Commit or Rollback on the returned ITransaction when you are done.
CaseInsensitiveLikeOperator ( ) : string
ColumnAliasPrefix ( ) : string
ColumnAliasSuffix ( ) : string
CreateDataAccessLayer ( ) : IDaLayer
CreateNewAdapter ( IDbCommand cmd ) : DbDataAdapter
CreateNewConnection ( ) : DbConnection
HasCaseInsensitiveLikeOperator ( ) : bool
MakeConnectionString ( string server, string port, string database, string user, string password, string encoding ) : string

Assembles a PostGreSQL/PostGIS connection string that can be used to get a database connection. All the parameters are optional for the purposes of this method, although obviously it would be possible to create a useless connection string if you leave out important parameters.
MakeModulusClause ( string columnName ) : SqlClauseWithValue
MakeSequenceValueQuery ( string sequenceName ) : string
NeedAsForColumnAliases ( ) : bool
NeedToAliasColumns ( ) : bool
PostgreSqlDescriptor ( Config config, string component, ConnectionInfoDecryptionDelegate decryptionDelegate ) : System

This constructor reads all the appropriate values from our standard config file in the normal format.
PostgreSqlDescriptor ( string server, string port, string database, string user, string password, string encoding ) : System

Constructor that lets you pass everything as parameters rather than requiring a config.
SetParametersOnCommand ( IDbCommand cmd, IEnumerable parameters ) : void
TableAliasPrefix ( ) : string
TableAliasSuffix ( ) : string
ToCleanString ( ) : string
ToCompleteString ( ) : string
UsePooling ( ) : bool

메소드 상세

BeginTransaction() 공개 메소드

Begins the transaction. Returns a transaction object that you should use for operations you wish to be part of the transaction. NOTE: You MUST call Commit or Rollback on the returned ITransaction when you are done.
public BeginTransaction ( ) : ITransaction
리턴 ITransaction

CaseInsensitiveLikeOperator() 공개 메소드

public CaseInsensitiveLikeOperator ( ) : string
리턴 string

ColumnAliasPrefix() 공개 메소드

public ColumnAliasPrefix ( ) : string
리턴 string

ColumnAliasSuffix() 공개 메소드

public ColumnAliasSuffix ( ) : string
리턴 string

CreateDataAccessLayer() 공개 메소드

public CreateDataAccessLayer ( ) : IDaLayer
리턴 IDaLayer

CreateNewAdapter() 공개 메소드

public CreateNewAdapter ( IDbCommand cmd ) : DbDataAdapter
cmd IDbCommand
리턴 System.Data.Common.DbDataAdapter

CreateNewConnection() 공개 메소드

public CreateNewConnection ( ) : DbConnection
리턴 System.Data.Common.DbConnection

HasCaseInsensitiveLikeOperator() 공개 메소드

public HasCaseInsensitiveLikeOperator ( ) : bool
리턴 bool

MakeConnectionString() 공개 정적인 메소드

Assembles a PostGreSQL/PostGIS connection string that can be used to get a database connection. All the parameters are optional for the purposes of this method, although obviously it would be possible to create a useless connection string if you leave out important parameters.
public static MakeConnectionString ( string server, string port, string database, string user, string password, string encoding ) : string
server string Server name that is hosting the database
port string Port number on the server to use, if you don't know then use DEFAULT_PORT.
database string Database name, if necessary to specify
user string User name to use when accessing the db
password string Password for above user, in plain text.
encoding string String encoding to use, if you don't know then use DEFAULT_ENCODING.
리턴 string

MakeModulusClause() 공개 메소드

public MakeModulusClause ( string columnName ) : SqlClauseWithValue
columnName string
리턴 Azavea.Open.DAO.SQL.SqlClauseWithValue

MakeSequenceValueQuery() 공개 메소드

public MakeSequenceValueQuery ( string sequenceName ) : string
sequenceName string
리턴 string

NeedAsForColumnAliases() 공개 메소드

public NeedAsForColumnAliases ( ) : bool
리턴 bool

NeedToAliasColumns() 공개 메소드

public NeedToAliasColumns ( ) : bool
리턴 bool

PostgreSqlDescriptor() 공개 메소드

This constructor reads all the appropriate values from our standard config file in the normal format.
public PostgreSqlDescriptor ( Config config, string component, ConnectionInfoDecryptionDelegate decryptionDelegate ) : System
config Azavea.Open.Common.Config Config to get params from.
component string Section of the config XML to look in for db params.
decryptionDelegate ConnectionInfoDecryptionDelegate Delegate to call to decrypt password fields. /// May be null if passwords are in plain text.
리턴 System

PostgreSqlDescriptor() 공개 메소드

Constructor that lets you pass everything as parameters rather than requiring a config.
public PostgreSqlDescriptor ( string server, string port, string database, string user, string password, string encoding ) : System
server string Server name or IP. May not be null.
port string Port number on the server. Null means use the default.
database string Database name on that server. May not be null.
user string Database user name, may be null.
password string Plain text password for the user. /// May be null.
encoding string String encoding to use. Null means use the default (unicode).
리턴 System

SetParametersOnCommand() 공개 메소드

public SetParametersOnCommand ( IDbCommand cmd, IEnumerable parameters ) : void
cmd IDbCommand
parameters IEnumerable
리턴 void

TableAliasPrefix() 공개 메소드

public TableAliasPrefix ( ) : string
리턴 string

TableAliasSuffix() 공개 메소드

public TableAliasSuffix ( ) : string
리턴 string

ToCleanString() 공개 메소드

public ToCleanString ( ) : string
리턴 string

ToCompleteString() 공개 메소드

public ToCompleteString ( ) : string
리턴 string

UsePooling() 공개 메소드

public UsePooling ( ) : bool
리턴 bool

프로퍼티 상세

DEFAULT_ENCODING 공개적으로 정적으로 프로퍼티

This is the "usual" character encoding that PostGreSQL uses. Unless you know your instance is using a different encoding, this is the one you should use.
public static string DEFAULT_ENCODING
리턴 string

DEFAULT_PORT 공개적으로 정적으로 프로퍼티

This is the "usual" port that PostGreSQL runs on. Unless you know your instance is running on a different port, this is the one you should use.
public static string DEFAULT_PORT
리턴 string