Python execute_with_params Examples

Programming Language: Python

Namespace/Package Name: assets.database.dbhelper

Method/Function: execute_with_params

Examples at hotexamples.com: 2

Python execute_with_params - 2 examples found. These are the top rated real world Python examples of assets.database.dbhelper.execute_with_params extracted from open source projects. You can rate examples to help us improve the quality of examples.

Example #1

Show file

 def update(self, where, **kwargs):
     fields, params = self._get_update_params(**kwargs)
     if where:
         where = " AND %s" % where
     sql = "UPDATE %s SET %s WHERE 1=1 %s" % (self.table, fields, where)
     print(sql)
     return dbhelper.execute_with_params(sql,params)

Example #2

Show file

 def delete(self, **kwargs):
     sql = "DELETE FROM %s %s" % (self.table, self._get_where(**kwargs))
     params = kwargs
     return dbhelper.execute_with_params(sql,params)