def _find_ec2_package_relations()

in lambdas/helper/dal.py [0:0]


    def _find_ec2_package_relations(self, aws_instance_id):
        DataAccessLayer._xray_start('find_ec2_package_relations')
        try:
            sql_parameters = [
                {'name':'aws_instance_id', 'value':{'stringValue': aws_instance_id}}
            ]
            sql = f'select aws_instance_id, package_name, package_version' \
                f' from {ec2_package_table_name}' \
                f' where aws_instance_id=:aws_instance_id'
            response = self.execute_statement(sql, sql_parameters)
            results = [
                {
                    'aws_instance_id': record[0]['stringValue'],
                    'package_name': record[1]['stringValue'],
                    'package_version': record[2]['stringValue']
                }
                for record in response['records']
            ]
            return results
        finally:
            DataAccessLayer._xray_stop()