pwtools.sql.sql_column¶
- pwtools.sql.sql_column(key, lst, sqltype=None, sqlval_func=<function <lambda>>, fileval_func=<function <lambda>>)[source]¶
Convert a list lst of values of the same type (i.e. all floats) to a list of SQLEntry instances of the same column name key and sqltype (e.g. ‘float’).
See ParameterStudy for applications.
- Parameters:
key (str) – sql column name
lst (sequence of arbitrary values, these will be SQLEntry.sqlval)
sqltype (str, optional) – sqlite type, if None then it is determined from the first entry in lst (possibly modified by sqlval_func)
sqlval_func (callable, optional) – Function to transform each entry lst[i] to SQLEntry.sqlval Default is sqlval = lst[i].
fileval_func (callable, optional) –
Function to transform each entry lst[i] to SQLEntry.fileval Default is fileval = lst[i].
example:
>>> lst[i] = '23' >>> fileval = 'value = 23' >>> fileval_func = lambda x: "value = %s" %str(x)
Examples
>>> vals = sql_column('ecutfwc', [25.0, 50.0, 75.0], ... fileval_func=lambda x: 'ecutfwc=%s'%x) >>> for v in vals: ... print(v.key, v.sqltype, v.sqlval, v.fileval) ecutfwc REAL 25.0 ecutfwc=25.0 ecutfwc REAL 50.0 ecutfwc=50.0 ecutfwc REAL 75.0 ecutfwc=75.0