create_table_ddl_t.cc File Reference

#include "cetlib/sqlite/Exception.h"
#include "cetlib/sqlite/column.h"
#include "cetlib/sqlite/create_table.h"
#include "cetlib/sqlite/detail/normalize_statement.h"
#include <iostream>
#include <string>

Go to the source code of this file.

Functions
int	main ()

Function Documentation

int main

(

void

)

Definition at line 30 of file create_table_ddl_t.cc.

           {
  // Test simple create_table() so we can use it later
  {
    auto const& test = detail::create_table("employees");
    std::string const ref{"CREATE TABLE employees"};
    compare_statements(test, ref);
  }

  // One column
  {
    auto const& test =
      detail::create_table_ddl("employees", column<string>{"name"});
    std::string const ref{detail::create_table("employees") + "(name text)"};
    compare_statements(test, ref);
  }

  // Two columns
  {
    auto const& test = detail::create_table_ddl(
      "employees", column<string>{"name"}, column<int>{"id"});
    std::string const ref{detail::create_table("employees") +
                          "(name text, id integer)"};
    compare_statements(test, ref);
  }

  // Two columns, the first with the PRIMARY KEY constraint
  {
    auto const& test = detail::create_table_ddl(
      "employees", column<int, primary_key>{"id"}, column<string>{"name"});
    std::string const ref{detail::create_table("employees") +
                          "(id integer PRIMARY KEY, name text)"};
    compare_statements(test, ref);
  }
}
catch (std::exception const& e) {
  std::cerr << e.what() << '\n';
  return 1;
}
catch (...) {
  std::cerr << "Caught unknown exception.\n";
  return 2;
}