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