{
    "info": {
        "author": "jander",
        "author_email": "jander.sy@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python"
        ],
        "description": "Introduction\r\n------------\r\n\r\nThis is a vary simple database access interface for python.\r\n\r\nFeature\r\n-------\r\n\r\n* Easy to use\r\n* supports sqlite, mysql\r\n\r\nDownload\r\n--------\r\n\r\nGo to the homepage: http://github.com/jander/littlesql/\r\n\r\nExample\r\n--------\r\n\r\nexample table: foo (id int, name string) \r\n\r\nConnect\r\n^^^^^^^\r\n\r\n**connect to sqlite3**\r\n::\r\n\r\n\tctx =  SqliteContext(\"test.db\")\r\n\tdb = Database(ctx)\r\n\r\n**connect mysql**\r\n::\r\n\r\n\tctx = MySqlContext(username=\"name\", password=\"pwd\", hostname=\"localhost\", db=\"test\")\r\n\tdb = Database(ctx)\r\n\r\nQuery\r\n^^^^^^^\r\n\r\n**query a row dict**\t\r\n::\r\n\r\n\tdb.foo(\"name=?\", \"tom\").get()\r\n\t\r\n\t# raw sql\r\n\tdb.get(\"select * from foo where name=?\", \"tom\")\r\n\r\n**query many rows**\t\r\n::\r\n\r\n\tdb.foo(\"id>?\", 100).orderby(\"id desc\").limit(0,10).query()\r\n\t\r\n\t# raw sql\r\n\tdb.query(\"select * from foo where id>? order by id desc limit 0,100;\", 100)\r\n\r\n**query selected cols**\t\t\r\n::\r\n\r\n\tdb.foo.query(\"id, name\")\r\n\t\r\n\t# raw sql\r\n\tdb.query(\"select id, name from foo\")\r\n\r\nUpdate\r\n^^^^^^^\r\n::\r\n\r\n\tfdict = dict(name=\"new foo\")\r\n\tdb.foo(\"id=?\", 1).update(**fidct)\r\n\t\r\n\t# raw sql\r\n\tdb.execute(\"update foo set name=? where id=?\", \"new foo\", 1)\r\n\r\nDelete\r\n^^^^^^^\r\n::\r\n\r\n\tdb.foo(\"name like ?\", \"test%\").delete()\r\n\t\r\n\t# raw sql\r\n\tdb.execute(\"delete from foo where name like ?\", \"test%\")\r\n\r\n\r\nOther\r\n^^^^^^^\r\n\r\nsee  the test code.\r\n\r\n\r\nReference\r\n-------------\r\n\r\n* tornado database\r\n* http://python.6.n6.nabble.com/CPyUG-tornado-database-py-Python-DAL-td2743761.html by lee Alexander.\r\n* spring python",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "UNKNOWN",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "http://github.com/jander/littlesql/",
        "keywords": "",
        "license": "License :: OSI Approved :: MIT License",
        "maintainer": "",
        "maintainer_email": "",
        "name": "littlesql",
        "package_url": "https://pypi.org/project/littlesql/",
        "platform": "any",
        "project_url": "https://pypi.org/project/littlesql/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "http://github.com/jander/littlesql/"
        },
        "release_url": "https://pypi.org/project/littlesql/0.1/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "a little database access interface",
        "version": "0.1"
    },
    "last_serial": 438595,
    "releases": {
        "0.1": []
    },
    "urls": []
}