Home  >  Article  >  Backend Development  >  Python developmenttorndb

Python developmenttorndb

大家讲道理
大家讲道理Original
2017-05-28 10:02:471701browse

Torndb module

 Summary: torndb is a lightweight module based on MySQLdb encapsulation. Is part of the tornadoframework. Its project homepage is: https://github.com/bdarnell/torndb. Since tornado version 3.0, it has been released as an independent module. You can install directly through easy_install or pip.

1, Connect to the database


##

# 创建连接
import torndb
# 数据库、账号、密码、时区
db = torndb.Connection("192.168.1.134:3306",'Jefrey',user='lzl',password='123456',time_zone='+8:00')


Supplement:

2 ,Create data table


# 创建
create='create table blog(id int,content text)'
db.execute(create)


##3、Insert data

#①

、execute

# 插入execute
# execute='insert into blog(id,content)values(%d,"%s")'%(7,'Jefrey5')
# db.execute(execute)



、insert##

# 单条insert
insert =  'insert into blog(id,content)values(%s,%s)'
db.insert(insert,10,'Jefrey10')



、insertmany

# insertmany
insertmany =  'insert into blog(id,content)values(%s,%s)'
db.insertmany(insert,[[11,'Jefrey11'],[12,'Jefrey12']])


 


4,

query

data

、query query

# Query查询
sql = &#39;SELECT * FROM blog WHERE content = %s AND id < %s&#39;
# 查询到一条数据时为列表
database = db.query(sql, &#39;Jefrey&#39;, 11)
# [{&#39;content&#39;: u&#39;Jefrey&#39;, &#39;id&#39;: 1L}]

# 查询到多条数据为也为列表
database5 = db.query(sql, &#39;Jefrey5&#39;, 11)
# [{&#39;content&#39;: u&#39;Jefrey5&#39;, &#39;id&#39;: 5L}, {&#39;content&#39;: u&#39;Jefrey5&#39;, &#39;id&#39;: 8L}, {&#39;content&#39;: u&#39;Jefrey5&#39;, &#39;id&#39;: 7L}]

# 查询数据不存在时为空列表
database10 = db.query(sql, &#39;Jefrey10&#39;, 11)
# []


##②
、get query

# Get查询
sql = &#39;SELECT * FROM blog WHERE content = %s AND id < %s&#39;
# 查询到一条数据时为字典
database = db.get(sql, &#39;Jefrey&#39;, 11)
# {&#39;content&#39;: u&#39;Jefrey&#39;, &#39;id&#39;: 1L}

# 查询到多条数据时报错
database5 = db.get(sql, &#39;Jefrey5&#39;, 11)
# Exception: Multiple rows returned for Database.get() query

# 查询数据不存在时为None
database10 = db.get(sql, &#39;Jefrey10&#39;, 11)
# None


 


The above is the detailed content of Python developmenttorndb. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn