
from sqlalchemy import Column, Integer, Unicode, ForeignKey
import base


class ShoppingItem(base.Base):
    """Sqlalchemy deals model"""
    __tablename__ = "shopping_item"

    catId = 'shopping_category.id'
    visitId = 'visits.id'

    id = Column(Integer, primary_key=True)
    name = Column('name', Unicode)
    category_id = Column('category', Integer, ForeignKey(catId))
    visit_id = Column('visit', Integer, ForeignKey(visitId))


from sqlalchemy import Column, Integer, Unicode, ForeignKey
import base


class ShoppingItem(base.Base):
    """Sqlalchemy deals model"""
    __tablename__ = "shopping_item"

    catId = 'shopping_category.id'
    visitId = 'visits.id'

    id = Column(Integer, primary_key=True)
    name = Column('name', Unicode)
    quantity = Column('name', Integer)
    category_id = Column('category', Integer, ForeignKey(catId))
    visit_id = Column('visit', Integer, ForeignKey(visitId))

Add quantity to shopping item model
Add quantity to shopping item model

  
  from sqlalchemy import Column, Integer, Unicode, ForeignKey
  import base
  
  
  class ShoppingItem(base.Base):
      """Sqlalchemy deals model"""
      __tablename__ = "shopping_item"
  
      catId = 'shopping_category.id'
      visitId = 'visits.id'
  
      id = Column(Integer, primary_key=True)
      name = Column('name', Unicode)
+     quantity = Column('name', Integer)
      category_id = Column('category', Integer, ForeignKey(catId))
      visit_id = Column('visit', Integer, ForeignKey(visitId))
  
Add quantity to shopping item model
## Code Before:

from sqlalchemy import Column, Integer, Unicode, ForeignKey
import base


class ShoppingItem(base.Base):
    """Sqlalchemy deals model"""
    __tablename__ = "shopping_item"

    catId = 'shopping_category.id'
    visitId = 'visits.id'

    id = Column(Integer, primary_key=True)
    name = Column('name', Unicode)
    category_id = Column('category', Integer, ForeignKey(catId))
    visit_id = Column('visit', Integer, ForeignKey(visitId))

## Instruction:
Add quantity to shopping item model
## Code After:

from sqlalchemy import Column, Integer, Unicode, ForeignKey
import base


class ShoppingItem(base.Base):
    """Sqlalchemy deals model"""
    __tablename__ = "shopping_item"

    catId = 'shopping_category.id'
    visitId = 'visits.id'

    id = Column(Integer, primary_key=True)
    name = Column('name', Unicode)
    quantity = Column('name', Integer)
    category_id = Column('category', Integer, ForeignKey(catId))
    visit_id = Column('visit', Integer, ForeignKey(visitId))
