def list(request):
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
if form.is_valid():
newdoc = Document(docfile = request.FILES['docfile'])
newdoc.save()
newdoc = newdoc.docfile.name
newdoc = str(newdoc)
wb = xlrd.open_workbook(newdoc)
sh = wb.sheet_by_index(0)
c = 1
while c < len(sh.col(0)):
first = sh.col_values(0)[c]
second = sh.col_values(1)[c]
x = db.cursor()
db.set_character_set('utf8')
x.execute('SET NAMES utf8;')
x.execute('SET CHARACTER SET utf8;')
x.execute('SET character_set_connection=utf8;')
x.execute("INSERT INTO testcont_content(title, description) VALUES('%s','%s');"%(first,second))
db.commit()
c=c+1
# Redirect to the document list after POST
return HttpResponseRedirect(reverse('upload.views.list'))
else:
form = DocumentForm() # A empty, unbound form
# Load documents for the list page
documents = Document.objects.all()
# Render list page with the documents and the form
return render_to_response(
'upload/list.html',
{'documents': documents, 'form': form, 'test': test,},
context_instance=RequestContext(request)
)
def post(self, request, *args, **kwargs):
form = DocumentForm(request.POST, request.FILES, auto_id=False)
if form.is_valid():
form.save()
documents = Document.objects.last()
createAndInsert(documents.document) # document를 추가하는 비지니스로직 수행
return redirect(self.success_url)
else:
return render(request, self.template_name, {'form': form})
def list(request):
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
if form.is_valid():
form.save()
return HttpResponseRedirect(reverse('upload.views.list'))
else:
form = DocumentForm()
documents = Document.objects.all()
return render_to_response(
'upload/list.html',
{'documents': documents, 'form': form},
context_instance=RequestContext(request)
)
def list(request):
# Handle file upload
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
if form.is_valid():
newdoc = Document(docfile=request.FILES['docfile'])
newdoc.save()
# Redirect to the document list after POST
return HttpResponseRedirect(reverse('list'))
else:
form = DocumentForm() # A empty, unbound form
# Load documents for the list page
documents = Document.objects.all()
# Render list page with the documents and the form
return render(request, 'list.html', {'documents': documents, 'form': form})
def model_form_upload(request):
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
if form.is_valid():
form.save()
return redirect('/')
else:
form = DocumentForm()
return render(request, 'upload/model_form_upload.html', {'form': form})
def list(request):
# Handle file upload
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
if form.is_valid():
newdoc = Document(docfile=request.FILES['docfile'])
newdoc.save()
# Redirect to the document list after POST
return HttpResponseRedirect(reverse('upload.views.list'))
else:
form = DocumentForm() # A empty, unbound form
# Load documents for the list page
documents = Document.objects.all()
# Render list page with the documents and the form
return render_to_response(
'upload/list.html',
{'documents': documents, 'form': form},
context_instance=RequestContext(request)
)
def home(request):
global location
userInput = UserInputForm
if 'import' in request.POST:
newdoc = Document(docfile = request.FILES['upload'])
newdoc.save()
location = newdoc.path()
# creating S3 bucket connection
conn = boto.connect_s3('AKIAIJZ56E33VC2GBG3Q', 'xfSWxuK9uGAsRwtwdJgIPBhiye0Z3ka5oRqRa8FD')
bucket = conn.create_bucket('client1.bucket')
k = Key(bucket)
filename = str(request.FILES['upload'])
filenameKey = re.sub('\.txt$', '', filename)
print filenameKey
k.key = filenameKey
k.set_contents_from_filename(location)
return HttpResponseRedirect(reverse('upload.views.home'))
else:
form = DocumentForm() # An empty, unbound form
if 'user_input' in request.POST:
form = UserInputForm(request.POST)
if form.is_valid():
form.save()
myfile = open(os.path.dirname(os.path.abspath(upload.__file__))+ "/media/Watchlists/userinput.txt", 'a')
myfile.write(request.POST['keyword'] + "\n")
myfile.close()
location = os.path.dirname(os.path.abspath(upload.__file__))+ "/media/Watchlists/userinput.txt"
conn = boto.connect_s3('AKIAIJZ56E33VC2GBG3Q', 'xfSWxuK9uGAsRwtwdJgIPBhiye0Z3ka5oRqRa8FD')
bucket = conn.create_bucket('client1.bucket')
k = Key(bucket)
filenameKey = "userinput"
print filenameKey
k.key = filenameKey
k.set_contents_from_filename(location)
return HttpResponseRedirect(reverse('upload.views.home'))
else:
form = UserInputForm()
# Load documents for the list page
documents = Document.objects.all()
# Rendner list page with the documents and the form
return render_to_response(
'upload/parallax.html',
{'documents': documents, 'form' : form, 'userInput' : userInput},
context_instance = RequestContext(request)
)
def list(request):
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
if form.is_valid():
newdoc = Document(docfile=request.FILES['docfile'])
newdoc.save()
newdoc = newdoc.docfile.name
newdoc = str(newdoc)
wb = xlrd.open_workbook(newdoc)
sh = wb.sheet_by_index(0)
c = 1
while c < len(sh.col(0)):
first = sh.col_values(0)[c]
second = sh.col_values(1)[c]
x = db.cursor()
db.set_character_set('utf8')
x.execute('SET NAMES utf8;')
x.execute('SET CHARACTER SET utf8;')
x.execute('SET character_set_connection=utf8;')
x.execute(
"INSERT INTO testcont_content(title, description) VALUES('%s','%s');"
% (first, second))
db.commit()
c = c + 1
# Redirect to the document list after POST
return HttpResponseRedirect(reverse('upload.views.list'))
else:
form = DocumentForm() # A empty, unbound form
# Load documents for the list page
documents = Document.objects.all()
# Render list page with the documents and the form
return render_to_response('upload/list.html', {
'documents': documents,
'form': form,
'test': test,
},
context_instance=RequestContext(request))
def model_form_upload(request):
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
if form.is_valid():
form.save()
documents = Document.objects.last() # 가장 최근에 삽입한 오브젝트 로드
createAndInsert(documents.document) # 테이블 생성 및 튜플 삽입
return redirect('form_upload.html')
else:
form = DocumentForm()
return render(request, 'form_upload.html', {'form': form})
def model_form_upload(request):
last_five = Document.objects.all().order_by('-id')[:5]
for one in last_five:
filepath = os.path.join('resultfiles', one.md5sum + '.json')
if os.path.exists(filepath):
one.status = "Ready"
else:
one.status = "NotReady"
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
if form.is_valid():
model_instance = form.save()
try:
apk = Document.objects.get(md5sum=model_instance.md5sum)
except Document.DoesNotExist:
model_instance.save()
apk = model_instance
return render(request, 'index.html', {
'unique_id': apk.unique_id,
'last_five': last_five
})
else:
form = DocumentForm()
error = "Please upload valid apk file"
return render(
request, 'index.html', {
'form': form,
'unique_id': '',
'error': error,
'last_five': last_five
})
else:
form = DocumentForm()
return render(request, 'index.html', {
'form': form,
'unique_id': '',
'last_five': last_five
})
def upload(request):
if request.user.is_authenticated:
# Is it better to use @login_required ?
username = request.user.username
print(username)
with connection.cursor() as cursor:
query = """SELECT file FROM public.upload_document where username_id in (SELECT id FROM public.auth_user where
username = username) ; """
cursor.execute(query)
row = cursor.fetchone()
print(row)
else:
username = ''
if request.method == 'POST':
form = DocumentForm(request.POST, request.FILES)
if form.is_valid():
form.instance.user = username
doc = form.save()
file_url = doc.file.url
print(file_url)
return redirect('upload_list')
else:
form = DocumentForm()
return render(request, 'upload/upload.html', {"form": form})
def home(request):
global location
userInput = UserInputForm
if 'import' in request.POST:
newdoc = Document(docfile=request.FILES['upload'])
newdoc.save()
location = newdoc.path()
# creating S3 bucket connection
conn = boto.connect_s3('AKIAIJZ56E33VC2GBG3Q',
'xfSWxuK9uGAsRwtwdJgIPBhiye0Z3ka5oRqRa8FD')
bucket = conn.create_bucket('client1.bucket')
k = Key(bucket)
filename = str(request.FILES['upload'])
filenameKey = re.sub('\.txt$', '', filename)
print filenameKey
k.key = filenameKey
k.set_contents_from_filename(location)
return HttpResponseRedirect(reverse('upload.views.home'))
else:
form = DocumentForm() # An empty, unbound form
if 'user_input' in request.POST:
form = UserInputForm(request.POST)
if form.is_valid():
form.save()
myfile = open(
os.path.dirname(os.path.abspath(upload.__file__)) +
"/media/Watchlists/userinput.txt", 'a')
myfile.write(request.POST['keyword'] + "\n")
myfile.close()
location = os.path.dirname(os.path.abspath(
upload.__file__)) + "/media/Watchlists/userinput.txt"
conn = boto.connect_s3('AKIAIJZ56E33VC2GBG3Q',
'xfSWxuK9uGAsRwtwdJgIPBhiye0Z3ka5oRqRa8FD')
bucket = conn.create_bucket('client1.bucket')
k = Key(bucket)
filenameKey = "userinput"
print filenameKey
k.key = filenameKey
k.set_contents_from_filename(location)
return HttpResponseRedirect(reverse('upload.views.home'))
else:
form = UserInputForm()
# Load documents for the list page
documents = Document.objects.all()
# Rendner list page with the documents and the form
return render_to_response('upload/parallax.html', {
'documents': documents,
'form': form,
'userInput': userInput
},
context_instance=RequestContext(request))