#PostgreSQLDriver

##Properties

Datatype Property name Property description Default Value
Boolean AlwaysGenerateAs Determines whether fields will always use the "AS" keyword when generating SQL queries. False
String AsForTables Gets the PostgreSQL keyword used to separate identifiers from aliases. String.Empty
String CacheKeyBase Gets a System.String that represents a unique key that can be used to query the cache. Izenda.AdHoc.Database.PostgreSQLDriver
Int32 CmdTimeout   3600
IDbConnection Connection Gets the current connection to the database or creates a new one if one does not exist or if the existing connection is dropped. null
IDbConnection ConnectionOpened   null
String ConnectionString Represents the default connection string for the driver in use. null
DatabaseSchema DatabaseSchema Represents the schema obtained from the database. null
String[] DateFormats Gets a collection of all the date format strings that are available. [M/dd/yyyyH:m, M/d/yyyyH:m,
M/dd/yyyyH:mtt, M/d/yyyyH:mtt,
MMMMdd,yyyyHH:mm, MMMMdd,yyyyHH:mmtt,
M/dd/yyyyh:m, M/d/yyyyh:m,
M/dd/yyyyh:mtt, M/d/yyyyh:mtt,
MMMMdd,yyyyhh:mm, MMMMdd,yyyyhh:mmtt,
M-dd-yyyy, M-d-yyyy,
M-dd-yy, M-d-yy,
M/dd/yyyy, M/d/yyyy,
M/dd/yy, M/d/yy,
MMMMd,yyyy, MMMMdd,yyyy,
MMMd,yyyy, MMMdd,yyyy,
M,yyyy, M-yyyy,
M,yy, M-yy,
MMM,yyyy, MMM-yyyy,
MMM,yy, MMM-yy,
MMMM,yyyy, MMMM-yyyy,
MMMM,yy, MMMM-yy,
yyyy-mm-ddHH:mm:ss, yyyy-m-dHH:mm:ss,
yyyy-mm-ddH:m:ss, yyyy-m-dH:m:ss,
yyyy-mm-dd, yyyy-mm-ddhh:mm:ss,
yyyy-m-dhh:mm:ss, yyyy-mm-ddh:m:ss,
yyyy-m-dh:m:ss, yyyy-mm-ddhh:mm:ss,
yyyy-mm-ddhh:mm:ss]
String DefaultSchemaName Represents the name of the default schema of the DBMS for this driver. public
Encoding Encoding Gets the System.Text.Encoding representation of the database's default text encoding. Unicode (UTF-8)
List NativeTypesOverrides Collection of the key-value pairs that is used to create a temporary table when SP is used as a data source. Key - SqlDbType Value - corresponding native DB type {[Decimal,Decimal(18,6)], [Variant,sql_variant],
[VarChar,VarChar(MAX)]}
Boolean OnlyNullIsBlank   False
TimeSpan QueryCachingTime Represents the period of time that queries made to the database will remain in the cache. Cached queries exist within application memory until this time period has elapsed or the queries cache is invalidated. The default is five minutes. 00:01:00
TimeSpan SchemaCachingTime Represents the period of time that the database schema will remain in the cache before it is invalidated and will be re-loaded from the database. The default is one day. 1.00:00:00
Boolean SupportsCreateDateExpression Determines if the version of the database supports the ability to create a date from portions of a date. True
Boolean UseTablesFromSchemaOnly   False
Version Version Gets the version of the database that is being connected to. Once the version has been obtained, its value will be cached to disk. null

##Methods

###AddConstraint(System.String,System.String) Represents a method used to add a primary/foreign key relationship between two tables' columns in the schema using an INNER JOIN. The wildcard "*" is accepted and column names are case sensitive.

Parameters:

  • System.String primaryColumn - The fully-qualified column name or wildcard to use as the primary(lefthand) table.
  • System.String foreignColumn - The fully-qualified column name or wildcard to use as the foreign(righthand) table.

###AddConstraint(System.String,System.String,Izenda.AdHoc.Database.DatabaseSchema)

Parameters:

###AddForcedLeftJoin(System.String,System.String) Represents a method to add a primary/foreign key relationship between two tables in the schema using a LEFT OUTER JOIN.

