Creating an array column within my model definition

Question

I want to create a table in my SQLAlchemy Pyramid app that stores a multidimensional array of values. I'm using PostgreSQL and I know that it has an array type. I'm just not quite sure of how to define the table in my models.py. Maybe something like:

class MyTable:
    __tablename__ = 'mytable'
    id = Column(Integer, primary_key=True)
    text_array = Column([Unicode])

    def __init__(self, text_array):
        self.text_array = text_array

If it's variable length and depth, prefer json. It'll be more straightforward to serialize and unserialize. And there's a json type which is useful in 9.3. — Denis de Bernardy
– Denis de Bernardy, Commented Oct 17, 2013 at 17:13

Mark Hildreth · Accepted Answer · 2013-10-18 14:19:51Z

4

According to the SQLAlchemy docs, you use the dialect-specific ARRAY type. Modifying your example leads to:

from sqlalchemy.dialects.postgresql import ARRAY

class MyTable:
    __tablename__ = 'mytable'

    id = Column(Integer, primary_key=True)
    text_array = Column(ARRAY(Unicode))

    def __init__(self, text_array):
        self.text_array = text_array

See the docs for multi-dimensional arrays (simply add the "dimensions" keyword argument to the ARRAY constructor).

edited Oct 18, 2013 at 14:19

answered Oct 17, 2013 at 18:30

Mark Hildreth

43.3k12 gold badges125 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating an array column within my model definition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related