Opened 18 years ago
Closed 18 years ago
#2563 closed defect (duplicate)
[patch] Full introspection functionality for ado_mssql backends
Reported by: | Owned by: | Adrian Holovaty | |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | dev |
Severity: | normal | Keywords: | |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | yes | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
This patch provides full introspection functionality for ado_mssql backends. It was tested on MSDE and SQL Server 2000 using adodbapi v. 2.0.1, Python 2.4.2, and Python 2.4.3. Using this patch, I was able to:
- Obtain a list of tables from the database.
- Obtain field information for each table.
- Map each field to its corresponding Django model type (including AutoFields).
- Retrieve relationship information.
- Retrieve Index information.
I tested this patch on two fairly large legacy databases, and the resulting model definitions were correct in both instances.
When time permits, I'll also test the patch on SQL Server Express and SQL Server 2005.
Note: This patch is dependent upon the changes in Ticket #2358. I've tested the changes in that ticket, and so far I haven't run into any problems. The attached patch actually improves on the introspection changes introduced that ticket.
The SVN diff of the patch.