Sql Alchemy: Θέμα με Sql Mapper

[PC_MAGAS]

Τώρα βλέπω το classical mapping στην sql alchemy και φράκαρα:

 

Έχω αυτό το scriptάκι:

#!/usr/bin/env python
# coding=utf-8
# -*- Mode: python; c-basic-offset: 4 -*-

from sqlalchemy import *
from sqlalchemy.orm import sessionmaker
from sqlalchemy.orm import mapper

db=create_engine('postgresql://pcmagas:[email protected]/hello')
db.echo = False
metadata = MetaData(db)

people=Table('people',metadata,autoload=True)

class People(object):
    def __init__(self, id, name, surname, age):
        self.id=id
        self.name=name
        self.surname=surname
        self.age=age

people_mapper=mapper(People,people)

db_session=sessionmaker()
db_session.configure(bind=db)

lewis_hamilton=People(null,null,null,null)
lewis_hamilton.name='Lewis'
lewis_hamilton.surname='Hamilton'
lewis_hamilton.age=44

db_session.save(lewis_hamilton)
db_session.flush()

Όπως ρώτησα και στο: https://stackoverflow.com/questions/44179045/python-and-sqlalchemy-classical-mapping-using-autoload-mapper-could-not-assembl

 

Και λαμβάνω το εξής σφάλμα:

sqlalchemy.exc.ArgumentError: Mapper Mapper|People|people could not assemble any primary key columns for mapped table 'people'

Και δεν έχω ΙΔΕΑ τις πταίει.

[pmav99]

http://docs.sqlalchemy.org/en/latest/orm/extensions/automap.html#basic-use

[mad-proffessor]

Προφανώς φταίει ότι περνάς και το id arg/field ως null ενω είναι auto_increment?