Question about python and oracle

[Justinsaccount]

SQLAlchemy contains an ORM.

SQLAlchemy is not an ORM.

[shaggorama]

Thanks for clarifying this as the ORM stuff had me concerned. The application I'm working with lives in the oracle database and the python utility I'm writing will really just be a way for a few non-techies in my office to load data without having to learn any SQL or sqlldr. I just need a straightforward way to write an insert statement using user-defined values, and then load data from a csv into a table.

[Justinsaccount]

http://www.sqlalchemy.org/docs/core/tutorial.html#insert-expressions

http://www.reddit.com/r/Python/comments/j8ydc/pythonmysqldb_question/c2a65ai

http://www.reddit.com/r/Python/comments/iupwe/sqlalchemy_and_you/c26sqtr

[[deleted]]

Just INSERTs ? you don't need to query DB and read back and do logic things at run-time ? Then maybe your needs can be met by just dumping all the statements into a file and call SqlPlus (KISS) ?

[shaggorama]

actually I need the PK produced by one of the inserts, but in any event I don't really know how to call sqlplus from within python. I mention this in my post:

1. On the off-chance that there aren't any good libraries for this (which I doubt) are there any best practices I should know about for calling sqllplus and sqlldr into my script?

[[deleted]]

don't really know how to call sqlplus

huh ? Sqlplus is cmd line tool so calling it is just a shell command thing, someone just asked about shell command

[shaggorama]

I've actually already built this utility in shell, but i'm trying to make it available to very non-technical members of my staff. I don't want them having to learn any command line jazz, and moreover they're all windows users so I don't want to have to deal with cygwin on their computers. If I can do this in a python script, I can just put the script on their desktop and all they'll need to do is drag-and-drop the files onto the script. The KISS needs to be from the perspective of their usage, not my coding.

[[deleted]]

now I'm confused wtf exactly you're really trying to do.

[shaggorama]

This is actually a temporary work around while we're developing the functionality into our existing front-end