def setup_development_servers(): """ Add lakka and hilla servers and create couple services and service groups """ if not ServerDatabase.query().filter(ServerDatabase.name == 'Hilla').all(): hilla = ServerDatabase() hilla.name = 'Hilla' hilla.save() else: hilla = ServerDatabase.query().filter(ServerDatabase.name == 'Hilla').one() if not ServerDatabase.query().filter(ServerDatabase.name == 'Lakka').all(): lakka = ServerDatabase() lakka.name = 'Lakka' lakka.save() else: lakka = ServerDatabase.query().filter(ServerDatabase.name == 'Lakka').one() if not ServerDatabase.query().filter(ServerDatabase.name == 'db1').all(): db1 = ServerDatabase() db1.name = 'db1' db1.save() else: db1 = ServerDatabase.query().filter(ServerDatabase.name == 'db1').one() if not ServerDatabase.query().filter(ServerDatabase.name == 'db2').all(): db2 = ServerDatabase() db2.name = 'db2' db2.save() else: db2 = ServerDatabase.query().filter(ServerDatabase.name == 'db2').one() if not ServiceGroupDatabase.query().filter(ServiceGroupDatabase.name == 'Hilla_ports').all(): hilla_ports = ServiceGroupDatabase() hilla_ports.name = 'Hilla_ports' hilla_ports.type = 'port' hilla_ports.save() else: hilla_ports = ServiceGroupDatabase.query().filter(ServiceGroupDatabase.name == 'Hilla_ports').one() if not ServiceGroupDatabase.query().filter(ServiceGroupDatabase.name == 'Lakka_ports').all(): lakka_ports = ServiceGroupDatabase() lakka_ports.name = 'Lakka_ports' lakka_ports.type = 'port' lakka_ports.save() else: lakka_ports = ServiceGroupDatabase.query().filter(ServiceGroupDatabase.name == 'Lakka_ports').one() if not ServiceGroupDatabase.query().filter(ServiceGroupDatabase.name == 'Mysql_databases').all(): mysql_databases = ServiceGroupDatabase() mysql_databases.name = 'Mysql_databases' mysql_databases.type = 'mysql_database' mysql_databases.save() else: mysql_databases = ServiceGroupDatabase.query().filter(ServiceGroupDatabase.name == 'Mysql_databases').one() if not ServiceGroupDatabase.query().filter(ServiceGroupDatabase.name == 'Psql_databases').all(): psql_databases = ServiceGroupDatabase() psql_databases.name = 'Psql_databases' psql_databases.type = 'Psql_database' psql_databases.save() else: psql_databases = ServiceGroupDatabase.query().filter(ServiceGroupDatabase.name == 'Psql_databases').one() dbsession.flush() if not ServiceDatabase.query().filter(ServiceDatabase.name == 'Mysql_database').all(): mysql_database = ServiceDatabase() mysql_database.name = 'Mysql_Database' mysql_database.service_group = mysql_databases mysql_database.server = hilla mysql_database.save() else: mysql_database = ServiceDatabase.query().filter(ServiceDatabase.name == 'Mysql_database').one() if not ServiceDatabase.query().filter(ServiceDatabase.name == 'Psql_database').all(): psql_database = ServiceDatabase() psql_database.name = 'Psql_database' psql_database.service_group = psql_databases psql_database.server = hilla psql_database.save() else: psql_database = ServiceDatabase.query().filter(ServiceDatabase.name == 'Psql_database').one() if not ServiceDatabase.query().filter(ServiceDatabase.name == 'Hilla_port').all(): hilla_port = ServiceDatabase() hilla_port.name = 'Hilla_port' hilla_port.service_group = hilla_ports hilla_port.server = hilla hilla_port.save() else: hilla_port = ServiceDatabase.query().filter(ServiceDatabase.name == 'Hilla_port').one() if not ServiceDatabase.query().filter(ServiceDatabase.name == 'Lakka_port').all(): lakka_port = ServiceDatabase() lakka_port.name = 'Lakka_port' lakka_port.service_group = lakka_ports lakka_port.server = hilla lakka_port.save() else: lakka_port = ServiceDatabase.query().filter(ServiceDatabase.name == 'Lakka_port').one() dbsession.commit()
def setup_development_servers(): """ Add lakka and hilla servers and create couple services and service groups """ if not ServerDatabase.query().filter(ServerDatabase.name == 'Hilla').all(): hilla = ServerDatabase() hilla.name = 'Hilla' hilla.save() else: hilla = ServerDatabase.query().filter( ServerDatabase.name == 'Hilla').one() if not ServerDatabase.query().filter(ServerDatabase.name == 'Lakka').all(): lakka = ServerDatabase() lakka.name = 'Lakka' lakka.save() else: lakka = ServerDatabase.query().filter( ServerDatabase.name == 'Lakka').one() if not ServerDatabase.query().filter(ServerDatabase.name == 'db1').all(): db1 = ServerDatabase() db1.name = 'db1' db1.save() else: db1 = ServerDatabase.query().filter(ServerDatabase.name == 'db1').one() if not ServerDatabase.query().filter(ServerDatabase.name == 'db2').all(): db2 = ServerDatabase() db2.name = 'db2' db2.save() else: db2 = ServerDatabase.query().filter(ServerDatabase.name == 'db2').one() if not ServiceGroupDatabase.query().filter( ServiceGroupDatabase.name == 'Hilla_ports').all(): hilla_ports = ServiceGroupDatabase() hilla_ports.name = 'Hilla_ports' hilla_ports.type = 'port' hilla_ports.save() else: hilla_ports = ServiceGroupDatabase.query().filter( ServiceGroupDatabase.name == 'Hilla_ports').one() if not ServiceGroupDatabase.query().filter( ServiceGroupDatabase.name == 'Lakka_ports').all(): lakka_ports = ServiceGroupDatabase() lakka_ports.name = 'Lakka_ports' lakka_ports.type = 'port' lakka_ports.save() else: lakka_ports = ServiceGroupDatabase.query().filter( ServiceGroupDatabase.name == 'Lakka_ports').one() if not ServiceGroupDatabase.query().filter( ServiceGroupDatabase.name == 'Mysql_databases').all(): mysql_databases = ServiceGroupDatabase() mysql_databases.name = 'Mysql_databases' mysql_databases.type = 'mysql_database' mysql_databases.save() else: mysql_databases = ServiceGroupDatabase.query().filter( ServiceGroupDatabase.name == 'Mysql_databases').one() if not ServiceGroupDatabase.query().filter( ServiceGroupDatabase.name == 'Psql_databases').all(): psql_databases = ServiceGroupDatabase() psql_databases.name = 'Psql_databases' psql_databases.type = 'Psql_database' psql_databases.save() else: psql_databases = ServiceGroupDatabase.query().filter( ServiceGroupDatabase.name == 'Psql_databases').one() dbsession.flush() if not ServiceDatabase.query().filter( ServiceDatabase.name == 'Mysql_database').all(): mysql_database = ServiceDatabase() mysql_database.name = 'Mysql_Database' mysql_database.service_group = mysql_databases mysql_database.server = hilla mysql_database.save() else: mysql_database = ServiceDatabase.query().filter( ServiceDatabase.name == 'Mysql_database').one() if not ServiceDatabase.query().filter( ServiceDatabase.name == 'Psql_database').all(): psql_database = ServiceDatabase() psql_database.name = 'Psql_database' psql_database.service_group = psql_databases psql_database.server = hilla psql_database.save() else: psql_database = ServiceDatabase.query().filter( ServiceDatabase.name == 'Psql_database').one() if not ServiceDatabase.query().filter( ServiceDatabase.name == 'Hilla_port').all(): hilla_port = ServiceDatabase() hilla_port.name = 'Hilla_port' hilla_port.service_group = hilla_ports hilla_port.server = hilla hilla_port.save() else: hilla_port = ServiceDatabase.query().filter( ServiceDatabase.name == 'Hilla_port').one() if not ServiceDatabase.query().filter( ServiceDatabase.name == 'Lakka_port').all(): lakka_port = ServiceDatabase() lakka_port.name = 'Lakka_port' lakka_port.service_group = lakka_ports lakka_port.server = hilla lakka_port.save() else: lakka_port = ServiceDatabase.query().filter( ServiceDatabase.name == 'Lakka_port').one() dbsession.commit()