#6148: Add generic support for database schemas
-------------------------------------+-------------------------------------
Reporter: ikelly | Owner:
Type: New feature | Status: new
Component: Database layer | Version: SVN
(models, ORM) | Resolution:
Severity: Normal | Triage Stage: Accepted
Keywords: oracle postgresql | Needs documentation: 0
mysql schemas | Patch needs improvement: 1
Has patch: 1 | UI/UX: 0
Needs tests: 1 |
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Changes (by akaariai):
* cc: anssi.kaariainen@… (added)
* easy: 1 => 0
Comment:
I think I am going to be the next one to pick this up. I hope I will have
time to work on this later this spring. But for now I have two questions:
When using MySQL or Oracle it seems you must create the schemas in testing
prefixed with `test_`. This will give serious problems for Raw SQL users,
and I guess there will be a lot of raw SQL users because multi-schema
support is most important for legacy databases. Any good ideas? You could
always write your SQL as:
{{{
cursor.execute("select * from %s where id = %%s" %
mymodel._meta.qualified_name, (params,))
}}}
that looks ugly, but I can't figure anything better. Better API welcome.
Although I don't care _that_ much, I use PostgreSQL... :)
The second question is if there is any core developer willing to support
my work? I hope there is somebody interested, as otherwise it can be
pretty hard to actually get the work finished and into core.
As said, I won't start working on this before I have time to do so. This
means at least a month before I can start polishing the patch, likely a
bit more.
--
Ticket URL: <https://code.djangoproject.com/ticket/6148#comment:97>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
