2 # -*- coding: utf-8 -*-
5 This file is part of Multilist.
7 Multilist is free software: you can redistribute it and/or modify
8 it under the terms of the GNU General Public License as published by
9 the Free Software Foundation, either version 3 of the License, or
10 (at your option) any later version.
12 Multilist is distributed in the hope that it will be useful,
13 but WITHOUT ANY WARRANTY; without even the implied warranty of
14 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 GNU General Public License for more details.
17 You should have received a copy of the GNU General Public License
18 along with Multilist. If not, see <http://www.gnu.org/licenses/>.
20 Copyright (C) 2008 Christoph Würstle
23 from __future__ import with_statement
36 _moduleLogger = logging.getLogger(__name__)
39 class SqlDialog(gtk.Dialog):
41 def __init__(self, db):
44 _moduleLogger.info("sqldialog, init")
48 _("SQL History (the past two days):"),
50 gtk.DIALOG_MODAL | gtk.DIALOG_DESTROY_WITH_PARENT,
51 (gtk.STOCK_CLOSE, gtk.RESPONSE_CLOSE)
54 self.add_button(_("Export"), gtk.RESPONSE_OK)
55 self.set_position(gtk.WIN_POS_CENTER)
57 self.liststore = gtk.ListStore(str, str, str)
59 # create the TreeView using liststore
60 self.treeview = gtk.TreeView(self.liststore)
62 # create a CellRenderers to render the data
63 self.cell1 = gtk.CellRendererText()
64 self.cell2 = gtk.CellRendererText()
65 self.cell3 = gtk.CellRendererText()
66 #self.cell1.set_property('markup', 1)
68 # create the TreeViewColumns to display the data
69 self.tvcolumn1 = gtk.TreeViewColumn(_('Date'))
70 self.tvcolumn2 = gtk.TreeViewColumn(_('SQL'))
71 self.tvcolumn3 = gtk.TreeViewColumn(_('Parameter'))
73 # add columns to treeview
74 self.treeview.append_column(self.tvcolumn1)
75 self.treeview.append_column(self.tvcolumn2)
76 self.treeview.append_column(self.tvcolumn3)
78 self.tvcolumn1.pack_start(self.cell1, True)
79 self.tvcolumn2.pack_start(self.cell2, True)
80 self.tvcolumn3.pack_start(self.cell3, True)
82 self.tvcolumn1.set_attributes(self.cell1, text = 0) #Spalten setzten hier!!!!
83 self.tvcolumn2.set_attributes(self.cell2, text = 1)
84 self.tvcolumn3.set_attributes(self.cell3, text = 2)
86 # make treeview searchable
87 #self.treeview.set_search_column(0)
88 #self.tvcolumn.set_sort_column_id(0)
90 # Allow NOT drag and drop reordering of rows
91 self.treeview.set_reorderable(False)
93 scrolled_window = gtk.ScrolledWindow()
94 scrolled_window.set_policy(gtk.POLICY_AUTOMATIC, gtk.POLICY_AUTOMATIC)
95 scrolled_window.add(self.treeview)
96 #self.pack_start(scrolled_window, expand = True, fill = True, padding = 0)
98 self.vbox.pack_start(scrolled_window, True, True, 0)
103 sql = "SELECT pcdatum, sql, param FROM logtable WHERE pcdatum>? ORDER BY pcdatum DESC"
104 rows = db.ladeSQL(sql, (time.time()-3*24*3600, ))
105 for i, row in enumerate(rows):
109 pcdatum, sql, param = row
110 datum = str(time.strftime("%d.%m.%y %H:%M:%S ", (time.localtime(pcdatum))))
112 param = param[:20]+_(" (Reduced parameter) ")+param[20:]
113 self.liststore.append([datum, sql, param])
115 self.set_size_request(500, 400)
117 def exportSQL(self, filename):
118 with open(filename, 'w') as f:
120 sql = "SELECT pcdatum, sql, param FROM logtable WHERE pcdatum>? ORDER BY pcdatum DESC"
121 rows = self.db.ladeSQL(sql, (time.time()-2*24*3600, ))
123 pcdatum, sql, param = row
124 datum = str(time.strftime("%d.%m.%y %H:%M:%S ", (time.localtime(pcdatum))))
125 f.write( datum +"\t" + sql + "\t\t" + param+ "\n")