Another Foreign Key Problem

--000e0cd34c7ac51d7104871df537
Content-Type: text/plain; charset=ISO-8859-1

Hi;
When I try to execute this code from my Python script, I get this error:

Traceback (most recent call last):
File "/var/www/html/creative.vi/clients/sea-flight/reservations/c reate_edit_bags3.py",
line 38, in ?
create_edit_bags3()
File "/var/www/html/creative.vi/clients/sea-flight/reservations/c reate_edit_bags3.py",
line 32, in create_edit_bags3
cursor.execute('insert into Baggage values (Null, %s, %s, %s,
%s)', (flight_id, customer_id, weight, ticket_no))
File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line
163, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py",
line 35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1452, 'Cannot add or update a child row: a foreign
key constraint fails (`seaflight/Baggage`, CONSTRAINT `Baggage_ibfk_2`
FOREIGN KEY (`customer_id`) REFERENCES `Customers` (`id`))')

However, when I try from the MySQL prompt after duly printing it out from
the code, it works. Why?
TIA,
Victor

--000e0cd34c7ac51d7104871df537--

Re: Another Foreign Key Problem

--000e0cd61a52f0786604871e0feb
Content-Type: text/plain; charset=ISO-8859-1

I'm canceling this thread. It belongs in the Python list. Sorry!
V

On Fri, May 21, 2010 at 1:24 PM, Victor Subervi wrote:

> Hi;
> When I try to execute this code from my Python script, I get this error:
>
> Traceback (most recent call last):
> File "/var/www/html/creative.vi/clients/sea-flight/reservations/c reate_edit_bags3.py", line 38, in ?
>
> create_edit_bags3()
> File "/var/www/html/creative.vi/clients/sea-flight/reservations/c reate_edit_bags3.py", line 32, in create_edit_bags3
>
> cursor.execute('insert into Baggage values (Null, %s, %s, %s, %s)', (flight_id, customer_id, weight, ticket_no))
> File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute
>
> self.errorhandler(self, exc, value)
> File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
> raise errorclass, errorvalue
> OperationalError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`seaflight/Baggage`, CONSTRAINT `Baggage_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `Customers` (`id`))')
>
> However, when I try from the MySQL prompt after duly printing it out from
> the code, it works. Why?
> TIA,
> Victor
>

--000e0cd61a52f0786604871e0feb--