#!/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 HTMLSession
keyword = ''
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)