FilesExpand file tree

master

/

sqlerrors.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

24 lines (21 loc) · 1.33 KB

master

/

sqlerrors.py

Copy path

Top

File metadata and controls

• Code
• Blame

24 lines (21 loc) · 1.33 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

import re

# thanks Ekultek (https://github.com/Ekultek) for giving better idea of detection

sql_errors = {

"MySQL": (r"SQL syntax.*MySQL", r"Warning.*mysql_.*", r"MySQL Query fail.*", r"SQL syntax.*MariaDB server"),

"PostgreSQL": (r"PostgreSQL.*ERROR", r"Warning.*\Wpg_.*", r"Warning.*PostgreSQL"),

"Microsoft SQL Server": (r"OLE DB.* SQL Server", r"(\W|\A)SQL Server.*Driver", r"Warning.*odbc_.*", r"Warning.*mssql_", r"Msg \d+, Level \d+, State \d+", r"Unclosed quotation mark after the character string", r"Microsoft OLE DB Provider for ODBC Drivers"),

"Microsoft Access": (r"Microsoft Access Driver", r"Access Database Engine", r"Microsoft JET Database Engine", r".*Syntax error.*query expression"),

"Oracle": (r"\bORA-[0-9][0-9][0-9][0-9]", r"Oracle error", r"Warning.*oci_.*", "Microsoft OLE DB Provider for Oracle"),

"IBM DB2": (r"CLI Driver.*DB2", r"DB2 SQL error"),

"SQLite": (r"SQLite/JDBCDriver", r"System.Data.SQLite.SQLiteException"),

"Informix": (r"Warning.*ibase_.*", r"com.informix.jdbc"),

"Sybase": (r"Warning.*sybase.*", r"Sybase message")

}

def check(html):

"""check SQL error is in HTML or not"""

for db, errors in sql_errors.items():

for error in errors:

if re.compile(error).search(html):

#print "\n" + db

return True, db

return False, None