Adminer - Unable to connect to PostgreSQL server: FATAL: Peer authentication failed for user

30 Jan 2014

You need to make sure you have the following line in your pg_hba.conf file:

local   all             postgres                                trust

Clone/Copy Table Schema From One Database To Another - SQLalchemy

30 Jan 2014

I got the following code from slide 36 of this slideshow: http://www.slideshare.net/Stiivi/python-business-intelligence-pydata-2012-talk

from sqlalchemy import create_engine, Table, Column, Integer, Unicode, MetaData, String, Text, update, and_, select, func, types # create engine, reflect existing columns, and create table object for oldTable srcEngine = create_engine('mysql+mysqldb://username:password@111.111.111.111/database') # change this for your source database srcEngine._metadata = MetaData(bind=srcEngine) srcEngine._metadata.reflect(srcEngine) # get columns from existing table srcTable = Table('oldTable', srcEngine._metadata) # create engine and table object for newTable destEngine = create_engine('mysql+mysqldb://username:password@localhost/database') # change this for your destination database destEngine._metadata = MetaData(bind=destEngine) destTable = Table('newTable', destEngine._metadata) # copy schema and create newTable from oldTable for column in srcTable.columns: destTable.append_column(column.copy()) destTable.create()

SQLalchemy - Print Tables In Database (Show Tables)

28 Jan 2014

from sqlalchemy import create_engine, Table, MetaData

engine = create_engine('mysql+mysqldb://username:password@111.111.111.111/databaseName')
metadata = MetaData(bind=engine)
metadata.reflect(engine)
print metadata.tables.keys()

You could also use that for looping through a list of the tables in the database.

Print Flask-Restless Routes

28 Jan 2014

# show api routes
for route in app.url_map.iter_rules():
    print route.rule

pip install MySQLdb

27 Jan 2014

In case you haven’t already noticed, the command in the title won’t work.

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

Generate Class From Existing Table Sql-Alchemy - Python

21 Jan 2014

http://stackoverflow.com/questions/6290162/how-to-automatically-reflect-database-to-sqlalchemy-declarative

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.

Best VNC Installation Guide

18 Jan 2014

Install VNC server on Ubuntu Server 12.04 (Amahi Wiki)

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.

"Could not connect to database: Database connection "Mysql" is missing, or could not be created." - CakePHP

15 Jan 2014

I got rid of this error just by creating the database manually. Shouldn’t Cake do this?

"Not Found The requested URL /app/install was not found on this server." - CakePHP

15 Jan 2014

Rather than dealing with my .htaccess problems to fix the error, I thought this would be a better approach: http://wwdj.wijndaele.com/getting-started-with-cakephp-without-mod_rewrite/

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 handles this more cleanly.

CakePHP Boilerplate

15 Jan 2014

While I was searching for a some good boilerplate to start my first CakePHP project with, I found this: https://github.com/hugodias/cakeStrap

There’s also this one, but it has much fewer commits: https://github.com/zynesis/cakephp-boilerplate

Older Newer