Описание плагина sqlserver

connect

Подключиться к базе данных (sqlserver)

connect(string alias, string connection_string)

alias псевдоним подключения

connection_string строка подключения к базе данных

Описание возврата: обьект подключения

Примеры использования

<?php
// init
$xhe_host = '127.0.0.1:7010';
$relative_app_dir = '..\\..\\..\\';
require($relative_app_dir.'Templates/init.php');
include($relative_app_dir.'Templates/_for_tests_.php');
$bUTF8Ver = true;
$PHP_Use_Trought_Shell = true;
$script_folder = $debug->get_cur_script_folder();
$app_dir = realpath($script_folder.$relative_app_dir);
$test = new _for_tests_($script_folder, $sqlserver);

// start
$test->echo_header('connect');

$connection_string = 'Server=localhost;Database=BikeStores;Trusted_Connection=True;';
$sqlserver->connect('local1', $connection_string);
echo 'connection created'."\n";

// end
echo "\n<hr><br>";

// Quit
$app->quit();
?>

// link to app
xhe_host = '127.0.0.1:7014'
_path = require('path')
relative_app_dir = '..\\..\\..\\'
echo = require(_path.join(relative_app_dir, 'Templates JS', 'init.js'))
_for_tests_ = require(_path.join(relative_app_dir, 'Templates JS', '_for_tests_.js'))
script_folder = debug.get_cur_script_folder()
app_dir = _path.resolve(_path.join(script_folder, relative_app_dir))
test = new _for_tests_(script_folder, sqlserver)

// start
test.echo_header('connect')

connection_string = 'Server=localhost;Database=BikeStores;Trusted_Connection=True;'
sqlserver.connect('local1', connection_string)
echo('connection created\n')

// end
echo('\n<hr><br>')

// Quit
app.quit()

# Additional paths
import sys, os
relative_app_dir = '..\\..\\..\\'
sys.path.append(os.path.join(relative_app_dir, 'Templates PY'))
# connect the object to control the app, if not already connected
xhe_host = '127.0.0.1:7010'
from xweb_human_emulator import *
from _for_tests_ import _for_tests_
script_folder = debug.get_cur_script_folder()
app_dir = os.path.abspath(os.path.join(script_folder, relative_app_dir))


test = _for_tests_(script_folder, sqlserver)

# start
test.echo_header('connect')

connection_string = 'Server=localhost;Database=BikeStores;Trusted_Connection=True;'
sqlserver.connect('local1', connection_string)
print('connection created')

# end
print('\n<hr><br>')

# Quit
app.quit()

disconnect

Отключиться от базы данных (sqlserver)

disconnect(string alias)

alias псевдоним подключения

Примеры использования

<?php
// init
$xhe_host = '127.0.0.1:7010';
$relative_app_dir = '..\\..\\..\\';
require($relative_app_dir.'Templates/init.php');
include($relative_app_dir.'Templates/_for_tests_.php');
$bUTF8Ver = true;
$PHP_Use_Trought_Shell = true;
$script_folder = $debug->get_cur_script_folder();
$app_dir = realpath($script_folder.$relative_app_dir);
$test = new _for_tests_($script_folder, $sqlserver);

// start
$test->echo_header('disconnect');

$sqlserver->disconnect('local1');
echo 'disconnected'."\n";

// end
echo "\n<hr><br>";

// Quit
$app->quit();
?>

// link to app
xhe_host = '127.0.0.1:7014'
_path = require('path')
relative_app_dir = '..\\..\\..\\'
echo = require(_path.join(relative_app_dir, 'Templates JS', 'init.js'))
_for_tests_ = require(_path.join(relative_app_dir, 'Templates JS', '_for_tests_.js'))
script_folder = debug.get_cur_script_folder()
app_dir = _path.resolve(_path.join(script_folder, relative_app_dir))
test = new _for_tests_(script_folder, sqlserver)

// start
test.echo_header('disconnect')

sqlserver.disconnect('local1')
echo('disconnected\n')

// end
echo('\n<hr><br>')

// Quit
app.quit()

