#!/usr/bin/env python#coding:utf-8# Author:  closed --<># Purpose: Check which keys have been blocked# Created: 2018/05/17# version: Python3.6#from requests_html import HTMLSessionkeyword = ''keylist = ['ADD','ALL','ALTER','AND','ANY','AS','ASC','AUTHORIZATION','AVG','BACKUP',           'BEGIN','BETWEEN','BREAK','BROWSE','BULK','BY','CASCADE','CASE',           'CHECKPOINT','CLOSE','CLUSTERED','COALESCE','COLUMN','COMMIT',           'COMMITTED','COMPUTE','CONSTRAINT','CONTAINS','CONTAINSTABLE',           'CONTINUE','CONVERT','COUNT','CREATE','CROSS','CURRENTZ_DATE',           'CURRENT_TIME','CURRENT_TIMESTAMP','CURRENT_USER','CURSOR','DATABASE',           'DBCC','DEALLOCATE','DECLARE','DEFAULT','DELETE','DENY','DESC','DISK',           'DISTINCT','DISTRIBUTED','DOUBLE','DROP','DUMP','ELSE','END','ESCAPE',           'EXEC','EXISTS','EXIT','FETCH','FILE','FILLFACTOR','FLOPPY','FOR','FOREIGN',           'FREETEXT','FREETEXTTABLE','FROM','FULL','GOTO','GRANT','GROUP','HAVING',           'HOLDLOCK','IDENTITY','IDENTITY_INSERT','IDENTITYCOL','IF','IN','INDEX',           'INNER','INSERT','INTERSECT','INTO','IS','ISOLATION','JOIN','KEY','KILL',           'LEFT','LEVEL','LIKE','LOAD','MAX','NATIONAL','NOCHECK','NOT','NONCLUSTERED',           'NULL','SELECT','NULLIF','OF','OFF','OFFSETS','ON','ONLY DECLARE','OPEN',           'OPEN QUERY','OPENROWSET','OPTION','OR','ORDER','OUTER','PERCENT','PIPE',           'PLAN','PREPARE','PRIMARY','PRINT','PRIVILEGES','PROC','PUBLIC','RAISERROR',           'READ','READTEXT','RECONFIGURE','REFERENCES','REPEATABLE','REPLICATION',           'RESTORE','RETURN','RIGHT','ROLLBACK','ROWCOUNT','ROWGUIDCOL','RULE','SAVE',           'SCHEMA','SERIALIZABLE','SESSION_USE','SET','SET USER','SHUTDOWN','SOME',           'STATISTICS','SUM','SYSTEM_USER','TABLE','TAPE','THEN','TO','TOP','TRAN',           'TRIGGER','TRUNCATE','UNCOMMITTED','UNION','UNIQUE','UPDATE','UPDATETEXT',           'USE','VALUES','VARYING','VIEW','WAITFOR','WHEN','WHERE','WHILE','WITH',           'WORK','WRITETEXT'                      ]baseurl = "xxx"session = HTMLSession()for i in keylist:    fullurl = "xxx{0}".format(i)    r = session.get(fullurl)        if("404" in str(r.html.text)):        print(i)    #print (r.html.text)