From how I understand you, I think a varchar in the db storing the
expression using some sort of placeholders for the variables, then your
evaluate method would sub the vars in and use eval to evaluate the
subbed text string. You could even use erb to do the substitution if
need be. Just be careful eval''ing anything that includes user supplied
variables or expressions. Make sure you thoroughly check the variables
they supply as they could supply virtually any ruby code to be evaluated.
HTH,
-Bill
eyal wrote:> Hello,
>
> any ideas how I might store a formula in a mysql database and access
> it through my rails application. For example, say I have a model
> Formula, which has two integer variables formula.var1 and
> formula.var2. And each formula should have a stored formula that is
> made up of only addition and multiplication by numbers and these
> variables.
>
> I want to be able to assign formula.expression=something and
> formula.evaluate=expression evaluated at current variable
> assignments.
>
> Any idea what the best way to implement this might be. I am using
> MySQL 4.1.25 and Rails 2.2.2.
>
> Thanks,
> Eyal
> >
>
--
"She was attempting to bicycle kick me when she raised her butt up and
farted on me your honor."
"I have a list of all the dvd''s she had tooken..."
"I called him because I was mad that he was spreadin my famly business
round the trailer court..."
"She said she had no money for rent but she was makin money strippin"
"...they just completely at the point being turmoiled my life."
"...when the motor blowed up 2 months ago."
"I basically furnitured the whole house."
"I started the conversate on MySpace."
"I axed her what a lace from wig was and she axed me to come in for a
consertation..."
"He is the emotionalist man I eva seen..."
"...it literally ranned over my car. I mean, it may be a 2002 DaeWoo, but
it''s ma ride."
"<judge>...and here is a picture of your private parts.</judge>
<defendant>That''s when he stoled my
phone.</defendant>"
- Anonymous Quotes from Daytime Judge Shows
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---