I'm using Django as front end to a MySQL database. User interface is a
terminal program, not a web site.
I've written a very simple generic function to edit the fields of one
record of a Django "object". It works fine for editing editable fields.
User specifies which field, then is shown the current value, raw_input()
for the new value, then save() the record.
For fields that connect to Foreign Keys, what I want to do is present to
user a simple list of Foreign Key records, from which the user will pick
the relevant ID. I know, given a list and the ID, how to then edit the
record by doing a Django get(id=ID) on the Foreign Key table. What I'm
having trouble doing is figuring how
1. Identify into a variable the name of the Foreign Key table/object
2. Then with that variable do a call to the relevant Foreign Key table,
e.g. ForeignKeyTable.objects.all()
See code below for <===WHAT I DO NOT KNOW HOW TO DO IN CODE Below. I think
I need some Django function that gives me the foreign key table in some
useable generic form.
Hope all this makes sense.
--rms
def EditDjangoObjectData(djangoobject,show=False,editonerecord=False):
"""
EditDjangoObjectData()
djangoojbect=a django object, e.g. a record in a table
"""
print "\n****ToDo Note: This routine not yet working on fields with
foreign keys!"
changelist=[]
ok=True
while ok:
change=None
fields = [(f.name, f.editable) for f in
djangoobject._meta.get_fields()]
if show:
print "\nfields:\n",fields
print "django object:\n",djangoobject
s="\nEditable Fields ('enter' to return): \n"
fieldlist=[]
for i in fields:
if i[1]: # only for 'editable' fields
if i[0].lower() <> "id":
s=s+i[0]+", "
fieldlist.append(i[0])
s=s+"DELETE or '?'"
fieldok=False
while not fieldok:
fieldtochange=raw_input("Enter field name to change:\n"+s+": ")
if not fieldtochange:
return None
elif fieldtochange.upper()=="DELETE":
ans=raw_input("...Confirm DELETE by typing 'DELETE': ")
try:
if ans=="DELETE":
rtn=djangoobject.delete()
print "Deleted. ",rtn
return rtn
except:
print "***DELETE Failed.",sys.exc_info()[0]
ans=raw_input("Press 'Enter' to continue ... ")
elif fieldtochange=="?":
PrintObjectDetails(djangoobject)
elif fieldtochange in fieldlist:
fieldok=True
else:
print "\n****Error. ",fieldtochange,"is not in list. Try
again."
print "Current Value of Field to
Change:",fieldtochange,"is:",getattr(djangoobject, fieldtochange)
**
** In here add some code to show a list of the foreign key records for user
to select, e.g. ID, Description,
**for r in ForeignKey.objects.all(): <== WHAT I DO NOT KNOW HOW TO DO IN
CODE.
** print i.id, i.description
**ID=raw_input("Enter ID:)
**foreignkeyobject=ForeignKey.objects.get(id=ID) <== WHAT I DO NOT KNOW
HOW TO DO IN CODE.
** ... then put that object into the relevant field
newvalue=raw_input("Enter New Value: ")
change="changed ["+fieldtochange+"]"
print "\nTo Save :",djangoobject
print "The Change:",change,"to",newvalue
if not newvalue:
return None
elif newvalue.lower()=="none":
newvalue=None
elif newvalue.lower()=="true":
newvalue==True
elif newvalue.lower()=="false":
newvalue=False
setattr(djangoobject, fieldtochange, newvalue)
try:
djangoobject.save()
print ": Success. Saved:",change,"to",newvalue
print ": New Object:",djangoobject
changelist.append(change)
print "ChangeList:",changelist
except:
print "***Save Failed.",sys.exc_info()[0]
ans=raw_input("Press 'Enter' to continue ... ")
if editonerecord:
ok=False
return changelist
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/4028d8fa-88b8-4940-ba41-a1b47a0913ba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
