Skip to main content

mysql operate

Project description

Info
====
`dbop 2018-08-10`

`Author: Zhao Mingming <471106585@qq.com>`

`Copyright: This module has been placed in the public domain.`

`version:0.0.0.1`
`version:0.0.0.2`
- `use zprint`: print log stderr and stdout

Classes:
- `dbop`: oprate the mysql db

Functions:

- `test()`: test function

How To Use This Module
======================
.. image:: funny.gif
:height: 100px
:width: 100px
:alt: funny cat picture
:align: center

1. example code:

.. code:: python
from dbop import dbop as dbop
#pool = PooledDB(MySQLdb,1,host='122.152.206.246',user='oco',passwd='MyNewPass4!',db='task_zmm',port=3306,charset='utf8')
#dbb0=dbop("122.152.206.246","oco","MyNewPass4!")
#db0l=dbb0.run("show databases;")
#print(db0l)
dbb=dbop("172.23.250.51","root","20180712")
dbl=dbb.run("show databases;")
#print dbb.run("use test0720")
#print dbb.run("desc test0720xml")
xml_num=0
jpg_num=0
for dbname in dbl:
if "fourgesture_detection_train" not in dbname[0]:
continue
#print dbname
sqlstr="use %s;"%(dbname[0])
dbb.run(sqlstr)
sqlstr="select count(*) from %sxml;"%(dbname[0])
rr=dbb.run(sqlstr)
xml_num+=dbb.getnum(rr)
xml_numtmp=dbb.getnum(rr)
sqlstr="select count(*) from %simg"%(dbname[0])
rr=dbb.run(sqlstr)
jpg_num+=dbb.getnum(rr)
jpg_numtmp=dbb.getnum(rr)
if xml_numtmp>0:
print dbname[0]
print "xmltmp:%d,jpgtmp:%s"%(xml_numtmp,jpg_numtmp)
print "xml:%d,jpg:%s"%(xml_num,jpg_num)
print dbb.help("sql")
#print len(dbl)
#print type(list(dbl))
#for db in dbl:
# print list(db)



Refresh
========



Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for dbop, version 0.0.0.2
Filename, size File type Python version Upload date Hashes
Filename, size dbop-0.0.0.2-py2.7.egg (8.6 kB) File type Egg Python version 2.7 Upload date Hashes View
Filename, size dbop-0.0.0.2-py2-none-any.whl (6.8 kB) File type Wheel Python version py2 Upload date Hashes View
Filename, size dbop-0.0.0.2.tar.gz (5.8 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page