Skip to content

SYSTEM SQL SYS_SAIMOD_LOG_CLASS_SYSTEM

Jump to bottom
Ulf Gebhardt edited this page Jul 25, 2017 · 4 revisions

SYSTEM\SQL\SYS_SAIMOD_LOG_CLASS_SYSTEM

QQ to get analytics data from system_log - class system

  • Class name: SYS_SAIMOD_LOG_CLASS_SYSTEM
  • Namespace: SYSTEM\SQL
  • Parent class: SYSTEM\DB\QP

Methods

get_class

string SYSTEM\SQL\SYS_SAIMOD_LOG_CLASS_SYSTEM::get_class()

Get Classname of the QQ

  • Visibility: public
  • This method is static.

pgsql

string SYSTEM\SQL\SYS_SAIMOD_LOG_CLASS_SYSTEM::pgsql()

Get QQs PostgreSQL Query String

  • Visibility: public
  • This method is static.

mysql

string SYSTEM\SQL\SYS_SAIMOD_LOG_CLASS_SYSTEM::mysql()

Get QQs MYSQL Query String

  • Visibility: public
  • This method is static.

QQ

\SYSTEM\DB\Result SYSTEM\DB\QP::QQ(array $params, \SYSTEM\DB\DBINFO $dbinfo)

Executes stored action and return Database Object

  • Visibility: public
  • This method is static.
  • This method is defined by SYSTEM\DB\QP

Arguments

  • $params array - <p>Parameter passed to the prepare-query</p>
  • $dbinfo SYSTEM\DB\DBINFO - <p>Database Info or Null for Default DB</p>

QA

array SYSTEM\DB\QP::QA(array $params, \SYSTEM\DB\DBINFO $dbinfo)

Executes stored action and return all Data found

  • Visibility: public
  • This method is static.
  • This method is defined by SYSTEM\DB\QP

Arguments

  • $params array - <p>Parameter passed to the prepare-query</p>
  • $dbinfo SYSTEM\DB\DBINFO - <p>Database Info or Null for Default DB</p>

Q1

array SYSTEM\DB\QP::Q1(array $params, \SYSTEM\DB\DBINFO $dbinfo)

Executes stored action and return one line of Data found

  • Visibility: public
  • This method is static.
  • This method is defined by SYSTEM\DB\QP

Arguments

  • $params array - <p>Parameter passed to the prepare-query</p>
  • $dbinfo SYSTEM\DB\DBINFO - <p>Database Info or Null for Default DB</p>

QI

boolean SYSTEM\DB\QP::QI(array $params, \SYSTEM\DB\DBINFO $dbinfo)

Executes stored action and return Database Result Object.

Use this function if the Result is either true or false (update/delete/insert)

  • Visibility: public
  • This method is static.
  • This method is defined by SYSTEM\DB\QP

Arguments

  • $params array - <p>Parameter passed to the prepare-query</p>
  • $dbinfo SYSTEM\DB\DBINFO - <p>Database Info or Null for Default DB</p>
Clone this wiki locally