AttributeError: "'module' object has no attribute 'ARRAY'"

Question

I'm trying to create a table in SQLAlchemy where the email column is an array of email addresses. However, I'm getting this error:

AttributeError: "'module' object has no attribute 'ARRAY'"

I looked up in the docs http://docs.sqlalchemy.org/en/latest/core/type_basics.html#sqlalchemy.types.ARRAY

but I guess I didn't understand the correct implementation.

import datetime
from sqlalchemy import schema, types
from sqlalchemy import orm


metadata = schema.MetaData()

def now():
    return datetime.datetime.now()

page_table = schema.Table('candidate', metadata,
    schema.Column('id', types.Integer, schema.Sequence('page_seq_id', optional=True), primary_key=True),
    schema.Column('email', types.ARRAY(String), nullable=False),
    schema.Column('first', types.Unicode(255), nullable=False),
    schema.Column('last', types.Unicode(255), nullable=False),
    schema.Column('company', types.Unicode(255), nullable=False),
    schema.Column('title', types.Unicode(255), nullable=False),
    schema.Column('linkedin', types.Unicode(255), nullable=False, unique=True),
)

class Candidate(object):
    pass

orm.mapper(Candidate, page_table)

Can any suggest how to make this work?

What is your sqlalchemy version?

alpert
– alpert

2016-04-29 17:11:42 +00:00
Commented Apr 29, 2016 at 17:11 — alpert
– alpert, Commented Apr 29, 2016 at 17:11

user2357112 · Accepted Answer · 2016-04-29 17:09:21Z

2

sqlalchemy.types.ARRAY is new in 1.1.0, a version that has not yet been released. Unless you're on a development build of SQLAlchemy, you will not have access to that type.

answered Apr 29, 2016 at 17:09

user2357112

286k32 gold badges490 silver badges571 bronze badges

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

6 Comments

dropWizard Over a year ago

ahh ok thank you. Is there anything I can do in the short term?

user2357112 Over a year ago

@MorganAllen: If you're on Postgresql, sqlalchemy.dialects.postgresql.ARRAY may be an appropriate substitute. If you're not on Postgresql, SQLAlchemy doesn't seem to actually have support for SQL arrays, even with sqlalchemy.types.ARRAY.

dropWizard Over a year ago

I'm currently using SQLLite

user2357112 Over a year ago

@MorganAllen: I don't think SQLite has arrays.

dropWizard Over a year ago

I guess the answer would be to break out the email address's into its own table and create a foreign key?

|

Brendan Abel · Accepted Answer · 2016-04-29 17:28:11Z

1

I'm guessing you want to use this to store multiple emails for a user. Without an ARRAY type, this would traditionally be handled by creating another table -- Email -- with a one-to-many link to the Candidate table.

email_table = schema.Table('email', metadata,
    schema.Column('id', types.Integer, schema.Sequence('email_seq_id', optional=True), primary_key=True),
    schema.Column('email', types.Unicode(255), nullable=False),
    schema.Column('candidate_id', types.Integer, ForeignKey("candidate.id"), nullable=False),
)

class Email(object):
    pass

mapper(Email, email_table)

mapper(Candidate, page_table, properties={
    'emails' : relationship(Email, backref='candidate', order_by=email_table.c.id)
})

edited Apr 29, 2016 at 17:28

answered Apr 29, 2016 at 17:22

Brendan Abel

38k16 gold badges101 silver badges126 bronze badges

Collectives™ on Stack Overflow

AttributeError: "'module' object has no attribute 'ARRAY'"

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related