pradeepgowda.com

A script to generate SQL create table statement given a CSV file

Pradeep Gowda — Mon, 04 May 2009 16:28:40 GMT

Given a CSV file with a header row and at-least one row of data, output a SQL `CREATE TABLE` statement by guessing the data type of the columns.

Pradeep Gowda — Thu, 16 Apr 2009 01:52:56 GMT

On request from a user, I've put together a sample django app that uses PyOFC2 to render charts in web browsers using Open Flash Charts 2.

The django+pyofc2 demo code can be downloaded from github.

Download Open Flash Chart 2
Download and install PyOFC2
Download SWFObject and put the files in your static media directory
Add references to the SWFObject files and open-flash-chart.swf file in the header section. See templates/index.html for details
Create a view to serve the json data from. See demoapp/views.py
Configure urls.py to map the view to the url endpoint.

Pradeep Gowda — Sun, 25 Jan 2009 03:04:26 GMT

I've written a python library to generate data files used by the excellent Open Flash Chart 2.The project page: http://btbytes.github.com/pyofc2/

There are a couple of advantages PyOFC2 has over the one distributed with OFC2.

Complete. I've implemented python wrapper classes for all chart types and elements.
Pythonic. The original PHP library uses setters and getters for properties etc.,
Demo charts. Each chart type has a test_foo function which shows the usage.
Test coverage.
No dependency on any python framework. The default distribution uses Cherrypy.

Notes

Pradeep Gowda — Wed, 05 Nov 2008 13:38:41 GMT

webgen.py is a simple static website generator written in Python.

The source code is available on github – http://github.com/btbytes/webgen.py

Pradeep Gowda — Tue, 04 Nov 2008 04:36:07 GMT

Jython is an implementation of Python programming language on Java Virtual Machine.