I've got a crazy requirement and I'm looking for tips & related projects.....or even possibly a contract engagement if someone has a brilliant solution they would like to propose
Customer wants "a visual rules editor" for their finance people......no problem, Blockly <https://blockly-demo.appspot.com/static/demos/blockfactory/index.html> can generate Python or multiple other executable syntax So what is the problem? - the data being passed INTO each generated Blockly function will vary in multiple ways: - In some contexts the payload-hierarchy is deep, in other contexts it's shallow - Some nodes in the payload will not always be present - In some cases, the "rule" needs a single aggregate value for it's math - in other cases, the rule needs to iterate individual rows for it's math OK -- talk about cross-cutting-concerns. So it seems to me the only sensible way to proceed is that the passed arg/param needs to have a queryable interface. Then the logic in the generated rule can remain someone simple as follows: - do you have any data like this? - then apply specified math to it Both SQLite and PYNC seem too heavy.......I have a limited set of queries, don't need "order by" and the mapping between queries and those libraries might be more work than hand-coding my own interface against a Dict(). I also feel strongly that the rule logic NOT be tied to SQL or that will bleed into the UI. But I also suspect implementing a Query-interface might be more complex than it initially seems. Feedback, suggestions, links, proposals?? Thanks, D -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
