Solved

Python CherryPy SQLAlchemy class - how to loop through form vars and assign to dat aobject

Posted on 2014-10-16
1
254 Views
Last Modified: 2014-10-20
Hi there,

I am using CherryPy and SQLALchemy and I am trying to put some code together to loop through the posted form vars and assign their values to my data object.  There are a lot of cases where I want to do this and the data records have a LOT of fields.

So, if the class I am trying to assign the values to is User with Last_Name and First_Name columns, for example.

I can loop through the kwargs and get the form vars.  The posted form-vars names/id's correspond with the column names on my User object.

But I don't know how to code an assignment as an expression

This_Object = User()     ... gives me my data class/object

.. then I loop through the parms ...

for lcParm in kwargs:
 lcVal = kwargs.get(lcParm,'')

..so, I can loop through and pick up the values, but how do I code the assignment of the value to the data object field?

The name is in lcParm (eg; Last_Name) .. but how do I code This_Object.lcParm = lcVal

Please help!

Thx, Scott
0
Comment
Question by:srbarker8
1 Comment
 
LVL 25

Accepted Solution

by:
clockwatcher earned 500 total points
ID: 40385894
You should be able to use the setattr function.
This_Object = User()
for lcParm in kwargs:
    lcVal = kwargs.get(lcParm,'')
    if hasattr(This_Object, lcParm) and lcParm in User.__mapper__.columns:
        setattr(This_Object, lcParm, lcVal)
session.add(This_Object)

Open in new window

0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Plenty of writing has gone on the web trying to compare Python with other competitive programming languages and vice versa. However, not much has been put into a wholistic perspective. This article should help you decide whether to adopt Python as a…
Dictionaries contain key:value pairs. Which means a collection of tuples with an attribute name and an assigned value to it. The semicolon present in between each key and values and attribute with values are delimited with a comma.  In python we can…
Learn the basics of strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question