30 Aug
2017
30 Aug
'17
2:06 p.m.
Hello all, I'm becoming a regular here now, aren't I?
So I have this table in mysql:
+----------+----------+--------+-----------+---------+
| key_name | key_type | value1 | value2 | value3 |
+----------+----------+--------+--------+--------+
| key1 | 1 | valueA | valueF | valueK |
| key1 | 1 | valueB | valueG | valueL |
| key1 | 1 | valueC | valueH | valueM |
| key2 | 1 | valueD | valueI | valueN |
| key2 | 1 | valueE | valueJ | valueO |
I was hoping I could have all this information available in an sht, where
for example:
$sht(a=>$key1[0]), $sht(a=>$key1[1]), etc
would return:
"valueA,valueF,valueK", "valueB,valueG,valueL" etc
but I can't figure out how to setup htable to import this data on
restart. I have tried various combinations of module parameters such
as:
modparam("htable", "htable",
'my_htable=>size=8;autoexpire=86400;dbtable=my_table;cols="key_name,value1,value2,value3";'
I'm either getting errors, or dumping htable will only show one of the
value sets (key_type is not set to array).
Does anyone have a working config to share? Thanks!
George