Electronics & Programming

develissimo

Open Source electronics development and programming

  • You are not logged in.
  • Root
  • » Django
  • » Using a Read-Only model for data, second database for "django stuff" [RSS Feed]

#1 March 26, 2008 14:08:26

Jesse N.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

Using a Read-Only model for data, second database for "django stuff"


This is a bit of an oddball question, but I figured I'd throw it out there.

I hate bugzilla's interface. I love Django.

I've been handed the task of doing a bit of data-mining on a bugzilla
database, and rather than work through the straight SQL, or using the
somewhat awful bugzilla query interface, I would much rather build out
my own little django app to provide the custom interface I want.

The problem I have is this - the bugzilla DB is read-only, no client
but bugzilla itself can change the tables, so I want to use the
auto-generated models.py from an inspectdb against the bz database,
but use a different database for any of the "other" tables/data (i.e:
the admin tables). I'd also need to set the model for the bz database
to read only.

Any suggestions on this - I know there was some discussion back in
Feb. about adding readonly/shadow flags to the models classes/Meta
options.

thanks

-jesse

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en-~----------~----~----~----~------~----~------~--~---

Offline

#2 March 26, 2008 17:26:40

James B.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

Using a Read-Only model for data, second database for "django stuff"


On Wed, Mar 26, 2008 at 8:08 AM, Jesse Noller <> wrote:
> I've been handed the task of doing a bit of data-mining on a bugzilla
> database, and rather than work through the straight SQL, or using the
> somewhat awful bugzilla query interface, I would much rather build out
> my own little django app to provide the custom interface I want.

Throw up databrowse on a user with read-only credentials.

To transfer data to another DB, simply import the appropriate database
adapter and grab a cursor, then starting INSERT'ing or UPDATE'ing
away.

--
"Bureaucrat Conrad, you are technically correct -- the best kind of correct."

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en-~----------~----~----~----~------~----~------~--~---

Offline

#3 March 26, 2008 17:27:04

James B.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

Using a Read-Only model for data, second database for "django stuff"


On Wed, Mar 26, 2008 at 11:26 AM, James Bennett <> wrote:
> To transfer data to another DB, simply import the appropriate database
> adapter and grab a cursor, then starting INSERT'ing or UPDATE'ing
> away.

(or, if you *must* use the ORM, use the serializer to spit out the
Bugzilla DB's data into a file, then deserialize into your read-write
DB)


--
"Bureaucrat Conrad, you are technically correct -- the best kind of correct."

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en-~----------~----~----~----~------~----~------~--~---

Offline

  • Root
  • » Django
  • » Using a Read-Only model for data, second database for "django stuff" [RSS Feed]

Board footer

Moderator control

Enjoy the 16th of December
PoweredBy

The Forums are managed by develissimo stuff members, if you find any issues or misplaced content please help us to fix it. Thank you! Tell us via Contact Options
Leave a Message
Welcome to Develissimo Live Support