Parameters:

  • System.String primaryTable - The fully-qualified table name to use as the primary(lefthand) table.
  • System.String foreignTable - The fully-qualified table name to use as the foreign(righthand) table.

###AddForcedLeftJoin(System.String) Represents a method to add a primary/foreign key relationship between a table and itself in the schema using a LEFT OUTER JOIN.

Parameters:

  • System.String table - The fully-qualified table name to use to join it to itself.

###BeginAddingMultipleConstraints()

###CastPivotValue(System.String,Izenda.AdHoc.Database.SqlType) Gets a SQL formatted System.String that safely converts values produced for pivot columns to the specified Izenda.AdHoc.Database.SqlType.

Parameters:

###CheckConnection() Checks to ensure connectivity to the database

###ContainColumn(System.String,System.String,System.String) Determines whether the specified table in the schema contains the column with the specified name in the PostgreSQL database.

Parameters:

  • System.String schemaName - The name of the database schema to use.
  • System.String tableName - The name of the table within the schema to use.
  • System.String columnName - The name of the column to determine the existence of.

Returns:

True if the column was found on the database. False if not.

###ContainsTableName(System.String) Checks to see if the specified table exists on the PostgreSQL database.

Parameters:

Returns:

A System.Boolean representation of the table's existence.

###ConvertToDbType(System.Type) Gets the System.Data.SqlDbType that is type equivalent to the specified System.Type

Parameters:

Returns:

The System.Data.SqlDbType produced from the specified System.Type

###CreateCommand(System.String) Creates an System.Data.IDbCommand object from the specified System.String SQL statement that can be cast to an Npgsql.NpgsqlCommandCommand.

Parameters:

Returns:

The System.Data.IDbCommand.

###CreateConnection() Creates a connection to the PostgreSQL database if the connection string exists.

Returns:

The System.Data.IDbConnection created that can be cast to an Npgsql.NpgsqlConnection.

###CreateDataAdapter(System.Data.IDbCommand) Creates an executable System.Data.IDbDataAdapter for the specified command.

Parameters:

Returns:

The executable adapter.

###CreateDataAdapter(System.String) Represents a method that creates an executable System.Data.IDbDataAdapter for the specified command.

Parameters:

Returns:

The executable adapter.

###CreateJoinedTablesList(System.String[],Izenda.AdHoc.ReportSet) Represents a method that creates a collection of related tables from the provided array of datasources for determining possible relationships between datasources.

Parameters:

###CreateParameter(System.String,System.Object) Creates a generically-typed System.Data.IDataParameter object from the specified values that can be typecast to an Npgsql.NpgsqlParameter object.

Parameters:

Returns:

The System.Data.IDataParameter created.

###CreateParameter(System.String,System.Object,System.Data.DbType) Creates a System.Data.IDataParameter object from the specified values that can be typecast to a Npgsql.NpgsqlParameter object.

Parameters:

Returns:

The System.Data.IDataParameter created.

###DateTimeNow() Gets the System.String representation of the PostgreSQL command to return the current system date from the database server.

Returns:

The System.String function for returning the current date.

###DeleteReportTemplate(System.String,System.String) Creates a System.Data.IDbCommand that can be executed to delete the HTML form for the specified report from the database.

Parameters:

Returns:

A System.Data.IDbCommand that can be used to delete the form data.

###DeleteReportThumbnail(System.String,System.String) Creates a System.Data.IDbCommand that can be executed to delete a report thumbnail image in the SavedReportsTable on the database.

Parameters:

Returns:

A System.Data.IDbCommand that can be used to delete a thumbnail.

###DeleteThumbnail(System.String,System.String)

Parameters:

###DetectVersion() Gets the version of the PostgreSQL database that is being connected to.

Returns:

The System.Version representation of the PostgreSQL database version.

###EndAddingMultipleConstraints()

###EnsureCorrectMeta(System.String) Rrepresents a method that is used to create a clustered index on the specified table name if one doesn't exist.

Parameters:

###Equals(System.Object) Determines whether the specified System.Object is equal to the current System.Object.

Parameters:

Returns:

