DataError: invalid input value for enum

[Michael Hipp]

I have a model that looks something like this:

TRANS_CODES = ( 'SellCar', 'BuyCar', 'BuyFee', 'SellFee',
'Gas/Fuel', 'Detail', 'Wash/Vac', 'Trans/Hauling',
'Service/Repair', 'DraftFee', 'Misc', 'Cash',
'CheckPaid', 'CheckRcvd', 'FloorPlan', 'Draft')

class Trans(Base):
__tablename__ = 'trans'

code = Column(Enum(*TRANS_CODES, name='trans_codes'),
nullable=False)

When I attempt to save a 'Cash' transaction I get the error below on the
enum value. Any suggestions on how to troubleshoot this?

Thanks,
Michael
---------------------------------------------------
sqlalchemy.exc.DataError: (DataError) invalid input value for enum
trans_codes: "Cash"
LINE 1: ...1T15:55:32.943000'::timestamp, false, false, E'', E'Cash', E...
^
'INSERT INTO trans (date, void, printed, agent, code, ch_num, memo,
payee, exp_id, qty, each, payment, deposit, invoice_id, account_id)
VALUES (%(date)s, %(void)s, %(printed)s, %(agent)s, %(code)s,
%(ch_num)s, %(memo)s, %(payee)s, %(exp_id)s, %(qty)s, %(each)s,
%(payment)s, %(deposit)s, %(invoice_id)s, %(account_id)s) RETURNING
trans.id_' {'code': 'Cash', 'account_id': None, 'invoice_id': 2, 'void':
False, 'agent': '', 'qty': Decimal('1'), 'payee': '', 'deposit': False,
'payment': True, 'each': Decimal('1000.00'), 'date':
datetime.datetime(2010, 10, 31, 15, 55, 32, 943000), 'exp_id': '',
'ch_num': '', 'memo': 'TEST AUTOMATIC PAYMENT', 'printed': False}

[Michael Bayer]

check that the ENUM type which was generated, or its CHECK constraint, includes "Cash". With the Enum type, you can't add new values to the list without also changing the ENUM type or CHECK constraint.

> --
> You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
> To post to this group, send email to sqlal...@googlegroups.com.
> To unsubscribe from this group, send email to sqlalchemy+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
>