| // run from within app web/ directory, presumes the sqlite db file is named "database.sqlite" (default for template) | |
| const DB_FILE_PATH = './database.sqlite'; | |
| const getAccessToken = async () => { | |
| return new Promise((resolve, reject) => { | |
| import('sqlite3').then((sqlite) => { | |
| const db = new sqlite.default.Database(DB_FILE_PATH); | |
| db.serialize(() => { | |
| db.get('SELECT accessToken FROM shopify_sessions LIMIT 1;', [], (err, { accessToken }) => { |
| # filter by request host header | |
| varnishlog -q 'ReqHeader ~ "Host: example.com"' | |
| # filter by request url | |
| varnishlog -q 'ReqURL ~ "^/some/path/"' | |
| # filter by client ip (behind reverse proxy) | |
| varnishlog -q 'ReqHeader ~ "X-Real-IP: .*123.123.123.123"' | |
| # filter by request host header and show request url and referrer header |
Needing a place to keep a list of all the tools/references used during Magento development.