Skip to main content

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


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)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

posql-0.1.2a0-py3-none-any.whl (4.3 kB view details)

Uploaded Python 3

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

Hashes for posql-0.1.2a0.tar.gz
Algorithm Hash digest
SHA256 f7107737954c17d1e36bbef3ac53b8dd583d016531fa1b834ab2b3149ac177cf
MD5 3ad6dd21e3f8070718ab769e855e5f4a
BLAKE2b-256 892cfaf0f39366bef64cdf5aea451cd043e82f9bc9f1339e9ae4800356b92166

See more details on using hashes here.

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

Hashes for posql-0.1.2a0-py3-none-any.whl
Algorithm Hash digest
SHA256 fb4365cb94ea2c264361234a0ec33a2f1be918beb189194c4a72fb6ed6041232
MD5 93e55d303ae6df8e8ce09afcfc6eb230
BLAKE2b-256 f6cf562fb0aba1a813b2452ae2db4c490b7782d3db0be0ae809e6724e5f8a2b2

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page