71 Commits

Author SHA1 Message Date
Charles Leifer ac959db5b4 Remove Python 2.x compatibility code. So long, old friend. 2026-03-09 10:39:07 -05:00
Charles Leifer ac82c4c08d New build system. 2026-01-06 23:01:39 -06:00
Charles Leifer caabbab3e0 Ensure backslashes are escaped properly in db filename (pwiz)
Fixes #2994, #2995
2025-06-02 13:52:59 -05:00
Charles Leifer 9a346d3e38 Better handling default engine when no engine specified to pwiz.
If no engine is specified and the db is a file, will default to sqlite
instead of postgres.
2021-03-27 13:41:21 -05:00
Charles Leifer b4d69192a2 Add support for cockroachdb to database model auto-generator. 2019-12-03 18:33:08 -06:00
Charles Leifer fb3b03d284 Use improved model and field naming with pwiz / reflection.
Replaces #1900
2019-03-31 12:34:44 -05:00
Charles Leifer 59a89ac873 Add option to ignore unknown field in pwiz.
Also fix introspection of BareField (no type) in Sqlite.
2019-03-24 13:30:00 -05:00
Charles Leifer 2730084137 Add support to playhouse.reflection and pwiz and for introspecting VIEWs.
Implements #1670
2018-07-17 14:32:04 -05:00
Charles Leifer b90bc0b9e5 Check for nonexistant pks in pwiz. 2017-05-16 23:50:08 -05:00
Charles Leifer 8cf9d918c3 pwiz updates and tests. 2017-04-24 10:23:50 -05:00
Charles Leifer 4274748a72 Add extension import to pwiz if required by schema. Fixes #929 2016-05-30 18:26:48 -05:00
Charles Leifer 6cf5c72980 Whoops, fix pwiz UnknownObject definition. 2016-05-11 20:43:03 -05:00
Charles Leifer 17866fff14 Fix #930, UnknownField implements __init__ method. 2016-05-11 11:02:01 -05:00
Charles Leifer 3635fcd4c4 Fix #757, thanks @SarahFowler73 2015-11-18 12:23:24 -06:00
Charles Leifer a225d69d9e Use getpass for password, fixes #756 2015-11-15 10:32:42 -06:00
pilate eb903737f4 Introspector doing too much work
Tables from arguments aren't being passed to introspector.
2015-05-20 10:07:37 -07:00
Charles Leifer ed3a5a3c6a Allow pwiz to preserve original column ordering, fixes #559 2015-03-26 23:16:45 -05:00
Charles Leifer 95672f6139 Fix bug in pwiz w/r/t composite pks and columns named 'id' 2015-03-12 11:28:50 -05:00
Charles Leifer 47d7500b49 Add code to print header when generating code w/pwiz. 2015-02-03 18:39:10 -06:00
Charles Leifer 9bc7df7cc4 Fix string formatting bug. 2015-01-22 14:56:42 -06:00
Charles Leifer b775cf34c5 Do not mark fields as PKs when there is a CompositeKey. Fixes #492 2014-12-31 11:16:41 -06:00
Charles Leifer 3f2d22bbd6 Fix #487 and #486 for real. 2014-12-31 10:08:48 -06:00
Charles Leifer f736a79820 Working on introspector refactor. 2014-11-25 21:15:25 -06:00
Charles Leifer 32730d3ddf Support for multi-column pks in reflection. 2014-10-30 13:51:47 -05:00
Charles Leifer 6a7617d4ff Refactor most of pwiz into a reflection module, refactor tests, add test
for pwiz model code generation.
2014-10-14 20:32:21 -05:00
Charles Leifer c7d538e216 Ensure all column names are generated before assigning foreign keys. 2014-09-24 06:46:10 -05:00
Charles Leifer 75981c468d Foreign key fixes for pwiz, fixes #426 2014-09-12 18:15:45 -05:00
Charles Leifer b9809882ed Stashing changes -- join_dict, notably 2014-07-27 11:54:21 -05:00
Charles Leifer a8f951176d Specify table_schema when getting columns, fixes #347 2014-05-03 09:55:21 -05:00
Charles Leifer 183cf77cb9 Rewrite of pwiz (!!!) 2014-04-29 22:53:21 -05:00
John Huffsmith bd629694c9 initializing kwargs earlier to prevent error at kwargs['primary_key'] = True 2014-03-25 13:22:15 -04:00
Charles Leifer 20329564fc Pwiz fixes. 2014-02-19 09:29:55 -05:00
Charles Leifer 8133618e6a Better FK regex in pwiz, fixes #300 2014-02-02 09:52:50 -06:00
Charles Leifer 3b8048dc9b Fixes #281 and #286, thanks @appetito for debugging this. 2014-01-16 10:04:57 -06:00
Charles Leifer 63086c84a1 Bugfix in pwiz. 2013-12-11 22:18:07 -06:00
Charles Leifer 13ed819071 Cleanup in pwiz, display unknown column types as comment, add underscore
to reserved words in column names rather thancommenting them out.
2013-12-10 00:16:06 -06:00
Charles Leifer 0ae1fb2cd4 Adding long -> bigint for sqlite. 2013-12-09 18:07:21 -06:00
Charles Leifer c84f83a235 Fix when column is named, simply, "_id" - fies #266 2013-12-06 09:59:37 -06:00
Charles Leifer a6884c52ce Handle square brackets in sqlite. 2013-11-11 08:50:54 -06:00
Charles Leifer 936874a78d Finally added tests for pwiz. 2013-06-20 11:47:15 -05:00
Charles Leifer a6c41329e0 Always generate the db_column attribute, fixes #44 2013-05-29 09:42:03 -07:00
Charles Leifer 8852188644 Small code cleanups to pwiz 2013-05-04 08:58:39 -05:00
Charles Leifer d031195d6e Fixing #189 2013-05-03 19:16:00 -05:00
Charles Leifer 525f1ee884 Fixing the table name generator in pwiz 2013-04-25 20:57:38 -05:00
Charles Leifer 187b394976 pwiz py3 compat 2013-04-01 21:48:19 -05:00
Charles Leifer c85eddf803 Hacking around on support for nullable columns in pwiz 2013-03-18 23:41:13 -05:00
Charles Leifer 83ea2ed77c Accept an optional list of tables and only print them (and their
dependencies)
2013-02-04 11:29:35 -06:00
Charles Leifer e0431b3b17 Docstring cleanup 2013-02-04 11:22:55 -06:00
Charles Leifer 5e98bda772 Fix for #159, print errors but do not terminate. Additionally, print to
standard error rather than stdout, so that error messages do not get
garbled with generated code
2013-02-02 19:55:32 -06:00
Charles Leifer c97355913f Check for reserved words in column names -- fixes #148 2013-01-15 14:20:26 -06:00