I need to be pointed in the right direction, some links to some good articles would be great!
My idea is thus!:-
Problem: Our clients quite often require rules based on dynamic values, these values can change quite often and these rules be quite complex.
Essentially I want to be able to perform certain database tasks based on these rules.
What I imagine is a web interface which allows end users to build a rule based on functions & operations given a specific set of information which I would supply to a scripting language, either in specifc javaobjects, or an available sets of information retrieved from the DB via simple user functions eg (LOOKUP(<tableName>,LIST(CRITERIA(<field>,<op>,<value>),CRITERIA(<field>,<op>,<value>))), ... or similar.
I'm thinking the interface should be remiscent of the simple script used in MS-Excel, and probably built using a similar interface.
So I guess I'm looking for a scripting language that will handle flow control (IF, AND, OR ,NOT ), simple math (3 + 3), temp variables, (@x = function() + 3*@y), and the ability to create custom tokens/functions that relate to Java based functions or variables (I want to relate scripting functions back to Java code not write them into the script. Why? I want to sniff out errors or injection & I want to use existing java based code, esp. for DB operations).
I think I'd prefer loose type-ing, but I think some user error control would be nice too!
Yeah that's it in a nut shell. I'm sure i'm not the first person to attempt doing this, so maybe one of you has done this before and can point me in the right direction to get started.