Re: [boost] sqlpp11: SQL for C++

Subject: Re: [boost] sqlpp11: SQL for C++
From: Larry Evans (cppljevans_at_[hidden])
Date: 2013-11-14 16:14:51

On 11/14/13 03:31, Roland Bock wrote:
> On 2013-11-13 19:49, Larry Evans wrote:
>> On 11/12/13 23:24, Roland Bock wrote:
>>> On 2013-11-12 22:37, Larry Evans wrote:
>>>> On 11/12/13 15:00, Roland Bock wrote:
>>>>> On 2013-11-12 21:04, Larry Evans wrote:
>>>>>> On 11/11/13 14:54, Larry Evans wrote:
>>>>>>> On 11/11/13 14:40, Roland Bock wrote:
>>>>>>>> On 2013-11-11 19:00, Larry Evans wrote:
>>>>>>> [snip]
>>>>>>>>> Is there an actual run against a real database somewhere in the
>>>>>>>>> tests?
>>>>>>>>> The 2 .cpp files I checked (SelectTest.cpp and UpdateTest.cpp)
>>>>>>>>> both
>>>>>>>>> use db of type MockDb, which doesn't seem to be connected to any
>>>>>>>>> real
>>>>>>>>> database.
>>>>>>>>> [snip]
>>>>>>>>>
>>>>>>>>> -Larry
>>>>>>>>
>>>>>>>> Hi Larry,
>>>>>>>>
>>>>>>>> those tests are really just tests, mostly compile time test to
>>>>>>>> ensure
>>>>>>>> that expressions yield the right types. I will have to add quite a
>>>>>>>> few
>>>>>>>> additional ones which check the generated strings.
>>>>>>>>
>>>>>>>> There are two connector libraries (MySQL/MariaDb and Sqlite3)
>>>>>>>> listed
>>>>>>>> here:
>>>>>>>>
>>>>>>>> https://github.com/rbock/sqlpp11#requirements
>>>>>>>>
>>>>>>>> They also contain tests, and those tests actually do something,
>>>>>>>> even
>>>>>>>> though it is not much :-)
>>>>>>>>
>>>>>>> Thanks Roland.  I'll try one of those next.
>>>>>> [snip]
>>>>>> The file:
>>>>>>      sqlpp11-connector-sqlite3/CMakeLists.txt
>>>>>> had:
>>>>>>      include_directories("${PROJECT_SOURCE_DIR}/include")
>>>>>> which lead to compile error because compiler wasn't looking in
>>>>>> the sqlpp11/include.  Adding the following line:
>>>>>>      include_directories("${PROJECT_SOURCE_DIR}/../sqlpp11/include")
>>>>>> seemed to solve the problem.
>>>>>>
>>>>>> Is there some reason why the 2nd include_directories statment
>>>>>> wasn't included in the CMakeLists.txt file?
>>>>>>
>>>>>> -regards,
>>>>>> Larry
>>>>> I assumed you'd be installing sqlpp11 first.
>>>>>
>>>> I installed each of the git clones in separate
>>>> directories:
>>>>
>>>>     /home/evansl/prog_dev/boost/git/sqlpp11:
>>>>     total used in directory 40 available 76979896
>>>>     drwxrwxr-x 8 evansl evansl 4096 Nov 12 04:42 .
>>>>     drwxr-xr-x 8 evansl evansl 4096 Nov 10 19:24 ..
>>>>     drwxrwxr-x 5 evansl evansl 4096 Nov 11 22:17 build
>>>>     -rw-rw-r-- 1 evansl evansl  134 Nov 11 18:21 cxxflags.txt
>>>>     -rw-rw-r-- 1 evansl evansl   61 Nov 11 18:21 cxxflags.txt~
>>>>     drwxrwxr-x 2 evansl evansl 4096 Nov 11 08:49 install
>>>>     drwxrwxr-x 3 evansl evansl 4096 Nov 11 22:19 logs
>>>>     drwxr-xr-x 6 evansl evansl 4096 Nov 10 19:26 sqlpp11
>>>>     drwxr-xr-x 6 evansl evansl 4096 Nov 12 04:42 sqlpp11-connector-mysql
>>>>     drwxr-xr-x 6 evansl evansl 4096 Nov 11 22:17
>>>> sqlpp11-connector-sqlite3
>>>>
>>>> IOW:
>>>>
>>>> ~/prog_dev/boost/git/sqlpp11 $ git clone
>>>> https://github.com/rbock\/sqlpp11.git
>>>>
>>>> ~/prog_dev/boost/git/sqlpp11 $ git clone
>>>> https://github.com/rbock\/sqlpp11-connector-sqlite3.git
>>>>
>>>> Was that not right?
>>>>
>>>> -regards,
>>>> Larry
>>>>
>>> I meant make install :-)
>>>
>>> Regards,
>>>
>>> Roland
>>>
>>> PS: I' might be offline for a day or two
>>>
>> As shown by attached work.log, starting from a fresh clone,
>> I tried cmake followed by make install and got an error.
>>
>> Could outline clearly what steps are needed to run the tests?
>>
>> -regards,
>> Larry
> cmake needs to be told the source directory. Here's what I do for instance
>
> cmake . -DCMAKE_CXX_COMPILER=g++-4.8
>
> (I need to tell it the c++ compiler because cmake uses an older version
> by default on my machine)
>
> HTH
>
> Roland
>
I've tried to get cmake to work; however, it only works for the:
   sqlpp11
directory, but fails for the:
   sqlpp11-connector-sqlite3
directory.

I've attached the Makefile, and the output from `make targets_dir`.
That target 1st clones sqlpp11, runs cmake in that directory,
the make installs in that directory.  Everything works find.
However, with the sqlpp11-connector-sqlite3, the clone
works, the cmake works; however, make gives a compilation
error:

/home/evansl/prog_dev/boost/git/sqlpp11/sqlpp11-connector-sqlite3/src/connection.cpp:29:31: 
fatal error: sqlpp11/exception.h: No such file or directory
  #include <sqlpp11/exception.h>

caused by *not* including:

   -I/home/evansl/prog_dev/boost/git/sqlpp11/sqlpp11/include

on the compiler command line.

Is there something else I'm doing wrong?

-regards,
Larry