def analyze (request,recurso):
theParser = make_parser()
theHandler = myContentHandler()
theParser.setContentHandler(theHandler)
file = urllib2.urlopen( 'http://barrapunto.com/index.rss')
theParser.parse(file)
theHandler.htmlFile.close()
print "Parse complete"
if request.method == 'GET':
index = open("index.html","r")
html=index.read()
try:
record = Table.objects.get(resource=recurso)
return HttpResponse(record.name+"<ul>"+html.decode('utf-8')+"</ul>")
except Table.DoesNotExist:
return HttpResponseNotFound('Page not found:')
elif request.method == 'PUT':
record = Table(resource= recurso,name =request.body)
record.save()
return HttpResponse('<h1>Actualizando.../h1>'+ request.body)
def form(request):
if request.method == "POST":
try:
num = Table.objects.get(url=request.POST["nombre"]).id
return HttpResponse("La url cortada es :" + str(num))
except Table.DoesNotExist:
record = Table(url=request.POST["nombre"].replace(
'%3A', ':').replace('%2F', '/'))
record.save()
return HttpResponse(
"La url cortada es :" + "<a href=" +
Table.objects.get(url=request.POST["nombre"]).url + ">" +
str(Table.objects.get(url=request.POST["nombre"]).id) + "</a>")
form = ""
form += "<body><h1>Url Shortener </h1><form method=post>Escribe la url:<input type=text name= nombre value=http:// /> <br/><input type=submit value=Enviar /></form>"
contents = Table.objects.all()
respues = "<ul>"
for cont in contents:
print cont
respues += "<li> <a href=" + str(cont.id) + ">" + str(
cont.url) + "</a></li>"
respues += "</ul></body></html>"
return HttpResponse(form + respues)
def analyze(request, recurso):
salida = ""
if request.method == 'GET':
print str(request.user.is_authenticated())
try:
record = Table.objects.get(resource=recurso)
return HttpResponse(record.name)
except Table.DoesNotExist:
lista = Table.objects.all()
for fila in lista:
salida += "<ul><li> Recurso: " + str(
fila.resource) + "\r" + str(fila.name) + "</li></ul>"
return HttpResponseNotFound('<br>Recurso no disponible' + salida)
elif request.method == 'PUT':
print str(request.user.is_authenticated())
if request.user.is_authenticated():
record = Table(resource=recurso, name=request.body)
record.save()
return HttpResponse("<h1><p>Logged in as " +
request.user.username +
"</p>Actualizando.../h1>" + str(recurso) +
"......" + str(request.body))
else:
return HttpResponse("Not logged in" + "<a href=http://" +
request.get_host() + "/admin" + "> Log in</a>")
def analyze(request, recurso):
if request.method == 'GET':
try:
record = Table.objects.get(resource=recurso)
return HttpResponse(record.name)
except Table.DoesNotExist:
return HttpResponseNotFound('Page not found:')
elif request.method == 'PUT':
record = Table(resource=recurso, name=request.body)
record.save()
return HttpResponse('<h1>Actualizando.../h1>' + request.body)
def show_css (request,recurso):
if request.method == 'GET':
try:
record = Table.objects.get(resource=recurso)
return HttpResponse(record.name, content_type="text/css")
except Table.DoesNotExist:
return HttpResponseNotFound('Page not found:')
elif request.method == 'PUT':
record = Table(resource= recurso,name =request.body)
record.save()
return HttpResponse('<h1>Actualizando.../h1>'+ request.body)
def show_html(request,recurso):
if request.method == 'PUT':
pos_in= request.body.find("<body>")
pos_fin= request.body.find("</body>")
record = Table(resource= recurso,name =request.body[pos_in+7:pos_fin])
record.save()
return HttpResponse('<h1>Actualizando.../h1>'+ request.body)
elif request.method == 'GET':
try:
record = Table.objects.get(resource=recurso)
template = get_template("index.html")
return HttpResponse(template.render(Context({'body': record.name})))
except Table.DoesNotExist:
return HttpResponseNotFound('Page not found:')
def urls(request, resource):
if request.method == "GET":
list = Table.objects.filter(blog=resource)
if not list:
return notfound(request, resource)
out = " "
for i in list:
out += 'Blog \" ' + i.blog + ' \": '
out += "<a href=http://" + i.url + ">" + i.url + "</a>\n"
return HttpResponse(out)
elif request.method == "PUT":
new_blog = Table(blog=resource, url=request.body)
new_blog.save()
out = ("New blog added. ")
return HttpResponse(out)
else:
return HttpResponseForbidden
def addTable(request):
data = {}
data.update(csrf(request))
if request.method == 'POST': #jak wyslano formularza
form = AddTableForm(request.POST)
if form.is_valid(): #jak wszystko okej
#to pozmieniaj dane
newTable = Table();
newTable.maxClientsCount = form.cleaned_data['maxClients']
newTable.addedBy = request.user
newTable.save()
#informacje
data['information'] = 'Dodano stolik numer '+newTable.pk.__str__()
data['back']='../'
return render_to_response('info.html',data)
else:
form = AddTableForm()
data['form'] = form
return render_to_response('addTable.html',data)
def form(request):
if request.method == "GET":
out = ""
form = '<form action="" method="POST">'
form += 'URL a acortar: <input type="text" name="real_url">'
form += '<input type="submit" value="Enviar">'
form += '</form>'
out += form
list = Table.objects.all()
if list:
out += "The previous searches are: "
out += "<html><body><ul>\n"
for i in list:
out += "<li><a href=" + str(i.id) + ">"
out += i.real_url + "</a></li>\n"
out += "</ul></body></html>"
else:
out += "There are no previous searches on this page"
out += "</ul></body></html>"
return HttpResponse(out)
elif request.method == "PUT" or request.method == "POST":
out = ""
url = request.body
url = url.split("real_url=")[1]
if url == "":
return HttpResponseBadRequest("Empty url")
elif not url.startswith("http://") and not url.startswith("https://"):
url = "http://" + url
else:
url = url.split("%3A%2F%2F")[0]
try:
new = Table.objects.get(real_url=request.body)
except Table.DoesNotExist:
new = Table(real_url=url)
new.save()
out += ("<html><body>" + "URL buscada: "
+ "<a href=" + url + ">" + url + "</href></br>"
+ "URL acortada: " + "<a href=" + str(new.id) + ">"
+ str(new.id) + "</href></br>" + "</body></html>")
return HttpResponse(out)
def form(request):
if request.method == "GET":
out = ""
form = '<form action="" method="POST">'
form += 'URL a acortar: <input type="text" name="real_url">'
form += '<input type="submit" value="Enviar">'
form += '</form>'
out += form
list = Table.objects.all()
if list:
out += "The previous searches are: "
out += "<html><body><ul>\n"
for i in list:
out += "<li><a href=" + str(i.id) + ">"
out += i.real_url + "</a></li>\n"
out += "</ul></body></html>"
else:
out += "There are no previous searches on this page"
out += "</ul></body></html>"
return HttpResponse(out)
elif request.method == "PUT" or request.method == "POST":
out = ""
url = request.body
url = url.split("real_url=")[1]
if url == "":
return HttpResponseBadRequest("Empty url")
elif not url.startswith("http://") and not url.startswith("https://"):
url = "http://" + url
else:
url = url.split("%3A%2F%2F")[0]
try:
new = Table.objects.get(real_url=request.body)
except Table.DoesNotExist:
new = Table(real_url=url)
new.save()
out += ("<html><body>" + "URL buscada: " + "<a href=" + url + ">" +
url + "</href></br>" + "URL acortada: " + "<a href=" +
str(new.id) + ">" + str(new.id) + "</href></br>" +
"</body></html>")
return HttpResponse(out)
def newtable(request):
if request.method == 'POST': # If the form has been submitted...
# ContactForm was defined in the the previous section
form = NewTableForm(request.POST) # A form bound to the POST data
if form.is_valid(): # All validation rules pass
# Process the data in form.cleaned_data
# ...
newTableEntry = Table(currentUsers=1, tableLimit=form.cleaned_data['tableLimit'], tableBlind=form.cleaned_data['tableBlind'] )
newTableEntry.save()
args = RequestContext(request)
args['user']= request.user
return redirect( '/tables/'+ str(newTableEntry.id));
else:
form = NewTableForm() # An unbound form
return render(request, 'createTable.html', {
'form': form,
})
def form(request):
if request.method == "POST":
try:
num = Table.objects.get(url=request.POST["nombre"]).id
return HttpResponse("La url cortada es :"+str(num))
except Table.DoesNotExist:
record = Table(url= request.POST["nombre"].replace('%3A',':').replace('%2F','/'))
record.save()
return HttpResponse("La url cortada es :" +"<a href="+Table.objects.get(url=request.POST["nombre"]).url +">"+str(Table.objects.get(url=request.POST["nombre"]).id)+"</a>")
form=""
form+="<body><h1>Url Shortener </h1><form method=post>Escribe la url:<input type=text name= nombre value=http:// /> <br/><input type=submit value=Enviar /></form>"
contents=Table.objects.all()
respues="<ul>"
for cont in contents:
print cont
respues+="<li> <a href="+str(cont.id)+">"+str(cont.url)+"</a></li>"
respues+="</ul></body></html>"
return HttpResponse(form+respues)
def urls(request, resource):
if request.method == "GET":
list = Table.objects.filter(blog=resource)
if not list:
return notfound(request, resource)
out = " "
for i in list:
out += 'Blog \" ' + i.blog + ' \": '
out += "<a href=http://" + i.url + ">" + i.url + "</a>\n"
out += login_message(request)
return HttpResponse(out)
elif request.method == "PUT":
if request.user.is_authenticated():
new_blog = Table(blog=resource, url=request.body)
new_blog.save()
out = ("New blog added. ")
else:
out = ("You must log in.")
out += login_message(request)
return HttpResponse(out)
else:
return HttpResponseForbidden
def newtable(request):
if request.method == 'POST': # If the form has been submitted...
# ContactForm was defined in the the previous section
form = NewTableForm(request.POST) # A form bound to the POST data
if form.is_valid(): # All validation rules pass
# Process the data in form.cleaned_data
# ...
newTableEntry = Table(currentUsers=1,
tableLimit=form.cleaned_data['tableLimit'],
tableBlind=form.cleaned_data['tableBlind'])
newTableEntry.save()
args = RequestContext(request)
args['user'] = request.user
return redirect('/tables/' + str(newTableEntry.id))
else:
form = NewTableForm() # An unbound form
return render(request, 'createTable.html', {
'form': form,
})
def json2schema(schema_json, commit = True, destdb = None):
"""
Creates Database, Table, and Column objects as needed to satisfy the incoming schema.
If the table is already present, assume we are updating: delete all columns and recreate from the schema.
Unless commit is false, call the required sql to create the incoming tables in the destination database.
"""
schema = json.loads(schema_json)
for dbname, table_schema in schema.iteritems():
if destdb:
dbname = destdb
try:
db = Database.objects.get(name=dbname)
except Database.DoesNotExist:
db = Database(name=dbname)
db.save()
for tablename, column_schema in table_schema.iteritems():
try:
table = Table.objects.get(db=db, name=tablename)
for column in Column.objects.filter(table=table):
column.delete()
except Table.DoesNotExist:
table = Table(db=db, name=tablename)
table.save()
for columnname, columntype in column_schema.iteritems():
column = Column(table=table, name=columnname, type=columntype)
column.save()
if commit:
model = ModelGenerator.getModel(dbname, tablename)
cursor = connections[dbname].cursor()
for sql in ModelGenerator.getSQL(model):
cursor.execute(sql)
return None
def analyze (request,recurso):
salida =""
if request.method == 'GET':
print str(request.user.is_authenticated())
try:
record = Table.objects.get(resource=recurso)
return HttpResponse(record.name)
except Table.DoesNotExist:
lista=Table.objects.all()
for fila in lista:
salida += "<ul><li> Recurso: "+str(fila.resource)+"\r"+str(fila.name)+"</li></ul>"
return HttpResponseNotFound('<br>Recurso no disponible'+salida)
elif request.method == 'PUT':
print str(request.user.is_authenticated())
if request.user.is_authenticated():
record = Table(resource= recurso,name =request.body)
record.save()
return HttpResponse("<h1><p>Logged in as " + request.user.username+"</p>Actualizando.../h1>"+ str(recurso)+"......"+str(request.body))
else:
return HttpResponse("Not logged in"+"<a href=http://"+request.get_host()+"/admin"+"> Log in</a>")
