make it easy to use pymysql
Project description
fastmysql
介绍
简单快速的使用mysql
软件架构
软件架构说明
安装教程
- pip安装
pip3 install fastmysql
- pip安装(使用淘宝镜像加速)
pip3 install fastmysql -i https://mirrors.aliyun.com/pypi/simple
使用说明
- demo
import fastmysql
query_res = fastmysql.query_table_all_data(
db_name='test',
tb_name='test'
)
# 获取建表语句
res = fastmysql.show_create_table(
db_name='test',
tb_name='test'
)
- 防止sql注入: 写法
cursor.execute('insert into user (name,password) value (?,?)',(name,password)) 或者
cursor.execute('insert into user (name,password) value (%s,%s)',(name,password)) %s与?都可以作为sql语句的占位符,它们作为占位符的功能是没有区别的,mysql.connector用 %s 作为占位符;pymysql用 ? 作为占位符。但是注意不要写成
cursor.execute('insert into user (name,password) value (?,?)'%(name,password)) 这种写法是直接将参数拼接到sql语句中,这样数据库就容易被sql注入攻击,比如
cursor.execute('select * from user where user=%s and password=%s'%(name,password)) 要是name和password都等于'a or 1=1',那么这个语句会把整个user表都查询出来
- 默认环境
- 默认使用的环境文件为:mysql.env
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
fastmysql-0.2.11.tar.gz
(16.4 kB
view hashes)
Built Distribution
fastmysql-0.2.11-py3-none-any.whl
(17.0 kB
view hashes)
Close
Hashes for fastmysql-0.2.11-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8bc107deffc5a0ae5e990667fd041c5fba65a0dfb4c156a7c1d9a23cf614121e |
|
MD5 | 38af35ab8d7e3c399f6d32c5bf9fb987 |
|
BLAKE2b-256 | 37ef2d275f1c4f80ce172e49e768adfe648f3d41a79599c39a1b25eb23c8f8f2 |