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

Subject: Re: [boost] sqlpp11: SQL for C++
From: Larry Evans (cppljevans_at_[hidden])
Date: 2013-11-13 13:49:37

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