query_dicts

query_dicts(string alias, string query, int timeout = 60)

Выполнить SQL запрос к Базе данных, для получения массива словарей

Команда на вход принимает параметры:

alias – псевдоним соединения БД
query – SQL запрос
timeout – таймаут, сек

После отработки команда возвращает результат своей работы в робот:

Текст - массив объектов словарей

Пример использования (php)

<?php
// Scenario: Demonstrates database connection, table creation, data insertion, query execution with dictionary results, and disconnection using SQLite
$xhe_host = "127.0.0.1:7010";
 
if (!isset($path)){
    // Path to the init.php file for connecting to the XHE API
    $path = "../../../Templates/init.php";
    // Including init.php grants access to all classes and functionality for working with the XHE API
    require($path);
}
 
// Example 1: Connect to SQLite database and execute queries with dictionary results
echo "\n<span >db->" . basename (__FILE__) . "</span>\n";
 
// MySQL connection
$connectionStr = "SERVER=localhost;Port=3306;DATABASE=my_db;Uid=root;PASSWORD=password1;";
$dbName = "my_db";
$tablesStore = "INFORMATION_SCHEMA.TABLES";
$dbType = "mysql";
$connectionId = "local";
 
// Example 1.1: Connect to database
echo("1. Connect to database: ");
echo SYSTEM::$bd->connect($connectionId, $connectionStr, $dbType);
 
// Example 1.2: Create table
$tableName = "tutorials_tbl";
$checkTableQuery = "SELECT COUNT(*) FROM $tablesStore WHERE TABLE_SCHEMA='$dbName' AND TABLE_NAME='$tableName' LIMIT 1";
$tableExists = SYSTEM::$bd->query($connectionId, $checkTableQuery);
if ($tableExists){
    $tableExists = json_decode($tableExists);
    if ($tableExists && is_array($tableExists) && count($tableExists) > 0 )
    {
		$tableExists = $tableExists[0];
		if ($tableExists && is_array($tableExists) && count($tableExists) > 0 ){
			$tableExists = $tableExists[0];
		 }
    }
}
 
if (!$tableExists) {
    $createTableQuery = "CREATE TABLE $tableName( " .
        "tutorial_id INT, " .
        "tutorial_title VARCHAR(100), " .
        "tutorial_author VARCHAR(40) )";
    echo("\n2. Create table execute query '$createTableQuery' : ");
    echo SYSTEM::$bd->query($connectionId, $createTableQuery);
} else {
    echo("\n2. Table already exists, skipping creation: ");
    echo "Table '$tableName' exists";
}
 
// Example 1.3: Insert first record
$tutorialTitle = "title1";
$tutorialAuthor = "author1";
$tutorialId = 1;
$insertQuery1 = "INSERT INTO $tableName " .
    "(tutorial_id,tutorial_title,tutorial_author) " . "VALUES " .
    "('$tutorialId', '$tutorialTitle' , '$tutorialAuthor' )";
echo("\n3. Insert first record. Query:  '$insertQuery1': ");
echo(SYSTEM::$bd->query($connectionId, $insertQuery1));
 
// Example 1.4: Insert second record
$tutorialTitle = "title2";
$tutorialAuthor = "author2";
$tutorialId = 2;
$insertQuery2 = "INSERT INTO $tableName " .
    "(tutorial_id,tutorial_title,tutorial_author) " . "VALUES " .
    "($tutorialId, '$tutorialTitle' , '$tutorialAuthor' )";
echo("\n4. Insert second record: ");
echo(SYSTEM::$bd->query($connectionId, $insertQuery2));
 
// Example 1.5: Select and display all records as dictionaries
$selectQuery = "SELECT * FROM $tableName ";
echo("\n5. Select and display all records as dictionaries: ");
$result = SYSTEM::$bd->query_dicts($connectionId, $selectQuery);
var_export($result);
 
// Example 1.6: Disconnect from database
echo("\n6. Disconnect from database: ");
echo SYSTEM::$bd->disconnect($connectionId);
 
// End
echo "\n";
 
// Quit
WINDOW::$app->quit();
?>

О продукте RPAbot

Установка и Активация

Интерфейс

Настройки программы

Плагины

Изменения по версиям

Системные требования

Визуальный конструктор

Создание роботов на языках программирования