tags:

views:

36

answers:

1
+1  Q: 

sqlalchemy in a single python script file

I've read about using sqlalchemywithin the pylons framework.

How will things work if I need it for a simple script file?

I have like importer.py that is spidering a site and I want to save to mysql.

If things are in a single file, can I still using sqlalchemy?

How do I setup my model/mappings then?

+3  A: 

If things are in a single file, can I still using sqlalchemy?

Yes, SQLAlchemy does not impose any restrictions on the way you use it.

You can see example on single-script initialization here: http://www.sqlalchemy.org/trac/attachment/ticket/1328/sqlalchemy-bug-query_Employee_company.py

Daniel Kluev  2010-07-27 14:41:38
thanks, what does: #!/usr/bin/env python mean at the top of the file?
Blankman  2010-07-27 14:43:44
Its common unix way to run scripts, called 'shebang'. It tells shell to execute '/usr/bin/env with arg 'python'. env itself is a way to run different installations of python on same machine. You can read more on it here: http://virtualenv.openplans.org/ P.S. you can consider it as just equivalent of running python <scriptname> from command line.
Daniel Kluev  2010-07-27 14:48:41

related questions

Programmatically talking to a Serial Port in OS X or Linux
Best ways to teach a beginner to program?
Calling a Function From a String With the Function's Name in Python
An executable Python app
Text Editor For Linux (Besides Vi)?
What Hosting Service is best for Django applications?
File size differences after copying a file to a server vía FTP
Python: what is the difference between (1,2,3) and [1,2,3], and when should I use each?
Python: What OS am I running on?
How do I make a menu in python that does not require the user to press (enter) to make a selection?
How do you express binary literals in Python?
What is the most efficient graph data structure in Python?
Adding a Method to an Existing Object
How to learn Python: Good Example Code?
How do I use Python's itertools.groupby()?
Python and MySQL
Class views in Django
Is there an IDE that provides code completion for Python
Using 'in' to match an attribute of Python objects in an array
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
Continuous Integration System for a Python Codebase
Get a preview jpeg of a pdf on windows?
How can I find the full path to a font from its display name on a Mac?
XML Processing in Python