Skip to content

Instantly share code, notes, and snippets.

@HennIdan

HennIdan/getRepos.sql

Created February 5, 2017 13:24
Show Gist options
  • Save HennIdan/a1453489e567095a715116e7cb30929f to your computer and use it in GitHub Desktop.
Save HennIdan/a1453489e567095a715116e7cb30929f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
getRepos.sql
SELECT *
FROM [java-log-levels-usage:java_log_level_usage.top_repos_java_contents_lines_no_android_no_arduino]
WHERE REGEXP_MATCH(line, r'.*((LOGGER|Logger|logger|LOG|Log|log)[.](trace|info|debug|warn|warning|error|fatal|severe|config|fine|finer|finest)).*')
OR REGEXP_MATCH(line, r'.*((Level|Priority)[.](TRACE|TRACE_INT|X_TRACE_INT|INFO|INFO_INT|DEBUG|DEBUG_INT|WARN|WARN_INT|WARNING|WARNING_INT|ERROR|ERROR_INT)).*')
OR REGEXP_MATCH(line, r'.*((Level|Priority)[.](FATAL|FATAL_INT|SEVERE|SEVERE_INT|CONFIG|CONFIG_INT|FINE|FINE_INT|FINER|FINER_INT|FINEST|FINEST_INT|ALL|OFF)).*')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment