Pip Not Working From Powershell

26 Feb 2014 If you have strawberry perl installed, you may get one of these errors when you try to use pip from powershell:

Did not provide a command
Unknown or unsupported command 'install'

This is the result of a conflict between strawberry perl's pip and python's pip. You need to remove anything related to strawberry perl from your path environmental variable and ensure you have C:\Python27\Scripts and C:\Python27\Scripts in your environmental variables.

Tableau's Frustrating Licensing Program

25 Feb 2014 Tableau's licensing program is crazy.

I was planning to use "Trusted Authentication" to share an embedded chart with lots of users (not all of whom have licenses). Some of those users will only look at the chart maybe once a year, and we can't justify buying them an entire license to look at a chart once.

This page says "everyone who visits the page must be a licensed user on Tableau Server": http://onlinehelp.tableausoftware.com/v7.0/server/en-us/trusted_auth.htm

If you want more details on how to implement Trusted Authentication using PHP, first visit the following folder on your server: C:\Program Files\Tableau\Tableau Server\8.1\extras\embedding\php

It has some sample code, but you need to install version 1.x of pecl_http to make it work. The guides for that are:

http://www.php.net/manual/en/http.install.php#113853
http://www.mkfoster.com/2009/01/04/how-to-use-the-pecl-http-pecl_http-extension-to-make-http-requests-from-php/ (careful, this guide will install pecl_http 2.x which is too different to work)

Possible Solution To Slow SQLalchemy + Flask Application

25 Feb 2014 This stackoverflow thread talks about why you want to use scoped_session:
http://stackoverflow.com/questions/6519546/scoped-sessionsession-maker-or-plain-session-maker-in-sqlalchemy

Basically, your web application isn't thread-safe if you're not using scoped_session. It's much better than having you application use a new thread for every instance.

An example of scoped_session in use is available here: https://github.com/mjhea0/flask-boilerplate/blob/master/models.py

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

Older Newer