Example #1
0
	def update( self, callback, *args, **kwargs):
		"""
		例子:更新字段id = 123的条目的数据
		xxx.filter(id = 123).update( cb, (field2, value1), (field2, value2), fieldN = valueN )
		
		回调格式:
		def callback(success, rows):
			pass
		"""
		assert self.model is not None
		where = self.build_where_clauses(*self.filters)

		paramsKey = []
		paramsVal = []
		kw = list(args) + list(kwargs.items())
		for k, v in kw:
			if hasattr(v, "resolve_expression"):
				paramsKey.append( "{} = {}".format( self.meta.fields[k].db_column, v.resolve_expression(self.meta) ) )
			else:
				paramsKey.append( "{} = %s".format( self.meta.fields[k].db_column ) )
				paramsVal.append( v )
		
		cmd = "UPDATE {} SET {}".format( self.meta.db_table, ", ".join( paramsKey ) )
		cmd = MysqlUtility.makeSafeSql( cmd, paramsVal ) + where
		#DEBUG_MSG( "%s::update(), %s" % (self.__class__.__name__, cmd) )
		KBEngine.executeRawDatabaseCommand( cmd, functools.partial( self._update_callback, cmd, callback ) )
Example #2
0
	def delete(self, callback, *args, **kwargs):
		"""
		def callback(success, rows):
			pass
		"""
		assert self.model is not None
		arg = self.filters + list(args) + list(kwargs.items())
		where = self.build_where_clauses(*arg)
		
		cmd = "DELETE FROM {}".format( self.meta.db_table )
		cmd = MysqlUtility.makeSafeSql( cmd ) + where
		#DEBUG_MSG( "%s::delete(), %s" % (self.__class__.__name__, cmd) )
		KBEngine.executeRawDatabaseCommand( cmd, functools.partial( self._delete_callback, cmd, callback ) )
Example #3
0
	def insert( self, callback, *args, **kwargs ):
		"""
		向数据库插入一条记录。
		def callback(success, insertid):
			pass
		"""
		kw = list(args) + list(kwargs.items())
		fieldNames = []
		fieldValues = []
		fieldValuesP = []
		for k, v in kw:
			fieldNames.append( self.meta.fields[k].db_column )
			fieldValues.append( v )
			fieldValuesP.append( "%s" )
		
		cmd = "INSERT INTO {} ( {} ) VALUES ( {} )".format( self.meta.db_table, ", ".join( fieldNames ), ", ".join( fieldValuesP ) )
		cmd = MysqlUtility.makeSafeSql( cmd, fieldValues )
		#DEBUG_MSG( "%s::insert(), %s" % (self.__class__.__name__, cmd) )
		KBEngine.executeRawDatabaseCommand( cmd, functools.partial( self._insert_callback, cmd, callback ) );
Example #4
0
    def select(self, callback, *args, **kwargs):
        """
		def callback(success, models):
			pass
		"""
        assert self.model is not None
        arg = self.filters + list(args) + list(kwargs.items())
        where = self.build_where_clauses(*arg)

        attrs = list(self.meta.fields)
        fields = [self.meta.fields[e].db_column for e in attrs]
        queryField = ", ".join(fields)
        cmd = "select {} from {}".format(queryField, self.meta.db_table)
        cmd = MysqlUtility.makeSafeSql(cmd)
        if where: cmd += b" where " + where
        #DEBUG_MSG( "%s::select(), %s" % (self.__class__.__name__, cmd) )
        KBEngine.executeRawDatabaseCommand(
            cmd, functools.partial(self._select_callback, cmd, attrs,
                                   callback))
Example #5
0
	def select(self, callback, *args, **kwargs):
		"""
		def callback(success, models):
			pass
		"""
		assert self.model is not None
		arg = self.filters + list(args) + list(kwargs.items())
		where = self.build_where_clauses(*arg)

		attrs = list( self.meta.fields )
		fields = [ self.meta.fields[e].db_column for e in attrs ]
		queryField = ", ".join( fields )
		select = "SELECT {} FROM {}".format( queryField, self.meta.db_table )
		cmd = b"".join([
			MysqlUtility.makeSafeSql( select ),
			where,
			self.build_order_by_clauses(),
			self.limit_opt and (" LIMIT %d, %d" % self.limit_opt).encode() or b"",
		])
		
		
		#DEBUG_MSG( "%s::select(), %s" % (self.__class__.__name__, cmd) )
		KBEngine.executeRawDatabaseCommand( cmd, functools.partial( self._select_callback, cmd, attrs, callback ) )