Exemplo n.º 1
0
 function prepareAndRunMergedDatasetQuery($select, $inputObj, $where, $groupby, $perPage, $pageNo)
 {
     $mergedDatasetQuery = new MergedDataSetQueryMaker($select, $inputObj, $where, $groupby, $perPage, $pageNo);
     $queryInfo = $mergedDatasetQuery->GetQuery();
     $externalDBCredentials = new stdClass();
     $externalDBCredentials->driver = $queryInfo->serverInfo->driver;
     $externalDBCredentials->user_name = $queryInfo->serverInfo->user_name;
     $externalDBCredentials->password = $queryInfo->serverInfo->password;
     $externalDBCredentials->source_database = $queryInfo->serverInfo->database;
     $externalDBCredentials->server_address = $queryInfo->serverInfo->server_address;
     $externalDBCredentials->port = $queryInfo->serverInfo->port;
     $externalDBCredentials->is_local = null;
     $externalDBCredentials->linked_server_name = null;
     return ExternalDBs::ExecuteQuery($queryInfo->finalQuery, $externalDBCredentials);
 }