How to create or open a database with a value stored in a variable

Question

I'm using sqlite to store some values in a database , but the values are from different source so i have to put them in different database so i tried something like:

 source_name = "hello"
 ext = ".db"
 path = "d:/"
 fullpath = path + source_name + ext
 db = sqlite3.connect("%s") % (fullpath)

but it didn't work, any solutions or ideas.

The error reported was :

%s within quotes :

 TypeError: unsupported operand type(s) for %: 'sqlite3.Connection' and 'str'

%s without quotes :

 SyntaxError: invalid syntax

Ignacio Vazquez-Abrams · Accepted Answer · 2015-06-11 22:14:35Z

3

str.__mod__() is a method on str:

db = sqlite3.connect("%s" % fullpath)

Or because fullpath is already a string:

db = sqlite3.connect(fullpath)

answered Jun 11, 2015 at 22:14

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create or open a database with a value stored in a variable

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related