true if the specified System.Object is equal to the current System.Object; otherwise, false.

###ExctractSchema() Represents a method that is used to obtain the database schema by populating the tables, views, stored procedures, and constraints.

Returns:

The Izenda.AdHoc.Database.DatabaseSchema object representing the collection of tables, views, stored procedures, and constraints.

###ExecuteDataSet(System.String) Gets a System.Data.DataSet object from the database using the SQL query provided.

Parameters:

Returns:

The System.Data.DataSet produced by the query from the database.

###ExecuteDataSet(System.String,System.Boolean) Gets a System.Data.DataSet object from the database using the SQL query provided.

Parameters:

###ExecuteNonQuery(System.String) Executes the SQL query on the database server and produces its return code.

Parameters:

Returns:

The System.Integer return code of the query.

###ExecuteNonQuery(System.Data.IDbCommand) Executes the SQL command on the database server and produces its return code.

Parameters:

Returns:

The System.Integer return code of the command.

###ExecuteScalar(System.String) Gets the first result from executing the specified SQL System.String.

Parameters:

Returns:

The first result from the executed scalar command.

###ExecuteScalar(System.String,System.Boolean) Gets the first result from executing the specified SQL System.String.

Parameters:

  • System.String sql - The System.String representation of the query to execute.
  • System.Boolean returnNull - Specifies whether an exception will cause the method to return null instead of the exception.

Returns:

The first result from the executed scalar command.

###FullStoredProceduresList() Gets a list of all stored procedures on the PostgreSQL database.

Returns:

The AdHoc.Database.Storedprocedure array corresponding to the stored procedures found.

###GenerateCommand(Izenda.AdHoc.Report,System.Boolean) Creates an System.Data.IDbCommand object from the specified Izenda.AdHoc.Report.

Parameters:

Returns:

The System.Data.IDbCommand that can be executed to get the report data.

###GenerateSQL(Izenda.AdHoc.Report,System.Boolean,System.String,out System.Collections.IList) Gets a SQL statement for the specified report with the option of including filter parameters in the output.

Parameters:

###GenerateSqlSafetyDescription(System.String) Gets a SQL-safe System.String representation of the given description.

Parameters:

  • System.String description - The alias of a column, table, or view that needs to be made SQL-safe.

Returns:

The System.String represetation of the description that has been made safe for executing in PostgreSQL.

###GenerateTotalsCommand(Izenda.AdHoc.Report,System.Int32) Gets a System.Data.IDbCommand that produces grand totals for the specified Izenda.AdHoc.Report.

Parameters:

Returns:

The System.Data.IDbCommand that produces grand totals.

###GenerateTotalsSQL(Izenda.AdHoc.Report,System.Boolean,System.String,out System.Collections.IList) Gets a SQL statement that generates subtotals for the specified report with the option of including filter parameters in the output.

Parameters:

###GetAggregateFunction(Izenda.AdHoc.StandardAggregateFunctionType,System.String) Gets the System.String representation of the SQL expression for the specified aggregate function using the input expression.

Parameters:

Returns:

The System.String representation of the entire aggregate function expression.

###GetAllStoredProcedures() Gets a list of all stored procedures on the PostgreSQL database from the VisibleDatasources.

Returns:

The AdHoc.Database.Storedprocedure array corresponding to the stored procedures found.

###GetAllTables() Gets a list of all tables and views on the PostreSQL database from the VisibleDataSources.

Returns:

The Izenda.AdHoc.Database.Table array corresponding to the tables and views found.

###GetAppropriateSqlTypeFromTypeGroup(Izenda.AdHoc.Database.SqlTypeGroup)

Parameters:

###GetBlankKeyword() Represents the keyword signifying NULLs or BLANK on the database.

Returns:

The symbol signifying NULL or BLANK

###GetColumns(Izenda.AdHoc.Database.Table) Gets the complete list of columns found on the PostgreSQL database for the specified table.

Parameters:

Returns:

The Izenda.AdHoc.Database.Column array corresponding to the columns found.

###GetColumns(Izenda.AdHoc.Database.StoredProcedure) Gets the list of columns for the specified stored procedure on the PostgreSQL database.

Parameters:

Returns:

The Izenda.AdHoc.Database.Column array corresponding to the columns found.

###GetColumnValuesSql(Izenda.AdHoc.Database.Column,System.Int32,System.String)

Parameters:

###GetConcatStringsExpression(System.String,System.String) Gets a System.String representation of an expression to concatenate two strings.

Parameters:

  • System.String expression1 - The first expression to concatenate.
  • System.String expression2 - The second expression to concatenate.

Returns:

The System.String representation of the SQL statement that can be executed to concatenate strings.

###GetConcatStringsExpression(System.String,System.String,System.String) Represents a method that gets the System.String of an expression to concatenate three strings.

Parameters:

  • System.String expression1 - The first expression to concatenate.
  • System.String expression2 - The second expression to concatenate.
  • System.String expression3 - The third expression to concatenate.

Returns:

The System.String representation of the SQL statement that can be executed to concatenate strings.

###GetConstraints(Izenda.AdHoc.Database.DatabaseSchema) Gets a list of constraints for the specified database schema on the PostgreSQL database.

Parameters:

Returns:

The Izenda.AdHoc.Database.Constraint array corresponding to the database constraints found.

###GetCreateArchiveTableCommand(System.String)

Parameters:

###GetCreateDateExpression(System.String,System.String,System.String) Gets a SQL formatted System.String representation of the function used to convert the specified parameters into a PostgreSQL date.

Parameters:

Returns:

The SQL statement that can be executed to construct a PostgreSQL formatted date from the parts provided.

###GetCreateReportCommand(System.String,System.String,System.String,System.String) Gets a PostgreSQL statement from the specified parameters that creates a System.Data.IDbCommand to create a report on the database.

Parameters:

  • System.String tableName - The name of the table used to store reports.
  • System.String reportName - The name of the report that will be created on the database.
  • System.String tenantId - The tenantId that the report should belong to when it's created.
  • System.String xml - The XML report representation of the report definition.

Returns:

The System.Data.IDbCommand created from the parameters.

###GetCreateReportCommand(System.String,System.String,System.String) Gets a PostgreSQL statement from the specified parameters that creates a System.Data.IDbCommand to create a report on the database. This method uses an empty tenantId.

Parameters:

  • System.String tableName - The name of the table used to store reports.
  • System.String reportName - The name of the report that will be created on the database.
  • System.String xml - The XML report representation of the report definition.

Returns:

The System.Data.IDbCommand created from the parameters.

###GetDatabase()

###GetDataReader(System.Data.IDbCommand) Gets a System.Data.IDataReader object from the specified database command that can be typecast to an Npgsql.NpgsqlCommand.

Parameters:

Returns:

The executed System.Data.IDataReader object.

###GetDataSet(System.Data.IDbCommand) Gets a System.Data.DataSet for the specified SQL command.

Parameters:

Returns:

The new System.Data.DataSet with the results of the query.

###GetDataSet(System.Data.IDbCommand,System.String) Gets a System.Data.DataSet for the specified SQL command.

Parameters:

Returns:

The new System.Data.DataSet with the results of the query.

###GetDataSetCached(System.String) Gets a System.Data.DataSet for the specified SQL expression from the cache if possible. CacheQueries must be on, otherwise the query will touch the database instead.

Parameters:

Returns:

The System.Data.DataSet that was cached the first time the query was executed or a new System.Data.DataSet with the results.

###GetDataSetCached(System.Data.IDbCommand) Gets a System.Data.DataSet for the specified SQL command from the cache if possible. CacheQueries must be on, otherwise the query will touch the database instead.

Parameters:

Returns:

The System.Data.DataSet that was cached the first time the query was executed or a new System.Data.DataSet with the results.

###GetDataSetCached(System.Data.IDbCommand,System.Boolean) Gets a System.Data.DataSet for the specified SQL command with the option of using the cached version.

Parameters:

Returns:

The System.Data.DataSet that was cached the first time the query was executed or a new System.Data.DataSet with the results.

###GetDataTable(System.String,System.Boolean) Gets the first System.Data.DataTable in the DataSet returned from executing the SQL.

Parameters:

Returns:

The first System.Data.DataTable found on the System.Data.DataSet returned by the query.

