def sqlitetest (txt, footer):
cx = sqlite3.connect ("D: \ Python-Test \ StuProject \ db.sqlite3")
cu = cx.cursor ()
#sql = '' 'insert into' comment_comment '(txt,' footer ') values (\ "% s \", \ "% s \");' ''% (pymysql.escape_string (txt), pymysql.escape_string (footer)) # string insert string sql
sql = ‘‘ ‘‘ insert into ‘comment_comment’ (txt, ‘footer’) values (\ "% s \", \ "% s \"); ‘‘ ‘% (txt, footer) # string insert string sql
try:
cu.execute (sql)
cx.commit ()
except Exception as e:
with open ("D: \ Python-Test \ StuProject \ dblog.txt", ‘a +‘) as f:
log = ‘‘ ‘Error executing SQL:% s \ n Output:% s’ ‘% (e, sql)
# f.write (log)
pass
print (cu)
++++++++++++++++++++++++++++++++++++++++++++++++++ ++
cur_page = 1
def net163 (request):
global cur_page # Handle error local variable ‘cur_page1’ referenced before assignment
try:
#cur_page = int (request.GET.get (‘cur_page’, ‘1‘)) # Jump page number
if request.POST:
cur_page = int (request.POST [‘num‘])
elif request.GET:
cur_page = int (request.GET [‘cur_page’])
else:
print ("Data transmission error")
except ValueError:
cur_page = 1
pagination = Pagination.create_pagination (
from_name = ‘comment.models’,
model_name = ‘comment’,
cur_page = cur_page,
start_page_omit_symbol = ‘...’,
end_page_omit_symbol = ‘...’,
one_page_data_size = 30, # Number of pages displayed
show_page_item_len = 10) #Number of pages
return render (request, ‘Net163.html’, {‘pagination’: pagination})
Python connects to SQLite database and Django gets receive HTML data