FilesExpand file tree

main

/

check-issue-for-code-formatting.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

33 lines (25 loc) · 1.63 KB

main

/

check-issue-for-code-formatting.py

Copy path

Top

File metadata and controls

• Code
• Blame

33 lines (25 loc) · 1.63 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

25

26

27

28

29

30

31

32

33

import re

import sys

post_text = sys.stdin.read()

sql_keyword_list = ["select", "from", "where", "join", "group by", "order by", "having", "with recursive", "union"]

sql_keyword_regex = f"({'|'.join(sql_keyword_list)})"

sql_keywords = len(re.findall(rf"{sql_keyword_regex}", post_text, flags=re.MULTILINE | re.IGNORECASE))

backticked_code_blocks = len(re.findall(r"^```", post_text))

indented_sql_code_lines = len(re.findall(r"^{sql_keyword_regex}", post_text, flags=re.MULTILINE | re.IGNORECASE))

indented_python_code_lines = len(re.findall(r"^ (import|duckdb)", post_text, flags=re.MULTILINE | re.IGNORECASE))

indented_r_code_lines = len(re.findall(r"^ (library|dbExecute)", post_text, flags=re.MULTILINE | re.IGNORECASE))

indented_hashbang_code_lines = len(re.findall(r"^ #!", post_text, flags=re.MULTILINE | re.IGNORECASE))

indented_code_lines = indented_sql_code_lines + indented_python_code_lines + indented_r_code_lines

inline_code_snippets = len(re.findall(r"`", post_text)) // 2

print("Metrics computed by 'check-issue-for-code-formatting.py':")

print(f"- {sql_keywords} SQL keyword(s)")

print(f"- {backticked_code_blocks} backticked code block(s)")

print(

f"- {indented_code_lines} indented code line(s): {indented_sql_code_lines} SQL, {indented_python_code_lines} Python, {indented_r_code_lines} R, {indented_hashbang_code_lines} hashbangs"

)

print(f"- {inline_code_snippets} inline code snippet(s)")

if sql_keywords > 2 and backticked_code_blocks == 0 and indented_code_lines == 0 and inline_code_snippets == 0:

print("The post is likely not properly formatted.")

exit(1)

else:

print("The post is likely properly formatted.")