###GetDataTable(System.String) Gets the first System.Data.DataTable in the DataSet returned from executing the SQL. The results are loaded from the cache if possible when CacheQueries is on.

Parameters:

Returns:

The first System.Data.DataTable found on the System.Data.DataSet returned by the query.

###GetDataTable(System.Data.IDbCommand,System.Boolean) Gets the first System.Data.DataTable in the DataSet returned from executing the SQL command.

Parameters:

Returns:

The first System.Data.DataTable found on the System.Data.DataSet returned by the query.

###GetDataTable(System.Data.IDbCommand,System.String) Gets the first System.Data.DataTable in the DataSet returned from executing the SQL command.

Parameters:

Returns:

The first System.Data.DataTable found on the System.Data.DataSet returned by the query.

###GetDataTable(System.Data.IDbCommand) Gets the first System.Data.DataTable in the DataSet returned from executing the SQL command.

Parameters:

Returns:

The first System.Data.DataTable found on the System.Data.DataSet returned by the query.

###GetDataTable(Izenda.AdHoc.Report,System.Data.IDbCommand) Gets a System.Data.DataTable from the specified Izenda.AdHoc.Report and System.Data.IDbCommand provided.

Parameters:

Returns:

The first System.Data.DataTable found on the System.Data.DataSet returned by the query.

###GetDateAdd(System.String,System.Int32,System.String)

Parameters:

###GetDateAdd(System.String,System.Double,System.String)

Parameters:

###GetDateDiffSQL(System.String,System.String,Izenda.AdHoc.StandardAggregateFunctionType) Gets the PostgreSQL System.String representation of a function that calculates the difference between two dates.

Parameters:

Returns:

The PostgreSQL formatted System.String created from the parameters.

###GetDateDiffSQL(System.String,System.String,System.String,Izenda.AdHoc.StandardAggregateFunctionType) Gets the PostgreSQL System.String representation of a function that calculates the difference between two dates.

Parameters:

Returns:

The PostgreSQL formatted System.String created from the parameters.

###GetDateExpression(System.DateTime)

Parameters:

###GetDateNameExpression(System.String,System.String) Gets a System.String representation of the specified date part and SQL expression formatted to be executed in SQL.

Parameters:

  • System.String part - The PostgreSQL date portion to conver the expression into.
  • System.String expression - The expression that should be modified by the expression built by this method.

Returns:

The System.String representation of the completed expression.

###GetDatePartExpression(System.String,System.String)

Parameters:

###GetDeleteReportSetCommand(System.String,System.String) Gets a PostgreSQL statement from the specified parameters that creates a System.Data.IDbCommand to delete the specified report definition from the database.

Parameters:

  • System.String tableName - The name of the table used to store reports.
  • System.String reportName - The name of the report that will be deleted from the database.

Returns:

The System.Data.IDbCommand created from the parameters.

###GetDeleteReportSetCommand(System.String,System.String,System.String) Gets a PostgreSQL statement from the specified parameters that creates a System.Data.IDbCommand to delete the specified report definition from the database.

Parameters:

Returns:

The System.Data.IDbCommand created from the parameters.

###GetDomainFunction() Represents a method that is used to get the SQL function that will be used for joining tables with web addresses.

Returns:

The System.String representation of the name of the SQL function if the DBMS supports it, or an exception if not.

###GetGetReportSQL(System.String)

Parameters:

###GetHashCode() Serves as a hash function for a particular type.

Returns:

A hash code for the current System.Object.

###GetInstance()

###GetIsNullSqlForStringColumn(System.String) Represents a method that gets the System.String of an Oracle statement that will check if the input statement is null.

Parameters:

  • System.String columnSql - The column statement to check for nulls.

Returns:

The System.String statement that can be executed.

###GetLikeExpression(System.String,System.String) Represents a method that gets a SQL formatted LIKE statement between the given values.

Parameters:

  • System.String column - The column to have its values compared for matches.
  • System.String value - The value to compare to the column value for matches.

Returns:

The System.String representation of the SQL formatted LIKE statement.

