-BEGIN;
CREATE TABLE "ipypbxweb_connection" (
"id" integer NOT NULL PRIMARY KEY,
"name" varchar(100) NOT NULL,
"id" integer NOT NULL PRIMARY KEY,
"user_id" varchar(100) NOT NULL,
"password" varchar(100) NOT NULL,
- "domain" varchar(100) NOT NULL,
+ "domain_id" integer NOT NULL REFERENCES "ipypbxweb_domain" ("id"),
"is_active" bool NOT NULL
)
;
"id" integer NOT NULL PRIMARY KEY,
"destination_match" varchar(100) NOT NULL,
"xml_dialplan" text NOT NULL,
- "domain" varchar(100) NOT NULL,
+ "domain_id" integer NOT NULL REFERENCES "ipypbxweb_domain" ("id"),
"endpoint_id" integer NOT NULL REFERENCES "ipypbxweb_endpoint" ("id"),
"authenticate_calls" bool NOT NULL,
"is_active" bool NOT NULL
CREATE INDEX "ipypbxweb_sipprofile_connection_id" ON "ipypbxweb_sipprofile" ("connection_id");
CREATE INDEX "ipypbxweb_domain_sip_profile_id" ON "ipypbxweb_domain" ("sip_profile_id");
CREATE INDEX "ipypbxweb_gateway_sip_profile_id" ON "ipypbxweb_gateway" ("sip_profile_id");
-CREATE INDEX "ipypbxweb_extension_endpoint_id" ON "ipypbxweb_extension" ("endpoint_id");
-COMMIT;
+CREATE INDEX "ipypbxweb_endpoint_domain_id" ON "ipypbxweb_endpoint" ("domain_id");
+CREATE INDEX "ipypbxweb_extension_domain_id" ON "ipypbxweb_extension" ("domain_id");
+CREATE INDEX "ipypbxweb_extension_endpoint_id" ON "ipypbxweb_extension" ("endpoint_id");
\ No newline at end of file
# Split into individual queries.
sql_queries = sql_script.split(';')
- # Execute all queries except BEGIN/COMMIT sequences.
+ # Execute all queries except last that is empty.
query = QtSql.QSqlQuery()
- for query_string in sql_queries[1:-2]:
+ for query_string in sql_queries[:-1]:
query.exec_(query_string)
else:
# Something went horribly wrong.
locale = QtCore.QLocale.system().name()
translator = QtCore.QTranslator()
-# if translator.load("/home/antisvin/dev/git/ipypbx/src/ipypbx/locale/ipypbx_ru.qm"):
if translator.load("ipypbx_%s" % locale.toLower(), "ipypbx/locale"):
QtGui.QApplication.installTranslator(translator)
- else:
- print locale
- print translator.translate('MainWindow', 'Name').toUtf8()
setupDb()
main = QtGui.QMainWindow()
controllers.EndpointController, controllers.ExtensionController):
controllerClass(parent=main, views=views)
- app.exec_()
-# sys.exit()
+ sys.exit(app.exec_())
+
class Endpoint(models.Model):
user_id = models.CharField(max_length=100)
password = models.CharField(max_length=100)
- domain = models.CharField(max_length=100)
+ domain = models.ForeignKey(Domain)
is_active = models.BooleanField()