def get_client_posts(cuid, start, count):
ret_posts = []
try:
posts = Posts.get_all_from_cuid(
session = DBSession,
cuid = cuid,
start = start,
count = count,
)
ret_posts = utils._decode_posts(posts)
except:
raise Exception("Database error.")
return ret_posts
def get_post(post_id):#, start, count):
ret_posts = []
try:
posts = Posts.get_with_media_objects_from_post_id(
session = DBSession,
post_id = post_id,
#start = start,
#count = count,
)
ret_posts = utils._decode_posts(posts)
except:
raise Exception("Database error.")
return ret_posts
def get_client_posts(cuid, start, count):
ret_posts = []
try:
posts = Posts.get_all_from_cuid(
session=DBSession,
cuid=cuid,
start=start,
count=count,
)
ret_posts = utils._decode_posts(posts)
except:
raise Exception("Database error.")
return ret_posts
def get_posts(start, count, deleted):
ret_posts = []
try:
posts = Posts.get_posts(
DBSession,
deleted = deleted,
start = start,
count = count,
)
ret_posts = utils._decode_posts(posts)
except:
raise Exception("Database error.")
return ret_posts
def get_post(post_id): #, start, count):
ret_posts = []
try:
posts = Posts.get_with_media_objects_from_post_id(
session=DBSession,
post_id=post_id,
#start = start,
#count = count,
)
ret_posts = utils._decode_posts(posts)
except:
raise Exception("Database error.")
return ret_posts
def get_posts(start, count, deleted):
ret_posts = []
try:
posts = Posts.get_posts(
DBSession,
deleted=deleted,
start=start,
count=count,
)
ret_posts = utils._decode_posts(posts)
except:
raise Exception("Database error.")
return ret_posts
def get_response_posts(assignment_id, start, count, deleted):
ret_posts = []
try:
posts = Posts.get_all_from_assignment_id(
session = DBSession,
assignment_id = assignment_id,
deleted = deleted,
start = start,
count = count,
)
ret_posts = utils._decode_posts(posts)
except:
raise Exception("Database error.")
return ret_posts
def get_response_posts(assignment_id, start, count, deleted):
ret_posts = []
try:
posts = Posts.get_all_from_assignment_id(
session=DBSession,
assignment_id=assignment_id,
deleted=deleted,
start=start,
count=count,
)
ret_posts = utils._decode_posts(posts)
except:
raise Exception("Database error.")
return ret_posts
def get_post(post_id):
ret_post = None
#try:
if True:
post = Posts.get_with_media_objects_from_post_id(
session = DBSession,
post_id = post_id,
)
print "\n\n"
print post
print "\n\n"
if not post is None and len(post) != 0:
ret_post = utils._decode_posts(post, clean=False)[0]
#except:
# raise Exception("Database error.")
return ret_post
def get_approved_posts(client_id, language_code, lat, lng, start, count):
ret_posts = []
try:
posts = Posts.get_all_approved_from_location(
session = DBSession,
client_id = client_id,
language_code = language_code,
lat = lat,
lng = lng,
start = start,
count = count,
)
ret_posts = utils._decode_posts(posts, clean=True)
except:
raise Exception("Database error.")
return ret_posts
