{ "info": { "author": "Abimanyu HK", "author_email": "manyu1994@hotmail.com", "bugtrack_url": null, "classifiers": [], "description": "# Golla\n\n* A SQL Query free ORM\n* Support SQLAlchemy ORM \n\n### Create Connection \n\n```\nfrom sqlalchemy import create_engine\nfrom sqlalchemy.orm import sessionmaker\n\nhost = 'localhost'\nuser = 'postgres'\npassword = 'root'\ndata_base = 'postgres'\nport = '5432'\nURL = 'postgresql://{}:{}@{}:{}/{}'\nURL = URL.format(user, password, host, port, data_base)\nds_schema = 'public'\n\nengine = create_engine(URL, encoding='utf8')\nengine.connect()\nConnection = sessionmaker(bind=engine)()\n\n```\n\n### Create Model class\n\n```\nfrom sqlalchemy.ext.declarative import declarative_base\nfrom sqlalchemy import Integer, String, Column\n\nfrom golla.table import BaseChild\n\nBase = declarative_base()\n\nBaseChild.Connection = Connection\n\n\nclass Employee(Base, BaseChild):\n __tablename__ = \"employee\"\n EMPID = Column(\"emp_id\", Integer, primary_key=True)\n NAME = Column(\"NAME\", String)\n Age = Column(\"Age\", Integer)\n\n```\n\n\n### Save object into DB\n\n```\ne = Employee()\ne.EMPID = 203\ne.Age = 20\ne.NAME = \"b\"\n\nEmployee.save(e)\n\n``` \n\n### Get records from table by id\n\n```\nemp = Employee().get_by_id(EMPID=100)\n```\n\n### Get all records \n\n```\nemps = Employee().get_all()\n```\n\n### Delete records from table by id\n\n```\nEmployee().delete_by_id(EMPID=201)\n```\n\n\n MIT License : Copyright (c) 2019 Abhimanyu Haralukallu\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/AbhimanyuHK/Golla", "keywords": "", "license": "MIT License : Copyright (c) 2019 Abhimanyu Haralukallu", "maintainer": "", "maintainer_email": "", "name": "Golla", "package_url": "https://pypi.org/project/Golla/", "platform": "", "project_url": "https://pypi.org/project/Golla/", "project_urls": { "Homepage": "https://github.com/AbhimanyuHK/Golla" }, "release_url": "https://pypi.org/project/Golla/0.0.0/", "requires_dist": null, "requires_python": "", "summary": "A SQL ORM Tool", "version": "0.0.0" }, "last_serial": 5911712, "releases": { "0.0.0": [ { "comment_text": "", "digests": { "md5": "597ffde7c45152ff4d410f1e7a176f14", "sha256": "aaf2e1c728aafdae2f4811204adc19200031d5975e2152f0a0912a13d0a7d3ee" }, "downloads": -1, "filename": "Golla-0.0.0-py3-none-any.whl", "has_sig": false, "md5_digest": "597ffde7c45152ff4d410f1e7a176f14", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2466, "upload_time": "2019-10-01T11:26:09", "url": "https://files.pythonhosted.org/packages/86/47/0a69a008c80d24edc3baf6719d64c3477007f37a9f3fed0c118d53f76753/Golla-0.0.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "95a7febd89bee7cbdbbba4efa78aa249", "sha256": "500a8c9ceaeedff02b2505c94a3b183498491e0e817fe8415633443fbb91bb3d" }, "downloads": -1, "filename": "Golla-0.0.0.tar.gz", "has_sig": false, "md5_digest": "95a7febd89bee7cbdbbba4efa78aa249", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2211, "upload_time": "2019-10-01T11:26:12", "url": "https://files.pythonhosted.org/packages/84/9c/8a0d909d24f011f8564aaf0ab698127e321e893548fe9ed7ef06d72f27c4/Golla-0.0.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "597ffde7c45152ff4d410f1e7a176f14", "sha256": "aaf2e1c728aafdae2f4811204adc19200031d5975e2152f0a0912a13d0a7d3ee" }, "downloads": -1, "filename": "Golla-0.0.0-py3-none-any.whl", "has_sig": false, "md5_digest": "597ffde7c45152ff4d410f1e7a176f14", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2466, "upload_time": "2019-10-01T11:26:09", "url": "https://files.pythonhosted.org/packages/86/47/0a69a008c80d24edc3baf6719d64c3477007f37a9f3fed0c118d53f76753/Golla-0.0.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "95a7febd89bee7cbdbbba4efa78aa249", "sha256": "500a8c9ceaeedff02b2505c94a3b183498491e0e817fe8415633443fbb91bb3d" }, "downloads": -1, "filename": "Golla-0.0.0.tar.gz", "has_sig": false, "md5_digest": "95a7febd89bee7cbdbbba4efa78aa249", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2211, "upload_time": "2019-10-01T11:26:12", "url": "https://files.pythonhosted.org/packages/84/9c/8a0d909d24f011f8564aaf0ab698127e321e893548fe9ed7ef06d72f27c4/Golla-0.0.0.tar.gz" } ] }