IBAN = Required(str)
Credit_Card_number = Required(int)
CV2 = Required(int)
"credit_card_number": "2221597849919620",
with db_session:
with open('user_data.json') as f:
for i in data:
Card(FirstName=i['firstName'], LastName=i['lastName'], Age=i['age'], IBAN=i['iban'], Credit_Card_number=i['credit_card_number'],.......
ValueError: Value 2221597849919620 of attr Card.Credit_Card_number is greater than the maximum allowed value 2147483647
So how do i fix this to allow it be sent into mysql using the pony orm and python.
You should be using a long integer column type for the
credit_card_number
field. On many databases (including MySQL, SQL Server, and Postgres), this would be aBIGINT
type column.