sqlalchemy in a single python script file

Question

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?

Daniel Kluev · Accepted Answer · 2010-07-27 14:41:38Z

3

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

answered Jul 27, 2010 at 14:41

Daniel Kluev

11.4k2 gold badges38 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Blankman Over a year ago

thanks, what does: #!/usr/bin/env python mean at the top of the file?

Daniel Kluev Over a year ago

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: virtualenv.openplans.org P.S. you can consider it as just equivalent of running python <scriptname> from command line.

Collectives™ on Stack Overflow

sqlalchemy in a single python script file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related