{ "info": { "author": "lkmc2", "author_email": "lkmc2@163.com", "bugtrack_url": null, "classifiers": [ "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: Implementation" ], "description": "# python-sql-faker\n#### \u8f7b\u91cf\u7ea7\u3001\u6613\u62d3\u5c55\u7684\u6570\u636e\u5e93\u667a\u80fd\u586b\u5145\u5f00\u6e90\u5e93\uff08Python\u5b9e\u73b0\u7248\uff09\n\n## \u5f00\u6e90\u5e93\u7279\u6027\n\n+ \u652f\u6301\u4e3b\u6d41\u7684MySQL\u3001Oracle\u3001SQL Server\u3001SQLite\u6570\u636e\u5e93\n+ \u652f\u63018\u79cd\u5e38\u89c1\u6570\u636e\u5e93\u5b57\u6bb5\u7c7b\u578b\u7684\u667a\u80fd\u586b\u5145\uff0c\u5e76\u652f\u6301\u81ea\u5b9a\u4e49\u62d3\u5c55\n+ \u652f\u6301\u4e00\u6b21\u6027\u63d2\u5165\u767e\u4e07\u7ea7\u522b\u7684\u6570\u636e\n+ \u652f\u6301\u4e8b\u52a1\n+ \u652f\u6301python2.7\n\n## \u4f7f\u7528\u793a\u8303\n\n``` python\nfrom sql_faker import Faker, DataType, Values, Times, DBHelper\nimport pymysql\n\n# \u8bbe\u7f6e\u6570\u636e\u5e93\u4fe1\u606f\nDBHelper.db_setting(db='python_sql_faker',\n driver=pymysql,\n user='root',\n passwd='123456',\n host='127.0.0.1',\n port=3306)\n\n# \u7ed9user\u8868\u7684\u56db\u4e2a\u5b57\u6bb5\u586b\u51455\u6761\u6570\u636e\nFaker.table_name(\"user\") \\\n .param(\"name\", DataType.USERNAME) \\\n .param(\"age\", DataType.AGE) \\\n .param(\"address\", DataType.ADDRESS) \\\n .param(\"birthday\", DataType.TIME) \\\n .insert_count(5) \\\n .execute()\n```\n\n\u4e0a\u8ff0\u4ee3\u7801\u5c06\u751f\u6210\u5982\u4e0bSQL\u8bed\u53e5\uff0c\u5e76\u5728\u6570\u636e\u5e93\u4e2d\u6267\u884c\uff1a\n\n```sql\ninsert into user(name,age,sex,address,birthday) values('\u6b66\u53f9\u971c', 21, '\u5c71\u897f\u7701\u664b\u57ce\u5e02\u6cfd\u5dde\u53bf\u5e86\u8fbe\u8def463\u53f7', '2018-02-24 10:56:37')\ninsert into user(name,age,sex,address,birthday) values('\u987e\u4ec0\u53ef', 50, '\u5e7f\u897f\u58ee\u65cf\u81ea\u6cbb\u533a\u67f3\u5dde\u5e02\u878d\u6c34\u82d7\u65cf\u81ea\u6cbb\u53bf\u5fb7\u5821\u8def419\u53f7', '2018-04-09 08:10:22')\ninsert into user(name,age,sex,address,birthday) values('\u8521\u9759\u968f', 46, '\u6cb3\u5357\u7701\u90d1\u5dde\u5e02\u5de9\u4e49\u5e02\u5e7f\u5ef6\u8def240\u53f7', '2018-06-11 23:02:19')\ninsert into user(name,age,sex,address,birthday) values('\u97e6\u4e38\u8d64', 27, '\u6cb3\u5357\u7701\u7126\u4f5c\u5e02\u535a\u7231\u53bf\u6d66\u6da6\u8def148\u53f7', '2018-02-22 15:52:50')\ninsert into user(name,age,sex,address,birthday) values('\u4efb\u5f90', 54, '\u6cb3\u5357\u7701\u65b0\u4e61\u5e02\u5ef6\u6d25\u53bf\u6c49\u6e90\u8def14\u53f7', '2018-07-07 03:48:51')\n```\n\n\n\n## \u4f9d\u8d56\u6dfb\u52a0\n\n\u672c\u5f00\u6e90\u5e93\u53e6\u5916\u4f9d\u8d56\u4e86DBUtils\u548cpymysql\u5e93\uff0c\u9700\u8981\u4e00\u8d77\u8fdb\u884cpip\u5b89\u88c5\u3002\n\n``` python\npip install sql-faker\npip install DBUtils\npip install pymysql\n```\n\n\u5982\u679c\u5b89\u88c5\u4e0d\u6210\u529f\uff0c\u70b9\u6b64\u8fde\u63a5\u8fdb\u884c\u4e0b\u8f7dwhl\u6587\u4ef6 \u70b9\u51fb\u4e0b\u8f7d\u3002\n\n\u7136\u540e\u5728\u63a7\u5236\u53f0\u4e2d\u79fb\u52a8\u5230\u6587\u4ef6\u4e0b\u8f7d\u8def\u5f84\u6267\u884c\u5982\u4e0b\u547d\u4ee4\uff1a\n\n```cmd\ncd \u4e0b\u8f7d\u8def\u5f84\npip install sql_faker-1.1.7-py2-none-any.whl\n```\n\n\n\n**\u6ce8\u610f**\uff1a\u9ed8\u8ba4\u4f7f\u7528MySQL\u6570\u636e\u5e93\uff0c\u5982\u9700\u66f4\u6362\u6210Oracle\u3001SQL Server\u3001SQLite\u7b49DBUtils\u8fde\u63a5\u6c60\u652f\u6301\u7684\u6570\u636e\u5e93\uff0c\u53ef\u53e6\u884c\u6dfb\u52a0\u4f9d\u8d56\uff0c\u5e76\u5728DBHelper.db_setting(driver=\u9a71\u52a8\u5bf9\u8c61)\u65b9\u6cd5\u4e2d\u6307\u5b9a\u6570\u636e\u5e93\u9a71\u52a8\u3002\n\n\n\n## \u6570\u636e\u5e93\u8fde\u63a5\n\n#### \u4e00\u3001\u8fde\u63a5\u5c5e\u6027\u8bbe\u7f6e\n\n\u5728\u8fdb\u884c\u63d2\u5165\u6570\u636e\u4e4b\u524d\u9700\u8981\u8bbe\u7f6e\u6570\u636e\u5e93\u5c5e\u6027\uff0c\u5982\u4ee3\u7801\u6240\u793a\uff1a\n\n``` python\nfrom sql_faker import DBHelper\nimport pymysql\n\n# \u8bbe\u7f6e\u6570\u636e\u5e93\u4fe1\u606f\nDBHelper.db_setting(db='python_sql_faker',\n driver=pymysql, # \u8bbe\u7f6e\u8fde\u63a5\u9a71\u52a8\n user='root',\n passwd='123456',\n host='127.0.0.1',\n port=3306)\n```\n\n\n\u53ef\u8bbe\u7f6e\u7684\u5c5e\u6027\u5982\u4e0b\u8868\uff1a\n\n| \u5c5e\u6027\u540d | \u8bf4\u660e | \u9ed8\u8ba4\u503c |\n| :----: | :-----: | :-------: |\n| db | \u6570\u636e\u5e93\u540d | \u65e0 |\n| driver | \u6570\u636e\u5e93\u9a71\u52a8\u5bf9\u8c61 | pymysql |\n| user | \u6570\u636e\u5e93\u7528\u6237\u540d | root |\n| passwd | \u6570\u636e\u5e93\u5bc6\u7801 | 12345 |\n| host | \u4e3b\u673a\u5730\u5740 | localhost |\n| port | \u7aef\u53e3\u53f7 | 3306 |\n\n\n\n#### \u4e8c\u3001\u7279\u6b8a\u60c5\u51b5\n\n1. \u5f53\u6570\u636e\u5e93\u5c5e\u6027\u503c\u90fd\u7b49\u4e8e\u9ed8\u8ba4\u503c\u65f6\uff0c\u53ef\u53ea\u8bbe\u7f6e\u6570\u636e\u5e93\u540d\uff1a\n\n``` python\nDBHelper.db_setting('python_sql_faker')\n```\n\n\n\n#### \u4e09\u3001\u652f\u6301\u7684\u9a71\u52a8\u7c7b\u578b\n\n```python\n# \u652f\u6301\u7684\u9a71\u52a8\u7c7b\u578b\uff0c\u53ef\u5728DBHelper.db_setting(driver=\u9a71\u52a8\u5bf9\u8c61)\u65b9\u6cd5\u6307\u5b9a\u6570\u636e\u5e93\u9a71\u52a8\n# 1.\u9996\u5148\u5728\u63a7\u5236\u53f0\u8fdb\u884cpip\u5b89\u88c5\npip install pymysql # mysql\npip install pymssql # sqlserver\npip install cx_Oracle # oracle\npip install sqlite3 # sqlite3\n\n# 2.\u4e4b\u540e\u5bfc\u5165\u6240\u9700\u9a71\u52a8\uff0c\u8bbe\u7f6e\u5230driver\u5c5e\u6027\u4e2d\nDBHelper.db_setting(db='python_sql_faker',\n driver=cx_Oracle) # \u8bbe\u7f6e\u8fde\u63a5\u9a71\u52a8\n```\n\n\n\n**\u6ce8\u610f** \uff1a\u6570\u636e\u5e93\u914d\u7f6e\u53ea\u9700\u8981\u8bbe\u7f6e\u4e00\u6b21\uff0c\u4e4b\u540e\u53ef\u4ee5\u591a\u6b21\u8c03\u7528Faker\u8fdb\u884c\u63d2\u5165\u6570\u636e\u64cd\u4f5c\u3002\n\n\n\n## \u6570\u636e\u63d2\u5165\n\n### \u4e00\u3001\u5c5e\u6027\u4ecb\u7ecd\n\u53ef\u8bbe\u7f6e\u7684\u5c5e\u6027\u5982\u4e0b\u8868\uff1a\n\n| \u5c5e\u6027\u540d | \u8bf4\u660e |\n| :------------------: | :-------------------: |\n| table_name(\u6570\u636e\u5e93\u8868\u540d) | \u8bbe\u7f6e\u6570\u636e\u5e93\u8868\u540d |\n| param(\u5b57\u6bb5\u540d, \u6570\u636e\u751f\u6210\u5668\u7c7b\u578b\u2460) | \u8bbe\u7f6e\u6570\u636e\u5e93\u5b57\u6bb5\u540d\uff0c\u4ee5\u53ca\u5bf9\u5e94\u7684\u6570\u636e\u751f\u6210\u5668\u7c7b\u578b |\n| insert_count(\u63d2\u5165\u6761\u6570) | \u8bbe\u7f6e\u63d2\u5165\u6570\u636e\u6761\u6570 |\n| execute( ) | \u751f\u6210SQL\uff0c\u663e\u793a\u5728\u63a7\u5236\u53f0\uff0c\u5e76\u5728\u6570\u636e\u5e93\u4e2d\u6267\u884c |\n| only_show_sql( ) | \u751f\u6210SQL\uff0c\u5e76\u663e\u793a\u5728\u63a7\u5236\u53f0 |\n| ignored( ) | \u4e0d\u6267\u884c\u4efb\u4f55\u64cd\u4f5c |\n\n\u6ce8\u610f\uff1a\u2460 \u6570\u636e\u751f\u6210\u5668\u7c7b\u578b\uff0c\u5fc5\u987b\u662fDataType\u679a\u4e3e\u503c\uff0c\u6216\u5b9e\u73b0\u4e86RandomData\u63a5\u53e3\u7684\u7c7b\u3002\n\n\u4f7f\u7528\u793a\u4f8b\uff1a\n``` java\n// \u7ed9user\u8868\u7684\u56db\u4e2a\u5b57\u6bb5\u586b\u51455\u6761\u6570\u636e\nFaker.table_name(\"user\") \\\n .param(\"name\", DataType.USERNAME) \\\n .param(\"age\", DataType.AGE) \\\n .param(\"sex\", DataType.SEX) \\\n .param(\"birthday\", DataType.TIME) \\\n .insert_count(5) \\\n .execute()\n\n// \u7ed9user\u8868\u7684\u4e24\u4e2a\u5b57\u6bb5\u751f\u62105\u6761SQL\uff0c\u5e76\u663e\u793a\u5728\u63a7\u5236\u53f0\nFaker.table_name(\"user\") \\\n .param(\"name\", DataType.USERNAME) \\\n .param(\"age\", DataType.AGE) \\\n .insert_count(5) \\\n .only_show_sql()\n\n// \u4e0d\u6267\u884c\u4efb\u4f55\u64cd\u4f5c\uff0c\u4e0d\u751f\u6210SQL\uff0c\u4e0d\u663e\u793a\u5728\u63a7\u5236\u53f0\nFaker.table_name(\"user\") \\\n .param(\"name\", DataType.USERNAME) \\\n .param(\"age\", DataType.AGE) \\\n .insert_count(5) \\\n .ignored()\n```\n\n\n\n### \u4e8c\u3001\u63d2\u5165\u6570\u636e\u7684\u65b9\u5f0f\n\n\u672c\u5f00\u6e90\u5e93\u4e00\u5171\u652f\u6301\u4e09\u79cd\u63d2\u5165\u6570\u636e\u7684\u65b9\u5f0f\uff0c\u53ef\u4ee5\u6df7\u5408\u4f7f\u7528\u3002\n\n#### 1. \u4f7f\u7528DataType\u6307\u5b9a\u6570\u636e\u7c7b\u578b\n\nDataType\u4e00\u5171\u652f\u63018\u79cd\u679a\u4e3e\u7c7b\u578b\uff0c\u5982\u4e0b\u8868\u6240\u793a\uff1a\n\n| \u5c5e\u6027\u540d | \u8bf4\u660e | \u7c7b\u578b | \u793a\u4f8b\u503c |\n| :------: | :--: | :----------------: | :-----------------: |\n| ID | \u7528\u6237ID | 19\u4f4d\u7684\u6570\u5b57\u578bUUID\u5b57\u7b26\u4e32 | 1049120504188764160 |\n| USERNAME | \u7528\u6237\u540d | \u957f\u5ea6\u4e3a2\u52304\u4e2a\u5b57\u7684\u4e2d\u6587\u540d | \u6b66\u53f9\u971c |\n| TIME | \u65f6\u95f4 | \u4e00\u5e74\u524d\u5230\u73b0\u5728\u7684\u65f6\u95f4\u8303\u56f4\u5185\u4efb\u610f\u4e00\u4e2a\u65f6\u523b | 2018-03-01 12:41:00 |\n| PHONE | \u624b\u673a\u53f7 | 11\u4f4d\u624b\u673a\u53f7 | 13192668109 |\n| ADDRESS | \u5730\u5740 | \u56fd\u5185\u5730\u5740\uff0c\u8be6\u7ec6\u5230\u95e8\u724c\u53f7 | \u56db\u5ddd\u7701\u7ef5\u9633\u5e02\u76d0\u4ead\u53bf\u5317\u5229\u8def738\u53f7 |\n| AGE | \u5e74\u9f84 | 18\u523060\u5c81\u7684\u6570\u5b57 | 19 |\n| SEX | \u6027\u522b | \u5b57\u7b26\uff0c0\uff1a\u7537\uff0c1\uff1a\u5973 | '1' |\n| EMAIL | \u90ae\u7bb1 | \u5e38\u89c1\u90ae\u7bb1\u5b57\u7b26\u4e32 | Alex705@gmail.com |\n\n\u4f7f\u7528\u793a\u4f8b\uff1a\n\n```java\n// \u7ed9user\u8868\u76848\u4e2a\u5b57\u6bb5\u586b\u51451\u6761\u6570\u636e\nFaker.table_name(\"user\") \\\n .param(\"id\", DataType.ID) \\\n .param(\"name\", DataType.USERNAME) \\\n .param(\"birthday\", DataType.TIME) \\\n .param(\"phone\", DataType.PHONE) \\\n .param(\"address\", DataType.ADDRESS) \\\n .param(\"age\", DataType.AGE) \\\n .param(\"sex\", DataType.SEX) \\\n .param(\"email\", DataType.EMAIL) \\\n .insert_count(1) \\\n .execute()\n```\n\u5bf9\u5e94\u751f\u6210\u7684SQL\u8bed\u53e5\u5982\u4e0b\uff1a\n\n```sql\ninsert into \nuser(\n id, name, birthday,\n phone, address, age,\n sex, email\n) \nvalues(\n '1049120504188764160', '\u6b66\u53f9\u971c', '2018-03-01 12:41:00',\n '13192668109', '\u56db\u5ddd\u7701\u7ef5\u9633\u5e02\u76d0\u4ead\u53bf\u5317\u5229\u8def73\u53f7', 19,\n '1', 'Alex705@gmail.com'\n)\n```\n\n\n\n#### 2. \u4f7f\u7528 Values.of()\u7cfb\u5217\u65b9\u6cd5\u751f\u6210\u53d6\u503c\u8303\u56f4\n\nValues\u7c7b\u5171\u6709\u4ee5\u4e0b8\u79cd\u751f\u6210\u53d6\u503c\u8303\u56f4\u65b9\u6cd5\uff0c\u5982\u4e0b\u8868\uff1a\n\n\n| \u65b9\u6cd5\u540d | \u53d6\u503c\u8303\u56f4 | \u793a\u4f8b\u503c |\n| :-------------------------------: | :-------------------------------------: | :-----------------: |\n| Values.of(\u53ef\u53d8\u957f\u53c2\u6570) | \u4ece\u53ef\u53d8\u957f\u53c2\u6570\u4e2d\u4efb\u610f\u62bd\u53d6\u4e00\u4e2a\u503c | \"\u4f18\u54c1\", \"\u826f\u54c1\", \"\u6b21\u54c1\" |\n| Values.of_int_range(\u8d77\u59cb\u503c,\u7ed3\u675f\u503c) | \u5728[\u8d77\u59cb\u503c, \u7ed3\u675f\u503c]\u7684\u8303\u56f4\u5185\u53d6\u4e00\u4e2a\u6574\u6570 | 33 |\n| Values.of_float_range(\u8d77\u59cb\u503c,\u7ed3\u675f\u503c,\u7cbe\u5ea6) | \u5728[\u8d77\u59cb\u503c, \u7ed3\u675f\u503c]\u7684\u8303\u56f4\u5185\u53d6\u4e00\u4e2a\u6d6e\u70b9\u6570\uff0c\u9ed8\u8ba4\u7cbe\u786e\u5230\u5c0f\u6570\u70b9\u540e2\u4f4d\uff0c\u6700\u591a10\u4f4d | 123.333333f |\n| Values.of_time_range(\u5f00\u59cb\u65f6\u95f4\uff0c\u7ed3\u675f\u65f6\u95f4) | \u5728[\u5f00\u59cb\u65f6\u95f4, \u7ed3\u675f\u65f6\u95f4]\u7684\u8303\u56f4\u5185\u53d6\u4e00\u4e2a\u65f6\u95f4\uff0c\u7cbe\u786e\u5230\u79d2 | 2018-03-14 13:21:11 |\n\n\u53e6\u5916\uff0cTimes\u7c7b\u4e2d\u8fd8\u6709\u7528\u4e8e\u8bbe\u5b9a\u65f6\u95f4\u7684\u4e24\u4e2a\u65b9\u6cd5\uff1a\n\n| \u65b9\u6cd5\u540d | \u8bf4\u660e |\n| :-------------------: | :---------: |\n| Times.of(\u5e74,\u6708,\u65e5) | \u7528\u4e8e\u751f\u6210\u65f6\u95f4\uff0c\u7cbe\u786e\u5230\u65e5 |\n| Times.of(\u5e74,\u6708,\u65e5,\u65f6,\u5206,\u79d2) | \u7528\u4e8e\u751f\u6210\u65f6\u95f4\uff0c\u7cbe\u786e\u5230\u79d2 |\n\n\n\n\u4f7f\u7528\u793a\u4f8b\uff1a\n\n\n\n```java\n// \u7ed9product\u8868\u76849\u4e2a\u5b57\u6bb5\u586b\u51451\u6761\u6570\u636e\nFaker.table_name(\"product\")\\\n .param(\"type\", Values.of(\"\u4f18\u54c1\", \"\u826f\u54c1\", \"\u6b21\u54c1\"))\\\n .param(\"person_count\", Values.of_int_range(20, 50))\\\n .param(\"enter_price\", Values.of_float_range(12.33, 34.57))\\\n .param(\"outcome_price\", Values.of_float_range(100.004132, 240.281424, 6))\\\n .param(\"firstTime\", Values.of_time_range(Times.of(2018,3,22), Times.of(2018,10,22)))\\\n .param(\"secondTime\",\n Values.of_time_range(\n Times.of(2018,3,22,11,23,24),\n Times.of(2018,10,22,22,15,17)\n )\n )\\\n .insert_count(1)\\\n .only_show_sql()\n```\n\n\u5bf9\u5e94\u751f\u6210\u7684SQL\u8bed\u53e5\u5982\u4e0b\uff1a\n\n```sql\ninsert into \nproduct(\n type, person_count, total_count,\n enter_price, outcome_price, speed,\n salary, firstTime, secondTime\n) \nvalues(\n '\u826f\u54c1', 33, 777777777,\n 22.22, 123.333333, 788.31,\n 1820.4231, '2018-03-14 00:00:00', '2018-03-14 13:21:11'\n)\n```\n\n\n\n#### 3. \u7ee7\u627fRandomData\u7c7b\uff0c\u91cd\u5199create()\u65b9\u6cd5\uff0c\u63d0\u4f9b\u53ef\u968f\u673a\u751f\u6210\u7684\u8fd4\u56de\u503c\n\nRandomData\u7c7b\u7684\u4ee3\u7801\u5982\u4e0b\uff1a\n\n```java\nclass RandomData:\n \"\"\"\u968f\u673a\u503c\u62bd\u8c61\u7c7b\uff0c\u5b50\u7c7b\u5fc5\u987b\u5b9e\u73b0create\u65b9\u6cd5\"\"\"\n __metaclass__ = ABCMeta\n\n @abstractmethod\n def create(self):\n pass\n```\n\n\u7ee7\u627f\u8be5\u7c7b\uff0c\u5e76\u91cd\u5199create( )\u65b9\u6cd5\u63d0\u4f9b\u4e00\u4e2a\u53ef\u968f\u673a\u751f\u6210\u7684\u8fd4\u56de\u503c\uff0c\u8be5\u8fd4\u56de\u503c\u5c31\u662f\u6570\u636e\u5e93\u5b57\u6bb5\u5bf9\u5e94\u63d2\u5165\u7684\u503c\u3002\n\n\u4f7f\u7528\u793a\u4f8b\uff1a\n\n1. \u521b\u5efa\u4e00\u4e2a\u81ea\u5b9a\u4e49\u7c7bEnglishNameRandom\uff0c\u7ee7\u627fRandomData\u7c7b\uff0c\u5e76\u63d0\u4f9b\u4e00\u4e2a\u53ef\u968f\u673a\u751f\u6210\u7684\u8fd4\u56de\u503c\u3002\n\n``` python\nimport random\nfrom sql_faker import Faker, DataType, Values, Times, DBHelper, RandomData\n\n# \u82f1\u6587\u540d\u6570\u636e\u751f\u6210\u5668\nclass EnglishNameRandom(RandomData):\n def create(self):\n # \u4f7f\u7528choice()\u65b9\u6cd5\u4ece\u5217\u8868\u4e2d\u968f\u673a\u62bd\u53d6\u4e00\u4e2a\u503c\uff0c\u4f5c\u4e3a\u8fd4\u56de\u503c\n return random.choice(['jack', 'andy', 'kim']) \n```\n\n2. \u5728Faker\u4e2d\u7ed9\u5b57\u6bb5\u6307\u5b9a\u4f7f\u7528EnglishNameRandom\u7c7b\u578b\u7684\u751f\u6210\u5668\u3002\n\n```java\n// \u6307\u5b9aname\u5b57\u6bb5\u4f7f\u7528EnglishNameRandom\u7c7b\u8fdb\u884c\u968f\u673a\u503c\u7684\u751f\u6210\nFaker.table_name(\"user\")\\\n .param(\"name\", EnglishNameRandom)\\\n .param(\"age\", Values.of_int_range(20, 50))\\\n .param(\"address\", DataType.ADDRESS)\\\n .insert_count(5)\\\n .execute()\n```\n\n\u5bf9\u5e94\u751f\u6210\u7684SQL\u8bed\u53e5\u5982\u4e0b\uff1a\n```sql\ninsert into user(name, age, address) \nvalues('Andy Wang', 23, '\u56db\u5ddd\u7701\u7ef5\u9633\u5e02\u76d0\u4ead\u53bf\u5317\u5229\u8def73\u53f7')\n```\n\n\nPS\uff1a\u5982\u679c\u6709\u4efb\u4f55\u5efa\u8bae\uff0c\u53ef\u4ee5\u5728Issues\u4e2d\u63d0\u51fa\uff0c\u5982\u6dfb\u52a0DataType\u7684\u9ed8\u8ba4\u7c7b\u578b\u7b49\u3002\n\n\n\n## License\n\nThe python-sql-faker is released under MIT License.", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/lkmc2/python-sql-faker", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "sql-faker", "package_url": "https://pypi.org/project/sql-faker/", "platform": "all", "project_url": "https://pypi.org/project/sql-faker/", "project_urls": { "Homepage": "https://github.com/lkmc2/python-sql-faker" }, "release_url": "https://pypi.org/project/sql-faker/1.2.0/", "requires_dist": null, "requires_python": "", "summary": "A lightweight SQL data creator", "version": "1.2.0" }, "last_serial": 4878140, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "fec2c957262ddd789832bbaeb34a22d9", "sha256": "d7f4cefb065fdb5dd6be7cb7a74c69246c5b29de99223ba081a3d233ca3abf37" }, "downloads": -1, "filename": "sql-faker-1.0.0.tar.gz", "has_sig": false, "md5_digest": "fec2c957262ddd789832bbaeb34a22d9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 48595, "upload_time": "2018-10-12T12:46:22", "url": "https://files.pythonhosted.org/packages/fb/08/a7b0cd945b44e67032dad47db9cc1a67a84c3cbdc2e3b9422150a506893b/sql-faker-1.0.0.tar.gz" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "6f5c6cdefddadaafc1fc4fc46cb63744", "sha256": "c3eba9654c0548b2698e393c4fad7af14a3b18abb745719cd1a137e8d7f7bf05" }, "downloads": -1, "filename": "sql-faker-1.0.1.tar.gz", "has_sig": false, "md5_digest": "6f5c6cdefddadaafc1fc4fc46cb63744", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 48622, "upload_time": "2018-10-12T13:08:52", "url": "https://files.pythonhosted.org/packages/9a/66/55355de379983e647ded471abb8c81be1b12b4720b599896d9610968e219/sql-faker-1.0.1.tar.gz" } ], "1.0.2": [ { "comment_text": "", "digests": { "md5": "367eacb885a062f1d9469b9ad534248c", "sha256": "e41c6f112a2d48aa837f0b11d974d3a510b2c784bb22748b203235d8d7e75292" }, "downloads": -1, "filename": "sql-faker-1.0.2.tar.gz", "has_sig": false, "md5_digest": "367eacb885a062f1d9469b9ad534248c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 48633, "upload_time": "2018-10-12T14:46:35", "url": "https://files.pythonhosted.org/packages/39/02/2b212d46c46db42efaaeab6060372c11dd7dcc5c05947a54c9d8d3aee26c/sql-faker-1.0.2.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "e0c2626500681b45785f9dbc1745590c", "sha256": "58644543d275219384b2eae0fe085cea0076db9150e896160f710fcaf1b10941" }, "downloads": -1, "filename": "sql-faker-1.0.3.tar.gz", "has_sig": false, "md5_digest": "e0c2626500681b45785f9dbc1745590c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 48780, "upload_time": "2018-10-12T14:57:56", "url": "https://files.pythonhosted.org/packages/5a/85/e4547e86359423b5737da725e294b79a7d01bd5cd00df9062fd3ebddeb3c/sql-faker-1.0.3.tar.gz" } ], "1.0.4": [ { "comment_text": "", "digests": { "md5": "33b8c827977d37aa0c7bbe9c4f91a092", "sha256": "92bff5e95767812d9b52d6c1de3bc1c00fc4c38bbae238019164f9aced1756af" }, "downloads": -1, "filename": "sql_faker-1.0.4-py2-none-any.whl", "has_sig": false, "md5_digest": "33b8c827977d37aa0c7bbe9c4f91a092", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 50118, "upload_time": "2018-10-12T15:11:23", "url": "https://files.pythonhosted.org/packages/76/cb/8289e21b69f82bf6c2f40b6eec90d6fbc5fef2b06b199af628800d0373a1/sql_faker-1.0.4-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "74158920cb775b2cb3310a46e14d7807", "sha256": "390cfcec2f71642eb10fd70514648504cc9925a4f9dc5cec1bd9d06861d38fff" }, "downloads": -1, "filename": "sql-faker-1.0.4.tar.gz", "has_sig": false, "md5_digest": "74158920cb775b2cb3310a46e14d7807", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 48783, "upload_time": "2018-10-12T15:11:02", "url": "https://files.pythonhosted.org/packages/9c/33/d62042bd68dd2375759a32d058f7f5528ee2b1442925c61f75d40479dc2c/sql-faker-1.0.4.tar.gz" } ], "1.0.5": [ { "comment_text": "", "digests": { "md5": "dace64937a92f4acca3e169658df3d6c", "sha256": "0d242d20da1bd71968d92ac016259d7bc9c3018aeea248ccf40db4c855cb35c5" }, "downloads": -1, "filename": "sql_faker-1.0.5-py2-none-any.whl", "has_sig": false, "md5_digest": "dace64937a92f4acca3e169658df3d6c", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 50066, "upload_time": "2018-10-12T15:19:22", "url": "https://files.pythonhosted.org/packages/48/6c/790075bfc696ae38a053e02c758fe517b9744881bb979e5a7494294f69df/sql_faker-1.0.5-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d297bb4c95e5563724432088683972cb", "sha256": "699eb9a781977ae1f75c15b451ff4d95bf17c29224fa8b1e0b94cad7282a6650" }, "downloads": -1, "filename": "sql-faker-1.0.5.tar.gz", "has_sig": false, "md5_digest": "d297bb4c95e5563724432088683972cb", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 48775, "upload_time": "2018-10-12T15:18:12", "url": "https://files.pythonhosted.org/packages/af/12/2c4d767aeb7eb7e64be000c56314ab30437351f9bd76e978ac41e01fce96/sql-faker-1.0.5.tar.gz" } ], "1.0.6": [ { "comment_text": "", "digests": { "md5": "9dbbe59cc8ab8384d7ad6127ec4487c1", "sha256": "3130f224b8e22637e831f98c60f3ec17c2a42df02fd6771cd0eb4c59fd9223aa" }, "downloads": -1, "filename": "sql_faker-1.0.6-py2-none-any.whl", "has_sig": false, "md5_digest": "9dbbe59cc8ab8384d7ad6127ec4487c1", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 52299, "upload_time": "2018-10-12T15:29:26", "url": "https://files.pythonhosted.org/packages/95/90/e9399be96fd484e8a48131022d46038288203d8a3c3f1a4fdbfbf6e4b217/sql_faker-1.0.6-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "c70f3fb525eda52d2129f8a478bd5e3f", "sha256": "28772cda9214d12f90ca0e4805a8a0307bd1ff62f3e102b53c327fe9d2cdbae0" }, "downloads": -1, "filename": "sql-faker-1.0.6.tar.gz", "has_sig": false, "md5_digest": "c70f3fb525eda52d2129f8a478bd5e3f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 48668, "upload_time": "2018-10-12T15:29:10", "url": "https://files.pythonhosted.org/packages/46/5a/27cf708ab45bfd93c9005bf5a546c00e36d26a563f6c52b9697fc81ec1c8/sql-faker-1.0.6.tar.gz" } ], "1.0.7": [ { "comment_text": "", "digests": { "md5": "64c92a3e2becfac4f43c934578092aae", "sha256": "1b6f99ccf9d39a0172c83118592bff50ce8b144a0bcb00c59cf0014139cda060" }, "downloads": -1, "filename": "sql_faker-1.0.7-py2-none-any.whl", "has_sig": false, "md5_digest": "64c92a3e2becfac4f43c934578092aae", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 52287, "upload_time": "2018-10-12T15:32:16", "url": "https://files.pythonhosted.org/packages/76/7f/03f96d0732808429f2b54bca60e27f31444d1f200605dba1364c85a6f538/sql_faker-1.0.7-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "78e983f304b14547f2b46b342da63cb8", "sha256": "57db4328497ab0355bf1ccc2f77af2b6c38c9bdbb1738f831bbe1d209c4c18ed" }, "downloads": -1, "filename": "sql_faker-1.0.7-py3-none-any.whl", "has_sig": false, "md5_digest": "78e983f304b14547f2b46b342da63cb8", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 47580, "upload_time": "2018-10-12T15:48:06", "url": "https://files.pythonhosted.org/packages/7e/de/fde2f8c7af1a101244b457b3908556cce8f91fe7373b65db8502478620fb/sql_faker-1.0.7-py3-none-any.whl" } ], "1.0.8": [ { "comment_text": "", "digests": { "md5": "ddab5c63be6e6d0ae560264b6e302cd6", "sha256": "cc174054bcb12c89e54aced4630eef742df14728bc4cd70c3732715525a12b58" }, "downloads": -1, "filename": "sql_faker-1.0.8-py2-none-any.whl", "has_sig": false, "md5_digest": "ddab5c63be6e6d0ae560264b6e302cd6", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 45902, "upload_time": "2018-10-12T15:54:27", "url": "https://files.pythonhosted.org/packages/54/e0/ef2339ef4d2208e48ecb53dd18f826b363a94bf692cb63ceb5e086b2dd09/sql_faker-1.0.8-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a6ba1282c911da8092d6f3bbf3e3465d", "sha256": "2dacdc28aea0464830662a4bb36b9b73c12df2753d36b8876b5f0b2ea9bf9706" }, "downloads": -1, "filename": "sql_faker-1.0.8-py3-none-any.whl", "has_sig": false, "md5_digest": "a6ba1282c911da8092d6f3bbf3e3465d", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 45061, "upload_time": "2018-10-12T15:55:58", "url": "https://files.pythonhosted.org/packages/b9/16/66bc0d2d857ef9b039ca418ef5de0ff50a1c9d298dbdfee9e98ba538d714/sql_faker-1.0.8-py3-none-any.whl" } ], "1.0.9": [ { "comment_text": "", "digests": { "md5": "cf8fd2216eabb5828a2edfd37cc813bd", "sha256": "79ae259b73d6bdcdc7b31513d7a22277ce86ff09e63a35e84078ed5996b38f8d" }, "downloads": -1, "filename": "sql_faker-1.0.9-py3-none-any.whl", "has_sig": false, "md5_digest": "cf8fd2216eabb5828a2edfd37cc813bd", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 45102, "upload_time": "2018-10-12T15:58:17", "url": "https://files.pythonhosted.org/packages/30/6a/b1a36d68207e549c75c2209297746711446cd2caefbd1b92b563551e68b5/sql_faker-1.0.9-py3-none-any.whl" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "1efdcb0318713299823411f1a316a90a", "sha256": "a05cbff6daa5b1325ffa36e94d23cc9e2cfe0fb211f472b5e56f6d5f8dc515f7" }, "downloads": -1, "filename": "sql_faker-1.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "1efdcb0318713299823411f1a316a90a", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 45317, "upload_time": "2018-10-12T16:03:15", "url": "https://files.pythonhosted.org/packages/43/59/f434efb689ca0bc9b6c665ef1322142bc4957ee07add4b8e8c3342380786/sql_faker-1.1.0-py3-none-any.whl" } ], "1.1.1": [ { "comment_text": "", "digests": { "md5": "b5f02be653dedf73999bb63cc74ae441", "sha256": "498c96bda7c92064bf2f5de8c567b39fdc670760dff783592b91c2c2632f240b" }, "downloads": -1, "filename": "sql_faker-1.1.1-py3-none-any.whl", "has_sig": false, "md5_digest": "b5f02be653dedf73999bb63cc74ae441", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 45342, "upload_time": "2018-10-12T16:08:07", "url": "https://files.pythonhosted.org/packages/44/2e/c3c3d540deeaaa1c4d07547f097a2ea0ff68643da4b0e58a8e184c41cf0f/sql_faker-1.1.1-py3-none-any.whl" } ], "1.1.2": [ { "comment_text": "", "digests": { "md5": "a2f5c56113d5fd360af5eb3231e5f608", "sha256": "788bbc1e01891ea0e15fa2a9db12512e40b61e1f1022e6784727cbe2ddf1a90e" }, "downloads": -1, "filename": "sql_faker-1.1.2-py3-none-any.whl", "has_sig": false, "md5_digest": "a2f5c56113d5fd360af5eb3231e5f608", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 45199, "upload_time": "2018-10-13T02:02:24", "url": "https://files.pythonhosted.org/packages/62/53/47e3e4f15305d682669e9a6ade0abf8ebbfd75600736599eb8a92857bb5d/sql_faker-1.1.2-py3-none-any.whl" } ], "1.1.4": [ { "comment_text": "", "digests": { "md5": "fd31a4795342c3920c3671e2c600a068", "sha256": "74d07d6d3e348959fc6238a48e35cddc3a64264a4384d9f1afc257e9cd19d862" }, "downloads": -1, "filename": "sql_faker-1.1.4-py2-none-any.whl", "has_sig": false, "md5_digest": "fd31a4795342c3920c3671e2c600a068", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 54091, "upload_time": "2018-10-13T02:38:49", "url": "https://files.pythonhosted.org/packages/24/be/ea5d9e956150549e528ff441674af456f9d88baa2e3577c609ecb08d53ca/sql_faker-1.1.4-py2-none-any.whl" } ], "1.1.5": [ { "comment_text": "", "digests": { "md5": "06bf5843f9f501a1850e72e1d2727ed3", "sha256": "aa1dc81767e856b22c3abea7187674bf0317fe4f7185a75fd5d03a0ccf9c5758" }, "downloads": -1, "filename": "sql_faker-1.1.5-py2-none-any.whl", "has_sig": false, "md5_digest": "06bf5843f9f501a1850e72e1d2727ed3", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 54449, "upload_time": "2018-10-13T02:53:43", "url": "https://files.pythonhosted.org/packages/66/e6/70e8bd784e72f3523f4077e6dc7da2a2e87eb23c4f2620cd81736ef7a10b/sql_faker-1.1.5-py2-none-any.whl" } ], "1.1.6": [ { "comment_text": "", "digests": { "md5": "0e438fefc1e9ef667f5343e7a68384d6", "sha256": "493a5ac433d98f5a9fc3bbec9939a3b9a2cb2c1339789c47ab66b1931ff212c0" }, "downloads": -1, "filename": "sql_faker-1.1.6-py2-none-any.whl", "has_sig": false, "md5_digest": "0e438fefc1e9ef667f5343e7a68384d6", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 54447, "upload_time": "2018-10-13T02:57:29", "url": "https://files.pythonhosted.org/packages/4a/b9/95864fd0711ed389ef69f0e66be942f0e63119ec92c1c61e579c7fa15913/sql_faker-1.1.6-py2-none-any.whl" } ], "1.1.7": [ { "comment_text": "", "digests": { "md5": "c85f879cf13253f4baedfd4f8e215d76", "sha256": "833c5a07cedec3d66fc5c2090efc03cc2e685fb003a7f54fc46f8a42bd197518" }, "downloads": -1, "filename": "sql_faker-1.1.7-py2-none-any.whl", "has_sig": false, "md5_digest": "c85f879cf13253f4baedfd4f8e215d76", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 54436, "upload_time": "2018-10-13T03:07:43", "url": "https://files.pythonhosted.org/packages/95/61/95aade9393d28381673fd2d140972c043cf349935967a7f9b1d80c1094c9/sql_faker-1.1.7-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e986dfb36831aaa208b7a8ffcd42109e", "sha256": "4d2e190e5890346d8d9a05bfa264b90121aeb8a569ab8381b376ee74f71d1506" }, "downloads": -1, "filename": "sql-faker-1.1.7.tar.gz", "has_sig": false, "md5_digest": "e986dfb36831aaa208b7a8ffcd42109e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 49279, "upload_time": "2019-02-28T05:40:32", "url": "https://files.pythonhosted.org/packages/d3/21/9653ea67c3be1d5a99e73a553b3b97a723ba96b4efcf1535d96163a1fac3/sql-faker-1.1.7.tar.gz" } ], "1.1.8": [ { "comment_text": "", "digests": { "md5": "759b957aa0f16097d20d2d44f1a51552", "sha256": "272111397f2e28476b7fdeb71864e3c032f4b1753573254ee349b145d9c32eab" }, "downloads": -1, "filename": "sql-faker-1.1.8.tar.gz", "has_sig": false, "md5_digest": "759b957aa0f16097d20d2d44f1a51552", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 49293, "upload_time": "2019-02-28T07:57:23", "url": "https://files.pythonhosted.org/packages/34/e9/113fde7802e7fa464134624108fab290695edfb5bdb601af607625014894/sql-faker-1.1.8.tar.gz" } ], "1.1.9": [ { "comment_text": "", "digests": { "md5": "75935bdbb26c00818eaa15c1b922ae99", "sha256": "2b4eaec74cd646759983e9392abce6c9b8b5bad5ef1825941ab2e635318ecae1" }, "downloads": -1, "filename": "sql-faker-1.1.9.tar.gz", "has_sig": false, "md5_digest": "75935bdbb26c00818eaa15c1b922ae99", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 49273, "upload_time": "2019-02-28T08:05:00", "url": "https://files.pythonhosted.org/packages/48/ef/e51301a3ae00736277601b923f4fd16c5523c50e9920f1a8b12a404d2737/sql-faker-1.1.9.tar.gz" } ], "1.2.0": [ { "comment_text": "", "digests": { "md5": "f8b6f06179398bbdc1e310a30be5b0b0", "sha256": "e1580b93e2f5a88d33ffc9225c7c19bfcbef55ec838e07895b1275a2c54180bd" }, "downloads": -1, "filename": "sql-faker-1.2.0.tar.gz", "has_sig": false, "md5_digest": "f8b6f06179398bbdc1e310a30be5b0b0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 49287, "upload_time": "2019-02-28T08:17:51", "url": "https://files.pythonhosted.org/packages/4a/aa/cb093fa2274370ece634dea1282b1dfb416bc7debe094426451b45056c65/sql-faker-1.2.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "f8b6f06179398bbdc1e310a30be5b0b0", "sha256": "e1580b93e2f5a88d33ffc9225c7c19bfcbef55ec838e07895b1275a2c54180bd" }, "downloads": -1, "filename": "sql-faker-1.2.0.tar.gz", "has_sig": false, "md5_digest": "f8b6f06179398bbdc1e310a30be5b0b0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 49287, "upload_time": "2019-02-28T08:17:51", "url": "https://files.pythonhosted.org/packages/4a/aa/cb093fa2274370ece634dea1282b1dfb416bc7debe094426451b45056c65/sql-faker-1.2.0.tar.gz" } ] }