I'm devolping a mall tool in python which uses several sqlitedatabases for storing the data. At the moment the tool ist importing regular during the night data into the database, so that I can use the data during the day. The Problem is, that my data is always round about 12 hours behind live which now is getting sometime a problem. Thats why I want to migrate my data to sqlite db server. First of all I installed the vserver on my kali linux desktop pc and stored the databases on a Synology NAS and mounted the folder. That works perfect.

Now my questions. Is it possible to access the database direct from my python source code. I installed the Python ADK from Valentina and tried to explore the given examples, but on my both systems I get different errormessages (like you can see in the attached screenshots). I tried a first test with the followig lines wich are based on the examples of VPython.

#!/usr/bin/python3



# Location of the extension (if need)

import sys

sys.path.append('/opt/VPython/')



# Import extension

import valentina

         



# Init valentina engine (don't need for client/server)

# valentina.init('VPTN-M-*', 'VPTN-W-*', 'VPTN-L-*')





print("test")



# Remote server without database

try:

    #conn = valentina.connect('sa:sa@192.168.178.84/block_000000_200000')

    conn = valentina.connect('sa:sa@127.0.0.1/block_000000_200000')



    print("test2")

    # Execute query

    cursor = conn.cursor()

    cursor.execute('SELECT count(*) FROM "block"')

      

    # check some cursor properties:

    print( "selected records count is:", cursor.rowcount )



    for row in cursor:

        print("Anzahl: " + str(row[0]))



    cursor.close()

    conn.close()

except Exception as e:

    print("Error-Msg. System: "+str(e))

Can somebody help me with this Problem? What I'm doing wrong?

Thanks a lot

Fabian