Simple Log Service:Use Simple Log Service SDK for PHP to use the Dedicated SQL feature

Sample code

The following sample code provides an example on how to use the Dedicated SQL feature. For more information, see Alibaba Cloud Simple Log Service SDK for PHP.

// The Simple Log Service endpoint. In this example, the Simple Log Service endpoint for the China (Hangzhou) region is used. Replace the parameter value with the actual endpoint. 
$endpoint = 'cn-hangzhou.log.aliyuncs.com';
// In this example, the AccessKey ID and AccessKey secret are obtained from environment variables. 
$accessKeyId = getenv('ALIBABA_CLOUD_ACCESS_KEY_ID');        
$accessKey = getenv('ALIBABA_CLOUD_ACCESS_KEY_SECRET'); 
// The name of the project. 
$project = 'aliyun-test-project';
// The name of the Logstore. 
$logstore = 'aliyun-test-logstore';
// The Security Token Service (STS) token. 
$token = "your_token";
// Create a Simple Log Service client. 
$client = new Aliyun_Log_Client($endpoint, $accessKeyId, $accessKey,$token);

// Execute an SQL statement in the specified Logstore.   
$from = time()-3600;
$to = time();
$query = "* | select count(method)";
$request = new Aliyun_Log_Models_LogStoreSqlRequest($project,$logstore,$from,$to,$query,true);
 
try {
   $response = $client->executeLogStoreSql($request);
   foreach($response -> getLogs() as $log)
   {   
       print $log -> getTime()."\t";
       foreach($log -> getContents() as $key => $value){
           print $key.":".$value."\t";
       }   
       print "\n";
    } 
   // Display the statistics about the analysis results. 
   // The number of lines of log data that is processed. 
    print "proccesedRows:".$response -> getProcessedRows()."\n";
    // The time that is required to execute the SQL statement. 
    print "elapsedMilli:".$response -> getElapsedMilli()."\n";
    // The CPU time that is consumed to execute the SQL statement after the Dedicated SQL feature is enabled. Unit: seconds. You are charged for the Dedicated SQL feature based on the CPU time. For more information, see the topics that are related to billable items. 
    print "cpuSec:".$response -> getCpuSec()."\n";
    // The number of CPU cores that are used to execute the SQL statement after the Dedicated SQL feature is enabled. 
    print "cpuCores:".$response -> getCpuCores()."\n";

} catch (Aliyun_Log_Exception $ex) {
 logVarDump($ex);
} catch (Exception $ex) {
 logVarDump($ex);
}   

// Execute an SQL statement in the specified project. 
$query = "select count(method) from sls_operation_log where __time__ > to_unixtime(now()) - 300 and __time__ < to_unixtime(now())";
$request = new Aliyun_Log_Models_ProjectSqlRequest($project,$query,True);   
try {
    $response = $client->executeProjectSql($request);
  #$response = $client->getProjectLogs($request);
  foreach($response -> getLogs() as $log)
  {
      print $log -> getTime()."\t";
      foreach($log -> getContents() as $key => $value){
          print $key.":".$value."\t";
      }
      print "\n";
  }
  // Display the statistics about the analysis results. 
  // The number of lines of log data that is processed. 
  print "proccesedRows:".$response -> getProcessedRows()."\n";
  // The time that is required to execute the SQL statement. 
  print "elapsedMilli:".$response -> getElapsedMilli()."\n";
  // The CPU time that is consumed to execute the SQL statement after the Dedicated SQL feature is enabled. Unit: seconds. You are charged for the Dedicated SQL feature based on the CPU time. For more information, see the topics that are related to billable items. 
  print "cpuSec:".$response -> getCpuSec()."\n";
  // The number of CPU cores that are used to execute the SQL statement after the Dedicated SQL feature is enabled. 
  print "cpuCores:".$response -> getCpuCores()."\n";
  print "requestId:".$response ->getRequestId()."\n";

} catch (Aliyun_Log_Exception $ex) {
 logVarDump($ex);
} catch (Exception $ex) {
   logVarDump($ex);
}

• Aliyun_Log_Models_LogStoreSqlRequest operation

  You can call the Aliyun_Log_Models_LogStoreSqlRequest operation to use the Dedicated SQL feature. Requests must be in the following format:

  $from = time()-3600;
  $to = time();
  $query = "* | select count(method)";
  $request = new Aliyun_Log_Models_LogStoreSqlRequest($project,$logstore,$from,$to,$query,$powerSql);

  The following table describes the parameters.

  Parameter	Type	Required	Example	Description
  $project	String	Yes	N/A	The name of the project. When you create a Simple Log Service client, you must specify a value for the $project parameter. Therefore, you do not need to configure the parameter again.
  $logstore	String	Yes	N/A	The name of the Logstore. When you create a Simple Log Service client, you must specify a value for the $logstore parameter. Therefore, you do not need to configure the parameter again.
  $from	Long	Yes	time()-3600	The beginning of the time range to query. The value is a UNIX timestamp representing the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC.
  $to	Long	Yes	time()	The end of the time range to query. The value is a UNIX timestamp representing the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC.
  $query	String	Yes	"* | select count(method)"	The query statement. Format: Search statement|Analytic statement. For more information, see Syntax. By default, Simple Log Service returns 100 rows of data. You can use a LIMIT clause to specify the number of data rows to return. For more information, see LIMIT clause.
  $powerSql	Boolean	No	true	Specifies whether to use the Dedicated SQL feature. For more information, see Enable Dedicated SQL. Valid values: true: uses the Dedicated SQL feature. false (default): uses the Standard SQL feature.

• Aliyun_Log_Models_ProjectSqlRequest operation

  You can call the Aliyun_Log_Models_ProjectSqlRequest operation to use the Dedicated SQL feature. Requests must be in the following format:

  $query = "select count(method) from sls_operation_log where __time__ > to_unixtime(now()) - 300 and __time__ < to_unixtime(now())";
  $request = new Aliyun_Log_Models_ProjectSqlRequest($project,$query,$powerSql);   

  The following table describes the parameters.

  Parameter	Type	Required	Example	Description
  $project	String	Yes	N/A	The name of the project. When you create a Simple Log Service client, you must specify a value for the $project parameter. Therefore, you do not need to configure the parameter again.
  $query	String	Yes	" select count(method) from sls_operation_log where __time__ > to_unixtime(now()) - 300 and __time__ < to_unixtime(now())"	The SQL statement. You must specify the search condition and time range in the WHERE clause of the SQL statement. By default, Simple Log Service returns 100 rows of data. You can use a LIMIT clause to specify the number of data rows to return. For more information, see LIMIT clause.
  $powerSql	Boolean	No	true	Specifies whether to use the Dedicated SQL feature. For more information, see Enable Dedicated SQL. Valid values: true: uses the Dedicated SQL feature. false (default): uses the Standard SQL feature.