def askVendorName():
dbSession = DBSession()
newUser=User()
newUser.email_id = session["username"]
newUser.hash_password("nopassword")
newUser.Name = "googleSignin"
newVendor=Vendor()
newVendor.name = request.form['vendorName']
newVendor.user = newUser
dbSession.add(newUser)
dbSession.add(newVendor)
dbSession.commit()
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Vendor, Base, Items, User
engine = create_engine('sqlite:///geekshack.db')
# Bind the engine to the metadata of the Base class so that the
# declaratives can be accessed through a DBSession instance
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
user = User(email_id="*****@*****.**")
user.Name = "EMC"
user.hash_password("testme")
user2 = User(email_id="*****@*****.**")
user2.Name = "CISCO"
user2.hash_password("testme")
vendor1 = Vendor(name="EMC")
vendor1.user = user
vendor2 = Vendor(name="CISCO")
vendor2.user = user2
session.add(vendor1)
session.commit()
