Scrapy + sqlalchemy + mysql error

Question

and i am building a web crawler for personal use.

Here is the Spider file

scrapySpider

Here is the model file

model

Here is the pipe line

pipeline

My database settings are

DATABASE = {'drivername': 'mysql+mysqldb',
        'host': 'localhost',
        'port': '3306',
        'username': 'user', # fill in your username here
        'password': 'pass', # fill in your password here
        'database': 'scrapydb'}

But i am getting this error

  .............., line 19, in process_item
  vehicle = vehicles(**item)
  exceptions.TypeError: vehicles() got an unexpected keyword argument 'odometer'

I've tried many things but was unsuccessful. Please help!

alecxe · Accepted Answer · 2015-01-18 02:40:27Z

1

vehicles should be a class, not a function:

class vehicles(DeclarativeBase):
    ...

answered Jan 18, 2015 at 2:40

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

Scrapy + sqlalchemy + mysql error

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