bee.osql.engine

class ObjSQL(bee.osql.base.AbstractCommOperate):

ObjSQL is Suid implementation.

def select(self, entity, condition: bee.condition.Condition = None):

def update(self, entity):

def insert(self, entity):

def delete(self, entity, condition: bee.condition.Condition = None):

beeSql

objToSQL

Inherited Members

bee.osql.base.AbstractCommOperate: local; doBeforePasreEntity; doBeforePasreListEntity; doBeforeReturn; doBeforeReturnSimple; logsql; log_params; log_params_for_batch

class ObjSQLRich(ObjSQL):

ObjSQLRich is SuidRich implementation.

def select_paging(self, entity, start, size, *selectFields):

def insert_batch(self, entity_list):

def select_first(self, entity):

def select_by_id(self, entity_class, *ids):

def delete_by_id(self, entity_class, *ids):

def select_fun(self, entity, functionType, field_for_fun):

def count(self, entity):

def exist(self, entity):

def updateBy(self, entity, condition: bee.condition.Condition, *whereFields):

def create_table(self, entityClass, is_drop_exist_table=None):

def index_normal(self, entity_class, fields, index_name=None):

def unique(self, entity_class, fields, index_name=None):

def drop_index(self, entity_class, index_name=None):

Inherited Members

ObjSQL: select; update; insert; delete; beeSql; objToSQL
bee.osql.base.AbstractCommOperate: local; doBeforePasreEntity; doBeforePasreListEntity; doBeforeReturn; doBeforeReturnSimple; logsql; log_params; log_params_for_batch

class PreparedSqlLib(bee.osql.base.AbstractCommOperate):

PreparedSqlLib is PreparedSql implementation.

def select(self, sql, return_type_class, params=None, start=None, size=None):

def select_dict( self, sql, return_type_class, params_dict=None, start=None, size=None):

eg: preparedSql=PreparedSql() entity_list =preparedSql.select_dict("SELECT * FROM orders WHERE name=#{name} and id=#{id} and name=#{name}", Orders, params_dict ={"name":"bee1","id":4})

def modify(self, sql, params=None):

eg: sql = "update orders set name = ?, remark = ? where id = ?" params = ('bee130', 'test-update', 1) updateNum = preparedSql.modify(sql, params)

def modify_dict(self, sql, params_dict=None):

eg: sql = "update orders set name = #{name}, remark = #{remark} where id = #{id}" params_dict={"id":1, "name":"newName","remark":"remark2"} updateNum = preparedSql.modify_dict(sql, params_dict)

beeSql

Inherited Members

bee.osql.base.AbstractCommOperate: local; doBeforePasreEntity; doBeforePasreListEntity; doBeforeReturn; doBeforeReturnSimple; logsql; log_params; log_params_for_batch