[Pytables-users] How-to create nested variable length arrays

[Erik D. <eri...@ya...>]

Hi,

what is the best way to create a Table with nested array columns?

I have a 1:N relationship in a data structure and would like to store the dependent data in the same row, because at each lookup of a child row I also need the parent data and vice versa.

Best would be, if I could create something like this:

class Child(IsDescription):
    id = IntCol()
    valueY = StringCol(10)

class Parent(IsDescription):
    id = IntCol()
    valueX = StringCol(50)
    childList = TableCol(Child)


and the usage would be:

h5 = tables.createFile(..., 'parent_tbl',....., Parent,....)
h5.root.parent_tbl.append(
    [(1,'valuexxx1', [(1, 'y1'), (2,'y2'), (3,'y3')]),
     (2,'valuexxx2', [(1, 'yy12'), (2,'yy22')]),
     (3,'valuexxx3', [(1, 'yyy123')])
    ])

As you can see the Sub-Array has not a fixed length.

If this is not possible what is the best and fastest way to get such a structure accessed?

Thanks in advance
Erik



      __________________________________________________________
Gesendet von Yahoo! Mail.
Dem pfiffigeren Posteingang.
http://de.overview.mail.yahoo.com