Solved

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

Posted on 2014-10-16
1
257 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Title # Comments Views Activity
.properties file to call function/method 9 63
python pyusb how to find a file on mass storage 3 97
Windows Command Line in Python 16 98
What is Python programming? 3 130
Variable is a place holder or reserved memory locations to store any value. Which means whenever we create a variable, indirectly we are reserving some space in the memory. The interpreter assigns or allocates some space in the memory based on the d…
When we want to run, execute or repeat a statement multiple times, a loop is necessary. This article covers the two types of loops in Python: the while loop and the for loop.
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 lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…

733 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