Calling all code-golfers ( @paul-griffith I know you like these) I am currently rewriting some stored procedures from the database into jython (to try to prove to my coworkers it’s a much easier to read 100 lines of jython vs 400 lines of SQL Server syntax to do the same thing). Here is the situati…

It’s not really practical to dynamically assign variables like this, but the obvious thing to try seems like returning a dictionary? So you’d have to productData['col1'] - still some extra characters, but not much. You’d have to decide how to feed the columns into this query, which would define you…

Yea I have a dictionary function already that does similar. I love dictionaries but not everyone I work with does, hence the question. This was more wondering if it was possible due to this reason. Good to know. Thanks @paul-griffith

I use a wrapper for dictionaries that look up missing properties in the dictionary, with an automatic fallback to none. SmartMap In this util script module. I instanciate from a dataset ds like so: smap = shared.smartmap.SmartMap(zip(ds.columnNames, [ds.getValueAt(0, c) for c in range(ds.columnCo…

[image] bkarabinchak.psi: col1 ,col2, col3, col4 = productData.getValueAt(0, 'col1'), productData.getValueAt(0, 'col2'), productData.getValueAt(0, 'col3'), productData.getValueAt(0, 'col4') not really a super good idea but it works... aslong there are no spaces or weird characters for name i…

Inductive Automation Forum

Cleaner way to get results of a query into variable names that match column?

Ignition