C# 클래스 ConfigurationSetupUtility.PostgresSetup

This class is used to aid in the manipulation of a PostgreSQL DB connection string as well as executing scripts and storing the data required for PostgreSQL DB setup.

파일 보기 프로젝트 열기: GridProtectionAlliance/substationSBG

공개 메소드들

메소드	설명
CreateLogin ( string loginName ) : void
CreateLogin ( string loginName, string password ) : void
ExecuteScript ( IDbConnection connection, string fileName ) : void	Executes a database script using the given connection.
ExecuteScript ( string fileName ) : void	Executes a database script as the admin user.
ExecuteStatement ( IDbConnection connection, string statement ) : void	Executes the given statement using the given connection.
ExecuteStatement ( string statement ) : void	Executes the given statement as the admin user.
GrantDatabaseAccess ( string loginName ) : void
OpenAdminConnection ( IDbConnection &connection ) : void	Opens a connection as the admin user.
OpenConnection ( IDbConnection &connection ) : void	Opens a connection as the schema user.

비공개 메소드들

메소드	설명
OpenConnection ( IDbConnection &connection, string connectionString ) : void

메소드 상세

CreateLogin() 공개 메소드

public CreateLogin ( string loginName ) : void
loginName	string
리턴	void

CreateLogin() 공개 메소드

public CreateLogin ( string loginName, string password ) : void
loginName	string
password	string
리턴	void

ExecuteScript() 공개 메소드

Executes a database script using the given connection.

public ExecuteScript ( IDbConnection connection, string fileName ) : void
connection	IDbConnection	The connection to be used to execute the script.
fileName	string	The path to the script to be executed.
리턴	void

ExecuteScript() 공개 메소드

Executes a database script as the admin user.

public ExecuteScript ( string fileName ) : void
fileName	string	The path to the script to be executed.
리턴	void

ExecuteStatement() 공개 메소드

Executes the given statement using the given connection.

public ExecuteStatement ( IDbConnection connection, string statement ) : void
connection	IDbConnection	The connection used to execute the statement.
statement	string	The statement to be executed.
리턴	void

ExecuteStatement() 공개 메소드

Executes the given statement as the admin user.

public ExecuteStatement ( string statement ) : void
statement	string	The statement to be executed.
리턴	void

GrantDatabaseAccess() 공개 메소드

public GrantDatabaseAccess ( string loginName ) : void
loginName	string
리턴	void

OpenAdminConnection() 공개 메소드

Opens a connection as the admin user.

public OpenAdminConnection ( IDbConnection &connection ) : void
connection	IDbConnection	The connection object to be created and opened.
리턴	void

OpenConnection() 공개 메소드

Opens a connection as the schema user.

public OpenConnection ( IDbConnection &connection ) : void
connection	IDbConnection	The connection object to be created and opened.
리턴	void