def _pg_row_to_json(self, ignore=['password', 'salt']): logger.debug('execute row_to_json()') sql_expression = \ """ select row_to_json(u) from ( select * from %s where user_id = %s) u; """ % (self.__tablename__, self.user_id) user = DBSession.execute(sql_expression).scalar() logger.debug('json user: %s' % user) for ig in ignore: user.pop(ig) return user
def _pg_all_to_json_array(cls, ignore=['password', 'salt']): logger.debug('execute array_to_json()') sql_expression = \ """ select array_to_json(array_agg(t)) from ( select * from %s) t; """ % (cls.__tablename__) users = DBSession.execute(sql_expression).scalar() logger.debug('json users: %s' % users) if users != None: for user in users: for ig in ignore: user.pop(ig) return users