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 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):
# 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 inscription(request):
inscription = None
if request.method == "POST":
form = forms.InscriptionForm(request.POST)
if form.is_valid():
username = form.cleaned_data["username"]
password = form.cleaned_data["password"]
email = form.cleaned_data["email"]
user = forms.models.User.objects.create_user(username,email,password)
directoryUser = "******"+username
document = Document(name=username,author=user,path=username,realPath=directoryUser,format="folder")
document.save()
profil = Profil(user=user,mainDocument=document)
profil.save()
inscription = True
if os.path.exists(directoryUser) == False:
os.mkdir(directoryUser)
return render(request,'index.html',locals())
form = forms.InscriptionForm()
return render(request,'inscription.html',locals())
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 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 add_folder(request):
post = request.POST["name_folder"]
nameOfFolder = json.loads(post)
id_parent = request.POST.get("id_parent", False)
if id_parent != False:
parent = json.loads(id_parent)
else:
parent = None
directoryUser = os.path.join(os.path.dirname(os.path.abspath(__file__)), "documents", request.user.username)
json_data = json.dumps({"response": False})
if os.path.exists(directoryUser):
iconFile = os.path.join("/static", "upload", "images", "closed_folder.png")
if parent != None and parent != "":
docParent = Document.objects.get(id=parent)
realPath = os.path.join(
os.path.dirname(os.path.abspath(__file__)), "documents", docParent.path, nameOfFolder
)
if os.path.exists(realPath) == False:
document = Document(
name=nameOfFolder,
author=request.user,
docContains=docParent,
path=os.path.join(docParent.path, nameOfFolder),
realPath=realPath,
icon=iconFile,
format="folder",
)
document.save()
os.mkdir(realPath)
json_data = json.dumps(
{"response": True, "name": document.name, "id": document.id, "icon": document.icon}
)
return HttpResponse(json_data, content_type="application/json")
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))
