local all postgres trust
I got the following code from slide 36 of this slideshow: http://www.slideshare.net/Stiivi/python-business-intelligence-pydata-2012-talk
engine = create_engine('mysql+mysqldb://username:firstname.lastname@example.org/databaseName')
metadata = MetaData(bind=engine)
You could also use that for looping through a list of the tables in the database.
for route in app.url_map.iter_rules():
You need to use: pip install MySQL-python
This article explains the correct approach: http://mysql-python.blogspot.com/2012/11/is-mysqldb-hard-to-install.html
That is the key to the kingdom when it comes to using extensions like Flask-Admin and Flask-Restless on existing tables which do not have a class already.
That guide gave me the least amount of hassle when I installed VNC on a server. I started by trying to get it working with 13.10, but had issues with a grey screen when tightvnc connected.
Unfortunately, it messed up quite a few links on my site.
I ended up solving the problem by changing "AllowOverride" None to "AllowOverride All" in my /etc/apache2/sites-available/default file.
Why the heck is CakePHP using .htaccess files by default anyway? Yii has this more streamlined.
There's also this one, but it has much fewer commits: https://github.com/zynesis/cakephp-boilerplate