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
