On Jan 24, 2011, at 6:55 AM, Massi wrote:
Hi everyone, in my script I have to deal with a table whose number of
columns can change at runtime. Since I have no information about the
structure I will have to handle at a given moment, I would need to
change dynamically the mapping during the program. If I try to re-map
the table I obviously get the following error:
sqlalchemy.exc.ArgumentError: Class 'class 'MyMappingClassa''
already has a primary mapper defined. Use non_primary=True to create a
non primary Mapper. clear_mappers() will remove *all* current mappers
from all classes.
On the other hand clear_mappers removes all the mappers that has been
defined on the classes; furthermore, as the documentation says:
clear_mappers` is *not* for normal use, as there is literally no valid
usage for it outside of very specific testing scenarios
Can anyone give a hint to handle correctly this situation or point me
out if there is a better approach to face it?
First I'll note that if the use case here is a table where some human or
process is constantly adding/dropping columns and the application needs to just
keep running and auto-adjusting to the schema changes, that is completely the
wrong way to use relational databases. Its like renovating your kitchen as you
make dinner at the same time.
Secondly, assuming that use case, you want to create the classes themselves on
the fly. Use the recipe at entity name:
http://www.sqlalchemy.org/trac/wiki/UsageRecipes/EntityName
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
