Wednesday, 15 December 2010

QtCore.QDate gotcha for python dictionaries

I came across an odd little issue this morning while creating a data model for a diary I am writing.

In the model, Data is stored in a dictionary, with dates as keys.
For a variety of reasons, my first choice was to use a QDate for the keys, however this produced odd results.
The following example code should demonstrate.

>>> from PyQt4.QtCore import QDate
>>> mydict = {}
>>> for year in range(2009,2013):
...     dt = QDate(year,1,1)
...     while dt.year() == year:
...         mydict[d] = "boo"
...         dt = dt.addDays(1)
>>> mydict.keys()[:3]
3: [PyQt4.QtCore.QDate(2011, 8, 21),
 PyQt4.QtCore.QDate(2009, 12, 17),
 PyQt4.QtCore.QDate(2009, 7, 15)]
>>> mydict[QDate(2011,8,21)]
KeyError: PyQt4.QtCore.QDate(2011, 8, 21)

so what is going on? The dictionary DOES have a key of QDate(2011,8,21)... but is unable to find it.

In debugging, I was reminded that python dictionaries hash the key values and it turns out that there is a known bug in QDate.__hash__
>>> d1 = QDate(2009,12,9)
>>> d1.__hash__()
4: 48759696
>>> d2 = QDate(2009,12,9)
>>> d2.__hash__()
5: 45344152

this has been fixed in the very latest versions of PyQt4 I believe (including the python3 version)
In the meantime, I am simply adding a step of conversion to python date types for the keys.

>>> d1.toPyDate().__hash__()
6: 5917697570912074722
>>> d2.toPyDate().__hash__()
7: 5917697570912074722

Thursday, 18 November 2010

a neat(?) postgresql solution using row_number() and self joining

For the scheduling aspect of openmolar, a common task is to find where "freeslots" occur. In the original openmolar, I performed this logic using python code. For openmolar2 the database itself will perform this search.
Here's how.

let's make a trivial diary table
create table diary (
 ix serial primary key, 
 startTime time, 
 endTime time, 
 activity varchar(80));
leading to this table of data.
select * from diary;
410:00:0011:30:00meeting with joe
514:00:0018:00:00golfing at Royal Dornoch

so the problem is this... how can I query that table to discover my free time on that day?
(there is 90 minutes before lunch)
NOTE - the activities are NOT in order!

the answer (and I found this in the excellent "sql cookbook") involves getting a view of that table in the correct order, and then performing a join on adjacent rows.

so first, get the ordered view.
=> select * from diary order by starttime;
ix starttime endtime activity
1 09:00:00 09:30:00 breakfast
2 09:30:00 10:00:00 jogging
4 13:00:00 14:00:00 lunch
3 10:00:00 11:30:00 meeting with joe
5 14:00:00 18:00:00 golfing at Royal Dornoch

But this doesn't help... because there is no way to definatively refer to the "next" activity, to do this we need to replace ix with a generated rownumber. We will use the row_number() window function of postgres 8.4.

=> select * from (select row_number() over (order by starttime) as rownumber,
starttime, endtime, activity from diary) as ordered_diary;

rownumber starttime endtime activity
1 09:00:00 09:30:00 breakfast
2 09:30:00 10:00:00 jogging
3 10:00:00 11:30:00 meeting with joe
4 13:00:00 14:00:00 lunch
5 14:00:00 18:00:00 golfing at Royal Dornoch

no we can self join that result set on itself..
(adding columns from the next row to the current row)

=> select * from
(select row_number() over (order by starttime) as row_number, * from diary) as diary1,
(select row_number() over (order by starttime) as row_number, * from diary) as diary2
where diary2.row_number = diary1.row_number+1

row_number ix starttime endtime activity row_number ix starttime endtime activity
1 1 09:00:00 09:30:00 breakfast 2 2 09:30:00 10:00:00 jogging
2 2 09:30:00 10:00:00 jogging 3 4 10:00:00 11:30:00 meeting with joe
3 4 10:00:00 11:30:00 meeting with joe 4 3 13:00:00 14:00:00 lunch
4 3 13:00:00 14:00:00 lunch 5 5 14:00:00 18:00:00 golfing at Royal Dornoch

or more succinctly...
=> select diary1.activity as first_activity, diary1.endtime as finishes,
diary2.activity as next_activity, diary2.starttime as starts from
(select row_number() over (order by starttime) as row_number, * from diary) as diary1,
(select row_number() over (order by starttime) as row_number, * from diary) as diary2
where diary2.row_number = diary1.row_number+1

first_activity finishes next_activity starts
breakfast 09:30:00 jogging 09:30:00
jogging 10:00:00 meeting with joe 10:00:00
meeting with joe 11:30:00 lunch 13:00:00
lunch 14:00:00 golfing at Royal Dornoch 14:00:00

so we simply now have to add a check to see if those times differ

so here's the final query!

=> select diary1.endtime as freetime_start, diary2.starttime as freetime_end from
(select row_number() over (order by starttime) as row_number, endtime from diary) as diary1,
(select row_number() over (order by starttime) as row_number, starttime from diary) as diary2
where diary2.row_number = diary1.row_number+1
and diary1.endtime < diary2.starttime

freetime_start freetime_end
11:30:00 13:00:00

Friday, 12 November 2010

Firesheep in Action

further to Yesterday's post on installing firesheep on 64-bit ubuntu .... I had a play with the firesheep plugin.

I disabled (temporarily) WPA on my home network, and started monitoring. I was able to hijack both my facebook and twitter sessions.

Thursday, 11 November 2010


Firesheep is a plugin for Firefox that is creating a lot of noise in the IT security community. It allows you to hijack sessions of other users on open wifi.

There is a windows/mac version of this plugin, but that is no use to me (and I will point out my intentions are NOT malicious, but to demonstrate to friends/colleagues the dangers of the interwebs).

thanks to information on this page I got it working on my 64-bit ubuntu 10.04(lucid) laptop.

here's what I did to get it working.


to install firesheep on lucid

1. get dependencies (your mileage may vary)

sudo apt-get install libhal-dev libtool autoconf xulrunner-dev libboost-dev libpcap-dev iw git

2. get the latest firesheep code from github

git clone git://

3. compile the firesheep.xpi "plugin"

cd firesheep
git submodule update --init

4. set up a monitor interface
sudo iw wlan0 interface add mon0 type monitor
sudo ifconfig mon0 up

5. Install the plugin into firefox.
Open Firefox, and from the menu choose "File", then open ~/firesheep/build/firesheep.xpi

restart firefox when asked

6. firesheep needs correct permissions to access your wifi card.

cd ~/.mozilla/firefox/7oyiuecg.default/extension/

sudo ./firesheep-backend --fix-permissions

note- there WILL be subtle differences in this directory

7. Ready to go!

open firefox and click on
then choose mon0 from the drop down list. (see screenshot below)

8. Enable the Firesheep Sidebar.

(or ctrl-shift-s)


Tuesday, 28 September 2010

Object Orientation Example

I knocked this example up today for a friend on IRC. Thought I would post it here.
#! /usr/bin/env python
##  Python Object Orientated example by rowinggolfer                          ##
##  the same object... but extra functionality added in layers                ##
##                                                                            ##
##  A noteable "Gotcha" for newbs is the __init__ function.                   ##
##  the base class in this example sets some important attributes in this     ##
##  function. Therefore classes which inherit from it, but be careful if      ##
##  re-implementing this function                                             ##
##  NOTE - the teenager class does NOT overwrite this function... hence when  ##
##  a teenager is initiated, python looks up the class hierarchy and executes ##
##  the first __init__ method it finds.. in this case the Toddler's __init__  ##
##                                                                            ##
##                                                                            ##
##  Run this script, and study the output.                                    ##
##                                                                            ##
##  Pay special attention to the attribute "description, and see how it is    ##
##  altered mid method in the teenage years.                                  ##
##                                                                            ##

from datetime import date
from base64 import b64decode

class TimritBaby(object):
    a baby has a date of birth, a name, and limited functionality
    def __init__(self, date_of_birth):
        print "TimritBaby initiated" = 'Scott Murtz'
        self.dob = date_of_birth
        self.description = "(a baby)"

    def poop(self):
        print "    %s %s can Poop!"% (, self.description)

