SQLAlchemy and INET Array in Python ( no Flask )

Question

How can you load a table with INET ARRAY type?

cidr_table = db.Table('cidr_table', metadata,
        db.Column('range_name', db.String(255), nullable=False),
        db.Column('wide_range_cidr', postgresql.INET(), nullable=False),
        db.Column('used_cidr_list', postgresql.ARRAY(??????))
        )

I am trying to get the used_cidr_list to be an array of INET values which will be populated like [10.0.0.0/10, 10.1.0.0/16, and so on ]

How can i achieve that?

Thank you

Possibly related.

snakecharmerb
– snakecharmerb

2022-04-19 06:31:18 +00:00
Commented Apr 19, 2022 at 6:31 — snakecharmerb
– snakecharmerb, Commented Apr 19, 2022 at 6:31

chintan-p-bhatt · Accepted Answer · 2022-07-09 15:45:36Z

2

There is the same method of using INET with or without flask

from sqlalchemy.dialects.postgresql import INET

class Hosts(db.Model):

    __tablename__ = 'hosts'

    host_id = db.Column(db.Integer(), db.Identity(), primary_key=True)

    host_name = db.Column(db.String(), nullable=False)

    host_ip_addresses = db.Column(db.ARRAY(INET()), nullable=True)

So in your case, It will be

    db.Column('used_cidr_list', db.ARRAY(INET()))

edited Jul 9, 2022 at 15:45

answered Jul 9, 2022 at 15:31

chintan-p-bhatt

1862 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

SQLAlchemy and INET Array in Python ( no Flask )

1 Answer 1

There is the same method of using INET with or without flask

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

There is the same method of using INET with or without flask

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related