This is the API docs for LemonStand V1, which has been discontinued. LemonStand is now a cloud based platform, available at lemonstand.com.

LemonStand API

core:onBeforeDatabaseQuery event

Triggered by /phproad/modules/db/classes/db_sqlbase.php
Author LemonStand eCommerce Inc.

Event handler signature

public void event_onBeforeDatabaseQuery(string $query)
$query string specifies the SQL query string.
Triggered before a SQL query is sent to the database. This event is triggered only if the ENABLE_DEVELOPER_TOOLS configuration option is enabled. Event handler example: 
public function subscribeEvents()
{
  Backend::$events->addEvent('core:onBeforeDatabaseQuery', $this, 'on_before_query');
  Backend::$events->addEvent('core:onAfterDatabaseQuery', $this, 'on_after_query');
}

public function on_before_query($sql)
{
  // Start timing for the query
  Phpr_DebugHelper::start_timing($sql);
}

public function on_after_query($sql, $result)
{
  // Stop timing and write the result to the trace log (logs/info.txt)
  Phpr_DebugHelper::end_timing($sql);
}

See Also