class TimritToddler(TimritBaby):
    a toddler has a new method
    def __init__(self, dob):
        # call the init method of the base class..
        # otherwise the name attribute won't work!!
        print "\nTimritToddler initiated"
        TimritBaby.__init__(self, dob)
        self.description = "(a toddler)"
    def walk(self):
        print "    %s %s can Walk!"% (, self.description)

class TimritTeenager(TimritToddler):
    a teenager with a secret habit
    def private_time(self):
        self.description = "(now a teeneager)"
        message = b64decode('aXMgbWFzdHVyYmF0aW5nIGFnYWlu')
        print "    %s %s %s"% (, self.description, message)

if __name__ == "__main__":
    baby = TimritBaby(date(1968,1,1))
    except AttributeError as e:
        print "ERROR - WHOOPS!", e
    teenager = TimritTeenager(date(1968,1,1))

Sunday, 12 September 2010

fuzzymatching in postgres on ubuntu

I had a battle getting the soundex function installed into my database on postgres.
but here's how I succeeded.

One - Install the postgres-contrib package
sudo apt-get install  postgresql-contrib

Two - change user to postgres (a database superuser created on install of postgresql
neil@slim-maroon:~$ sudo su - postgres

Three - pipe the supplied script into the database (my database is called "openmolar_demo")
postgres@slim-maroon:~$ psql -d openmolar_demo -f /usr/share/postgresql/8.4/contrib/fuzzystrmatch.sql

Four - test it!
openmolar_demo=> SELECT soundex('Neil');
(1 row)

Tuesday, 7 September 2010

Postgres for openmolar2

I've been playing with postgres all morning, and have decided that the next version of openmolar will use it in preference to MySQL.

Main Reasons.
    1. it's a clean break with the past
    2. GNUmed use postgres
    3. active development
    4. standards compliance
    5. not owned by oracle
A huge thankyou to all postgres devs for a wonderful open-source back-end.

Thursday, 2 September 2010

Pynotify style notifications

The notifcation system for openmolar2 is nearly complete.

Why not use pynotify? Cross-platform is a goal here.

Wednesday, 4 August 2010

tllts co-incidence makes me feel awful.

so today, I am playing golf and listening to last week's tllts.
for the 1st time in my life, I get half way through the show (well, maybe 30 minutes in)... and i think "not enjoying this!" and delete it!

imagine what a douche i feel then, when I get home.... to find an air mail package containing a tllts T-shirt and hackey sack.

it's as if the cock just crowed 3 times, and i realise my denial.

Allan, Pat, Linc and Dann, please forgive me, it won't happen again.


last night I began work on a new version of openmolar.

this one will not be done in a hurry (ie. in 4 months because of a proprietary license termination), nor will I be bound to a schema which I dare not change. I have come a long way on my programming journey, and feel ready to take the plunge into what I hope will be the most customisable, pluggable, and downright froody piece of dental management software known to mankind.

openmolar up to this point, is software for my practice alone.
openmolar2 will be of use to other practices (I hope).

more later.


Tuesday, 3 August 2010

QTextEdit with autocompletion using pyqt

Problem - I wanted a text-edit which would help enter long words.

Solution - I have converted the C++ example code into python, and post it here to for all to see.

NB - The code assumes your dictionary is located at /usr/share/dict/words.

from PyQt4 import QtGui, QtCore

STARTTEXT = ('This TextEdit provides autocompletions for words that have ' +
'more than 3 characters.\nYou can trigger autocompletion using %s\n\n'''% (

class DictionaryCompleter(QtGui.QCompleter):
    def __init__(self, parent=None):
        words = []
            f = open("/usr/share/dict/words","r")
            for word in f:
        except IOError:
            print "dictionary not in anticipated location"
        QtGui.QCompleter.__init__(self, words, parent)

class CompletionTextEdit(QtGui.QTextEdit):
    def __init__(self, parent=None):
        super(CompletionTextEdit, self).__init__(parent)
        self.completer = None

    def setCompleter(self, completer):
        if self.completer:
            self.disconnect(self.completer, 0, self, 0)
        if not completer:

        self.completer = completer
            QtCore.SIGNAL("activated(const QString&)"), self.insertCompletion)

    def insertCompletion(self, completion):
        tc = self.textCursor()
        extra = (completion.length() -

    def textUnderCursor(self):
        tc = self.textCursor()
        return tc.selectedText()

    def focusInEvent(self, event):
        if self.completer:
        QtGui.QTextEdit.focusInEvent(self, event)

    def keyPressEvent(self, event):
        if self.completer and self.completer.popup().isVisible():
            if event.key() in (

        ## has ctrl-E been pressed??
        isShortcut = (event.modifiers() == QtCore.Qt.ControlModifier and
                      event.key() == QtCore.Qt.Key_E)
        if (not self.completer or not isShortcut):
            QtGui.QTextEdit.keyPressEvent(self, event)

        ## ctrl or shift key on it's own??
        ctrlOrShift = event.modifiers() in (QtCore.Qt.ControlModifier ,
        if ctrlOrShift and event.text().isEmpty():
            # ctrl or shift key on it's own

        eow = QtCore.QString("~!@#$%^&*()_+{}|:\"<>?,./;'[]\\-=") #end of word

        hasModifier = ((event.modifiers() != QtCore.Qt.NoModifier) and
                        not ctrlOrShift)

        completionPrefix = self.textUnderCursor()

        if (not isShortcut and (hasModifier or event.text().isEmpty() or
        completionPrefix.length() < 3 or

        if (completionPrefix != self.completer.completionPrefix()):
            popup = self.completer.popup()

        cr = self.cursorRect()
            + self.completer.popup().verticalScrollBar().sizeHint().width())
        self.completer.complete(cr) ## popup it up!

if __name__ == "__main__":

    app = QtGui.QApplication([])
    completer = DictionaryCompleter()
    te = CompletionTextEdit()

Wednesday, 30 June 2010

Session Managers and PyQt Applications

X11 window managers commonly have an option to "remember" applications which are running when a session ends.

Here's the gnome-checkbox (System -> Preferences -> Startup Applications)

but for this to work, the applications themselves need to comply. Qt does this with the QSessionManager class.

The class is not used directly, but is passed as an argument into functions of qApp, namely the saveState and commitData functions.
qApp therefore needs to be subclassed, and these two functions overwritten.

here's a working example. Note the simplicity of the functions!

#! /usr/bin/env python

from PyQt4 import QtGui, QtCore
import sys

class RestorableApplication(QtGui.QApplication):
    def __init__(self):
        super(RestorableApplication, self).__init__(sys.argv)

    def commitData(self, session):
        '''re-implement this method, called on quit'''

    def saveState(self, session):
        '''re-implement this method, called on run'''

app = RestorableApplication()

mw = QtGui.QMainWindow()
mw.setWindowTitle("I live on after a logout!")

label = QtGui.QLabel(
'''Leave me running and log off
I will survive! (on X11 systems)
Window size and position will be restored
... cool eh?''', mw)




Tuesday, 22 June 2010


Making the pluggable pyqt app has been more fun than I thought, and I believe the application may actually turn out to be half decent contacts manager.

it accepts plugins now (a zipped folder, with a config file within) and I am still finialising the plugin API, but I am certain I am on the right lines. The "zipimport" module did all that I hoped for and more.

It's running great on linux and windows. Plugins can simply be dropped into the applications plugins folder which reside here.
linux = ~/.qt-o-fax/plugins
windows = C:\Documents and Settings\USER\.qt-o-fax\
Config file is simple format, heavily influenced by the gedit method of plugin config
[qt-o-fax Plugin]
# module is where the entry point of the plugin is
# it should contain a class Plugin, with a method run()
# for this example, it is


Name=Hello World
Name[fr]=bonjour toulemande
Description=The simplest possible plugin
Description[fr]=Un plugin moins sofisticate

Authors=Neil Wallace 
Copyright=Copyright © 2010 Neil Wallace


Hello World Plugin

This plugin simply displays a hello world message when activated.
It connects to no signals, nor alters the database.

So what plugins could be created?? I think the sky is the limit. Add custom fields to the database, send SMS messages, create word processor documents with addresses embedded, christmas card lists.... contact sharing..

I've stuck it up on launchpad


Wednesday, 16 June 2010

Making a pyqt4 application which accepts "plugins".

So I decided that openmolar needed to be broken up into bits. I did this last week, Client, Server and language packs are now seperate packages, meaning that I can update one part of it independently of the other bits. All well and good.

However, I REALLY want "plugins" (similar to firefox functionality) to provide some of the functionality that folks are going to want (partly because it will make it possible for them to code such things themselves)

So, as ever, 1st stage is to make a trivial app, and see if I can get some form of plugin system going.

Here's a video of that application (In making it, I learned a lot about QToolbar class... something I haven't used much before).
(if you have an HTML5 compatible browser, that should appear by magic below.. simply hit play)

If you want to see the code for this little application, I stuck it on launchpad - get it this way.

~$ bzr branch lp:~rowinggolfer/+junk/pluggable-pyqt-app

the vid was taken with the files at revision 1.

Now for the difficult bit.. designing and loading the plugins.

My idea is that plugins should be zipped folders. Signed by the author ideally, and containing a config file which describes it, gives version numbers, and installation instructions which the parent app can use.

Python can import modules from zipped folders easily thanks to the zipimport module.

I think I am on the right lines for this... I'll let you know (via this blog) how I get on

Friday, 7 May 2010

cloud required??

I have 2 issues to solve today.
1. backup of x-ray images (currently that is approx 3GB of data per year)
2. being able to share these images with colleagues when appropriate
now... forgive me if I am wrong.. but is the solution not "dropbox" or similar??

big opportunity for a lucrative market.


Wednesday, 5 May 2010

QTreeView and QAbractItemModel example

This little example sets up a pythonic model, attaches a treeview to it, and allows user interaction in 2 ways.

1. clicking on the treeview
2. making selections using buttons.

Why is this important? Well, "models" are not aware of what is selected by the various views attached to them. With multiple views of the same data (or related data) it is up to the coder to keep this reference. the button click stuff is used in this example to explore such a scenario.

from PyQt4 import QtGui, QtCore

HORIZONTAL_HEADERS = ("Surname", "Given Name")
class person_class(object):
    a trivial custom data object
    def __init__(self, sname, fname, isMale):
        self.sname = sname
        self.fname = fname
        self.isMale = isMale

    def __repr__(self):
        return "PERSON - %s %s"% (self.fname, self.sname)
class TreeItem(object):
    a python object used to return row/column data, and keep note of
    it's parents and/or children
    def __init__(self, person, header, parentItem):
        self.person = person
        self.parentItem = parentItem
        self.header = header
        self.childItems = []

    def appendChild(self, item):

    def child(self, row):
        return self.childItems[row]

    def childCount(self):
        return len(self.childItems)

    def columnCount(self):
        return 2
    def data(self, column):
        if self.person == None:
            if column == 0:
                return QtCore.QVariant(self.header)
            if column == 1:
                return QtCore.QVariant("")                
            if column == 0:
                return QtCore.QVariant(self.person.sname)
            if column == 1:
                return QtCore.QVariant(self.person.fname)
        return QtCore.QVariant()

    def parent(self):
        return self.parentItem
    def row(self):
        if self.parentItem:
            return self.parentItem.childItems.index(self)
        return 0

class treeModel(QtCore.QAbstractItemModel):
    a model to display a few names, ordered by sex
    def __init__(self, parent=None):
        super(treeModel, self).__init__(parent)
        self.people = []
        for fname, sname, isMale in (("John","Brown", 1), 
        ("Fred", "Bloggs", 1), ("Sue", "Smith", 0)):
            person = person_class(sname, fname, isMale)
        self.rootItem = TreeItem(None, "ALL", None)
        self.parents = {0 : self.rootItem}

    def columnCount(self, parent=None):
        if parent and parent.isValid():
            return parent.internalPointer().columnCount()
            return len(HORIZONTAL_HEADERS)

    def data(self, index, role):
        if not index.isValid():
            return QtCore.QVariant()

        item = index.internalPointer()
        if role == QtCore.Qt.DisplayRole:
        if role == QtCore.Qt.UserRole:
            if item:
                return item.person

        return QtCore.QVariant()

    def headerData(self, column, orientation, role):
        if (orientation == QtCore.Qt.Horizontal and
        role == QtCore.Qt.DisplayRole):
                return QtCore.QVariant(HORIZONTAL_HEADERS[column])
            except IndexError:

        return QtCore.QVariant()

    def index(self, row, column, parent):
        if not self.hasIndex(row, column, parent):
            return QtCore.QModelIndex()

        if not parent.isValid():
            parentItem = self.rootItem
            parentItem = parent.internalPointer()

        childItem = parentItem.child(row)
        if childItem:
            return self.createIndex(row, column, childItem)
            return QtCore.QModelIndex()

    def parent(self, index):
        if not index.isValid():
            return QtCore.QModelIndex()

        childItem = index.internalPointer()
        if not childItem:
            return QtCore.QModelIndex()
        parentItem = childItem.parent()

        if parentItem == self.rootItem:
            return QtCore.QModelIndex()

        return self.createIndex(parentItem.row(), 0, parentItem)

    def rowCount(self, parent=QtCore.QModelIndex()):
        if parent.column() > 0:
            return 0
        if not parent.isValid():
            p_Item = self.rootItem
            p_Item = parent.internalPointer()
        return p_Item.childCount()
    def setupModelData(self):
        for person in self.people:
            if person.isMale:
                sex = "MALES"
                sex = "FEMALES"
            if not self.parents.has_key(sex):                
                newparent = TreeItem(None, sex, self.rootItem)

                self.parents[sex] = newparent

            parentItem = self.parents[sex]
            newItem = TreeItem(person, "", parentItem)
    def searchModel(self, person):
        get the modelIndex for a given appointment
        def searchNode(node):
            a function called recursively, looking at all nodes beneath node
            for child in node.childItems:
                if person == child.person:
                    index = self.createIndex(child.row(), 0, child)
                    return index
                if child.childCount() > 0:
                    result = searchNode(child)
                    if result:
                        return result
        retarg = searchNode(self.parents[0])
        print retarg
        return retarg
    def find_GivenName(self, fname):
        app = None
        for person in self.people:
            if person.fname == fname:
                app = person
        if app != None:
            index = self.searchModel(app)
            return (True, index)            
        return (False, None)

if __name__ == "__main__":    

    def row_clicked(index):
        when a row is clicked... show the name
        print tv.model().data(index, QtCore.Qt.UserRole)
    def but_clicked():
        when a name button is clicked, I iterate over the model, 
        find the person with this name, and set the treeviews current item
        name = dialog.sender().text()
        print "BUTTON CLICKED:", name
        result, index = model.find_GivenName(name)
        if result:
            if index:
    app = QtGui.QApplication([])
    model = treeModel()
    dialog = QtGui.QDialog()

    layout = QtGui.QVBoxLayout(dialog)

    tv = QtGui.QTreeView(dialog)
    label = QtGui.QLabel("Search for the following person")
    buts = []
    frame = QtGui.QFrame(dialog)
    layout2 = QtGui.QHBoxLayout(frame)
    for person in model.people:
        but = QtGui.QPushButton(person.fname, frame)
        QtCore.QObject.connect(but, QtCore.SIGNAL("clicked()"), but_clicked)

    but = QtGui.QPushButton("Clear Selection")
    QtCore.QObject.connect(but, QtCore.SIGNAL("clicked()"), tv.clearSelection)

    QtCore.QObject.connect(tv, QtCore.SIGNAL("clicked (QModelIndex)"),



Saturday, 17 April 2010

openmolar - preparing for roll out

i am thinking of breaking openmolar into bits

ie. separate packages namely openmolar-server, openmolar-client and openmolar-help multiple reasons for this.
A slimmer version of the existing package will become the client, and this will be the cross platform bit (ie. I will make a windows executable)

openmolar-server will be the package which sets up and configures the mysql server and allows for practice customisation. This will only run on unix-like OSs.

openmolar-help will simply put a set of html docs and videos into a pre-destined location.

 if anyone has any thoughts, please let me know.

Monday, 12 April 2010

PyQt4 model/view drag & drop example

In PyQt4, drag and drop with QListWidget works really, really well.

However, for real life application, I believe it's best to leave the convenience widgets (like QListWidget) behind, and head for the model/view pyqt4 classes. This gives a lot more flexibility than the "one-size fits all" model which comes with QListwidget et al.

This enables easy referencing of the true python objects that underlie the model, using Qt.UserRole to refer to the object, and pickle (or cPickle) to convert to a bytestream which the drag/drop can handle.

here is a little example using a few tricks to get drag and drop of native python objects in PyQt4.

import datetime
import cPickle
import pickle
import sys

from PyQt4 import QtGui, QtCore

class person(object):
    a custom data structure, for example purposes
    def __init__(self, name, dob, house_no): = name
        self.dob = dob
        self.addr = "%d Rue de la Soleil"% house_no
    def __repr__(self):
        return "%s\n%s\n%s"% (, self.dob, self.addr)

class simple_model(QtCore.QAbstractListModel):
    def __init__(self, parent=None):
        super(simple_model, self).__init__(parent)
        self.list = []
        for name, dob, house_no in (
        ("Neil",,12,9), 23),
        ("John",,5,3), 2543),
        ("Ilona",,4,6), 1)):
            self.list.append(person(name, dob, house_no))

    def rowCount(self, parent=QtCore.QModelIndex()):
        return len(self.list)

    def data(self, index, role):
        if role == QtCore.Qt.DisplayRole: #show just the name
            person = self.list[index.row()]
            return QtCore.QVariant(
        elif role == QtCore.Qt.UserRole:  #return the whole python object
            person = self.list[index.row()]
            return person
        return QtCore.QVariant()

    def removeRow(self, position):
        self.list = self.list[:position] + self.list[position+1:]

class dropZone(QtGui.QLabel):
    def __init__(self, parent=None):
        super(dropZone, self).__init__(parent)
        self.setText("Drop Here")

    def dragEnterEvent(self, event):
        if event.mimeData().hasFormat("application/x-person"):

    def dragMoveEvent(self, event):
        if event.mimeData().hasFormat("application/x-person"):

    def dragLeaveEvent(self, event):

    def dropEvent(self, event):
        data = event.mimeData()
        bstream = data.retrieveData("application/x-person",
        selected = pickle.loads(bstream.toByteArray())

    def set_bg(self, active=False):
        if active:
            val = "background:yellow;"
            val = "background:green;"

class draggableList(QtGui.QListView):
    a listView whose items can be moved
    def ___init__(self, parent=None):
        super(draggableList, self).__init__(parent)

    def dragEnterEvent(self, event):
        if event.mimeData().hasFormat("application/x-person"):

    def startDrag(self, event):
        index = self.indexAt(event.pos())
        if not index.isValid():

        ## selected is the relevant person object
        selected = self.model().data(index,QtCore.Qt.UserRole)

        ## convert to  a bytestream
        bstream = cPickle.dumps(selected)
        mimeData = QtCore.QMimeData()
        mimeData.setData("application/x-person", bstream)

        drag = QtGui.QDrag(self)

        # example 1 - the object itself

        pixmap = QtGui.QPixmap()
        pixmap = pixmap.grabWidget(self, self.rectForIndex(index))

        # example 2 -  a plain pixmap
        #pixmap = QtGui.QPixmap(100, self.height()/2)

        drag.setHotSpot(QtCore.QPoint(pixmap.width()/2, pixmap.height()/2))
        result = drag.start(QtCore.Qt.MoveAction)
        if result: # == QtCore.Qt.MoveAction:

    def mouseMoveEvent(self, event):

class testDialog(QtGui.QDialog):
    def __init__(self, parent=None):
        super(testDialog, self).__init__(parent)
        self.setWindowTitle("Drag Drop Test")
        layout = QtGui.QGridLayout(self)

        label = QtGui.QLabel("Drag Name From This List")

        self.model = simple_model()
        self.listView = draggableList()
        self.listView.setModel(self.model) = dropZone()


if __name__ == "__main__":
    the try catch here is to ensure that the app exits cleanly no matter what
    makes life better for SPE
        app = QtGui.QApplication([])
        dl = testDialog()
    except Exception, e:  #could use as e for python 2.6...
        print e

Thursday, 25 March 2010

putting video onto lg ks360 mobile phone

Tonight the problem I had to solve was putting video onto my daughter's mobile phone, which is an inexpensive lg ks360.
First I grabbed the latest, uncrippled ffmpeg, following this howto

now after some experimenting I settled on the following params to convert to a format the phone supported.
ffmpeg -i input_file -acodec libfaac -ar 22000 -ab 32k -ac 2 -vtag mp4v -r 15 -s 320x240 output_file.mp4
then I drop the output_file.mp4 onto the phone's miniSD card, in the folder "Videos", and I'm done.

Monday, 1 March 2010

The DreamPie Python Shell

Just trying out the DreamPie Python Shell.
Lovin' it so far, this solves a lot of problems I have with other interative shells.
I grabbed it from The dreampie PPA
Highly recommended.

Thursday, 25 February 2010

Graphical database application with 67 lines of python

Following some discussion in the #pyqt chatroom on, I decided to play with the QtSql module of pyqt.

Here's the results, the table allows direct editing of the db.

note - you may need to install some dependencies
sudo apt-get install python-qt4 python-qt4-sql libqt4-sql-sqlite
#! /usr/bin/env python
##   A Demo Application showing the use of sqlite3     ##
##   and the QSqlTableModel    Class                    ##
##   written by rowinggolfer 24th Feb 2010              ##
##   version 0.1 and NOT YET WORKING!!                  ##
##   this work is in the public domain,                 ##
##   do with it as you please                           ##
import os, sys
from PyQt4 import QtCore, QtGui, QtSql

def makeDB():
    import sqlite3
    db = sqlite3.connect("test.db")
    db.execute("create table if not exists table1 (value text, data text)")
    query = "insert into table1 (value, data) values (?, ?)"
    valueSet = (("day","today"),("time","noon"),("food","cheese"))
    for values in valueSet:
        db.execute(query, values)

class TestApp(QtGui.QDialog):
    def __init__(self, model, parent = None):
        super(TestApp, self).__init__(parent)
        self.model = model
        table = QtGui.QTableView()

        button = QtGui.QPushButton("Add a row")
        layout = QtGui.QVBoxLayout(self)

        self.connect(button, QtCore.SIGNAL("clicked()"), self.addRow)

    def addRow(self):
        self.model.insertRows(self.model.rowCount(), 1)

class myModel(QtSql.QSqlTableModel):
    def __init__(self, parent = None):
        super(myModel, self).__init__(parent)

if __name__ == "__main__":
    if not os.path.exists("test.db"):
    myDb = QtSql.QSqlDatabase.addDatabase("QSQLITE")
    if not
        print "Unable to create connection!"
        print "have you installed the sqlite driver?"
        print "sudo apt-get install libqt4-sql-sqlite"
    model = myModel()
    app = QtGui.QApplication(sys.argv)
    dl = TestApp(model)

Wednesday, 24 February 2010

Ubuntu Update manager - feature request

Ubuntu handles updates really well, no question. The user is prompted to update, but without annoying pop ups that disrupt a workflow (cf M$ windows reboot in 5 minutes - ARGHH!)
However, there's one thing I would like to see altered.
Once one has clicked "install", the top level dialog box prevents access to all the wonderful information about the updates being installed. Granted, one should check before accepting these.. but....
I would prefer if I could still read details about what is being installed... as it happens.

As a hobby coder, I realise this is extra work, but if the scrollArea and Description widgets were still acessible.. I would be delighted.

update - I've filed a bug

watch this space

Wednesday, 10 February 2010


There's been a lot of buzz about pitivi perhaps being in ubuntu lucid by default.

So I thought I would try the latest version.

I was surprised to learn that there isn't a ppa version available, so I set one up, and made a deb from the latest git version of pitivi. It works very well indeed, and is very intuitive.

My ppa for pitivi "unstable" is here, and can be added using the new add-apt-repository command, which saves a lot of key hassle.

sudo add-apt-repository ppa:rowinggolfer/pitivi-unstable

add the g-streamer ppa while you are at it (pitivi uses gstreamer for the heavy lifting)
sudo add-apt-repository ppa:gstreamer-developers/ppa

Here's my first attempt with the new pitivi.. a title page tacked onto the front of a wee video.

How did I make the title page? Gimp. But that's another issue altogether....