python django 原生sql 获取数据的例子
作者:zhaoyangjian724 时间:2023-02-16 18:35:02
如下所示:
node2:/django/mysite/blog#cat views.py
1,
# -*- coding: utf-8 -*-
from __future__ import unicode_literals
# from django.shortcuts import render, render_to_response
from .models import *
# Create your views here.
from django.http import HttpResponse
from django.template import loader
import MySQLdb
def query():
conn= MySQLdb.connect(
host='localhost',
port = 3306,
user='root',
passwd='1234567',
db ='tlcb',
)
cur = conn.cursor()
a=cur.execute("select title,body, DATE_FORMAT(timestamp,'%Y~%m~%d %k.%i.%s') A from blog_blogpost")
info = cur.fetchall()
return info
cur.close()
conn.close()
def archive(req):
print 'aaaaaaaaaaaaaaaaaaaaaaaaaaa'
print req
print type(req)
print req.GET
print '#############################'
print req.GET['aa']
print req.GET['cc']
print '#############################'
print 'aaaaaaaaaaaaaaaaaaaaaaaaaaa'
# get all blogpost objects
posts =query()
print posts
print type(posts)
#print blog_list
template = loader.get_template('archive.html')
context = {
'posts':posts
}
print '------------------------------------------'
print HttpResponse(template.render(context, req))
print '------------------------------------------'
return HttpResponse(template.render(context, req))
node2:/django/mysite/blog#
node2:/django/mysite/blog/templates#vi archive.html
node2:/django/mysite/blog/templates#
node2:/django/mysite/blog/templates#
node2:/django/mysite/blog/templates#
node2:/django/mysite/blog/templates#cat archive.html
{% extends "base.html" %}
{% block content %}
{% for post in posts %}
<h2>{{ post.0 }}</h2>
<p>{{ post.1 | date:"1,F jS"}}</p>
<p>{{ post.2 }}</p>
{% endfor %}
{% endblock %}
(('dd', 'ddd', '2017~11~24 8.31.42'), ('66666666', '66666', '2017~11~24 8.35.25'), ('777777777', '77777777777', '2017~11~27 1.46.15'))
<type 'tuple'>
在自定义 model 方法和模块级方法里,你可以自由的执行自定义SQL语句. 对象 django.db.connection 表示当前的数据库连接. 调用connection.cursor() 得到一个游标对象. 然后调用 cursor.execute(sql, [params])``以执行 SQL 语句, 使用 ``cursor.fetchone() 或cursor.fetchall() 得到结果集. 下面是一个例子:
def my_custom_sql(self):
from django.db import connection
cursor = connection.cursor()
cursor.execute("SELECT foo FROM bar WHERE baz = %s", [self.baz])
row = cursor.fetchone()
return row
如果你的SQL语句改变了数据库中的数据 -- 比如你使用了 DELETE 或 UPDATE 语句. 你需要调用 connection.commit() 来使你的修改生效.
例子:
def my_custom_sql2(self):
from django.db import connection
cursor = connection.cursor()
cursor.execute("DELETE FROM bar WHERE baz = %s", [self.baz])
connection.commit()
来源:https://blog.csdn.net/zhaoyangjian724/article/details/78657346
标签:python,django,原生sql,数据
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
常用python数据类型转换函数总结
2023-07-27 23:07:16
escape解决AJAX中文乱码的简单方法
2008-10-23 14:32:00
Python中获取图片的大小问题
2022-11-08 21:43:23
浅谈Python中range和xrange的区别
2021-04-18 14:52:13
oracle 触发器 实现出入库
2009-07-23 14:56:00
在ASP.NET 2.0中操作数据之二十七:创建自定义排序用户界面
2023-06-25 21:01:05
![](https://img.aspxhome.com/file/2023/0/76350_0s.png)
python判断字符串是否是json格式方法分享
2023-01-02 20:50:37
centos下yum搭建安装linux+apache+mysql+php环境教程
2023-11-14 01:04:39
Pytest+request+Allure实现接口自动化框架
2023-08-12 17:29:33
![](https://img.aspxhome.com/file/2023/7/64297_0s.jpg)
SQL Server 2000数据库FOR XML查询概述
2008-12-09 14:49:00
仿淘宝网站的导航标签效果!
2008-11-05 12:37:00
![](https://img.aspxhome.com/file/UploadPic/up/2008110512540282.gif)
python中实现php的var_dump函数功能
2023-11-16 07:11:04
![](https://img.aspxhome.com/file/2023/2/101712_0s.jpg)
Numpy对于NaN值的判断方法
2022-12-15 15:08:21
![](https://img.aspxhome.com/file/2023/2/75282_0s.png)
浅谈Python协程asyncio
2021-01-12 21:30:32
php中正则替换函数ereg_replace用法实例
2023-06-13 03:03:51
PHP安全的URL字符串base64编码和解码
2023-09-06 22:04:45
优化MySQL数据库性能的八大“妙手”
2007-11-18 14:49:00
多栏自适应布局问题浅谈
2010-08-16 12:56:00
![](https://img.aspxhome.com/file/UploadPic/20108/16/two_column_layout-58s.png)
python如何编写win程序
2022-12-09 11:48:38
![](https://img.aspxhome.com/file/2023/6/76856_0s.png)
用Assets 面板为你的站点定做颜色
2007-02-03 11:39:00