def insert_user(username, state): session = Session() user = User(username, state) res = session.query(User).filter(User.name == username).all() if len(res) < 1: session.add(user) session.commit() session.close() else: print('User already exists')
def update_status(username, state): session = Session() res = session.query(User).filter(User.name == username).all() if len(res) < 1: user = User(username, state) session.add(user) session.commit() session.close() if len(res) == 1: user = session.query(User).filter(User.name == username).first() user.state = state session.commit() session.close()
def setup_db(): Base.metadata.create_all(engine) session = Session() if session.query(User).first() == None: # plain text password: admin session.add( User( 0, "admin", "103ed64fd2ec3a053dd50bca44ddf7ed6cdeedf83963c44044b494ea69afa52e" )) if session.query(Room).first() == None: session.add( Room(0, "Main Room", "Initial room you connect to.", 100, "admin")) session.commit() session.close()
def save(self): Session.add(self) Session.commit()
} if __name__ == "__main__": from sqlalchemy import create_engine from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker Base.metadata.create_all(engine) session = Session() tmpservice = Service(name="Hello eeeWorld4",information=None,url="www.tbi.com", date=date(2002, 10, 11)) #s=session.query(Service).get(1) session.add(tmpservice) print(tmpservice) session.commit() owner = Owner(name="userw2w2w21", information="User1", url="www.user1.com", date=date(2002,11,10)) domain = Domain(name="carrow2w2w21", information="Opel", url="www.user1.com", date=date(2012,11,10)) element = Element(name="elementw2w21") tmpservice.owner.append(owner) owner.domain.append(domain) domain.element.append(element) session.add(owner)
def insert_translate(translate_word): session = Session() translate = Translate(translate_word) session.add(translate) session.commit() session.close()
def insert_word(eng_word): session = Session() word = Word(eng_word) session.add(word) session.commit() session.close()