Run sqlite query using connect_db() method 'NoneType' object has no attribute 'cursor'

Question

I'm having issues using the method I made to connect to my sqlite db. I get an error of 'NoneType' object has no attribute 'cursor', when i call connect_db() below:

When i try to use connect_db()

def connect_db(dbname):
    try:
        dbconn = sqlite3.connect(dbname)
    except:
        print ("error connecting to db")

It throws the error here:

        #save to database
        dbconn = connect_db('./syncdb.db')
        cursor = dbconn.cursor()
        cursor.execute('''
            CREATE TABLE paths (
                id INTEGER PRIMARY KEY, 
                source TEXT, 
                destination TEXT
            ) 
        ''')

Anyone know what I'm doing wrong? I've tried a lot of different ways already to use this method connect_db(), but it doesnt seem to be able to work correctly.

Thank you.

What is the issue? Try not catching all exceptions, see which exception is raised. Your indentation is a bit messy too, maybe it's just a paste error though. — André Laszlo
– André Laszlo, Commented Jul 4, 2015 at 17:05
The issue is, i cant access the connection/creation/ of syncdb.db created in connect_db() when i try to get it lower down in my script. How do i access it? — CodeTalk
– CodeTalk, Commented Jul 4, 2015 at 17:07

hiro protagonist · Accepted Answer · 2015-07-04 17:32:45Z

2

you need to return the connection; otherwise the function returns None

def connect_db(dbname):
    try:
        dbconn = sqlite3.connect(dbname)
    except:
        print ("error connecting to db")
    return dbconn

answered Jul 4, 2015 at 17:32

hiro protagonist

47.3k17 gold badges93 silver badges119 bronze badges

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

Collectives™ on Stack Overflow

Run sqlite query using connect_db() method 'NoneType' object has no attribute 'cursor'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related