Thanks a lot Michael, now it works! this is my final script, maybe it
could help others:
engine = create_engine('oracle://user:passw...@host:1521/dbname',
echo=True)
metadata = MetaData()
pushmail_table = Table('pushmail', metadata,
Column('telefono', String, primary_key=True),
Column('fecha', DateTime, default=datetime.datetime.now ),
Column('correo', String),
schema='manpushmail'
)
On sqlplus I do a : "SELECT * FROM MANPUSHMAIL.PUSHMAIL;"
On 2 mar, 16:34, Michael Bayer <mike...@zzzcomputing.com> wrote:
> additionally don't shove a schema/owner name into your table's name field.
> Use the "schema" kw arg for that.
>
> On Mar 2, 2010, at 4:23 PM, celord wrote:
>
> > Thanks Michael, I have changed all UPERCASE to lowercase
> >http://www.pastebin.org/100149, the output has changed a bit but the
> > table name is still quoted and the insert does not work
>
> > sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-00942: table or view
> > does not exist
> > 'INSERT INTO "manpushmail.pushmail" (telefono, fecha, correo) VALUES
> > (:telefono, :fecha, :correo)' {'correo': 'cgar...@ice.co.cr', 'fecha':
> > ' ', 'telefono': '87445511'}
>
> > On 2 mar, 12:39, "Michael Bayer" <mike...@zzzcomputing.com> wrote:
> >> read the note about "case sensitivity" in
>
> >>http://www.sqlalchemy.org/docs/reference/dialects/oracle.html?highlig...
>
> >> celord wrote:
> >>> Hello guys, I have the table on an oracle db:
>
> >>> SQL> desc MANPUSHMAIL.PUSHMAIL;
> >>> Nombre Nulo? Tipo
> >>> ----------------------------------------- --------
> >>> ----------------------------
> >>> TELEFONO NOT NULL VARCHAR2(12)
> >>> FECHA DATE
> >>> CORREO VARCHAR2(40)
> >>> ESTADO NUMBER(1)
> >>> FECHA_EJECUCION DATE
> >>> FECHA_EJECUTADO DATE
> >>> RESPUESTA VARCHAR2(500)
>
> >>> I can insert data succesfully via sqlplus like this:
>
> >>> insert into MANPUSHMAIL.PUSHMAIL values
> >>> ('55552222',sysdate,'t...@domain.con','','','','');
>
> >>> but using this scripthttp://www.pastebin.org/100014viasqlalchemy I
> >>> get this:
>
> >>> sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-00942: table or view
> >>> does not exist
> >>> 'INSERT INTO "MANPUSHMAIL.PUSHMAIL" ("FECHA", "CORREO") VALUES
> >>> (:FECHA, :CORREO) RETURNING "MANPUSHMAIL.PUSHMAIL"."TELEFONO"
> >>> INTO :ret_0' {'CORREO': None, 'FECHA': None, 'ret_0':
> >>> <cx_Oracle.STRING with value None>}
>
> >>> I do not know if the error could be here: 'INSERT INTO
> >>> "MANPUSHMAIL.PUSHMAIL", because when I try to do the insert with the
> >>> table name between quotes I get the same error:
>
> >>> insert into "MANPUSHMAIL.PUSHMAIL" values
> >>> ('55553333',sysdate,'te...@domain.com','','','','')
> >>> ORA-00942: table or view does not exist
>
> >>> I am using sqlalchemy version: 0.6beta1 , Python 2.6 on a Solaris 10
> >>> box, and Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
>
> >>> Thanks a lot!!!
>
> >>> --
> >>> You received this message because you are subscribed to the Google Groups
> >>> "sqlalchemy" group.
> >>> To post to this group, send email to sqlalch...@googlegroups.com.
> >>> To unsubscribe from this group, send email to
> >>> sqlalchemy+unsubscr...@googlegroups.com.
> >>> For more options, visit this group at
> >>>http://groups.google.com/group/sqlalchemy?hl=en.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "sqlalchemy" group.
> > To post to this group, send email to sqlalch...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > sqlalchemy+unsubscr...@googlegroups.com.
> > For more options, visit this group
> > athttp://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
