def media_by_mocambola(request, repository, mucua, username, limit=20):
if mucua != 'all':
try:
mucua = Mucua.objects.get(description=mucua)
except Mucua.DoesNotExist:
mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
redirect_page = True
try:
repository = Repository.objects.get(name=repository)
except Repository.DoesNotExist:
repository = Repository.objects.get(name=DEFAULT_REPOSITORY)
try:
author = User.objects.get(username=username)
except User.DoesNotExist:
print 'user not exists'
if mucua != 'all':
medias = Media.objects.filter(repository=repository.id).filter(
origin=mucua.id).filter(author=author.id).order_by('-date')[:limit]
else:
medias = Media.objects.filter(repository=repository.id).filter(
author=author.id).order_by('-date')[:limit]
# serializa e da saida
serializer = MediaSerializer(medias, many=True)
return Response(serializer.data)
class ModuleSerializer(CreatedModifiedByModelSerializerV2):
class Meta:
model = Module
category = ModuleCategorySerializer(read_only=True)
category_id = serializers.UUIDField()
main_media = MediaSerializer(read_only=True)
main_media_id = serializers.UUIDField()
user_assessment = UserAssessmentSerializer(read_only=True)
user_assessment_id = serializers.UUIDField()
def media_last(request, repository, mucua, limit=5):
"""
List the last added medias
"""
try:
mucua = Mucua.objects.get(description=mucua)
except Mucua.DoesNotExist:
mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
try:
repository = Repository.objects.get(name=repository)
except Repository.DoesNotExist:
repository = Repository.objects.get(name=DEFAULT_REPOSITORY)
medias = Media.objects.filter(repository=repository.id).filter(
origin=mucua.id).order_by('-date')[:limit]
# serializa e da saida
serializer = MediaSerializer(medias, many=True)
return Response(serializer.data)
def media_detail(request, repository, mucua, pk=None, format=None):
"""
Retrieve, create, update or delete a media instance.
"""
# pegando sessao por url
redirect_page = False
try:
mucua = Mucua.objects.get(description=mucua)
except Mucua.DoesNotExist:
mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
redirect_page = True
try:
repository = Repository.objects.get(name=repository)
except Repository.DoesNotExist:
repository = Repository.objects.get(name=DEFAULT_REPOSITORY)
redirect_page = True
# redirect
if redirect_page:
return HttpResponseRedirect(redirect_base_url + repository.name +
'/' + mucua.description + '/media/')
author = request.user
if pk:
try:
media = Media.objects.get(uuid=pk)
except Media.DoesNotExist:
return Response(status=status.HTTP_404_NOT_FOUND)
if request.method == 'GET':
if pk == '':
# acessa para inicializar tela de publicaocao de conteudo / gera
# token
c = RequestContext(request, {'autoescape': False})
c.update(csrf(request))
t = Template('{ "csrftoken": "{{ csrf_token }}" }')
return HttpResponse(t.render(c), mimetype=u'application/json')
if pk != '':
serializer = MediaSerializer(media)
return Response(serializer.data)
elif request.method == 'PUT':
if pk == '':
return HttpResponseRedirect(
redirect_base_url + repository.name + '/' +
mucua.description + '/bbx/search')
media.name = request.DATA['name']
media.note = request.DATA['note']
media.type = request.DATA['type']
media.license = request.DATA['license']
media.date = request.DATA['date']
media.save()
if media.id:
tags = request.DATA['tags'].split(',')
media.tags.clear()
for tag in tags:
if tag:
try:
tag = tag.strip()
tag = Tag.objects.get(name=tag)
except Tag.DoesNotExist:
tag = Tag.objects.create(name=tag)
# TODO: case or proximity check to avoid spelling
# errors? Or do people handle this by manual merging &
# deletion of tags?
tag.save()
media.tags.add(tag)
return Response("updated media - OK",
status=status.HTTP_201_CREATED)
else:
return Response("error while creating media",
status=status.HTTP_400_BAD_REQUEST)
if serializer.is_valid():
serializer.save()
return Response(serializer.data)
else:
return Response(serializer.errors,
status=status.HTTP_400_BAD_REQUEST)
elif request.method == 'POST':
"""
create a new media
"""
if request.DATA['author'] != '':
author = request.DATA['author']
else:
author = request.user
try:
author = User.objects.get(username=author)
except User.DoesNotExist:
author = User.objects.get(username=request.user)
media = Media(repository=repository,
origin=mucua,
author=author,
name=request.DATA['name'],
note=request.DATA['note'],
type=request.DATA['type'],
format=request.FILES['media_file'].name.split('.')[-1].lower(),
license=request.DATA['license'],
date=(request.DATA['date'] if request.DATA['date'] !=
'' else datetime.now()),
media_file=request.FILES['media_file'],
uuid=generate_UUID()
)
media.save()
if media.id:
# get tags by list or separated by ','
tags = (request.DATA['tags'] if iter(request.DATA['tags'])
else request.DATA['tags'].split(','))
for tag_name in tags:
try:
if tag_name.find(':') > 0:
args = tag.split(':')
tag_name = args[1]
tag = Tag.objects.get(name=tag_name)
except Tag.DoesNotExist:
tag = Tag.objects.create(name=tag_name)
tag.save()
media.tags.add(tag)
media.save() # salva de novo para chamar o post_save
serializer = MediaSerializer(media)
return Response(serializer.data, status=status.HTTP_201_CREATED)
else:
return Response("error while creating media",
status=status.HTTP_400_BAD_REQUEST)
elif request.method == 'DELETE':
media.delete()
return Response(status=status.HTTP_204_NO_CONTENT)
def media_detail(request, repository, mucua, pk=None, format=None):
"""
Retrieve, create, update or delete a media instance.
"""
# TODO: Use object permissions for more fine grained control.
# For now, do a more primitive check that the user is authenticated.
if request.method != 'GET' and not request.user.is_authenticated():
raise PermissionDenied
# pegando sessao por url
redirect_page = False
if mucua == 'rede':
mucua = request.DATA['origin']
try:
mucua = Mucua.objects.get(description=mucua)
except Mucua.DoesNotExist:
mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
redirect_page = True
try:
repository = Repository.objects.get(name=repository)
except Repository.DoesNotExist:
repository = Repository.objects.get(name=DEFAULT_REPOSITORY)
redirect_page = True
# redirect
if redirect_page:
return HttpResponseRedirect(redirect_base_url + repository.name +
'/' + mucua.description + '/media/')
author = request.user
# verifica se tem primary key definido antes de direcionar para os request.methods (get, put, post)
if pk:
# get media
try:
media = Media.objects.get(uuid=pk)
except Media.DoesNotExist:
return Response(status=status.HTTP_404_NOT_FOUND)
if request.method == 'GET':
# get media
if pk == '':
"""
get media
Se pk nao existe, chama token (preparacao para insercao) # TODO: mover?
"""
media_token(request, repository, mucua)
if pk != '':
serializer = MediaSerializer(media)
return Response(serializer.data)
elif request.method == 'PUT':
"""
update media
"""
if pk == '':
return HttpResponseRedirect(
redirect_base_url + repository.name + '/' +
mucua.description + '/bbx/search')
media.name = request.DATA['name']
media.note = request.DATA['note']
media.type = request.DATA['type']
media.license = request.DATA['license']
media.date = request.DATA['date']
# workaround for date problem
file_day = str(media.media_file).split('/')[-2]
date_day = str(media.date)[8:10]
if file_day != date_day:
media.date = media.date[0:8] + file_day + media.date[10:]
media.save()
if media.id:
tags = request.DATA['tags'].split(',')
media.tags.clear()
add_and_synchronize_tags(media, tags, mucua)
return Response(_("updated media - OK"),
status=status.HTTP_201_CREATED)
else:
return Response(_("error while creating media"),
status=status.HTTP_400_BAD_REQUEST)
if serializer.is_valid():
serializer.save()
return Response(serializer.data)
else:
return Response(serializer.errors,
status=status.HTTP_400_BAD_REQUEST)
elif request.method == 'POST':
"""
create a new media
"""
if request.DATA['author'] != '':
author = request.DATA['author']
else:
author = request.user
try:
author = User.objects.get(username=author)
except User.DoesNotExist:
author = User.objects.get(username=request.user)
try:
mucua = Mucua.objects.get(description=request.DATA['origin'])
except Mucua.DoesNotExist:
mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
media = Media(repository=repository,
origin=mucua,
author=author,
note=request.DATA['note'],
type=request.DATA['type'],
license=request.DATA['license'],
name=request.DATA.get('name', ''),
date=(request.DATA['date'] if request.DATA['date'] !=
'' else get_now()),
uuid=generate_UUID()
)
logger.info('processing upload')
# multiple upload
for filename, file in request.FILES.iteritems():
file_name = request.FILES[filename].name
media.format=file_name.split('.')[-1].lower()
if media.name == '':
media.name = get_media_name_by_filename(file_name)
if hasattr(request.FILES[filename], 'temporary_file_path'):
# if file bigger than 2.5MB, is stored in /tmp
tmp_file = request.FILES[filename].temporary_file_path()
else:
# if lesser than 2.5MB, is stored on memory
tmp_file = '/tmp/' + media.uuid
f = open(tmp_file, 'w')
f.write(request.FILES[filename].read())
f.close()
media.type=get_media_type_by_filename(tmp_file)
if media.type == 'imagem':
media.media_file=handle_uploaded_image(media, tmp_file,request.FILES[filename])
else:
media.media_file=request.FILES[filename]
media.save()
if media.id:
# get tags by list or separated by ','
tags = request.DATA['tags'].split(',')
add_and_synchronize_tags(media, tags, mucua)
media.save() # salva de novo para chamar o post_save
serializer = MediaSerializer(media)
return Response(serializer.data, status=status.HTTP_201_CREATED)
else:
return Response(_("error while creating media"),
status=status.HTTP_400_BAD_REQUEST)
elif request.method == 'DELETE':
media.delete()
return Response(status=status.HTTP_204_NO_CONTENT)
def media_list(request, repository, mucua, args=None, format=None):
"""
List all medias, or search by terms
"""
if request.method == 'GET':
"""
list medias
"""
# pegando sessao por url
redirect_page = False
# REPOSITORIO: verifica se existe no banco, senao pega a default
if mucua == 'rede':
# get actual mucua for excluding it
this_mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
else:
try:
mucua = Mucua.objects.get(description=mucua)
except Mucua.DoesNotExist:
mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
redirect_page = True
try:
repository = Repository.objects.get(name=repository)
except Repository.DoesNotExist:
repository = Repository.objects.get(name=DEFAULT_REPOSITORY)
redirect_page = True
# redirect
if redirect_page:
return HttpResponseRedirect(redirect_base_url + repository.name +
'/' + mucua.description +
'/bbx/search/')
"""
====================
SEARCH ENGINE
-------------
Sample urls
Valid with the following types of url (TODO: create tests):
[repository]/[mucua]/search/video/quilombo/limit/5
[repository]/[mucua]/search/orderby/note/limit/10
[repository]/[mucua]/search/video/quilombo/orderby/title/limit/5
[repository]/[mucua]/search/video/quilombo/orderby/type/desc/name/asc/limit/5
[repository]/[mucua]/search/video/quilombo/orderby/author/desc
TODO: still failling when receives incomplete urls. i.e.:
[repository]/[mucua]/search/video/quilombo/orderby/title/limit/5
"""
""" if passed, get limiting rules """
""" TODO: move default_limit to configurable place """
params = []
default_limit = 20
limiting_params = []
if (args.find('limit') != -1):
limiting_params.append(int(args.split('limit/')[1]))
args = args.split('limit/')[0]
else:
limiting_params.append(int(default_limit))
""" if passed, get ordering rules """
ordering_sql = ''
ordering_params = []
default_ordering = 'name ASC'
if (args.find('orderby/') != -1):
ordering_terms = args.split('orderby/')[1].split('/')
ordering_list = []
counting = 0
""" as ordering must not be passed as wildchar, we're filtering the input """
accepted_ordering = [
'uuid', 'name', 'date', 'note', 'type', 'author', 'origin',
'format', 'license', 'repository', 'is_local', 'is_requested',
'num_copies'
]
""" hack: author and origin must be django objects, but here will assume string form """
hack_fields = ['author', 'origin']
for term in ordering_terms:
if ((term == 'asc') | (term == 'desc')):
if counting == 0:
continue
ordering_sql += ' ' + term + ','
else:
if (term in accepted_ordering):
if (term in hack_fields):
term = '_' + term
ordering_sql += term
counting += 1
if ordering_sql != '':
if ordering_sql[-1] == ',':
ordering_sql = ordering_sql[:-1]
else:
ordering_sql = default_ordering
args = args.split('orderby/')[0]
else:
ordering_sql = default_ordering
origin_sql = ""
""" if mucua, filter it """
if (mucua != 'rede'):
origin_sql = "origin_id=? AND "
params.append(mucua.id)
""" appends repository id """
params.append(repository.id)
""" compose query string for terms """
term_sql = ""
args = args.rstrip('/')
if args != '':
term_index = 0
for term in args.split('/'):
term = str(term.encode('utf-8'))
if (term in [
key for (key, type_choice) in getTypeChoices()
if term == type_choice
]):
if (term_index > 0):
term_sql += " AND "
term_sql += " type LIKE ? "
params.append("%" + term + "%")
elif term in [
key for (key, format_choice) in getFormatChoices()
if term == format_choice
]:
term_sql += " format LIKE ? "
params.append("%" + term + "%")
else:
if (term_index > 0):
term_sql += " AND "
term_sql += " ( t.name LIKE ? "
term_sql += " OR m.name LIKE ?"
term_sql += " OR m.note LIKE ? )"
params.append("%" + term + "%")
params.append("%" + term + "%")
params.append("%" + term + "%")
term_index += 1
if (len(term_sql) > 0):
term_sql = ' AND (' + term_sql + ')'
sql = "SELECT DISTINCT \
m.*, \
u.username AS _author, \
mu.description AS _origin \
FROM \
media_media m \
LEFT JOIN media_media_tags mt \
ON m.id = mt.media_id \
LEFT JOIN tag_tag t \
ON mt.tag_id = t.id \
LEFT JOIN auth_user u \
ON u.id = m.author_id \
LEFT JOIN mucua_mucua mu \
ON mu.id = m.origin_id \
WHERE (" + origin_sql + " repository_id = ? ) " + term_sql + " \
ORDER BY " + ordering_sql + " \
LIMIT ?"
sql = sql.decode('utf-8')
params.extend(limiting_params)
medias = Media.objects.raw(sql, params)
""" sql log
logger.info('sql: ' + sql)
"""
# serializa e da saida
serializer = MediaSerializer(medias, many=True)
return Response(serializer.data)
def media_detail(request, repository, mucua, pk=None, format=None):
"""
Retrieve, create, update or delete a media instance.
"""
# pegando sessao por url
redirect_page = False
try:
mucua = Mucua.objects.get(description=mucua)
except Mucua.DoesNotExist:
mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
redirect_page = True
try:
repository = Repository.objects.get(name=repository)
except Repository.DoesNotExist:
repository = Repository.objects.get(name=DEFAULT_REPOSITORY)
redirect_page = True
# redirect
if redirect_page:
return HttpResponseRedirect(redirect_base_url + repository.name + '/' +
mucua.description + '/media/')
author = request.user
if pk:
try:
media = Media.objects.get(uuid=pk)
except Media.DoesNotExist:
return Response(status=status.HTTP_404_NOT_FOUND)
if request.method == 'GET':
if pk == '':
# acessa para inicializar tela de publicaocao de conteudo / gera
# token
c = RequestContext(request, {'autoescape': False})
c.update(csrf(request))
t = Template('{ "csrftoken": "{{ csrf_token }}" }')
return HttpResponse(t.render(c), mimetype=u'application/json')
if pk != '':
serializer = MediaSerializer(media)
return Response(serializer.data)
elif request.method == 'PUT':
if pk == '':
return HttpResponseRedirect(redirect_base_url + repository.name +
'/' + mucua.description +
'/bbx/search')
media.name = request.DATA['name']
media.note = request.DATA['note']
media.type = request.DATA['type']
media.license = request.DATA['license']
media.date = request.DATA['date']
media.save()
if media.id:
tags = request.DATA['tags'].split(',')
media.tags.clear()
for tag in tags:
if tag:
try:
tag = tag.strip()
tag = Tag.objects.get(name=tag)
except Tag.DoesNotExist:
tag = Tag.objects.create(name=tag)
# TODO: case or proximity check to avoid spelling
# errors? Or do people handle this by manual merging &
# deletion of tags?
tag.save()
media.tags.add(tag)
return Response("updated media - OK",
status=status.HTTP_201_CREATED)
else:
return Response("error while creating media",
status=status.HTTP_400_BAD_REQUEST)
if serializer.is_valid():
serializer.save()
return Response(serializer.data)
else:
return Response(serializer.errors,
status=status.HTTP_400_BAD_REQUEST)
elif request.method == 'POST':
"""
create a new media
"""
if request.DATA['author'] != '':
author = request.DATA['author']
else:
author = request.user
try:
author = User.objects.get(username=author)
except User.DoesNotExist:
author = User.objects.get(username=request.user)
media = Media(
repository=repository,
origin=mucua,
author=author,
name=request.DATA['name'],
note=request.DATA['note'],
type=request.DATA['type'],
format=request.FILES['media_file'].name.split('.')[-1].lower(),
license=request.DATA['license'],
date=(request.DATA['date']
if request.DATA['date'] != '' else datetime.now()),
media_file=request.FILES['media_file'],
uuid=generate_UUID())
media.save()
if media.id:
# get tags by list or separated by ','
tags = (request.DATA['tags'] if iter(request.DATA['tags']) else
request.DATA['tags'].split(','))
for tag_name in tags:
try:
if tag_name.find(':') > 0:
args = tag.split(':')
tag_name = args[1]
tag = Tag.objects.get(name=tag_name)
except Tag.DoesNotExist:
tag = Tag.objects.create(name=tag_name)
tag.save()
media.tags.add(tag)
media.save() # salva de novo para chamar o post_save
serializer = MediaSerializer(media)
return Response(serializer.data, status=status.HTTP_201_CREATED)
else:
return Response("error while creating media",
status=status.HTTP_400_BAD_REQUEST)
elif request.method == 'DELETE':
media.delete()
return Response(status=status.HTTP_204_NO_CONTENT)
def media_list(request, repository, mucua, args=None, format=None):
"""
List all medias, or search by terms
"""
if request.method == 'GET':
"""
list medias
"""
# pegando sessao por url
redirect_page = False
# REPOSITORIO: verifica se existe no banco, senao pega a default
if mucua == 'rede':
# get actual mucua for excluding it
this_mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
else:
try:
mucua = Mucua.objects.get(description=mucua)
except Mucua.DoesNotExist:
mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
redirect_page = True
try:
repository = Repository.objects.get(name=repository)
except Repository.DoesNotExist:
repository = Repository.objects.get(name=DEFAULT_REPOSITORY)
redirect_page = True
# redirect
if redirect_page:
return HttpResponseRedirect(redirect_base_url + repository.name +
'/' + mucua.description +
'/bbx/search/')
"""
====================
SEARCH ENGINE
-------------
Sample urls
Valid with the following types of url (TODO: create tests):
[repository]/[mucua]/search/video/quilombo/limit/5
[repository]/[mucua]/search/orderby/note/limit/10
[repository]/[mucua]/search/video/quilombo/orderby/title/limit/5
[repository]/[mucua]/search/video/quilombo/orderby/type/desc/name/asc/limit/5
[repository]/[mucua]/search/video/quilombo/orderby/author/desc
[repository]/[mucua]/search/video/quilombo/is_local
[repository]/[mucua]/search/video/quilombo/is_requested
"""
""" if passed, get limiting rules """
""" TODO: move default_limit to configurable place """
params = []
return_count = False
shuffle = False
license_params = ''
# remove ultimo caractere
if args[:-1] == '/':
args = args[:-1]
# se passado na url, retorna apenas listagem (count como palavra reservada)
if (args.find('count') != -1):
args = args.split('count')[0]
return_count = True
# se passado na url, aleatoriza retorno (shuffle como palavra reservada)
if (args.find('shuffle') != -1):
args = ''.join(args.split('shuffle'))
shuffle = True
# se passado na url, adiciona busca por licenca (license como palavra reservada)
if (args.find('license') != -1):
license_params = args.split('license/')[1].split('/')[0]
""" TODO: move licenses to a dynamic list """
accepted_licenses = ['gplv3',
'gfdl',
'lgplv3',
'agplv3',
'copyleft',
'clnc_educ',
'cc',
'cc_nc',
'cc_ci',
'cc_ci_nc',
'cc_sd',
'cc_sd_nc'
]
if license_params in accepted_licenses:
args = args.split('license/' + license_params + '/')[0] + args.split('license/' + license_params + '/')[1]
else:
license_params = ""
args = args.split('license/')[0] + args.split('license/')[1]
default_limit = 20
limiting_params = []
""" fields that if passed will make a boolean check """
filter_fields = ['is_local', 'is_requested']
if (args.find('limit') != -1):
limiting_params = args.split('limit/')[1].split('/')
if (limiting_params != ''):
limiting_params = [ int(x) for x in limiting_params ]
args = args.split('limit/')[0]
else:
if not return_count:
limiting_params.append(default_limit)
""" if passed, get ordering rules """
ordering_sql = ''
ordering_params = []
default_ordering = 'date DESC'
if (shuffle):
# shuffle query
if args.find('orderby'):
args = args.split('orderby/')[0]
ordering_sql += ' RANDOM()'
elif (args.find('orderby/') != -1):
# pass orderby to query
ordering_terms = args.split('orderby/')[1].split('/')
ordering_list = []
counting = 0
""" as ordering must not be passed as wildchar, we're filtering the input """
accepted_ordering = ['uuid', 'name', 'date', 'note', 'type', 'author', 'origin', 'format', 'license', 'repository', 'is_local', 'is_requested', 'num_copies']
""" hack: author and origin must be django objects, but here will assume string form """
hack_fields = ['author', 'origin']
for term in ordering_terms:
if ((term == 'asc') | (term == 'desc')):
if counting == 0:
continue
ordering_sql += ' ' + term + ','
elif (term in filter_fields):
# check if needed
continue
else:
if (term in accepted_ordering):
if (term in hack_fields):
term = '_' + term
ordering_sql += term
counting += 1
if ordering_sql != '':
if ordering_sql[-1] == ',':
ordering_sql = ordering_sql[:-1]
else:
ordering_sql = default_ordering
args = args.split('orderby/')[0]
else:
# normal ordering
ordering_sql = default_ordering
origin_sql = ""
""" if mucua, filter it """
if (mucua != 'rede'):
origin_sql = "origin_id=? AND "
params.append(mucua.id)
""" appends repository id """
params.append(repository.id)
""" compose query string for terms """
term_sql = ""
args = args.rstrip('/')
if args != '':
term_index = 0
for term in args.split('/'):
term = str(term.encode('utf-8'))
if (term in filter_fields):
if (term_index > 0):
term_sql += " AND "
term_sql += term + "=1"
elif (term in [key for (key, type_choice) in getTypeChoices() if
term == type_choice]):
if (term_index > 0):
term_sql += " AND "
term_sql += " type LIKE ? "
params.append("%" + term + "%")
elif term in [key for
(key, format_choice) in getFormatChoices() if
term == format_choice]:
term_sql += " format LIKE ? "
params.append("%" + term + "%")
# suporte a busca de mocambola
elif re.search('[^@]+@[^@]+\.[^@]+', term):
if (term_index > 0):
term_sql += " AND "
term_sql += ' u.username = ? '
params.append(term)
else:
if (term_index > 0):
term_sql += " AND "
term_sql += " ( tag_concat LIKE ? "
term_sql += " OR m.name LIKE ?"
term_sql += " OR m.note LIKE ? )"
params.append("%" + term + "%")
params.append("%" + term + "%")
params.append("%" + term + "%")
term_index += 1
""" license search """
if license_params:
term_sql += " AND license=?"
params.append(license_params)
if (len(term_sql) > 0):
term_sql = ' HAVING (' + term_sql + ')'
if return_count:
sql = "SELECT \
m.id, \
t.name || ',' || group_concat(t.name, ',') as tag_concat "
else :
sql = "SELECT DISTINCT \
m.*, \
t.name || ',' || group_concat(t.name, ',') as tag_concat, \
u.username AS _author, \
mu.description AS _origin "
sql += "FROM \
media_media m \
LEFT JOIN media_media_tags mt \
ON m.id = mt.media_id \
LEFT JOIN tag_tag t \
ON mt.tag_id = t.id \
LEFT JOIN auth_user u \
ON u.id = m.author_id \
LEFT JOIN mucua_mucua mu \
ON mu.id = m.origin_id \
WHERE (" + origin_sql + " repository_id = ? ) \
GROUP BY m.id " + term_sql
if not return_count:
sql += " ORDER BY " + ordering_sql
if len(limiting_params) >1:
sql += " LIMIT ?,?"
elif len(limiting_params) == 1:
sql += " LIMIT ?"
sql = sql.decode('utf-8')
params.extend(limiting_params)
medias = Media.objects.raw(sql, params)
""" sql log & params
logger.info('sql: ' + sql)
for i in params:
logger.info(i)
"""
# serializa e da saida
if (return_count):
response_count = {
'count': len(list(medias))
}
return HttpResponse(json.dumps(response_count), mimetype=u'application/json')
else:
serializer = MediaSerializer(medias, many=True)
return Response(serializer.data)
def media_detail(request, repository, mucua, pk=None, format=None):
"""
Retrieve, create, update or delete a media instance.
"""
# TODO: Use object permissions for more fine grained control.
# For now, do a more primitive check that the user is authenticated.
if request.method != 'GET' and not request.user.is_authenticated():
raise PermissionDenied
# pegando sessao por url
redirect_page = False
if mucua == 'rede':
mucua = request.DATA['origin']
try:
mucua = Mucua.objects.get(description=mucua)
except Mucua.DoesNotExist:
mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
redirect_page = True
try:
repository = Repository.objects.get(name=repository)
except Repository.DoesNotExist:
repository = Repository.objects.get(name=DEFAULT_REPOSITORY)
redirect_page = True
# redirect
if redirect_page:
return HttpResponseRedirect(redirect_base_url + repository.name +
'/' + mucua.description + '/media/')
author = request.user
# verifica se tem primary key definido antes de direcionar para os request.methods (get, put, post)
if pk:
# get media
try:
media = Media.objects.get(uuid=pk)
except Media.DoesNotExist:
return Response(status=status.HTTP_404_NOT_FOUND)
if request.method == 'GET':
# get media
if pk == '':
"""
get media
Se pk nao existe, chama token (preparacao para insercao) # TODO: mover?
"""
media_token(request, repository, mucua)
if pk != '':
serializer = MediaSerializer(media)
return Response(serializer.data)
elif request.method == 'PUT':
"""
update media
"""
if pk == '':
return HttpResponseRedirect(
redirect_base_url + repository.name + '/' +
mucua.description + '/bbx/search')
media.name = request.DATA['name']
media.note = request.DATA['note']
media.type = request.DATA['type']
media.license = request.DATA['license']
media.date = request.DATA['date']
# workaround for date problem
file_day = str(media.media_file).split('/')[-2]
date_day = str(media.date)[8:10]
if file_day != date_day:
media.date = media.date[0:8] + file_day + media.date[10:]
media.save()
if media.id:
tags = request.DATA['tags'].split(',')
media.tags.clear()
add_and_synchronize_tags(media, tags, mucua)
return Response(_("updated media - OK"),
status=status.HTTP_201_CREATED)
else:
return Response(_("error while creating media"),
status=status.HTTP_400_BAD_REQUEST)
if serializer.is_valid():
serializer.save()
return Response(serializer.data)
else:
return Response(serializer.errors,
status=status.HTTP_400_BAD_REQUEST)
elif request.method == 'POST':
"""
create a new media
"""
if request.DATA['author'] != '':
author = request.DATA['author']
else:
author = request.user
try:
author = User.objects.get(username=author)
except User.DoesNotExist:
author = User.objects.get(username=request.user)
try:
mucua = Mucua.objects.get(description=request.DATA['origin'])
except Mucua.DoesNotExist:
mucua = Mucua.objects.get(description=DEFAULT_MUCUA)
media = Media(repository=repository,
origin=mucua,
author=author,
note=request.DATA['note'],
type=request.DATA['type'],
license=request.DATA['license'],
name=request.DATA.get('name', ''),
date=(request.DATA['date'] if request.DATA['date'] !=
'' else get_now()),
uuid=generate_UUID()
)
logger.info('processing upload')
# multiple upload
for filename, file in request.FILES.iteritems():
file_name = request.FILES[filename].name
media.format=file_name.split('.')[-1].lower()
if media.name == '':
media.name = get_media_name_by_filename(file_name)
if hasattr(request.FILES[filename], 'temporary_file_path'):
# if file bigger than 2.5MB, is stored in /tmp
tmp_file = request.FILES[filename].temporary_file_path()
else:
# if lesser than 2.5MB, is stored on memory
tmp_file = '/tmp/' + media.uuid
f = open(tmp_file, 'w')
f.write(request.FILES[filename].read())
f.close()
media.type=get_media_type_by_filename(tmp_file)
if media.type == 'imagem':
media.media_file=handle_uploaded_image(media, tmp_file,request.FILES[filename])
else:
media.media_file=request.FILES[filename]
media.save()
if media.id:
# get tags by list or separated by ','
tags = request.DATA['tags'].split(',')
add_and_synchronize_tags(media, tags, mucua)
media.save() # salva de novo para chamar o post_save
serializer = MediaSerializer(media)
return Response(serializer.data, status=status.HTTP_201_CREATED)
else:
return Response(_("error while creating media"),
status=status.HTTP_400_BAD_REQUEST)
elif request.method == 'DELETE':
media.delete()
return Response(status=status.HTTP_204_NO_CONTENT)
from media.models import Media from media.serializers import MediaSerializer from rest_framework.renderers import JSONRenderer from rest_framework.parsers import JSONParser import StringIO media = Media(title='Video Beco 1') media.save() serializer = MediaSerializer(media) serializer.data content = JSONRenderer().render(serializer.data) content stream = StringIO.StringIO(content) data = JSONParser().parse(stream) serializer = MediaSerializer(data=data) serializer.is_valid() serializer.object