def update(self, table, data, where=None):
"""
更新
:param table: 执行的数据表
:param data: 需要插入的数据
:param where: 更新的条件
:return: self
"""
self._type = 2
sql = "UPDATE " + table + " SET "
last_key = list(data.keys())[-1]
self._params = []
for key, value in data.items():
self._params.append(value)
if key == last_key:
sql += str(key) + "=" + "%s"
else:
sql += str(key) + "=" + "%s,"
if where:
self._checkWhere(where)
builder = QueryBuilder()
where = builder.buildWhere(where, {})
builderParams = builder.params
self._params = self._params + builderParams
sql += " " + where
self._sql = sql
return self
def delete(self, table, where=None):
"""
删除
:param table: 执行的数据表
:param where: 删除的条件
:return: self
"""
self._type = 2
self._sql = "DELETE FROM " + table
if where:
self._checkWhere(where)
builder = QueryBuilder()
where = builder.buildWhere(where, {})
builderParams = builder.params
self._params = self._params + builderParams
self._sql += " " + where
return self
