custom model + PyQt4

[wirasto]

I want create my custom model. But i confused with the code.

I want set text aligment some column and if in a cell have value =0, cell will color red.

#!/usr/bin/env python
 
from PyQt4.QtCore import * 
from PyQt4.QtGui import *
from PyQt4.QtSql import * 
 
class myModel(QSqlQueryModel):
    def __init__(self, parent=None):
	QSqlQueryModel.__init__(self)
 
    def data(self, index, role):
	?????

#!/usr/bin/env python

from PyQt4.QtCore import * 
from PyQt4.QtGui import *
from PyQt4.QtSql import * 

class myModel(QSqlQueryModel):
    def __init__(self, parent=None):
	QSqlQueryModel.__init__(self)

    def data(self, index, role):
	?????

To copy to clipboard, switch view to plain text mode 

Sorry, my englis is bad

[Lykurg]

What's about using Qt::TextAlignmentRole and Qt::BackgroundRole.

[wirasto]

I need example code. And, I mean in Python code. Not C++

[Lykurg]

I need example code.

Oh yes, sorry that I don't have developed your application. My fault. I am terribly sorry, because we are dealing here with high end programming stuff.

And, I mean in Python code. Not C++

Why certainly!

And here a gentile: rtfm. And is it so heavy to transform c++ in python? From Qt::TextAlignmentRole to Qt.TextAlignmentRole? And is it not possible to think about

if role == Qt.TextAlignmentRole and index.row == 1:
  return Qt.AlignRight

if role == Qt.TextAlignmentRole and index.row == 1:
  return Qt.AlignRight

To copy to clipboard, switch view to plain text mode 

If so, I strongly recommend the Newbie section of that board...

[wirasto]

I already have an example here.

http://www.mail-archive.com/pyqt@riv.../msg17197.html

And your sample, the same as that in there. But unfortunately code like that do not display data. Therefore, I ask in here. Sorry...

def data(self, index, role):
	if role == Qt.TextAlignmentRole and index.row == 2:
               return Qt.AlignRight
	return QVariant()

def data(self, index, role):
	if role == Qt.TextAlignmentRole and index.row == 2:
               return Qt.AlignRight
	return QVariant()

To copy to clipboard, switch view to plain text mode 

[wirasto]

Someone give me a sample code

def data(self, index, role):
   value=QSqlQueryModel.data(self, index, role)
   if role == Qt.TextAlignmentRole:
       if (index.column()==2):
              return QVariant(Qt.AlignRight)
   return value

def data(self, index, role):
   value=QSqlQueryModel.data(self, index, role)
   if role == Qt.TextAlignmentRole:
       if (index.column()==2):
              return QVariant(Qt.AlignRight)
   return value

To copy to clipboard, switch view to plain text mode 

i hope can be useful for others

[Lykurg]

And your sample, the same as that in there. But unfortunately code like that do not display data.

That's because it is only a part out of the whole function. You have to respect the other roles by yourself or - as below - call the base class.

def data(self, index, role):
   value=QSqlQueryModel.data(self, index, role)
   if role == Qt.TextAlignmentRole:
       if (index.column()==2):
              return QVariant(Qt.AlignRight)
   return value

def data(self, index, role):
   value=QSqlQueryModel.data(self, index, role)
   if role == Qt.TextAlignmentRole:
       if (index.column()==2):
              return QVariant(Qt.AlignRight)
   return value

To copy to clipboard, switch view to plain text mode 

For speed and performance issues you should better use:

def data(self, index, role):
  if role == Qt.TextAlignmentRole:
    if (index.column()==2):
      return QVariant(Qt.AlignRight)
  return QSqlQueryModel.data(self, index, role)

def data(self, index, role):
  if role == Qt.TextAlignmentRole:
    if (index.column()==2):
      return QVariant(Qt.AlignRight)
  return QSqlQueryModel.data(self, index, role)

To copy to clipboard, switch view to plain text mode