Exemplo n.º 1
0
 function setUp()
 {
     DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false);
     $sql = DB::newDirectSql("CREATE TABLE simple3_table(\n          id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id),\n          nome VARCHAR(255),\n          livello INT,\n          properties TEXT);");
     $sql->exec();
     ActiveRecord::init("Simple3");
 }
Exemplo n.º 2
0
 public function setUp()
 {
     DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false);
     $this->__dropTable();
     $this->__createTable();
     $this->__loadData(1, "Marco", 2);
     $this->__loadData(2, "Federico", 5);
 }
Exemplo n.º 3
0
 private function initializeDatabase()
 {
     $db_name = Config::instance()->{IDBConfigKeys::DEFAULT_DB_NAME};
     $db_hostname = Config::instance()->{IDBConfigKeys::DEFAULT_DB_HOSTNAME};
     $db_username = Config::instance()->{IDBConfigKeys::DEFAULT_DB_USERNAME};
     $db_password = Config::instance()->{IDBConfigKeys::DEFAULT_DB_PASSWORD};
     $db_persistent_connection = Config::instance()->{IDBConfigKeys::DEFAULT_DB_PERSISTENT_CONNECTION};
     DB::openConnection($db_name, $db_hostname, $db_username, $db_password, $db_persistent_connection);
 }
Exemplo n.º 4
0
 function setUp()
 {
     DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false);
     $sql1 = DB::newDirectSql("CREATE TABLE test_tab_dipinti(\n          id_dipinto INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_dipinto),\n          nome VARCHAR(255),\n          id_autore INT NOT NULL,\n          periodo INT NOT NULL,\n          properties TEXT NOT NULL);");
     $sql1->exec();
     $sql2 = DB::newDirectSql("CREATE TABLE test_tab_colori_dipinto(\n                  id_colore_dipinto INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_colore_dipinto),\n                  id_dipinto INT NOT NULL,\n                  id_colore INT NOT NULL);");
     $sql2->exec();
     $sql3 = DB::newDirectSql("CREATE TABLE test_tab_colori(\n          id_colore INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_colore),\n          nome INT NOT NULL,\n          rgb VARCHAR(6) NOT NULL);");
     $sql3->exec();
     $sql4 = DB::newDirectSql("CREATE TABLE test_tab_autori(\n          id_autore INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_autore),\n          nome VARCHAR(64) NOT NULL,\n          cognome VARCHAR(64) NOT NULL,\n          stile VARCHAR(32));");
     $sql4->exec();
     ActiveRecord::init("TestDipinto");
     ActiveRecord::init("TestAutore");
     ActiveRecord::init("TestColore");
     ActiveRecord::init("TestColoreDipinto");
 }
Exemplo n.º 5
0
 function setUp()
 {
     DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false);
 }
Exemplo n.º 6
0
 public function setUp()
 {
     DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false);
     ActiveRecord::init("SimpleBis");
 }
Exemplo n.º 7
0
 function setUp()
 {
     DB::openConnection(Config::instance()->TEST_DB_NAME, "localhost", Config::instance()->TEST_DB_USERNAME, Config::instance()->TEST_DB_PASSWORD, false);
     DB::newDirectSql($this->setup_sql)->exec();
 }
Exemplo n.º 8
0
<?php

define('HOST_NAME', $_SERVER['HTTP_HOST']);
header('Content-Type: application/json');
require 'vendor/autoload.php';
require_once 'lib/Db.class.php';
$app = new Slim\App();
$app->get('/', function () {
    var_dump($_SERVER);
    DB::openConnection();
});
$app->group('/app', function () use($app) {
    $app->get('/hello/{name}', function ($request, $response, $args) {
        $response->write("Hello, " . $args['name']);
        return $response;
    });
    $app->group('/user', function () use($app) {
        $app->post('/login/', function () {
            var_dump('OK');
        });
    });
});
$app->run();