A small database operation package
Project description
数据库操作有风险,请谨慎对待!一旦出现问题,阴阳亦爱莫能助。切记,勿忘。
import posql
myconn = posql.mysql(passwd='Ycode01')
myconn.select_table('default', 'test')
""" 增
myconn.sql(0).insert({'domain': 'www.baidu.com', 'position': 'start'})
"""
""" 删
myconn.sql(0).where('`id` > 7').delete()
"""
""" 改
myconn.sql(0).where('`id` = 7').update({'position': 'end'})
"""
""" 查
results = myconn.select()
print(results)
"""
"""
results = myconn.where('`id` = 1').sql(1).select()
print(results)
"""
"""
results = myconn.order(field='id').limit(5).select()
print(results)
"""
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
posql-0.1.2a0.tar.gz
(3.1 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file posql-0.1.2a0.tar.gz.
File metadata
- Download URL: posql-0.1.2a0.tar.gz
- Upload date:
- Size: 3.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/46.1.3 requests-toolbelt/0.9.1 tqdm/4.45.0 CPython/3.7.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
f7107737954c17d1e36bbef3ac53b8dd583d016531fa1b834ab2b3149ac177cf
|
|
| MD5 |
3ad6dd21e3f8070718ab769e855e5f4a
|
|
| BLAKE2b-256 |
892cfaf0f39366bef64cdf5aea451cd043e82f9bc9f1339e9ae4800356b92166
|
File details
Details for the file posql-0.1.2a0-py3-none-any.whl.
File metadata
- Download URL: posql-0.1.2a0-py3-none-any.whl
- Upload date:
- Size: 4.3 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/46.1.3 requests-toolbelt/0.9.1 tqdm/4.45.0 CPython/3.7.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
fb4365cb94ea2c264361234a0ec33a2f1be918beb189194c4a72fb6ed6041232
|
|
| MD5 |
93e55d303ae6df8e8ce09afcfc6eb230
|
|
| BLAKE2b-256 |
f6cf562fb0aba1a813b2452ae2db4c490b7782d3db0be0ae809e6724e5f8a2b2
|