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

Exception in thread "main" java.lang.NoClassDefFoundError - Java

07 Jan 2014

Got this error when I was missing a library that came with the build.

If you’re getting this error, you may need to move the lib folder from your build directory into the folder of your JAR file.

Older Newer