Dear readers,
This is a beginner's question, but I am really stuck with this problem. Currently I am trying to retrieve data from a given Oracle database with Sqlalchemy (version 0.7.7). Until now, this worked fine for me. However, now I have to read out this table create table DISPLAYOPTIONS ( DOID integer constraint DO_PK primary key USING INDEX (create index DO_PK_IX on DISPLAYOPTIONS(DOID) ), OPT dispopt); where dispopt is a custom type defined as CREATE OR REPLACE TYPE DISPOPT AS OBJECT ( LABEL_X varchar2(50), LABEL_Y varchar2(50), LABEL_Z varchar2(50)); How do you define custom types in Sqlalchemy? I found in the documentation http://docs.sqlalchemy.org/en/rel_0_9/core/types.html#creating-new-types Is this the right starting point? Do you know some examples close to the problem I face? Furthermore, I found this on Stackoverflow: How do I make compound columns with SQLAlchemy declarative? <http://stackoverflow.com/questions/9565689/how-do-i-make-compound-columns-with-sqlalchemy-declarative> linking to the documentation: <http://docs.sqlalchemy.org/en/latest/orm/mapper_config.html#composite-column-types> http://docs.sqlalchemy.org/en/latest/orm/mapper_config.html#composite-column-types and set up: class DISPOPT(object): def __init__(self, LABEL_X, LABEL_Y, LABEL_Z): self.LABEL_X = LABEL_X self.LABEL_Y = LABEL_Y self.LABEL_Z = LABEL_Z def __composite_values__(self): return self.LABEL_X, self.LABEL_Y, self.LABEL_Z class DISPLAYOPTIONS(Base): __tablename__ = "DISPLAYOPTIONS" DOID = Column(Integer, primary_key = True) OPT = composite( DISPOPT, Column('LABEL_X', String(50)), Column('LABEL_Y', String(50)), Column('LABEL_Z', String(50)) ) But still I am receiving error messages from the database. Please note that I also have posted my question on Stackoverflow: http://stackoverflow.com/questions/25137847/how-to-set-up-an-user-defined-type-in-sqlalchemy I hope that this is tolerated on this mailing list. Thank you very much in advance and best regards, Felix -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.