What's the proper way to define a "MAC Address" for a column type?

[waliddoch]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

from sqlmodel import SQLModel, Field, Relationship
import sqlalchemy as sa 

class SensorDevice(SQLModel, table=True):
    __tablename__: str = "sensor_device"
    
    id: int | None = Field(default=None, primary_key=True)
    mac_address: str = Field(sa_column=sa.Column(sa.types.MACADDR))  # Using MACADDR type

Description

What is the common proper way to set a MAC Address via SQLModel (PostgreSQL) ?
For the following code example, i got this error:

"MACADDR" is not a known attribute of module ".types"PylancereportAttributeAccessIssue
(function) MACADDR: Unknown

Operating System

Linux, Windows, macOS

Operating System Details

No response

SQLModel Version

0.0.19

Python Version

Python 3.12.4

Additional Context

No response

[YuriiMotov]

This type is dialect-specific (postgresql).
Use correct import path

from sqlalchemy.dialects.postgresql import MACADDR