As I said, the issue lies with the usage of the psycopg2 dbapi. Write
a test case using only psycopg2:
import psycopg2
conn = psycopg2.connect(user=user, passwd=password)
cursor = conn.cursor()
cursor.execute("my statement")
Assuming the behavior reproduces, check with their mailing list.
There is nothing SQLAlchemy does outside of the above.
On May 25, 2009, at 11:38 AM, Paulo Nuin wrote:
>
> Hi
>
> The line on temp2.csv has all the values, and the delimiters are fine:
>
> 13177 13177 13177 555.2051 1662.59362792969 64.374802
> 109 0
>
> If I remove the line, it sometimes fails again on the same line, with
> different values then, or fails in another line. I have a series of
> tab
> delimited files to input, and the command fails with different types
> of
> inputs, integer, floats, etc. A larger file also fails in the
> middle, a
> shorter file also fails. Testing all the possible input sizes on psql,
> everything is smooth and the inputs are accepted.
>
> Thanks
>
> Paulo
>
>
> Michael Bayer wrote:
>> On May 25, 2009, at 11:13 AM, nuin wrote:
>>
>>
>>> sqlalchemy.exceptions.DataError: (DataError) missing data for column
>>> "spectral_analysis_id"
>>> CONTEXT: COPY precursor, line 360: "13177 13177 13177
>>> 555.2051 1662.59362792969 64.374"
>>> "COPY precursor (spectrum_number, scan_begin, scan_end, mass, mtoz,
>>> elution_time_begin, spectral_analysis_id, charge) F
>>> ROM 'C:/Users/nuin/workspace/OCBN/src/ipad_parser_1/temp2.csv' " {}
>>>
>>>
>>
>> im not familiar with direct usage of COPY FROM but it seems here like
>> line 360 of your input file only has six elements and the COPY
>> statement is asking for eight. its not a SQLalchemy issue in any
>> case and if anything would be specific to psycopg2, if at all.
>>
>>
>>>
>>
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
