{ "info": { "author": "Pattarawut Imamnuaysup", "author_email": "pattarawut@hot-now.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "# PGAnonymizer\n\nPGAnonymizer is a tool for anonymizing database for testing purposes.\n\n## Installation\nPGAnonymizer required Python 3.5 and above to run. PGAnonymizer can be installed using pip.\n```sh\n$ pip install pganonymizer\n```\n\n## Background\nPGAnonymizer will hash columns in table depending on the rules inside CSJ file.\n### CSJ file format:\n```\n\"table\", \"column\", \"rule\"\n\"schema.table_to_be_hased\", \"columned_to_be_hased\", \"hash\"\n\"schema.table_to_be_hased\", \"columned_to_be_hased\", \"date\"\n\"schema.table_to_be_hased\", \"columned_to_be_hased\", \"phone\"\n```\n#### Example for rules for hashing\n`Hash` is for text type field such as name or address. The return value will be in base32 with length of atmost 16. \nExample input:\n```\nCustomer1\n```\nExample output:\n```\nEC35FEOXDMVR7Y5C\n```\n`Date` is for date type field. The return value will keep the original year but hash the month and date field. \nExample input:\n```\n2000-12-15\n```\nExample output:\n```\n2000-01-10\n```\n`Phone` is for phone number. The return value will be of same length as the original number. \nExample input:\n```\n+66932019385\n```\nExample output:\n```\n+66254818000\n```\n## Instruction\nFormat:\n```sh\n$ pganonymizer [database environment] [option]\n```\nTo use PGAnonymizer, you can call:\n```sh\n$ pganonymizer --schema path_to_schema_file.csj\n```\nBy default, PGAnonymizer will connect to database using user's username as database and role. \nOtherwise, please specify as follow:\n```sh\n$ pganonymizer -d postgres -U postgres --schema path_to_schema_file.csj\n```\nFor more information on the usage, please use the following command:\n```sh\n$ pganonymizer --help\n```\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/pypa/sampleproject", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "pganonymizer", "package_url": "https://pypi.org/project/pganonymizer/", "platform": "", "project_url": "https://pypi.org/project/pganonymizer/", "project_urls": { "Homepage": "https://github.com/pypa/sampleproject" }, "release_url": "https://pypi.org/project/pganonymizer/0.0.5/", "requires_dist": [ "asyncpg", "csj-parser", "click", "asyncio", "pytest-asyncio" ], "requires_python": ">=3.5", "summary": "Database anonymizer package", "version": "0.0.5" }, "last_serial": 5307642, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "7edde93b79b67553df09583dded6ba18", "sha256": "60b7c428e56d70bde4ce3cdc07624275e68e98c7181484d04057b76a140ca6d3" }, "downloads": -1, "filename": "pganonymizer-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "7edde93b79b67553df09583dded6ba18", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 5680, "upload_time": "2019-04-24T06:50:00", "url": "https://files.pythonhosted.org/packages/5d/ed/8cd551e7fc0f9aa70ae41f30667f24ecef59a57d63e06541a1232182e728/pganonymizer-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9eac993e6be1c9fff7f6ab79cfa31f95", "sha256": "69c44c3d5ec4a8004ab44bfc3ce707940b299b02ee05cb9b737dfe67a3b7d19c" }, "downloads": -1, "filename": "pganonymizer-0.0.1.tar.gz", "has_sig": false, "md5_digest": "9eac993e6be1c9fff7f6ab79cfa31f95", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 3726, "upload_time": "2019-04-24T06:50:02", "url": "https://files.pythonhosted.org/packages/50/62/c3ddc77d91c559ef746cbffbf93a3260044b183154871404f2619e1531a3/pganonymizer-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "72a86772dfc11901c68804a59adf1173", "sha256": "d30348ab44497308f8b886aeafe7466c13f84042adccef42f9a7ca3d432c88ed" }, "downloads": -1, "filename": "pganonymizer-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "72a86772dfc11901c68804a59adf1173", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 5748, "upload_time": "2019-04-24T10:55:20", "url": "https://files.pythonhosted.org/packages/a1/98/1afb9b42c036b05ca2655a9423f24c67b4f5673d77c64b1714e2df72796a/pganonymizer-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "51e62d8a1b21c88945e8bdf2c9eb2854", "sha256": "f7616439fd5ad1d0e0865dc0d0587a9975b5a0446d75ec520bd8920b384df86e" }, "downloads": -1, "filename": "pganonymizer-0.0.2.tar.gz", "has_sig": false, "md5_digest": "51e62d8a1b21c88945e8bdf2c9eb2854", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 3787, "upload_time": "2019-04-24T10:55:22", "url": "https://files.pythonhosted.org/packages/a2/8a/648d356a9527a04f404fd4242a4df3429776d9f437b051dfa3a002b723d4/pganonymizer-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "bec1e356d98937c7e7a1f4ea930a7258", "sha256": "6c291df6643bea5f97f2d4e747cb989974ea75cb424189099f732b1e1bc354eb" }, "downloads": -1, "filename": "pganonymizer-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "bec1e356d98937c7e7a1f4ea930a7258", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 7288, "upload_time": "2019-05-08T06:35:22", "url": "https://files.pythonhosted.org/packages/e1/b8/4a9cc0f817ce5595380a2598785dd0a785e3259d43f2c8cb6f8d45d97dc4/pganonymizer-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "24bc286c33ef790d1fda5e640e072705", "sha256": "a6f61aacb9be60a02cc27e23b3cd96db7ba5284c52cb0afd0089320d046226a5" }, "downloads": -1, "filename": "pganonymizer-0.0.3.tar.gz", "has_sig": false, "md5_digest": "24bc286c33ef790d1fda5e640e072705", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 4731, "upload_time": "2019-05-08T06:35:23", "url": "https://files.pythonhosted.org/packages/ad/47/e143abf0b0d97cd0fea92aa1744efe60a3c599bbffb38f743fd16e031e32/pganonymizer-0.0.3.tar.gz" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "a80547d3502e47fdee05d225e9abdd96", "sha256": "d939197ef17d8d9aa4482c20ba9496f463fa1d299752df49fbde091f8b9a1f9c" }, "downloads": -1, "filename": "pganonymizer-0.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "a80547d3502e47fdee05d225e9abdd96", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 7313, "upload_time": "2019-05-08T10:06:47", "url": "https://files.pythonhosted.org/packages/89/42/3d8814c419a1e8b6e569fb325f6751a5a0d01d6c501ad6fdaaa38e904994/pganonymizer-0.0.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a4c438df9c64c6d8d154bd9b6becf032", "sha256": "1d90563088fd058a4d0476eec949440f8733e806962bf1db267152b466174890" }, "downloads": -1, "filename": "pganonymizer-0.0.4.tar.gz", "has_sig": false, "md5_digest": "a4c438df9c64c6d8d154bd9b6becf032", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 4752, "upload_time": "2019-05-08T10:06:49", "url": "https://files.pythonhosted.org/packages/a9/de/a0fa262a4db7d09d6df61615132d695e5d0a1b10f54b0a4378bad4272ee0/pganonymizer-0.0.4.tar.gz" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "43bf4725fb5d9919f63c21eac454623c", "sha256": "8a48015ce228caa42fe2257e659753eb4d2ef38879221ca1832bc673ab8be556" }, "downloads": -1, "filename": "pganonymizer-0.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "43bf4725fb5d9919f63c21eac454623c", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 7332, "upload_time": "2019-05-23T13:54:37", "url": "https://files.pythonhosted.org/packages/ce/89/afb9851f7e486cd6d8ca3a52af3435b01c15c35a8180b7f2d42f7805a08c/pganonymizer-0.0.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "39016f5f5f754f3fd18d70259ba92dfa", "sha256": "e988e699326d41b8e43fb086964743164269e47aa5f2f899066c9fe2d0e9b2ec" }, "downloads": -1, "filename": "pganonymizer-0.0.5.tar.gz", "has_sig": false, "md5_digest": "39016f5f5f754f3fd18d70259ba92dfa", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 4770, "upload_time": "2019-05-23T13:54:39", "url": "https://files.pythonhosted.org/packages/75/33/bcbc6a9d44db5898fac79d77a4d0f1b5c69c75176ff22b23bd2cc34e2c26/pganonymizer-0.0.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "43bf4725fb5d9919f63c21eac454623c", "sha256": "8a48015ce228caa42fe2257e659753eb4d2ef38879221ca1832bc673ab8be556" }, "downloads": -1, "filename": "pganonymizer-0.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "43bf4725fb5d9919f63c21eac454623c", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 7332, "upload_time": "2019-05-23T13:54:37", "url": "https://files.pythonhosted.org/packages/ce/89/afb9851f7e486cd6d8ca3a52af3435b01c15c35a8180b7f2d42f7805a08c/pganonymizer-0.0.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "39016f5f5f754f3fd18d70259ba92dfa", "sha256": "e988e699326d41b8e43fb086964743164269e47aa5f2f899066c9fe2d0e9b2ec" }, "downloads": -1, "filename": "pganonymizer-0.0.5.tar.gz", "has_sig": false, "md5_digest": "39016f5f5f754f3fd18d70259ba92dfa", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 4770, "upload_time": "2019-05-23T13:54:39", "url": "https://files.pythonhosted.org/packages/75/33/bcbc6a9d44db5898fac79d77a4d0f1b5c69c75176ff22b23bd2cc34e2c26/pganonymizer-0.0.5.tar.gz" } ] }