Skip to content

SYSTEM SQL SYS_CRON_LAST_VISIT

Ulf Gebhardt edited this page Jul 25, 2017 · 3 revisions

SYSTEM\SQL\SYS_CRON_LAST_VISIT

QQ to find the cronjob which had ben run the most reacent

  • Class name: SYS_CRON_LAST_VISIT
  • Namespace: SYSTEM\SQL
  • Parent class: SYSTEM\DB\QQ

Methods

get_class

string SYSTEM\SQL\SYS_CRON_LAST_VISIT::get_class()

Get Classname of the QQ

  • Visibility: public
  • This method is static.

pgsql

string SYSTEM\SQL\SYS_CRON_LAST_VISIT::pgsql()

Get QQs PostgreSQL Query String

  • Visibility: public
  • This method is static.

mysql

string SYSTEM\SQL\SYS_CRON_LAST_VISIT::mysql()

Get QQs MYSQL Query String

  • Visibility: public
  • This method is static.

QQ

\SYSTEM\DB\Result SYSTEM\DB\QQ::QQ(\SYSTEM\DB\DBINFO $dbinfo)

Executes stored action and return Database Object

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

Arguments

  • $dbinfo SYSTEM\DB\DBINFO - <p>Database Info or Null for Default DB</p>

QA

array SYSTEM\DB\QQ::QA(\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\QQ

Arguments

  • $dbinfo SYSTEM\DB\DBINFO - <p>Database Info or Null for Default DB</p>

Q1

array SYSTEM\DB\QQ::Q1(\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\QQ

Arguments

  • $dbinfo SYSTEM\DB\DBINFO - <p>Database Info or Null for Default DB</p>

QI

boolean SYSTEM\DB\QQ::QI(\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\QQ

Arguments

  • $dbinfo SYSTEM\DB\DBINFO - <p>Database Info or Null for Default DB</p>
Clone this wiki locally