import sqlite3
 
with sqlite3.connect(':memory:') as conn:
    conn.enable_load_extension(True)
    conn.execute("SELECT load_extension('spatialite4.dll')")
    conn.execute("CREATE VIRTUAL TABLE kladr USING VirtualDbf('c:/temp/kladr/kladr.dbf', 'CP866')")
    conn.execute("CREATE VIRTUAL TABLE street USING VirtualDbf('c:/temp/kladr/street.dbf', 'CP866')")
 
    qry = '''
        select
            k.name,
            s.name
        from kladr k inner join street s on substr(k.code, 1, 11) = substr(s.code, 1, 11)
        where substr(k.code, 12, 2) = '00' and substr(s.code, 16, 2) = '00'
    '''
    for rec in conn.execute(qry):
        print ' '.join(unicode(i) for i in rec)

#!/usr/bin/env python
# -*- coding: utf-8 -*-
 
from PyQt4 import QtGui, QtCore
import sys
 
class Example(QtGui.QWidget):
    def __init__(self):
        super(Example, self).__init__()
        self.initUI()
 
    def initUI(self):
        model = QtGui.QStringListModel(self)
        strings = QtCore.QStringList(['abc1', 'def2', 'ghi3'])
        model.setStringList(strings)
 
        view = QtGui.QListView(self)
        view.setModel(model)
 
        combo = QtGui.QComboBox(self)
        combo.setModel(model)
 
        tree = QtGui.QTreeView(self)
        tree.setModel(model)
 
        layout = QtGui.QHBoxLayout(self)
        layout.addWidget(view)
        layout.addWidget(combo)
        layout.addWidget(tree)
 
        self.setLayout(layout)
 
        self.setGeometry(300, 300, 400, 300)
        self.setWindowTitle('Model')
        self.show()
 
def main():
    app = QtGui.QApplication(sys.argv)
    ex = Example()
    sys.exit(app.exec_())
 
if __name__ == '__main__':
    main()