pluf2

pluf2 Git Source Tree


Root/tests/Pluf_DB_Schema/PlufDBSchemaSQLiteTest.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?php
/* -*- tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
# ***** BEGIN LICENSE BLOCK *****
# This file is part of Plume CMS, a website management application.
# Copyright (C) 2001-2007 Loic d'Anterroches and contributors.
#
# Plume CMS is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# Plume CMS is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
#
# ***** END LICENSE BLOCK ***** */
 
error_reporting(E_ALL | E_STRICT);
 
$path = dirname(__FILE__).'/../../src/';
set_include_path(get_include_path().PATH_SEPARATOR.$path);
 
require_once 'PHPUnit/Framework/TestCase.php';
require_once 'PHPUnit/Framework/IncompleteTestError.php';
 
require_once 'Pluf.php';
 
include_once dirname(__FILE__).'/../Pluf_Model/TestModels.php';
 
class PlufDBSchemaSQLiteTest extends PHPUnit_Framework_TestCase
{
 
    public $db = null;
 
    protected function setUp()
    {
        Pluf::start(dirname(__FILE__).'/../conf/pluf.config.php');
        $this->db = Pluf::db();
        if ($this->db->engine != 'SQLite') {
            $this->markTestSkipped('Only to be run with the SQLite DB engine');
        }
    }
 
    protected function tearDown()
    {
        $this->db->close();
        unset($this->db);
    }
 
    public function testGenerateSchema3()
    {
        $model = new TestModel();
        $schema = Pluf::factory('Pluf_DB_Schema', $this->db);
        $schema->model = $model;
        $gen = $schema->getGenerator();
        $sql = $gen->getSqlCreate($model);
        $create = "CREATE TABLE pluf_unit_tests_testmodel (
id integer primary key autoincrement,
title varchar(100) default '',
description text not null default ''
);";
        $this->assertEquals($create, $sql['pluf_unit_tests_testmodel']);
    }
 
    public function testDeleteSchemaTestModel()
    {
        $model = new TestModel();
        $schema = Pluf::factory('Pluf_DB_Schema', $this->db);
        $schema->model = $model;
        $gen = $schema->getGenerator();
        $del = $gen->getSqlDelete($model);
        $this->assertEquals('DROP TABLE IF EXISTS pluf_unit_tests_testmodel', $del[0]);
    }
 
 
    public function testGenerateSchema()
    {
        $model = new TestModel();
        $schema = Pluf::factory('Pluf_DB_Schema', $this->db);
        $schema->model = $model;
        $gen = $schema->getGenerator();
        $this->assertEquals(true, $schema->dropTables());
        $sql = $gen->getSqlCreate($model);
        foreach ($sql as $k => $query) {
            $this->db->execute($query);
        }
        $sql = $gen->getSqlIndexes($model);
        foreach ($sql as $k => $query) {
            $this->db->execute($query);
        }
        $model->title = 'my title';
        $model->description = 'A small desc.';
        $this->assertEquals(true, $model->create());
        $this->assertEquals(1, (int) $model->id);
        $del = $gen->getSqlDelete($model);
        foreach ($del as $sql) {
            $this->db->execute($sql);
        }
    }
 
    public function testGenerateSchema2()
    {
        $model = new TestModel();
        $schema = Pluf::factory('Pluf_DB_Schema', $this->db);
        $schema->model = $model;
        $this->assertEquals(true, $schema->dropTables());
        $this->assertEquals(true, $schema->createTables());
        $model->title = 'my title';
        $model->description = 'A small desc.';
        $this->assertEquals(true, $model->create());
        $this->assertEquals(1, (int) $model->id);
        $this->assertEquals(true, $schema->dropTables());
    }
}

Archive Download this file

Branches

Number of commits:
Page rendered in 0.08692s using 11 queries.