# Additional paths
import sys, os
relative_app_dir = '..\\..\\..\\'
sys.path.append(os.path.join(relative_app_dir, 'Templates PY'))
# connect the object to control the app, if not already connected
xhe_host = '127.0.0.1:7010'
from xweb_human_emulator import *
from _for_tests_ import _for_tests_
script_folder = debug.get_cur_script_folder()
app_dir = os.path.abspath(os.path.join(script_folder, relative_app_dir))


test = _for_tests_(script_folder, sqlserver)

# start
test.echo_header('disconnect')

sqlserver.disconnect('local1')
print('disconnected')

# end
print('\n<hr><br>')

# Quit
app.quit()

execute_query

выполнить запрос query (sqlserver)

execute_query(string alias, string query)

alias псевдоним подключения

query запрос к базе данных

Описание возврата: результат запроса (json)

Примеры использования

<?php
// init
$xhe_host = '127.0.0.1:7010';
$relative_app_dir = '..\\..\\..\\';
require($relative_app_dir.'Templates/init.php');
include($relative_app_dir.'Templates/_for_tests_.php');
$bUTF8Ver = true;
$PHP_Use_Trought_Shell = true;
$script_folder = $debug->get_cur_script_folder();
$app_dir = realpath($script_folder.$relative_app_dir);
$test = new _for_tests_($script_folder, $sqlserver);

// start
$test->echo_header('execute_query');

$alias = 'local1';
$query = 'select phone from sales.staffs';
$res = $sqlserver->execute_query($alias, $query);
echo 'res: '.$res."\n";

// end
echo "\n<hr><br>";

// Quit
$app->quit();
?>

// link to app
xhe_host = '127.0.0.1:7014'
_path = require('path')
relative_app_dir = '..\\..\\..\\'
echo = require(_path.join(relative_app_dir, 'Templates JS', 'init.js'))
_for_tests_ = require(_path.join(relative_app_dir, 'Templates JS', '_for_tests_.js'))
script_folder = debug.get_cur_script_folder()
app_dir = _path.resolve(_path.join(script_folder, relative_app_dir))
test = new _for_tests_(script_folder, sqlserver)

// start
test.echo_header('execute_query')

alias = 'local1'
query = 'select phone from sales.staffs'
res = sqlserver.execute_query(alias, query)
echo(`res: ${res}\n`)

// end
echo('\n<hr><br>')

// Quit
app.quit()

# Additional paths
import sys, os
relative_app_dir = '..\\..\\..\\'
sys.path.append(os.path.join(relative_app_dir, 'Templates PY'))
# connect the object to control the app, if not already connected
xhe_host = '127.0.0.1:7010'
from xweb_human_emulator import *
from _for_tests_ import _for_tests_
script_folder = debug.get_cur_script_folder()
app_dir = os.path.abspath(os.path.join(script_folder, relative_app_dir))


test = _for_tests_(script_folder, sqlserver)

# start
test.echo_header('execute_query')

alias = 'local1'
query = 'select phone from sales.staffs'
res = sqlserver.execute_query(alias, query)
print(f'res: {res}')

# end
print('\n<hr><br>')

# Quit
app.quit()

execute_non_query

выполнить запрос non query (sqlserver)

execute_non_query(string alias, string query)

alias псевдоним подключения

query запрос к базе данных

Описание возврата: результат запроса

Примеры использования

<?php
// init
$xhe_host = '127.0.0.1:7010';
$relative_app_dir = '..\\..\\..\\';
require($relative_app_dir.'Templates/init.php');
include($relative_app_dir.'Templates/_for_tests_.php');
$bUTF8Ver = true;
$PHP_Use_Trought_Shell = true;
$script_folder = $debug->get_cur_script_folder();
$app_dir = realpath($script_folder.$relative_app_dir);
$test = new _for_tests_($script_folder, $sqlserver);

// start
$test->echo_header('execute_non_query');

$alias = 'local1';
$query = 'update sales.staffs set last_name=\'unkown\' where staff_id=1';
$res = $sqlserver->execute_non_query($alias, $query);
echo 'res: '.$res."\n";

// end
echo "\n<hr><br>";

// Quit
$app->quit();
?>

