关键字拦截查询

#!/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)