#! /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); }