#! /usr/bin/php
<?php
require_once '../pgproc/php/pgprocedures.php';
require_once '../config.inc.php';
$base = new PgProcedures2($pg_host, $pg_user, $pg_pass, $pg_database);
$base->startTransaction();
$variationUser = $base->login->user_login('variation', 'variation', '{users,organization,structure}');
$token = $variationUser['usr_token'];
// Create topics
$tHygiene = $base->organ->topic_add($token, 'Hygiène', 'Hygiène corporelle');
$tBudget = $base->organ->topic_add($token, 'Budget', 'Argent de poche et gestion du budget');
$tPlacement = $base->organ->topic_add($token, 'Placement', 'Mesures placement (ASE, PJJ, TE)');
$tEtatCivil = $base->organ->topic_add($token, 'Droit de séjour', 'État civil et droits de séjour');
$tEducation = $base->organ->topic_add($token, 'Éducation', 'Accompagnement éducatif');
$tStage = $base->organ->topic_add($token, 'Emploi', 'Stages et apprentissage');
$tEntretien = $base->organ->topic_add($token, 'Entretien', 'Entretien et participation aux services');
$tVeture = $base->organ->topic_add($token, 'Vêture', 'Vêture et autres fournitures');
$tFamille = $base->organ->topic_add($token, 'Famille', 'Famille, tuteur et parrainage');
$tLogement = $base->organ->topic_add($token, 'Logement', 'Logement collectif ou individuel');
$tScolarite = $base->organ->topic_add($token, 'Scolarité', 'Scolarité');
$tPriseEnCharge = $base->organ->topic_add($token, 'Prises en charge', 'Prises en charge, admission et autorisations');
$tProjet = $base->organ->topic_add($token, 'Projet individuel', 'Projet individuel');
$tPsy = $base->organ->topic_add($token, 'Psychologie', 'Accompagnement psychologique');
$tRestauration = $base->organ->topic_add($token, 'Restauration', 'Restauration et alimentation');
$tSante = $base->organ->topic_add($token, 'Santé', 'Suivi médical');
$tSocial = $base->organ->topic_add($token, 'Loisirs', 'Vie sociale, loisirs et séjours');
$tTransport = $base->organ->topic_add($token, 'Transport', 'Transport');
// Create user marie, Secrétaire
$loginMarie = 'marie';
$uMarie = create_user($base, $token, $loginMarie, 'marie', 'Marie', 'SECRET');
// Create user jeanne, Psychologue
<?php
require '../pgproc/php/pgprocedures.php';
require '../config.inc.php';
$base = new PgProcedures2($pg_host, $pg_user, $pg_pass, $pg_database);
$cmd = $_GET['o'];
$body = json_decode(file_get_contents('php://input'));
if (strpos($cmd, '/')) {
list($schema, $function) = explode('/', $cmd, 2);
} else {
$schema = 'public';
$function = $cmd;
}
$debug = true;
$ret = $base->get_arguments($schema, $function);
$all = false;
if (count($ret)) {
foreach ($ret as $r) {
$all = true;
foreach ($r['argnames'] as $argname) {
if (!property_exists($body, $argname)) {
if ($debug) {
echo "{$argname} not found\n";
print_r($body);
}
$all = false;
break;
}
}
if ($all) {
break;
public function testDistinct()
{
$in = array(1, 3, 2, 3, 4);
$out = self::$base->pgtests->test_integer_array_arg($in, PgProcedures2::distinct(), PgProcedures2::order('test_integer_array_arg'));
$this->assertSame(array(1, 2, 3, 4), $out);
}
#! /usr/bin/php
<?php
require_once '../pgproc/php/pgprocedures.php';
require_once '../config.inc.php';
$base = new PgProcedures2($pg_host, $pg_user, $pg_pass, $pg_database);
$base->startTransaction();
$variationUser = $base->login->user_login('variation', 'variation', '{users,organization,structure}');
$token = $variationUser['usr_token'];
// Create topics
$tSocial = $base->organ->topic_add($token, 'Social', 'Social');
$tJustice = $base->organ->topic_add($token, 'Justice', 'Justice');
$tSport = $base->organ->topic_add($token, 'Sport', 'Sport');
$tCulture = $base->organ->topic_add($token, 'Culture', 'Culture');
$tFinancer = $base->organ->topic_add($token, 'Financer', 'Financer');
$tSupport = $base->organ->topic_add($token, 'Support', 'Support');
// Create user foo1
$userLogin1 = 'foo1';
$base->login->user_add($token, $userLogin1, null, null);
$fooInfo1 = $base->login->user_info($token, $userLogin1);
$stfId1 = $base->organ->participant_add($token, 'Pierre', 'MARTIN');
$base->login->user_participant_set($token, $userLogin1, $stfId1);
$foo1 = $base->login->user_login($userLogin1, $fooInfo1['usr_temp_pwd'], null);
$base->login->user_change_password($foo1['usr_token'], 'bar');
// Create user foo2
$userLogin2 = 'foo2';
$base->login->user_add($token, $userLogin2, null, null);
$fooInfo2 = $base->login->user_info($token, $userLogin2);
$stfId2 = $base->organ->participant_add($token, 'Paul', 'DURAND');
$base->login->user_participant_set($token, $userLogin2, $stfId2);
$foo2 = $base->login->user_login($userLogin2, $fooInfo2['usr_temp_pwd'], null);
$base->login->user_change_password($foo2['usr_token'], 'bar');
<?php
require_once 'pgproc/php/pgprocedures.php';
require_once 'config.inc.php';
$base = new PgProcedures2($pg_host, $pg_user, $pg_pass, $pg_database);
$ret = $base->execute_sql('NOTIFY toto');
print_r($ret);
<?php
require_once 'pgproc/php/pgprocedures.php';
require_once 'config.inc.php';
$base = new PgProcedures2($pg_host, $pg_user, $pg_pass, $pg_database);
$base->execute_sql('LISTEN toto');
for ($i = 0; $i < 60; $i++) {
$res = pg_get_notify($base->handler);
if (isset($res['message'])) {
print_r($res);
}
sleep(1);
}