def deleteAllCategories(self): session = self.session() for cat in session.query(Category): session.delete(cat) #tasks get deleted cascade session.commit()
def deleteCategory(self, p_CategoryId): session = self.session() query = session.query(Category).filter(Category.id==p_CategoryId) category = query.first() session.delete(category) session.commit()
def deleteTask(self, p_TaskId): session = self.session() query = session.query(Task).filter(Task.id==p_TaskId) task = query.first() session.delete(task) session.commit()
def downgrade(): session = sa.orm.session.Session(bind=op.get_bind()) default_category = (session.query(TagCategory).filter( TagCategory.name == 'default').filter( TagCategory.color == 'default').filter( TagCategory.version == 1).filter( TagCategory.default == 1).one_or_none()) if default_category: session.delete(default_category) session.commit()
def main(): engine = sqlalchemy.create_engine(MYSQL_URL, encoding='UTF8', echo=True) sqlalchemy.orm.session.Session = sqlalchemy.orm.sessionmaker(bind=engine) # 创建sesstion类型 session = sqlalchemy.orm.session.Session() user =session.query(User).get(3) session.delete(user) session.commit() print(user) session.close()
def main(): try: engine = sqlalchemy.create_engine(MYSQL_URL, echo=True) # 返回所有的操作信息 sqlalchemy.orm.session.Session = sqlalchemy.orm.sessionmaker( bind=engine) # 創建Session類型 session = sqlalchemy.orm.session.Session() # 實例化Session對象 user = session.query(User).get(3) # 查詢3號數據 session.delete(user) # 刪除實體(ORM是以實體為主) session.commit() # 事務提交 session.close() # 關畢session(釋放連接) except Exception as e: logging.info(traceback.format_exc())
def downgrade(): session = sa.orm.session.Session(bind=op.get_bind()) default_category = ( session .query(TagCategory) .filter(TagCategory.name == 'default') .filter(TagCategory.color == 'default') .filter(TagCategory.version == 1) .filter(TagCategory.default == 1) .one_or_none()) if default_category: session.delete(default_category) session.commit()
def deletarPessoa(nome_): session = DBSession() p = getPessoa(nome_) if p != None: telefones = session.query(Telefone).filter_by(pessoa_id=p.id) for x in telefones: session.delete(x) enderecos = session.query(Endereco).filter_by(pessoa_id=p.id) for x in enderecos: session.delete(x) session.delete(p) session.commit() else: print("Contato não encontrado.\n") session.close()
def deleteRestaurant(RestaurantName): temp = session.query(Restaurant).filter_by(name=RestaurantName).one() print(temp.name, "is being DELETED...") session.delete(temp) session.commit() print("Deleted Sucessfully")
#!/usr/bin/python3 """ lists all State objects from the database hbtn_0e_6_usa """ import sys from model_state import Base, State from sqlalchemy import (create_engine) from sqlalchemy.orm import session, sessionmaker if __name__ == "__main__": engine = create_engine('mysql+mysqldb://{}:{}@localhost/{}'.format( sys.argv[1], sys.argv[2], sys.argv[3]), pool_pre_ping=True) Session = sessionmaker(bind=engine) session = Session() for i in session.query(State).filter(State.name.like('%a%')): session.delete(i) session.commit()
database name You must use the module SQLAlchemy You must import State and Base from model_state - from model_state import Base, State Your script should connect to a MySQL server running on localhost at port 3306 Your code should not be executed when imported """ import sys from model_state import Base, State import sqlalchemy from sqlalchemy import (create_engine) from sqlalchemy.orm import session, sessionmaker if __name__ == "__main__": engine = create_engine('mysql+mysqldb://{}:{}@localhost/{}'.format( sys.argv[1], sys.argv[2], sys.argv[3]), pool_pre_ping=True) Base.metadata.create_all(engine) Session = sessionmaker(bind=engine) session = Session() delState = session.query(State).filter(State.name.like('%a%')) for state in delState: session.delete(state) session.commit() session.close()