tests/basics/driver.cxx


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

// file      : tests/basics/driver.cxx
// copyright : Copyright (c) 2009-2015 Code Synthesis Tools CC
// license   : GNU GPL v2; see accompanying LICENSE file

// Basic test to make sure the library is usable. Functionality testing
// is done in the odb-tests package.

#include <cassert>

#include <odb/sqlite/database.hxx>
#include <odb/sqlite/exceptions.hxx>
#include <odb/sqlite/transaction.hxx>

using namespace odb::sqlite;

int
main ()
{
  database db (":memory:");

  {
    transaction t (db.begin ());
    db.execute ("CREATE TABLE test (id INTEGER PRIMARY KEY, str TEXT)");
    t.commit ();
  }

  {
    transaction t (db.begin ());
    db.execute ("INSERT INTO test VALUES (123, 'abc')");
    t.commit ();
  }

  try
  {
    transaction t (db.begin ());
    db.execute ("INSERT INTO test VALUES (123, 'ABC')");
    assert (false);
  }
  catch (const database_exception&) {}

  {
    transaction t (db.begin ());
    db.execute ("DROP TABLE test");
    t.commit ();
  }
}