from Feed import Feed
from sqlalchemy import Column
from sqlalchemy import Integer
from sqlalchemy import MetaData
from sqlalchemy import String
from sqlalchemy import Table
from sqlalchemy.orm import mapper

def createMapping(engine):
    metadata = MetaData(engine)
    
    feedTable = Table("feed", metadata,
        Column("pk", Integer, primary_key=True),
        Column("name", String(255), nullable=False),
        Column("url", String(255), nullable=False)
    )

    metadata.create_all()

    mapper(Feed, feedTable)