Skip to content

Instantly share code, notes, and snippets.

@AbhimanyuAryan

AbhimanyuAryan/gf_stats.sql

Created March 7, 2022 12:14
Show Gist options
  • Save AbhimanyuAryan/fc038ef881006e96e4b8143dc1c1295a to your computer and use it in GitHub Desktop.
Save AbhimanyuAryan/fc038ef881006e96e4b8143dc1c1295a to your computer and use it in GitHub Desktop.
Download ZIP
genieframework downloads
Raw
gf_stats.sql
SELECT SUM(request_count) from stats WHERE package_name IN('Genie',
'SearchLight',
'Stipple',
'StippleCharts',
'StippleUI',
'StipplePlotly',
'SearchLightMySQL',
'SearchLightPostgreSQL',
'GenieAuthentication',
'SearchLightSQLite',
'StippleLatex',
'StipplePlotlyExport',
'GenieAutoreload',
'GenieAuthorisation')
@AbhimanyuAryan
Copy link
Author 

SELECT * FROM stats WHERE stats.package_name in ('Genie', 'SearchLight',
'Stipple',
'StippleCharts',
'StippleUI',
'StipplePlotly',
'SearchLightMySQL',
'SearchLightPostgreSQL',
'GenieAuthentication',
'SearchLightSQLite',
'StippleLatex',
'StipplePlotlyExport',
'GenieAutoreload',
'GenieAuthorisation') AND stats.date >= '2023-01-01'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment