메소드 | 설명 | |
---|---|---|
ClipboardClear ( ) : void |
Expose Clipboard.Clear()
|
|
ClipboardGetText ( ) : string |
Expose Clipboard.SetText()
|
|
ClipboardGetText ( int textDataType ) : string |
Exposes ClipboardGetText(TestDataFormat);
|
|
ClipboardSetText ( object text ) : void |
Expose Clipboard.SetText()
|
|
ClipboardSetText ( object text, object textDataType ) : void |
Exposes ClipboardSetText(text, TestDataFormat);
|
|
EscapeSqlString ( string sqlString ) : string |
escapes a literal string so it can be inserted using sql
|
|
ExecuteSql ( string sqlString ) : bool |
Execute SQL and catch Exception
|
|
FormatXPath ( string xpath ) : string |
formats an xpath according to the type of database. For Oracle and Firebird it should be ALL CAPS
|
|
GetRepositoryType ( ) : RepositoryType |
Gets the rep type for this model
|
|
Initialize ( EA rep ) : void |
Initialize an rep Model object Intended to use from a scripting environment
|
|
MakeEaItemListFromQuery ( System.Xml.Linq.XDocument x ) : List |
Make EA XML output format from EA SQLQuery XDocument format (LINQ to XML)
|
|
MakeEaXmlOutput ( System.Xml.Linq.XDocument x ) : string |
Make EA XML output format from EA SQLQuery XDocument format (LINQ to XML). If nothing found or an error has occurred nothing is displayed.
|
|
MakeEaXmlOutput ( string x ) : string |
Make EA XML output format from EA SQLQuery format (string)
|
|
Model ( ) : System |
Create a model on the first running EA instance
|
|
Model ( EA repository ) : System |
Create a Model
|
|
SearchRun ( string searchName, string searchTerm ) : void |
Runs the search (EA search or hoTools SQL file if it's a *.sql file). It handles the exceptions. It converts wild cards of the <Search Term>.
|
|
SqlExecuteNative ( string sqlExecute ) : bool |
EA Execute SQL: - formatSQL - runSQL - return SQL string
|
|
SqlExecuteWithException ( string sql ) : bool |
Run EA SQL Query with Exception handling
|
|
SqlQuery ( string sqlQuery ) : |
EA SQL Query with: - formatSQL - runSQL - return SQL string as XmlDocument
|
|
SqlQueryNative ( string sqlQuery ) : string |
EA SQL Query native with: - formatSQL - runSQL - return SQL string
|
|
SqlQueryWithException ( string query ) : string |
Run EA SQL Query with Exception handling. It deletes the error file and reads it back to detect errors.
|
|
SqlRun ( string sql, string searchText ) : void |
Run an SQL string and if query output the result in EA Search Window. If update, insert, delete execute SQL.
|
메소드 | 설명 | |
---|---|---|
EmptyQueryResult ( ) : string |
Empty Query Result
|
|
FormatSql ( string sqlQuery ) : string |
sets the correct wild cards depending on the database type. changes '%' into '*' if on ms access and _ into ? on msAccess
|
|
FormatSqlFunctions ( string sqlQuery ) : string |
Operation to translate SQL functions in there equivalents in different sql syntaxes supported functions: - lcase -> lower in T-SQL (SqlSvr and Asa)
|
|
FormatSqlTop ( string sqlQuery ) : string |
limiting the number of results in an sql query is different on different platforms.
|
|
FormatSqldBspecific ( string sql ) : string |
Format DB specific by removing unnecessary DB specific string parts.
|
|
ReplaceSqlWildCards ( string sqlQuery ) : string |
Replace the wild cards in the given sql query string to match either MSAccess or ANSI syntax. It works for:
|
public ClipboardGetText ( int textDataType ) : string | ||
textDataType | int | |
리턴 | string |
public ClipboardSetText ( object text, object textDataType ) : void | ||
text | object | |
textDataType | object | |
리턴 | void |
public EscapeSqlString ( string sqlString ) : string | ||
sqlString | string | the string to be escaped |
리턴 | string |
public FormatXPath ( string xpath ) : string | ||
xpath | string | the xpath to format |
리턴 | string |
public MakeEaItemListFromQuery ( System.Xml.Linq.XDocument x ) : List |
||
x | System.Xml.Linq.XDocument | Output from EA SQLQuery |
리턴 | List |
public MakeEaXmlOutput ( System.Xml.Linq.XDocument x ) : string | ||
x | System.Xml.Linq.XDocument | Output from EA SQLQuery |
리턴 | string |
public SearchRun ( string searchName, string searchTerm ) : void | ||
searchName | string | EA Search name or SQL file name (uses path to find absolute path) |
searchTerm | string | |
리턴 | void |
public SqlExecuteNative ( string sqlExecute ) : bool | ||
sqlExecute | string | |
리턴 | bool |
public SqlExecuteWithException ( string sql ) : bool | ||
sql | string | |
리턴 | bool |
public SqlQuery ( string sqlQuery ) : |
||
sqlQuery | string | |
리턴 |
public SqlQueryNative ( string sqlQuery ) : string | ||
sqlQuery | string | |
리턴 | string |
public SqlQueryWithException ( string query ) : string | ||
query | string | |
리턴 | string |
public SqlRun ( string sql, string searchText ) : void | ||
sql | string | |
searchText | string | Search Text to replace 'Search Term' macro |
리턴 | void |