###GetListReportsCommand(System.String,System.DateTime,System.String) Gets a PostgreSQL statement from the specified parameters that creates a System.Data.IDbCommand to get a list of reports from the database.

Parameters:

Returns:

The System.Data.IDbCommand created from the parameters.

###GetLoadReportSetCommand(System.String,System.String) Gets a PostgreSQL statement from the specified parameters that creates a System.Data.IDbCommand to load the specified report definition from the database.

Parameters:

  • System.String tableName - The name of the table used to store reports.
  • System.String reportName - The name of the report that will be loaded from the database.

Returns:

The System.Data.IDbCommand created from the parameters.

###GetLoadReportSetCommand(System.String,System.String,System.String) Gets a PostgreSQL statement from the specified parameters that creates a System.Data.IDbCommand to load the specified report definition with the specified name and tenantId from the database.

Parameters:

  • System.String tableName - The name of the table used to store reports.
  • System.String reportName - The name of the report that will be loaded from the database.
  • System.String tenantID - The tenantId that the report was saved with.

Returns:

The System.Data.IDbCommand created from the parameters.

###GetMinMax(System.Collections.Generic.IDictionary>,out System.DateTime,out System.DateTime) Gets the minimum and maximum System.DateTime values from a collection of date columns across various tables.

Parameters:

###GetNoLockSql() Represents the DBMS's NOLOCK statement, if one exists for the DBMS.

###GetNumericColumnRoundSQL(System.String) Represents a method that gets a SQL formatted function to ROUND a numeric column.

Parameters:

  • System.String nativeColumnSql - The SQL statement or column to ROUND.

Returns:

The System.String representation of the SQL statement or column with the applied ROUND function.

###GetObjectIdAndTypeSql(System.String,System.Boolean) Gets a System.String representation of an Oracle command that gets the id and type of the specified object.

Parameters:

  • System.String objectName - The name of the object to look for.
  • System.Boolean isStandard - A System.Boolean representing whether the object being searched for is an Oracle standard object or a user object. When true, the statement will require administrator privileges.

Returns:

The System.String representation of the database command to get an object ID and its type.

###GetObjectMetaSql(System.String,System.Boolean) Gets the System.String representation of an database command that obtains metadata information about the object with the specified ID.

Parameters:

  • System.String objectID
  • System.Boolean isStandard - A System.Boolean representing whether the object being searched for is a standard database object or a user object. When true, the statement will require administrator privileges.

Returns:

The System.String representation of the command that gets the metadata for the object with the specified ID.

###GetObjectSchemaSql(System.String) Gets the System.String representation of a command that selects the database schema(owner) of the object with the specified name.

Parameters:

Returns:

The System.String representation of the database command to get the schema of the object.

###GetParamFilters(Izenda.AdHoc.Report) Gets a collection of all the filters in a report that are parameters for stored procedures.

Parameters:

Returns:

The Izenda.AdHoc.FilterCollection containing all the filters that are stored procedure parameters.

###GetParams(Izenda.AdHoc.Database.StoredProcedure) Gets the list of parameters for the specified stored procedure on the PostgreSQL database.

Parameters:

Returns:

he Izenda.AdHoc.Database.Column array corresponding to the parameters found.

###GetQuarterNumberExpresion(System.String) Gets a SQL formatted System.String of a function to extract the quarter of the year from the specified SQL expression.

Parameters:

Returns:

The SQL formatted System.String that can be executed to return the quarter of the year.

###GetReportInfo(System.Data.DataRow,System.String,System.Boolean) Creates a new Izenda.AdHoc.ReportInfo object from the parameters provided.

Parameters:

Returns:

The Izenda.AdHoc.ReportInfo object containing information about the report.

###GetReportInfo(System.Data.DataRow) Returns a new Izenda.AdHoc.ReportInfo object from the specified System.Data.DataRow that contains data relevant to constructing the object.

Parameters:

Returns:

A new Izenda.AdHoc.ReportInfo object built from the System.Data.DataRow.

###GetReportStoredProcedures(Izenda.AdHoc.Report) Gets a collection of Izenda.AdHoc.Database.Table objects that represent the stored procedures included on the report.

Parameters:

Returns:

A list of Izenda.AdHoc.Database.Table objects corresponding to the stored procedures found on the report.

