Hide Zero Value Points On Google Chart

18 Feb 2014 I have a line chart which needed a series of points. I don't want points to show if the value is zero.

Here's my solution:

Set the series's lineWidth to zero and make the point larger than 0:
series: {0: {lineWidth: 0, pointSize: 5}}
Make the viewWindow setting's min higher than 0 (to hide the 0 points):
vAxis: { viewWindowMode:'explicit', viewWindow:{ min: 0.5 } },

Change Home Flask-Admin

17 Feb 2014 This was the only thing I was able to get working: http://www.marteinn.se/blog/?p=637

Just putting index.html into an admin/ directory wouldn't work.

There's also an even shorter way to do it, for example:
admin = Admin(app, "G-Cal Manager", index_view=AdminIndexView(name='Home', template='admin/home.html', url='/'))

The example above will change the root url to / instead of /admin and it will use home.html from your templates/admin folder.

To fix the 404 errors on your stylesheets after the change, you will also need to change the static_folder in your flask object:
app = Flask(__name__, static_folder='admin')

invalid byte sequence for encoding "UTF8" - sqlalchemy

30 Jan 2014 Try putting ?charset=utf8 at the end of your connection string, like:
'mysql+mysqldb://user:pass@111.111.111.111/rf?charset=utf8'

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 https://wiki.amahi.org/index.php/Install_VNC_server_on_Ubuntu_Server_12.04

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.

Older Newer