def openQueryBox(self):
num = self.tabViews.currentIndex()
view = self.listViews[num]
qb = QueryBox(parent = self,
metadata = self.metadata,
globalApplicationDict = self.globalApplicationDict,
table = view['topHierarchyTable'],
)
qb.setWindowFlags(Qt.Dialog)
qb.setWindowModality(Qt.WindowModal)
qb.setWindowTitle('Edit a query for table '+view['topHierarchyTable'])
qb.show()
self.connect(qb, SIGNAL('New query applied'), self.newQueryApplied)
def openQueryBox(self):
num = self.tabViews.currentIndex()
view = self.listViews[num]
qb = QueryBox(
parent=self,
metadata=self.metadata,
globalApplicationDict=self.globalApplicationDict,
table=view["topHierarchyTable"],
)
qb.setWindowFlags(Qt.Dialog)
qb.setWindowModality(Qt.WindowModal)
qb.setWindowTitle("Edit a query for table " + view["topHierarchyTable"])
qb.show()
self.connect(qb, SIGNAL("New query applied"), self.newQueryApplied)
def __init__(
self,
parent=None,
metadata=None,
session=None,
globalApplicationDict=None,
table=None,
#~ orientation = Qt.Horizontal,
orientation=Qt.Vertical,
query=None,
):
QWidget.__init__(self, parent)
self.metadata = metadata
self.globalApplicationDict = globalApplicationDict
self.table = table
sp = QSplitter(orientation)
self.mainLayout = QVBoxLayout()
self.setLayout(self.mainLayout)
self.mainLayout.addWidget(sp)
self.queryBox = QueryBox(metadata=metadata,
globalApplicationDict=globalApplicationDict,
table=table,
query=query)
sp.addWidget(self.queryBox)
self.connect(self.queryBox, SIGNAL('New query applied'),
self.refreshTree)
#~ self.tree = QTreeWidget()
self.tree = QtSqlTreeView(
metadata=metadata,
session=session,
dictChildren={table: []},
showColumns={},
topHierarchyTable=table,
topHierarchyQuery=query,
context_menu=None,
)
sp.addWidget(self.tree)
class QueryResultBox(QWidget) :
"""
Widget to write sql query et get the result in a list.
"""
def __init__(self , parent = None ,
metadata = None,
session = None,
globalApplicationDict = None,
table = None,
#~ orientation = Qt.Horizontal,
orientation = Qt.Vertical,
query = None,
):
QWidget.__init__(self, parent)
self.metadata = metadata
self.globalApplicationDict = globalApplicationDict
self.table = table
sp = QSplitter(orientation)
self.mainLayout = QVBoxLayout()
self.setLayout(self.mainLayout)
self.mainLayout.addWidget(sp)
self.queryBox = QueryBox(metadata = metadata,
globalApplicationDict = globalApplicationDict,
table = table,
query = query )
sp.addWidget(self.queryBox)
self.connect(self.queryBox, SIGNAL('New query applied'), self.refreshTree)
#~ self.tree = QTreeWidget()
self.tree = QtSqlTreeView(metadata = metadata,
session = session,
dictChildren = { table:[] },
showColumns = { },
topHierarchyTable = table,
topHierarchyQuery = query,
context_menu = None,
)
sp.addWidget( self.tree )
def refreshTree(self):
query = self.queryBox.query()
self.tree.applyNewFilterWithQuery( query )