###GetReportTemplate(System.String,System.String) Creates a System.Data.IDbCommand that can be executed to get the HTML form for the specified report from the database.

Parameters:

Returns:

A System.Data.IDbCommand that can be used to get the form data.

###GetReportThumbnail(System.String,System.String)

Parameters:

###GetScalar(System.Data.IDbCommand) Gets the first result from executing the specified SQL System.Data.IDbCommand.

Parameters:

Returns:

The first result from the executed scalar command.

###GetScalar(System.String) Gets the first result from executing the specified SQL System.String.

Parameters:

Returns:

The first result from the executed scalar command.

###GetSchemaInfo(System.Boolean) Represents a method to obtain an array of Izenda.AdHoc.Webservices.DataBaseInfo objects from a single database or multiple databases. Multiple databases are only supported when using Fusion.

Parameters:

  • System.Boolean useSingleDatabaseForFusionDriver - Specifies whether to categorize all tables and columns under a category called "Single Database" or to obtain category information from the DataSourceCategories collection.

Returns:

The collection of Izenda.AdHoc.Webservices.DataBaseInfo objects corresponding to all tables, views, stored procedures, constraints, and columns in the database schema with category information.

###GetSqlName(Izenda.AdHoc.Database.Table) Gets the System.String representation of the fully-qualified name of the table formatted for PostgreSQL.

Parameters:

Returns:

The System.String representation of the table name.

###GetSqlName(Izenda.AdHoc.Database.Column) Gets the System.String representation of the fully-qualified name of the column formatted for PostgreSQL.

Parameters:

Returns:

The System.String representation of the column name.

###GetSqlTypeByDbType(System.String) Gets an Izenda.AdHoc.Database.SqlType object from the specified database type string if it exists in the list of registered types.

Parameters:

Returns:

The Izenda.AdHoc.Database.SqlType that was found, or a dummy if one was not found.

###GetStoredProceduresCommand(Izenda.AdHoc.Report,System.Collections.Generic.List,System.Data.IDbCommand,System.String,System.Boolean,out System.Boolean,out System.Boolean) Gets a System.Data.IDbCommand that contains the SQL generated for a report containing stored procedures.

Parameters:

Returns:

A System.Data.IDbCommand that can be executed to obtain the data for the stored procedure report.

###GetStringConst(System.String)

Parameters:

###GetTemporaryColumnByName(System.String)

Parameters:

###GetTemporaryTableByName(System.String)

Parameters:

###GetTextBracket() Gets the database field delimiter character.

Returns:

The character that is used to delimit identifiers on the database.

###GetTimeSum(System.String) Gets a formatted System.String that constructs a SQL statement to get the aggregate sum of the SQL time expression.

Parameters:

  • System.String innerSQL - The SQL statement that produces a SQL date expression to construct a time period from.

Returns:

The sum of time that has elapsed since January 1, 1900 until the specified date.

###GetTopNSql(System.String,System.Int32) Creates a LIMIT statement to be used with the specified SQL expression to select the number of records specified.

Parameters:

  • System.String sql - The SQL statement that will receive the LIMIT statement.
  • System.Int32 n - The number of records to fetch with this LIMIT statement.

Returns:

The System.String SQL statement with the appended LIMIT n records.

###GetToStringExpression(System.String) Gets a System.String representation of the specified SQL expression CAST to a string.

Parameters:

  • System.String expression - The SQL expression that should be cast to a string type.

Returns:

The System.String representation of the SQL statement.

###GetType() Gets the System.Type of the current instance.

Returns:

The System.Type instance that represents the exact runtime type of the current instance.

###GetUpdateReportCommand(System.String,System.String,System.String,System.String)

Parameters:

###GetUpdateReportCommand(System.String,System.String,System.String) Gets a PostgreSQL statement from the specified parameters that creates a System.Data.IDbCommand to update a report on the database. This method uses an empty tenantId.

Parameters:

  • System.String tableName - The name of the table used to store reports.
  • System.String reportName - The name of the report that will be updated on the database.
  • System.String xml - The XML report representation of the report definition.

Returns:

The System.Data.IDbCommand created from the parameters.

