| Package | stimulsoft.report.dictionary.databases |
| Class | public class StiSqlDatabase |
| Inheritance | StiSqlDatabase  StiDatabase StiService StiObject Object |
| Subclasses | StiCustomDatabase, StiDB2Database, StiDotConnectUniversalDatabase, StiEffiProzDatabase, StiFirebirdDatabase, StiInformixDatabase, StiJdbcDatabase, StiMongoDBDatabase, StiMSAccessDatabase, StiMySqlDatabase, StiOdbcDatabase, StiOleDbDatabase, StiOracleDatabase, StiOracleODPDatabase, StiPostgreSQLDatabase, StiSqlCeDatabase, StiSQLiteDatabase, StiSybaseAdsDatabase, StiSybaseAseDatabase, StiUndefinedDatabase, StiUniDirectDatabase, StiVistaDBDatabase |
| Property | Defined By | ||
|---|---|---|---|
 | alias : String Gets or sets an alias of the database. | StiDatabase | |
| connectionString : String Gets or sets a connection string which contains SQL connection parameters. | StiSqlDatabase | ||
| connectionStringEncrypted : String Gets or sets a connection string which contains SQL connection parameters, in encrypted form. | StiSqlDatabase | ||
| dataSet : DataSet = null | StiDatabase | |
| dataSources : StiDataSourcesCollection Коллекция всех источников данных этого подключения. | StiDatabase | |
| dataSourcesCache : Array | StiDatabase | |
| dictionary : StiDictionary = null | StiDatabase | |
| inherited : Boolean | StiDatabase | |
| loadData : Boolean = true | StiDatabase | |
| name : String Gets or sets a name of the database. | StiDatabase | |
| password : String = null | StiSqlDatabase | ||
| promptUserNameAndPassword : Boolean Gets or sets a value which indicates that UserName and Password parameters should be requested from user. | StiSqlDatabase | ||
| properties : StiRepositoryItems | StiService | |
| ref : int | StiDatabase | |
| serviceCategory : String [read-only] Gets a service category. | StiService | |
| serviceInfo : String [read-only] Gets a service description. | StiService | |
| serviceName : String [override] [read-only] Gets a service name. | StiSqlDatabase | ||
| serviceType : Class [read-only] Gets a service type. | StiService | |
| username : String = null | StiSqlDatabase | ||
| Property | Defined By | ||
|---|---|---|---|
| dataAdapterType : Class [override] [read-only] | StiSqlDatabase | ||
| Method | Defined By | ||
|---|---|---|---|
StiSqlDatabase(name:String, alias:String = null, connectionString:String, promptUserNameAndPassword:Boolean = false) | StiSqlDatabase | ||
| addEventListener(type:String, listener:Function, useCapture:Boolean = false, priority:int = 0, useWeakReference:Boolean = false):void | StiDatabase | |
| clone(... args):Object [override] Creates a new object that is a copy of the current instance. | StiService | |
| createDataSet(dataSources:Array):DataSet Создание нового DataSet с таблицами данных на основе указанного списка источников данных | StiDatabase | |
| createDataSourcesCache():Array Создание списка источников данных текущего подключения для их последующей загрузки | StiDatabase | |
| dispatchEvent(event:Event):Boolean | StiDatabase | |
| equals(object:Object):Boolean | StiObject | |
| StiDatabase | ||
| getShortTypeName():String Get a short object type name (without library path). | StiObject | |
| getType():Class | StiObject | |
| getTypeName():String | StiObject | |
| hasEventListener(type:String):Boolean | StiDatabase | |
| isSimple(object:*):Boolean [static] | StiObject | |
memberwiseClone():Object [override] | StiSqlDatabase | ||
| packService():void | StiService | |
promptUserPassword(method:Function, query:String = null, parameters:StiDataParametersCollection = null):void | StiSqlDatabase | ||
regData(dictionary:StiDictionary, loadData:Boolean):void [override] Загрузка всех данных из SQL источников текущей базы данных | StiSqlDatabase | ||
| removeEventListener(type:String, listener:Function, useCapture:Boolean = false):void | StiDatabase | |
retrieveColumns(nameInSource:String):Array [override] Возвращает массив сохранённых колонок по имени источника данных | StiSqlDatabase | ||
Синхронизация таблиц и колонок с внутренним кэшем базы данных | StiSqlDatabase | ||
testConnection():void Тестирование подключения к базе данных | StiSqlDatabase | ||
| toString():String | StiDatabase | |
| Method | Defined By | ||
|---|---|---|---|
onDataAdapterResult(event:StiDataAdapterEvent):void Загрузка успешно завершена | StiSqlDatabase | ||
| onRetrieveColumnsResult(event:StiDataAdapterEvent):void Событие завершения получения таблиц и колонок базы данных | StiDatabase | |
onTestConnectionResult(event:StiDataAdapterEvent):void | StiSqlDatabase | ||
parseQuery(query:String, parameters:StiDataParametersCollection = null):String Применение парсера выражений к указанному SQL запросу | StiSqlDatabase | ||
regDataSource(dataSource:StiSqlSource):void Загрузка данных из очередного SQL источника | StiSqlDatabase | ||
synhronizeStart(query:String, parameters:StiDataParametersCollection):void | StiSqlDatabase | ||
| connectionString | property |
Hide Inherited Public Properties
Show Inherited Public PropertiesconnectionString:StringGets or sets a connection string which contains SQL connection parameters.
public function get connectionString():String public function set connectionString(value:String):void| connectionStringEncrypted | property |
connectionStringEncrypted:StringGets or sets a connection string which contains SQL connection parameters, in encrypted form.
public function get connectionStringEncrypted():String public function set connectionStringEncrypted(value:String):void| dataAdapterType | property |
dataAdapterType:Class [read-only] [override] protected function get dataAdapterType():Class| password | property |
public var password:String = null| promptUserNameAndPassword | property |
promptUserNameAndPassword:BooleanGets or sets a value which indicates that UserName and Password parameters should be requested from user.
public function get promptUserNameAndPassword():Boolean public function set promptUserNameAndPassword(value:Boolean):void| serviceName | property |
serviceName:String [read-only] [override] Gets a service name.
public function get serviceName():String| username | property |
public var username:String = null| StiSqlDatabase | () | Constructor |
public function StiSqlDatabase(name:String, alias:String = null, connectionString:String, promptUserNameAndPassword:Boolean = false)name:String | |
alias:String (default = null) | |
connectionString:String | |
promptUserNameAndPassword:Boolean (default = false) |
| memberwiseClone | () | method |
override public function memberwiseClone():ObjectReturnsObject |
| onDataAdapterResult | () | method |
protected function onDataAdapterResult(event:StiDataAdapterEvent):voidЗагрузка успешно завершена
Parameters
event:StiDataAdapterEvent |
| onTestConnectionResult | () | method |
protected function onTestConnectionResult(event:StiDataAdapterEvent):voidParameters
event:StiDataAdapterEvent |
| parseQuery | () | method |
protected function parseQuery(query:String, parameters:StiDataParametersCollection = null):StringПрименение парсера выражений к указанному SQL запросу
Parameters
query:String | |
parameters:StiDataParametersCollection (default = null) |
String |
| promptUserPassword | () | method |
public function promptUserPassword(method:Function, query:String = null, parameters:StiDataParametersCollection = null):voidParameters
method:Function | |
query:String (default = null) | |
parameters:StiDataParametersCollection (default = null) |
| regData | () | method |
override public function regData(dictionary:StiDictionary, loadData:Boolean):voidЗагрузка всех данных из SQL источников текущей базы данных
Parameters
dictionary:StiDictionary | |
loadData:Boolean |
| regDataSource | () | method |
protected function regDataSource(dataSource:StiSqlSource):voidЗагрузка данных из очередного SQL источника
Parameters
dataSource:StiSqlSource |
| retrieveColumns | () | method |
override public function retrieveColumns(nameInSource:String):ArrayВозвращает массив сохранённых колонок по имени источника данных
Parameters
nameInSource:String |
Array |
| synhronize | () | method |
public function synhronize(dictionary:StiDictionary, query:String, parameters:StiDataParametersCollection):voidСинхронизация таблиц и колонок с внутренним кэшем базы данных
Parameters
dictionary:StiDictionary | |
query:String | |
parameters:StiDataParametersCollection |
| synhronizeStart | () | method |
protected function synhronizeStart(query:String, parameters:StiDataParametersCollection):voidParameters
query:String | |
parameters:StiDataParametersCollection |
| testConnection | () | method |
public function testConnection():voidТестирование подключения к базе данных