Hypernode patch info outdated

[gwillem]

https://tools.hypernode.com/patches/community/1.9.2.0 gives:

{
    "required": [
        "SUPEE-10266",
        "SUPEE-10415",
        "SUPEE-6482",
        "SUPEE-6788",
        "SUPEE-7405",
        "SUPEE-7405 v1.1",
        "SUPEE-8788",
        "SUPEE-8788 v2",
        "SUPEE-9652",
        "SUPEE-9767 v2"
    ]
}

AFAIK, there was an auto-syncer for the spreadsheet but it might got broken because the syntax in the spreadsheet changed.

[vdloo]

This thing?

cat /srv/app/tools/patch_spreadsheet_to_json.py
#!/usr/bin/env python3

import json
import os
from collections import defaultdict

import gspread  # this is a modified version! see requirements.txt
import logging

# https://docs.google.com/spreadsheets/d/1MTbU9Bq130zrrsJwLIB9d8qnGfYZnkm4jBlfNaBF19M/pubhtml
SPREADSHEET_ID = '1MTbU9Bq130zrrsJwLIB9d8qnGfYZnkm4jBlfNaBF19M'
PATH = os.path.dirname(os.path.realpath(__file__))

debug = False

if debug:
    import requests_cache
    requests_cache.install_cache(
        'cache',
        backend='sqlite',
        allowable_methods=('GET', 'POST'),
        allowable_codes=(200, 401, 403, 404, 502, 503, 301, 302, 303),
    )


def find_patches_for_row(row, patches):
    required_patches = set()

    for col_id, cell in enumerate(row):
        if cell in ('', 'Not Required', 'Not Supported', 'Under investigation', 'Ask support'):
            continue
        elif cell.startswith('Replaced by'):
            continue
        elif cell == 'Required':
            patch = patches[col_id]
        elif cell.startswith('Use '):
            patch = cell[4:]
        else:
            logging.warning("Unsupported status: %s" % cell)
            continue

        # requires different patch id's per mag version, so not usable for automatic parsing
        if 'APPSEC' in patch:
            continue

        patch = patch.replace(' V', ' v')
        required_patches.add(patch)


    # sort patches alphabetically on patch version and take the latest (v2 over v1.1)
    return sorted(required_patches)



gc = gspread.public()
document = gc.open_by_key(SPREADSHEET_ID)

giant_blob = {}

for sheet in document.worksheets():
    matrix = sheet.get_all_values()
    assert matrix[1][0] == 'Version'

    edition = matrix[2][0]  # Community or Enterprise
    patches = matrix[1][2:]  # skip first 2 cols

    giant_blob[edition] = {}

    for row_id in range(3, 50):
        version = matrix[row_id][0]
        # break on first empty row
        if not version:
            break
        required_patches = find_patches_for_row(matrix[row_id][2:], patches)
        giant_blob[edition][version] = required_patches

try:
    assert 'SUPEE-8788' in giant_blob['Community']['1.7.0.0']
    assert 'SUPEE-8788 v2' in giant_blob['Community']['1.7.0.0']
    assert 'SUPEE-6788' in giant_blob['Enterprise']['1.6.x']
    assert 'SUPEE-7405 v1.1' in giant_blob['Enterprise']['1.14.2.1']
    assert 'SUPEE-7405' in giant_blob['Enterprise']['1.14.2.1']

    assert 'SUPEE-6079' not in giant_blob['Enterprise']['1.14.2.0']
    assert 'SUPEE-3762' not in giant_blob['Community']['1.4.0.0']
except AssertionError:
    print("Patch parsing didn't work out. Result is:\n%s" % json.dumps(giant_blob, indent=2))
    raise

with open(PATH + '/../static/required_magento_patches.json', 'w') as f:
    f.write(json.dumps(giant_blob, indent=2, sort_keys=True))

Traceback (most recent call last):
  File "/srv/app/tools/patch_spreadsheet_to_json.py", line 62, in <module>
    assert matrix[1][0] == 'Version'

sheet.get_all_values() now returns:

sheet: <Worksheet 'Magento 1 Community Patch List' id:o36eqrc>