// link to app
xhe_host = '127.0.0.1:7014'
_path = require('path')
relative_app_dir = '..\\..\\..\\'
echo = require(_path.join(relative_app_dir, 'Templates JS', 'init.js'))
_for_tests_ = require(_path.join(relative_app_dir, 'Templates JS', '_for_tests_.js'))
script_folder = debug.get_cur_script_folder()
app_dir = _path.resolve(_path.join(script_folder, relative_app_dir))
test = new _for_tests_(script_folder, sqlserver)

// start
test.echo_header('execute_non_query')

alias = 'local1'
query = 'update sales.staffs set last_name=\'unkown\' where staff_id=1'
res = sqlserver.execute_non_query(alias, query)
echo(`res: ${res}\n`)

// end
echo('\n<hr><br>')

// Quit
app.quit()

# Additional paths
import sys, os
relative_app_dir = '..\\..\\..\\'
sys.path.append(os.path.join(relative_app_dir, 'Templates PY'))
# connect the object to control the app, if not already connected
xhe_host = '127.0.0.1:7010'
from xweb_human_emulator import *
from _for_tests_ import _for_tests_
script_folder = debug.get_cur_script_folder()
app_dir = os.path.abspath(os.path.join(script_folder, relative_app_dir))


test = _for_tests_(script_folder, sqlserver)

# start
test.echo_header('execute_non_query')

alias = 'local1'
query = 'update sales.staffs set last_name=\'unkown\' where staff_id=1'
res = sqlserver.execute_non_query(alias, query)
print(f'res: {res}')

# end
print('\n<hr><br>')

# Quit
app.quit()

execute_scalar

выполнить запрос scalar (sqlserver)

execute_scalar(string alias, string query)

alias псевдоним подключения

query запрос к базе данных

Описание возврата: результат scalar

Примеры использования

<?php
// init
$xhe_host = '127.0.0.1:7010';
$relative_app_dir = '..\\..\\..\\';
require($relative_app_dir.'Templates/init.php');
include($relative_app_dir.'Templates/_for_tests_.php');
$bUTF8Ver = true;
$PHP_Use_Trought_Shell = true;
$script_folder = $debug->get_cur_script_folder();
$app_dir = realpath($script_folder.$relative_app_dir);
$test = new _for_tests_($script_folder, $sqlserver);

// start
$test->echo_header('execute_scalar');

$alias = 'local1';
$query = 'select count(staff_id) from sales.staffs';
$res = $sqlserver->execute_scalar($alias, $query);
echo 'res: '.$res."\n";

// end
echo "\n<hr><br>";

// Quit
$app->quit();
?>

// link to app
xhe_host = '127.0.0.1:7014'
_path = require('path')
relative_app_dir = '..\\..\\..\\'
echo = require(_path.join(relative_app_dir, 'Templates JS', 'init.js'))
_for_tests_ = require(_path.join(relative_app_dir, 'Templates JS', '_for_tests_.js'))
script_folder = debug.get_cur_script_folder()
app_dir = _path.resolve(_path.join(script_folder, relative_app_dir))
test = new _for_tests_(script_folder, sqlserver)

// start
test.echo_header('execute_scalar')

alias = 'local1'
query = 'select count(staff_id) from sales.staffs'
res = sqlserver.execute_scalar(alias, query)
echo(`res: ${res}\n`)

// end
echo('\n<hr><br>')

// Quit
app.quit()

# Additional paths
import sys, os
relative_app_dir = '..\\..\\..\\'
sys.path.append(os.path.join(relative_app_dir, 'Templates PY'))
# connect the object to control the app, if not already connected
xhe_host = '127.0.0.1:7010'
from xweb_human_emulator import *
from _for_tests_ import _for_tests_
script_folder = debug.get_cur_script_folder()
app_dir = os.path.abspath(os.path.join(script_folder, relative_app_dir))


test = _for_tests_(script_folder, sqlserver)

# start
test.echo_header('execute_scalar')

alias = 'local1'
query = 'select count(staff_id) from sales.staffs'
res = sqlserver.execute_scalar(alias, query)
print(f'res: {res}')

# end
print('\n<hr><br>')

# Quit
app.quit()

sqlserver plugin

connect

disconnect

execute_query

execute_non_query

execute_scalar