OracleDataSource

Introduction #

Although using PDODataSource can connect to SQL Server. However if for some reasons, you do not have the PDO Driver, you may use the old traditional connection to Oracle using OracleDataSource.

Settings #

Nametypedefaultdescription
classstringMust set to '\koolreport\datasources\OracleDataSource'
connectionStringstringConnection string, like 'localhost:1521/XE'
usernamestringYour login username
passwordstringYour password

Methods #

Namereturndescription
query(string $str_query)OracleDataSourceThis method is used in report's setup() function. It will help to setup query string which will be executed when report is run.
params(array $params)OracleDataSourceThis method is used to set list of parameters for query statement

Example #

<?php
class MyReport extends \koolreport\KoolReport
{
    public function settings()
    {
        return array(
            "dataSources"=>array(
                "oracle_mydb"=>array(
                    'connectionString' => 'localhost:1521/XE',
                    'username' => 'sa',
                    'password' => 'root',
                    'class' => "\koolreport\datasources\OracleDataSource",
                ),
            )
        );
    }
    public function setup()
    {
        $this->src('oracle_mydb')
        ->query("SELECT * FROM tblPurchase where status=:status")
        ->params(array(":status"=>"completed"))
        ->pipe(..)
        ->pipe(..)
        ->pipe($this->dataStore('purchase_summary'));
    }
}