intuit / oauth-jsclient

    async saveAuthToken(tokenData, yardId) {

        await client.connect()

        const query = `

            INSERT INTO erp_tool_credentials

            (erp_system_id, qb_access_token, qb_refresh_token, qb_expires_in,

             qb_refresh_token_expires_in, created_at, yard_id)

            VALUES ($1, $2, $3, $4, $5, to_timestamp($6), $7)

            ON CONFLICT

                ON CONSTRAINT erp_tool_credentials_pkey

                DO UPDATE

                SET erp_system_id               = $1,

                    qb_access_token             = $2,

                    qb_refresh_token            = $3,

                    qb_expires_in               = $4,

                    qb_refresh_token_expires_in = $5,

                    created_at               = to_timestamp($6),

                    yard_id                     = $7

            RETURNING *

        `

        const values = [tokenData.realmId, tokenData.access_token, tokenData.refresh_token, tokenData.expires_in, tokenData.x_refresh_token_expires_in, tokenData.createdAt / 1000, yardId]

        try {

            const res = await client.query(query, values)

            console.log('saved credentials')

            console.log(res.rows[0])

        } catch (err) {

            console.log(err.stack)

        }

        await client.end()

    }

}