[['Dates', '', '27/02/2018', '28/11/2017', '15/09/2017', '12/07/2017', '31/05/2017', '07/02/2017', '14/10/2016', '11/10/2016', '23/02/2016', '20/01/2016', '27/10/2015', '06/08/2015', '07/07/2015', '15/05/2015', '12/02/2015', '08/12/2014', '03/10/2014', '17/01/2014'], ['Version', 'Release Date', 'SUPEE-10570', 'SUPEE-10415', 'SUPEE-10266', 'SUPEE-9767 V2', 'SUPEE-9767', 'SUPEE-9652', 'SUPEE-8788 V2', 'SUPEE-8788', 'SUPEE-7405 v1.1', 'SUPEE-7405', 'SUPEE-6788', 'SUPEE-6482', 'SUPEE-6285', 'SUPEE-5994', 'SUPEE-5344', 'SUPEE-3762', 'SUPEE-1533', 'APPSEC-212'], ['Community', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['1.9.3.7', '28/11/2017', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.3.6', '15/09/2017', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.3.4', '12/07/2017', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.3.3', '31/05/2017', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.3.2', '07/02/2017', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.3.1', '14/11/2016', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.3.0', '11/10/2016', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.2.4', '23/02/2016', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.2.3', '20/01/2016', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.2.2', '27/10/2015', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.2.1', '04/08/2015', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.2.0', '07/07/2015', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.9.1.1', '01/05/2015', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Replaced by 6788', 'Not Required', 'Not Required'], ['1.9.1.0', '24/11/2014', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Replaced by 6788', 'Not Required', 'Not Required'], ['1.9.0.1', '15/05/2014', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Replaced by 6788', 'Required', 'Not Required'], ['1.9.0.0', '13/05/2014', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Replaced by 6788', 'Required', 'Not Required'], ['1.8.1.0', '11/12/2013', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Required'], ['1.8.0.0', '25/09/2013', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Required'], ['1.7.0.2', '05/07/2012', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Required'], ['1.7.0.1', '20/06/2012', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Required'], ['1.7.0.0', '24/04/2012', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Required'], ['1.6.2.0', '11/01/2012', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Required'], ['1.6.1.0', '19/10/2011', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Required'], ['1.6.0.0', '18/08/2011', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Required'], ['1.5.1.0', '26/04/2011', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Not Supported'], ['1.5.0.1', '09/02/2011', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Not Supported'], ['1.4.2.0', '08/12/2010', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Not Supported'], ['1.4.1.1', '26/07/2010', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Not Supported'], ['1.4.1.0', '10/06/2010', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Required', 'Not Supported'], ['1.4.0.1', '19/02/2010', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Supported', 'Required', 'Not Required', 'Required', 'Not Supported'], ['1.4.0.0', '12/02/2010', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Not Supported', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Supported', 'Required', 'Not Required', 'Required', 'Not Supported'], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['Key', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['Required', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['Not Required', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['Not Supported', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['Last Updated', '27/02/2018', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '']]


sheet: <Worksheet 'Magento 1 Enterprise Patch List' id:od6>


[['Dates', '', '27/02/2018', '28/11/2017', '15/09/2017', '12/07/2017', '31/05/2017', '06/02/2017', '14/10/2016', '10/10/2016', '23/02/2016', '20/01/2016', '27/10/2015', '06/08/2015', '07/07/2015', '15/05/2015', '12/02/2015', '12/02/2015', '12/02/2015', '12/02/2015', '12/02/2015', '12/02/2015', '12/02/2015', '08/12/2014', '03/10/2014', '12/12/2013', '12/12/2013', '12/12/2013', '12/12/2013', '12/12/2013', '02/11/2013'], ['Version', 'Release Date', 'SUPEE-10570', 'SUPEE-10415', 'SUPEE-10266', 'SUPEE-9767 V2', 'SUPEE-9767', 'SUPEE-9652', 'SUPEE-8788 v2', 'SUPEE-8788', 'SUPEE-7405 v1.1', 'SUPEE-7405', 'SUPEE-6788', 'SUPEE-6482', 'SUPEE-6285', 'SUPEE-5994', 'SUPEE-6079', 'SUPEE-5388', 'SUPEE-5390', 'SUPEE-5341', 'SUPEE-5346', 'SUPEE-5345', 'SUPEE-5344', 'SUPEE-3762', 'SUPEE-1533', 'SUPEE-2717', 'SUPEE-2751', 'SUPEE-2750', 'SUPEE-2677', 'SUPEE-2747', 'Zend Security Upgrade'], ['Enterprise', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['1.14.3.7', '28/11/2017', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.3.6', '15/09/2017', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.3.4', '12/07/2017', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.3.3', '31/05/2017', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.3.2', '06/02/2017', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.3.1', '14/11/2016', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.3.0', '10/11/2016', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.2.4', '23/02/2016', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.2.3', '20/01/2016', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.2.2', '27/10/2015', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.2.1', '06/08/2015', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.2.0', '22/04/2015', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.1.0', '13/11/2014', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Required', 'Replaced by 6788', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.0.1', '15/05/2014', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Required', 'Replaced by 6788', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.14.0.0', '13/05/2014', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Required', 'Replaced by 6788', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required', 'Not Required'], ['1.13.1.0', '25/11/2013', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Required', 'Not Required', 'Required', 'Use SUPEE-2747', 'Use SUPEE-2747', 'Use SUPEE-2747', 'Use SUPEE-2747', 'Required', 'Not Required'], ['1.13.0.2', '13/08/2013', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Use SUPEE-5344', 'Required', 'Not Required', 'Required', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Required', 'Use SUPEE-2677', 'Not Required'], ['1.12.0.2', '04/07/2012', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Required', 'Use SUPEE-5345', 'Not Required', 'Required', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Required', 'Use SUPEE-2677', 'Not Required'], ['1.12.0.1', '20/06/2012', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Required', 'Use SUPEE-5345', 'Not Required', 'Required', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Required', 'Use SUPEE-2677', 'Required'], ['1.12.0.0', '24/04/2012', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Use SUPEE-5345', 'Required', 'Use SUPEE-5345', 'Not Required', 'Required', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Required', 'Use SUPEE-2677', 'Required'], ['1.11.2.0', '', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5346', 'Use SUPEE-5346', 'Use SUPEE-5346', 'Use SUPEE-5346', 'Required', 'Use SUPEE-5346', 'Use SUPEE-5346', 'Not Required', 'Required', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Required', 'Use SUPEE-2677', 'Required'], ['1.11.1.0', '17/10/2011', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5346', 'Use SUPEE-5346', 'Use SUPEE-5346', 'Use SUPEE-5346', 'Required', 'Use SUPEE-5346', 'Use SUPEE-5346', 'Not Required', 'Required', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Required', 'Use SUPEE-2677', 'Required'], ['1.11.0.2', '26/09/2011', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5341', 'Use SUPEE-5341', 'Use SUPEE-5341', 'Required', 'Use SUPEE-5341', 'Use SUPEE-5341', 'Use SUPEE-5341', 'Not Required', 'Required', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Required', 'Use SUPEE-2677', 'Required'], ['1.11.0.0', '18/08/2011', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5341', 'Use SUPEE-5341', 'Use SUPEE-5341', 'Required', 'Use SUPEE-5341', 'Use SUPEE-5341', 'Use SUPEE-5341', 'Not Required', 'Required', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Required', 'Use SUPEE-2677', 'Required'], ['1.10.1.1', '13/04/2011', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5390', 'Use SUPEE-5390', 'Required', 'Use SUPEE-5390', 'Use SUPEE-5390', 'Use SUPEE-5390', 'Use SUPEE-5390', 'Not Required', 'Required', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Required', 'Use SUPEE-2677', 'Required'], ['1.10.1.0', '', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5390', 'Use SUPEE-5390', 'Required', 'Use SUPEE-5390', 'Use SUPEE-5390', 'Use SUPEE-5390', 'Use SUPEE-5390', 'Not Required', 'Required', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Use SUPEE-2677', 'Required', 'Use SUPEE-2677', 'Required'], ['1.10.0.2', '18/02/2011', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5388', 'Required', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Not Required', 'Required', 'Use SUPEE-2750', 'Use SUPEE-2750', 'Required', 'Use SUPEE-2750', 'Use SUPEE-2750', 'Required'], ['1.10.0.1', '', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5388', 'Required', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Not Required', 'Required', 'Use SUPEE-2750', 'Use SUPEE-2750', 'Required', 'Use SUPEE-2750', 'Use SUPEE-2750', 'Required'], ['1.9.1.1', '03/02/2010', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5388', 'Required', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Not Required', 'Required', 'Use SUPEE-2750', 'Use SUPEE-2750', 'Required', 'Use SUPEE-2750', 'Use SUPEE-2750', 'Required'], ['1.9.0.0', '14/07/2010', 'Required', 'Required', 'Required', 'Required', 'Replaced by V2', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5388', 'Required', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Not Required', 'Required', 'Use SUPEE-2750', 'Use SUPEE-2750', 'Required', 'Use SUPEE-2750', 'Use SUPEE-2750', 'Required'], ['1.8.x', '', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5388', 'Required', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Not Required', 'Not Supported', 'Use SUPEE-2751', 'Required', 'Use SUPEE-2751', 'Use SUPEE-2751', 'Use SUPEE-2751', ''], ['1.7.x', '', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-5388', 'Required', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Use SUPEE-5388', 'Not Required', 'Not Supported', 'Use SUPEE-2751', 'Required', 'Use SUPEE-2751', 'Use SUPEE-2751', 'Use SUPEE-2751', ''], ['1.6.x', '', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Ask support', 'Required', 'Required', 'Required', 'Required', 'Required', 'Use SUPEE-6079', 'Use SUPEE-6079', 'Use SUPEE-6079', 'Use SUPEE-6079', 'Use SUPEE-6079', 'Use SUPEE-6079', 'Not Required', 'Not Supported', 'Required', 'Use SUPEE-2717', 'Use SUPEE-2717', 'Use SUPEE-2717', 'Use SUPEE-2717', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'SUPEE-6079, 5388, 5390, 5341, 5346, 5345 and SUPEE-5344 address the same vulnerability for different Magento versions.', '', '', '', '', '', '', '', '', 'Replaces SUPEE-2531', 'Replaces SUPEE-2530', 'Replaces SUPEE-2529', 'Replaces SUPEE-2518', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', 'Note: if a patch for your Magento Enterprise version is not on the list, you can request it from Magento Support.', '', '', '', '', '', '', '', '', '', '', '', 'Note: if you have patch SUPEE-2531, 2530, 2529 or 2518, you need to revert it first, then install patch above.', '', '', '', '', ''], ['Key', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['Required', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['Not Required', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['Not Supported', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['Last Updated', '27/02/2018', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '']]


sheet: <Worksheet 'Magento 2 - Security Updates' id:o7srdp3>


[['', 'Magento 2.2', 'Magento 2.1', 'Magento 2.0', 'Security Announcement'], ['27/02/2018', '2.2.3', '2.1.12 ', '2.0.18', 'https://magento.com/security/patches/magento-223-2112-and-2018-security-update'], ['07/11/2017', '2.2.1', '2.1.10', '2.0.17', 'https://magento.com/security/patches/magento-221-2110-and-2017-security-update'], ['14/09/2017', '', '2.1.9', '2.0.16', 'https://magento.com/security/patches/magento-2016-and-219-security-update'], ['31/05/2017', '', '2.1.7', '2.0.14', 'https://magento.com/security/patches/magento-2014-and-217-security-update'], ['11/10/2016', '', '2.1.2', '2.0.10', 'https://magento.com/security/patches/magento-2010-and-212-security-update'], ['17/05/2016', '', '', '2.0.6', 'https://magento.com/security/patches/magento-206-security-update'], ['31/03/2016', '', '', '2.0.4', 'https://magento.com/security/patches/magento-204-security-update'], ['20/01/2016', '', '', '2.0.1', 'https://magento.com/security/patches/magento-201-security-update'], ['', '', '', '', ''], ['Last Updated', '27/02/2018', '', '', '']]

[vdloo]

fixed in Hypernode/tools.hypernode.com#10

app@83f000-hypernode-magweb-do:~/public$ curl -s https://tools.hypernode.com/patches/community/1.9.2.0 | python -m json.tool
{
    "required": [
        "SUPEE-10266",
        "SUPEE-10415",
        "SUPEE-10570",
        "SUPEE-6482",
        "SUPEE-6788",
        "SUPEE-7405",
        "SUPEE-7405 v1.1",
        "SUPEE-8788",
        "SUPEE-8788 v2",
        "SUPEE-9652",
        "SUPEE-9767 v2"
    ]
}