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