###GetUserTables() Represents a method that gets a list of all tables and views on the database available to the user(schema) specified in the connection string.

Returns:

The Izenda.AdHoc.Database.Table array corresponding to the tables and views found.

###GetWeekNumberExpression(System.String)

Parameters:

###GetYearAndWeekExpression(System.String) Gets a SQL formatted System.String representation of a PostgreSQL function to extract the year and week from the specified SQL expression.

Parameters:

Returns:

The SQL formatted System.String that can be executed to extract the year and week portion from the expression.

###InvalidateQueryCache() Represents a method to remove queries from the application's in-memory cache.

###InvalidateSchemaCache() Represents a method to remove the schema from the application's in-memory cache.

###IsJoinAllowable(Izenda.AdHoc.Database.SqlType,Izenda.AdHoc.Database.SqlType) Represents a method that determines whether two tables' Izenda.AdHoc.Database.SqlTypes are compatible to join the tables.

Parameters:

Returns:

True if the types are compatible, false if not.

###IsStandardFunctionsAvailable() Determines whether Oracle standard functions are available to query and obtain metadata for.

Returns:

A System.Boolean representing whether standard functions are available or not.

###isUserFunction(System.String) Determines whether the object with the specified name is a user function or a system function for the specified database object.

Parameters:

  • System.String objectName - The name of the database object to find on the database.

Returns:

A System.Boolean returned from executing the database command.

###ParameterName(System.String) Gets the PostgreSQL formatted System.String for the specified parameter name.

Parameters:

Returns:

The formatted parameter name.

###PrepareData(Izenda.AdHoc.Report) Represents a method that can be used to pre-process the report before the results are obtained from the database and the data is formatted.

Parameters:

###PrepareForArithmeticOperation(System.String)

Parameters:

###PrepareForArithmeticOperation(System.String,Izenda.AdHoc.Database.SqlTypeGroup) Represents a method that safely converts the expression into a database type that can receive arithmetic operations.

Parameters:

Returns:

The SQL formatted expression that allows arithmetic operations to be performed on it.

###RemoveConstraint(System.String,System.String) Represents a method that removes a primary/foreign key relationship between two tables' columns in the schema. Wildcards are not accepted and column names are case sensitive.

Parameters:

  • System.String fullyQualifiedPrimaryColumn - The fully-qualified column name or wildcard to use as the primary(lefthand) table.
  • System.String fullyQualifiedForeignColumn - The fully-qualified column name or wildcard to use as the foreign(righthand) table.

Returns:

True when the constraint was removed. When it could not be found or removed, this is false.

###RemoveConstraint(System.String,System.String,Izenda.AdHoc.Database.DatabaseSchema)

Parameters:

###StringToSqlName(System.String) Gets a System.String representation of the specified value that will be formatted to be acceptible as a PostgreSQL identifier.

Parameters:

  • System.String str - The table, view, or column name to be formatted as a PostgreSQL identifier

Returns:

The value specified with PostgreSQL style identifier notation.

###StringToSqlNameBySafetyDescription(System.String) Gets a System.String representation of the specified value that will be formatted to be acceptible as a PostgreSQL identifier.

Parameters:

  • System.String str - The table, view, or column name to be formatted as a PostgreSQL identifier

Returns:

The value specified with PostgreSQL style identifier notation.

###ToString() Returns a System.String that represents the current System.Object.

Returns:

A System.String that represents the current System.Object.

###UnPrepareData(Izenda.AdHoc.Report) Represents a method that can be used to post-process the report after the results are obtained from the database and the data is formatted.

Parameters:

###UpdateForm(System.String,System.String,System.String,System.String) Updates the PostgreSQL database table where reports are stored with the System.String representation of the HTML form used for the specified report.

Parameters:

  • System.String tableName - The name of the database table that holds saved reports.
  • System.String reportName - The name of the report that the HTML form belongs to.
  • System.String form - The System.String representation of the HTML form that is to be saved with the report.
  • System.String tenantID - The tenantID that the report belongs to.

###UpdateThumbnail(System.String,System.String)

Parameters:

###VerifyThumbnail(System.String,System.String)

Parameters:

Izenda Logo