{ "info": { "author": "zhaomingming", "author_email": "13271929138@163.com", "bugtrack_url": null, "classifiers": [], "description": "Info\n====\n`dbop 2018-08-10`\n\n`Author: Zhao Mingming <471106585@qq.com>`\n\n`Copyright: This module has been placed in the public domain.`\n\n`version:0.0.0.1`\n`version:0.0.0.2`\n- `use zprint`: print log stderr and stdout \n\nClasses:\n- `dbop`: oprate the mysql db \n\nFunctions:\n\n- `test()`: test function \n\nHow To Use This Module\n======================\n.. image:: funny.gif\n :height: 100px\n :width: 100px\n :alt: funny cat picture\n :align: center\n\n1. example code:\n\n.. code:: python\nfrom dbop import dbop as dbop\n #pool = PooledDB(MySQLdb,1,host='122.152.206.246',user='oco',passwd='MyNewPass4!',db='task_zmm',port=3306,charset='utf8')\n #dbb0=dbop(\"122.152.206.246\",\"oco\",\"MyNewPass4!\")\n #db0l=dbb0.run(\"show databases;\")\n #print(db0l)\n dbb=dbop(\"172.23.250.51\",\"root\",\"20180712\")\n dbl=dbb.run(\"show databases;\") \n #print dbb.run(\"use test0720\")\n #print dbb.run(\"desc test0720xml\")\n xml_num=0\n jpg_num=0\n for dbname in dbl:\n if \"fourgesture_detection_train\" not in dbname[0]:\n continue\n #print dbname\n sqlstr=\"use %s;\"%(dbname[0])\n dbb.run(sqlstr) \n sqlstr=\"select count(*) from %sxml;\"%(dbname[0])\n\trr=dbb.run(sqlstr) \n xml_num+=dbb.getnum(rr)\n xml_numtmp=dbb.getnum(rr)\n sqlstr=\"select count(*) from %simg\"%(dbname[0])\n\trr=dbb.run(sqlstr) \n jpg_num+=dbb.getnum(rr)\n jpg_numtmp=dbb.getnum(rr)\n if xml_numtmp>0:\n print dbname[0]\n\t print \"xmltmp:%d,jpgtmp:%s\"%(xml_numtmp,jpg_numtmp)\n\t print \"xml:%d,jpg:%s\"%(xml_num,jpg_num)\n print dbb.help(\"sql\") \n #print len(dbl)\n #print type(list(dbl))\n #for db in dbl:\n # print list(db)\n\n\n\nRefresh\n========\n\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://www.zhaomingming.cn", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "dbop", "package_url": "https://pypi.org/project/dbop/", "platform": "any", "project_url": "https://pypi.org/project/dbop/", "project_urls": { "Homepage": "http://www.zhaomingming.cn" }, "release_url": "https://pypi.org/project/dbop/0.0.0.2/", "requires_dist": [ "check-manifest; extra == 'dev'", "coverage; extra == 'test'" ], "requires_python": "", "summary": "mysql operate", "version": "0.0.0.2" }, "last_serial": 4202445, "releases": { "0.0.0.1": [ { "comment_text": "", "digests": { "md5": "16d6aa5ea7ee87aaebb5c4f1a47a9434", "sha256": "2528030885efe8e1e839add3cd612aa76aec4f63f3a27fbc3811827c08c0d2ca" }, "downloads": -1, "filename": "dbop-0.0.0.1-py2.7.egg", "has_sig": false, "md5_digest": "16d6aa5ea7ee87aaebb5c4f1a47a9434", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 8462, "upload_time": "2018-08-10T13:27:02", "url": "https://files.pythonhosted.org/packages/06/75/7a69821ad8af355c309bf1f526b144ea4e457a10ada64f36b51eb34ebc97/dbop-0.0.0.1-py2.7.egg" }, { "comment_text": "", "digests": { "md5": "880287140da7667cea5f7c4cfd2b94aa", "sha256": "ff95967b11fa752305995a59106004dba32d9b73639a0be4aa1fedf832e96da7" }, "downloads": -1, "filename": "dbop-0.0.0.1-py2-none-any.whl", "has_sig": false, "md5_digest": "880287140da7667cea5f7c4cfd2b94aa", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 6718, "upload_time": "2018-08-10T13:27:00", "url": "https://files.pythonhosted.org/packages/cb/90/66320fb6ba55bca2075daf2cac50efa2c182bde466a1aff1ec97846a1731/dbop-0.0.0.1-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0aac0c5fb939aa2e58197e969309e251", "sha256": "8437c831d13084a15234162508c578bcb1da2778b4dc22e342c1e834aa568af9" }, "downloads": -1, "filename": "dbop-0.0.0.1.tar.gz", "has_sig": false, "md5_digest": "0aac0c5fb939aa2e58197e969309e251", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5736, "upload_time": "2018-08-10T13:27:03", "url": "https://files.pythonhosted.org/packages/12/74/ece2df0787796807377eb58d359343473108707a85b33f22438228ba503b/dbop-0.0.0.1.tar.gz" } ], "0.0.0.2": [ { "comment_text": "", "digests": { "md5": "d398cae7b47ed006e5b6e53254eb14d6", "sha256": "60e4ec7c6876c3d79af09d29cfc2a90ae152e6639f7715c35fa9e17001444a20" }, "downloads": -1, "filename": "dbop-0.0.0.2-py2.7.egg", "has_sig": false, "md5_digest": "d398cae7b47ed006e5b6e53254eb14d6", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 8561, "upload_time": "2018-08-24T05:31:48", "url": "https://files.pythonhosted.org/packages/80/18/90d8fb987d49e6da64750f3d75a92831438c924d59f10812d663a19c3591/dbop-0.0.0.2-py2.7.egg" }, { "comment_text": "", "digests": { "md5": "69c95968a3f4e6b398e2bc756d77b131", "sha256": "cc6dc0f447c1d28cdf6f4166d762316db0588c161536236ca6dcd35b88223be3" }, "downloads": -1, "filename": "dbop-0.0.0.2-py2-none-any.whl", "has_sig": false, "md5_digest": "69c95968a3f4e6b398e2bc756d77b131", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 6798, "upload_time": "2018-08-24T05:31:46", "url": "https://files.pythonhosted.org/packages/bc/b7/a4931a98f408f507bd97f29a44b925c6e0596b89505a177746076684c03c/dbop-0.0.0.2-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "61222ad0821f51929f1495473c97fd1b", "sha256": "3df42005dc24bcc69308110908e4f94497c6b851bbc251cfca50a806643e0a12" }, "downloads": -1, "filename": "dbop-0.0.0.2.tar.gz", "has_sig": false, "md5_digest": "61222ad0821f51929f1495473c97fd1b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5802, "upload_time": "2018-08-24T05:31:50", "url": "https://files.pythonhosted.org/packages/18/a7/3e057fc54dd072f1aa37624e263834d4da2626291b91380a5e142ed49b98/dbop-0.0.0.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "d398cae7b47ed006e5b6e53254eb14d6", "sha256": "60e4ec7c6876c3d79af09d29cfc2a90ae152e6639f7715c35fa9e17001444a20" }, "downloads": -1, "filename": "dbop-0.0.0.2-py2.7.egg", "has_sig": false, "md5_digest": "d398cae7b47ed006e5b6e53254eb14d6", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 8561, "upload_time": "2018-08-24T05:31:48", "url": "https://files.pythonhosted.org/packages/80/18/90d8fb987d49e6da64750f3d75a92831438c924d59f10812d663a19c3591/dbop-0.0.0.2-py2.7.egg" }, { "comment_text": "", "digests": { "md5": "69c95968a3f4e6b398e2bc756d77b131", "sha256": "cc6dc0f447c1d28cdf6f4166d762316db0588c161536236ca6dcd35b88223be3" }, "downloads": -1, "filename": "dbop-0.0.0.2-py2-none-any.whl", "has_sig": false, "md5_digest": "69c95968a3f4e6b398e2bc756d77b131", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 6798, "upload_time": "2018-08-24T05:31:46", "url": "https://files.pythonhosted.org/packages/bc/b7/a4931a98f408f507bd97f29a44b925c6e0596b89505a177746076684c03c/dbop-0.0.0.2-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "61222ad0821f51929f1495473c97fd1b", "sha256": "3df42005dc24bcc69308110908e4f94497c6b851bbc251cfca50a806643e0a12" }, "downloads": -1, "filename": "dbop-0.0.0.2.tar.gz", "has_sig": false, "md5_digest": "61222ad0821f51929f1495473c97fd1b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5802, "upload_time": "2018-08-24T05:31:50", "url": "https://files.pythonhosted.org/packages/18/a7/3e057fc54dd072f1aa37624e263834d4da2626291b91380a5e142ed49b98/dbop-0.0.0.2.tar.gz" } ] }