Used with the Shopify Node App Template to get the access token stored in the installation session

get_shopify_access_token.js

// 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 }) => {
                    return resolve(accessToken);
                });
            });
        });
    });
}

console.log(await getAccessToken());