def create(request):
if request.method == "POST":
title = request.POST['title'] # title是指從表單接收到的ID名稱
content = request.POST['content'] # content是指從表單接收到的ID名稱
with connection.cursor() as cursor:
sql = """insert into pm25(title,content,pudDateTime)values(%s,%s,%s)"""
cursor.execute(sql,
(title, content, srt(datetime.now()))) #執行上行SQL語法
return redirect('/') # 新增完成後傳回給redirect函式
return render(
request,
'create.html') # if函式使用!! 如果不是POST傳送過來呼叫轉送至Templates/Cerate.html
def update(request, id=None):
if request.method == "POST":
with connection.cursor() as cursor:
sql = """update pm25.pm25 set title=%s, contnet=%s where id=%s"""
cursor.execute(sql, (title, contnet, num))
return redirect('/')
with connection.cursor() as cursor:
sql = """select * from pm25 where id=%s"""
cursor.execute(sql, (num, ))
row = cursor.fetchone()
return render(request, 'edit.html', {'pm25': d})
def update(request, id=None):
if request.method == "POST":
with connection.cursor() as cursor:
sql = """update article_article set title=%s, contnet=%s where id=%s"""
cursor.execute(sql, (title, contnet, id))
return redirect('/')
with connection.cursor() as cursor:
sql = """select * from article_article where id=%s"""
cursor.execute(sql, (id, ))
row = cursor.fetchone()
return render(request, 'edit.html', {'article': d})
def get_random_ip(self):
random_sql_ip = '''
SELECT ip,port FROM proxy_ip
ORDER BY RAND()
LIMIT 1
'''
result = cursor.execute(random_sql_ip)
for ip_info in cursor.fetchall():
ip = ip_info[0]
port = ip_info[1]
judge_result = self.judge_ip(ip, port)
if judge_result:
return 'http://{0}{1}'.format(ip, port)
else:
return self.get_random_ip()
def delete(request, id):
with connection.cursor() as cursor:
sql = """delete from pm25 where num=%s"""
cursor.execute(sql, (num, ))
return redirect('/')
def index(request):
with connection.cursor() as cursor:
cursor.execute("select * form pm25") #select * form articles
row = cursor.fetchall()
return render(request, index.html, {'datas': pm25}) # 原本{'datas':articles}
def delete(request, id):
with connection.cursor() as cursor:
sql = """delete from article_article where id=%s"""
cursor.execute(sql, (id, ))
return redirect('/')