summaryrefslogtreecommitdiffstats
path: root/sca-cpp/trunk/components/sqldb/pgsql-test.cpp
blob: 5d7bb98cd8eccab012066c634e167802ec7678d3 (plain)
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
/*
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */

/* $Rev$ $Date$ */

/**
 * Test PostgreSQL access functions.
 */

#include <assert.h>
#include "stream.hpp"
#include "string.hpp"
#include "perf.hpp"
#include "pgsql.hpp"

namespace tuscany {
namespace pgsql {

const bool testPGSql() {
    PGSql pg("host=localhost port=6432 dbname=db", "test");
    const value k = mklist<value>("a");
    const value lk = mklist<value>(mklist<value>("like", "%"), mklist<value>("limit", "2"));
    const value rx = mklist<value>(mklist<value>("regex", "a"), mklist<value>("limit", "2"));
    const value ts = mklist<value>(mklist<value>("textsearch", "AAA"), mklist<value>("limit", "2"));
    const value rxts = mklist<value>(mklist<value>("regex", "a"), mklist<value>("textsearch", "AAA"), mklist<value>("limit", "2"));

    assert(hasContent(post(k, string("AAA"), pg)));
    assert(content(get(k, pg)) == value(string("AAA")));
    assert(cadr<value>(car<value>(content(get(lk, pg)))) == value(string("AAA")));
    assert(cadr<value>(car<value>(content(get(rx, pg)))) == value(string("AAA")));
    assert(cadr<value>(car<value>(content(get(ts, pg)))) == value(string("AAA")));
    assert(cadr<value>(car<value>(content(get(rxts, pg)))) == value(string("AAA")));

    assert(hasContent(put(k, string("aaa"), pg)));
    assert(content(get(k, pg)) == value(string("aaa")));
    assert(hasContent(del(k, pg)));
    assert(!hasContent(get(k, pg)));

    return true;
}

const bool testGetPerf() {
    const value k = mklist<value>("c");
    PGSql pg("host=localhost port=6432 dbname=db", "test");
    assert(hasContent(post(k, string("CCC"), pg)));

    const blambda gl = [k, pg]() -> const bool {
        assert(content(get(k, pg)) == value(string("CCC")));
        return true;
    };
    cout << "PGSql get test " << time(gl, 5, 200) << " ms" << endl;
    return true;
}

}
}

int main() {
    tuscany::cout << "Testing..." << tuscany::endl;

    tuscany::pgsql::testPGSql();
    tuscany::pgsql::testGetPerf();

    tuscany::cout << "OK" << tuscany::endl;

    return 0;
}