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()