AttributeError: 'function' object has no attribute 'connect'

Question

I'm trying to insert data into my already created sqlite3 database. The data is able to be inputted. However, when trying to connect to my database and save I receive an error saying " AttributeError: 'function' object has no attribute 'connect'" My code fragment is listed below:

def data_entry():
    option_choice=0
    call("clear")
    print"\t","\n"*4
    print"\t","-"*45
    print"\t","\t-- Data Entry --"

    ID = raw_input("what is your user ID?")
    Name = raw_input("What is your name?")
    Age = raw_input("how old are you?")
    incidents = raw_input("How many incidents have you been involved in?")
    physical_ability = raw_input("what is your physical driving state?")
    Address = raw_input("what is your address?")
    Tel = raw_input("what is your phone number?")
    datestamp = raw_input("What is today's date?")
    keyword = raw_input("What is the make of your vehicle?")
    monthly_salary = raw_input("How much do you earn each month?")

    conn = db.connect('Insurance_Shark.db') 
    cursor = conn.cursor()
    cursor.execute("INSERT INTO customerdatabase VALUES(?, ?, ?, ?, ?, ?)",
        (ID, Name, Age, incidents, physical_ability, Address, Tel, datestamp, keyword, monthly_salary))

show you import line and what db in db.connect is.

vrs
– vrs

2016-01-10 18:16:49 +00:00
Commented Jan 10, 2016 at 18:16 — vrs
– vrs, Commented Jan 10, 2016 at 18:16

alecxe · Accepted Answer · 2016-01-10 20:05:46Z

1

You haven't shown how the db variable is defined, but it looks like it is a function, because:

>>> def db():
...     pass
... 
>>> db.connect()
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
AttributeError: 'function' object has no attribute 'connect'

The connect() function is available directly from the sqlite3 module:

>>> import sqlite3 
>>> sqlite3.connect("test.db")
<sqlite3.Connection object at 0x10d922a28>

answered Jan 10, 2016 at 20:05

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

Collectives™ on Stack Overflow

AttributeError: 'function' object has no attribute 'connect'

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