def handle(self):
input = self.request.input
input.password = uuid4().hex
input.extra = input.extra.encode('utf-8') if input.extra else b''
self.validate_extra(self.cid, input.extra.decode('utf-8'))
with closing(self.odb.session()) as session:
existing_one = session.query(SQLConnectionPool.id).\
filter(SQLConnectionPool.cluster_id==input.cluster_id).\
filter(SQLConnectionPool.name==input.name).\
first()
if existing_one:
raise Exception(
'An outgoing SQL connection [{0}] already exists on this cluster'
.format(input.name))
try:
cluster = session.query(Cluster).filter_by(
id=input.cluster_id).one()
item = SQLConnectionPool(cluster=cluster)
item.name = input.name
item.is_active = input.is_active
item.engine = input.engine
item.host = input.host
item.port = input.port
item.db_name = input.db_name
item.username = input.username
item.password = input.password
item.pool_size = input.pool_size
item.extra = input.extra
session.add(item)
session.commit()
self.notify_worker_threads(input)
self.response.payload.id = item.id
self.response.payload.name = item.name
self.response.payload.display_name = get_sql_engine_display_name(
input.engine, self.server.fs_sql_config)
except Exception:
self.logger.error(
'SQL connection could not be created, e:`{}`',
format_exc())
session.rollback()
raise
def handle(self):
input = self.request.input
input.password = uuid4().hex
input.extra = input.extra.encode('utf-8') if input.extra else b''
self.validate_extra(self.cid, input.extra.decode('utf-8'))
with closing(self.odb.session()) as session:
existing_one = session.query(SQLConnectionPool.id).\
filter(SQLConnectionPool.cluster_id==input.cluster_id).\
filter(SQLConnectionPool.name==input.name).\
first()
if existing_one:
raise Exception(
'An outgoing SQL connection [{0}] already exists on this cluster'
.format(input.name))
try:
item = SQLConnectionPool()
item.name = input.name
item.is_active = input.is_active
item.cluster_id = input.cluster_id
item.engine = input.engine
item.host = input.host
item.port = input.port
item.db_name = input.db_name
item.username = input.username
item.password = input.password
item.pool_size = input.pool_size
item.extra = input.extra
session.add(item)
session.commit()
self.notify_worker_threads(input)
self.response.payload.id = item.id
self.response.payload.name = item.name
except Exception, e:
msg = 'Could not create an outgoing SQL connection, e:[{e}]'.format(
e=format_exc(e))
self.logger.error(msg)
session.rollback()
raise
def handle(self):
input = self.request.input
input.password = uuid4().hex
input.extra = input.extra.encode('utf-8') if input.extra else b''
self.validate_extra(self.cid, input.extra.decode('utf-8'))
with closing(self.odb.session()) as session:
existing_one = session.query(SQLConnectionPool.id).\
filter(SQLConnectionPool.cluster_id==input.cluster_id).\
filter(SQLConnectionPool.name==input.name).\
first()
if existing_one:
raise Exception('An outgoing SQL connection [{0}] already exists on this cluster'.format(input.name))
try:
item = SQLConnectionPool()
item.name = input.name
item.is_active = input.is_active
item.cluster_id = input.cluster_id
item.engine = input.engine
item.host = input.host
item.port = input.port
item.db_name = input.db_name
item.username = input.username
item.password = input.password
item.pool_size = input.pool_size
item.extra = input.extra
session.add(item)
session.commit()
self.notify_worker_threads(input)
self.response.payload.id = item.id
self.response.payload.name = item.name
except Exception, e:
msg = 'Could not create an outgoing SQL connection, e:[{e}]'.format(e=format_exc(e))
self.logger.error(msg)
session.rollback()
raise
