def structured(request):
group_list = request.user.groups.all().values_list('name', flat = True)
source_list = get_choice_data('Source', get_source_list())
if request.POST:
try:
source = request.POST.get('source')
db_name = request.POST.get('database')
table_name = request.POST.get('table')
query = request.POST.get('query')
response = []
if db_name:
db_list = get_choice_data('DB', get_database_list(source))
if table_name:
table_list = get_choice_data('Table', get_table_list(source, db_name))
query = "select * from %s limit 10;" %(table_name)
response = get_data(source, db_name, query)
triple_response = transform_to_triple(source, db_name, table_name, response)
except Exception as e:
response = "There is some error with the program for selected input please check\n\n%s" %(e)
source = str(source)
return render_to_response('converter/structured.html', locals(), context_instance=RequestContext(request))
def __init__(self, *args, **kwargs):
super(StructuredDataForm, self).__init__(*args, **kwargs)
choices = [('','Please select Source')]
choices.extend(get_source_list())
self.fields['source'].choices = choices
