Testing sqlite database howto ?

[Stewart Lees]

Hello,

This is my first attempt at using robotframework, I have followed the demos and have selenium2Library working.

However i would like to test a sqlite database, the file is called cm.db 

----------------------------------

*** Settings ***

Documentation     frist db test attempt

...

...

Library           DatabaseLibrary

*** Variables ***

${DBAPI}          sqlite3

${DBNAME}         cm.db

*** Test Cases ***

Test1

    Con DB

    Check If Not Exists In Database    "HTTP Access prt"

*** Keywords ***

Check If Not Exists In Database

    [Arguments] ${value}

    select value from CMConfiguration where description = ${value}

Con DB

    Connect To Database     ${DBNAME}    ${DBAPI}

---------------------------------------

Starting test: Db Tests.Resource.Test1

20131030 15:31:30.658 :  FAIL : NoSectionError: No section: 'default'

Ending test:   Db Tests.Resource.Test1

Any help appreciated.

[Kevin O.]

I think you have transposed the arguments to Connect To Database. dbapiModuleName is first.

Change to:

Connect To Database     ${DBAPI}    ${DBNAME}

[Stewart Lees]

Thanks for the reply I had tried that and a few permutations.

the final fix was to use the "Connect To Database Using Custom Params" method

like so:

           Connect To Database Using Custom Params    sqlite3    database='cm.db'