1 # Copyright (c) Stas Shtin, 2010
3 # This file is part of IPyPBX.
5 # IPyPBX is free software: you can redistribute it and/or modify
6 # it under the terms of the GNU General Public License as published by
7 # the Free Software Foundation, either version 3 of the License, or
8 # (at your option) any later version.
10 # IPyPBX is distributed in the hope that it will be useful,
11 # but WITHOUT ANY WARRANTY; without even the implied warranty of
12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 # GNU General Public License for more details.
15 # You should have received a copy of the GNU General Public License
16 # along with IPyPBX. If not, see <http://www.gnu.org/licenses/>.
20 from ipypbx import controllers, sql, ui
21 from PyQt4 import QtCore, QtGui, QtSql
24 # Working directory path.
25 # NOTE: ~/.ipypbx gives an error - for some reason QT doesn't like the dot?
26 PREFIX = os.path.expanduser('~/.ipypbx')
32 def setupDb(prefix=PREFIX, dbname=DB_NAME):
37 # Create it if necessary.
39 if not os.path.exists(prefix):
41 os.mkdir(prefix, 0700)
45 # Connect to SQLite database.
46 db = QtSql.QSqlDatabase.addDatabase("QSQLITE")
47 db.setDatabaseName(dbname)
51 for query in sql.creation_queries:
52 QtSql.QSqlQuery().exec_(query)
54 QtGui.QMessageBox.warning(
55 None, "Fatal Error", "Database Error: %s" % db.lastError().text())
59 if __name__ == '__main__':
60 app = QtGui.QApplication(sys.argv)
62 # import pdb; pdb.set_trace()
64 views = ui.MainWindow()
67 connectionModel = QtSql.QSqlTableModel(views)
68 connectionModel.setTable('connections')
69 connectionModel.setHeaderData(
70 sql.Connection.id, QtCore.Qt.Horizontal,
71 QtCore.QVariant('Connection_ID'))
72 connectionModel.setHeaderData(
73 sql.Connection.name, QtCore.Qt.Horizontal,
74 QtCore.QVariant('Name'))
75 connectionModel.setHeaderData(
76 sql.Connection.local_ip_address, QtCore.Qt.Horizontal,
77 QtCore.QVariant('Local_IP_Address'))
78 connectionModel.setHeaderData(
79 sql.Connection.local_port, QtCore.Qt.Horizontal,
80 QtCore.QVariant('Local_Port'))
81 connectionModel.setHeaderData(
82 sql.Connection.freeswitch_ip_address, QtCore.Qt.Horizontal,
83 QtCore.QVariant('Freeswitch_IP_Address'))
84 connectionModel.setHeaderData(
85 sql.Connection.freeswitch_port, QtCore.Qt.Horizontal,
86 QtCore.QVariant('Freeswitch_Port'))
87 connectionModel.select()
89 views.connectionView.setModel(connectionModel)
90 views.connectionView.setColumnHidden(sql.Connection.id, True)
91 views.connectionView.setSelectionMode(QtGui.QTableView.SingleSelection)
92 views.connectionView.setSelectionBehavior(QtGui.QTableView.SelectRows)
93 views.connectionView.resizeColumnsToContents()
94 views.connectionView.resizeRowsToContents()
95 views.connectionView.horizontalHeader().setStretchLastSection(True)
98 views.connectionData.setModel(connectionModel)
99 connectionController = controllers.ConnectionController()
102 # (self.ui.connectionList, 'currentRowChanged(int)',
103 # self.connections.select),
104 # (self.ui.connectionClone, 'clicked()', self.connections.clone),
105 # (self.ui.connectionSave, 'clicked()', self.connections.save),
106 # (views.connectionAdd, 'clicked()', connectionController.add),
109 # for sender, signal, receiver in signals_data:
110 # QtCore.QObject.connect(sender, QtCore.SIGNAL(signal), receiver)