Run `node ./node_modules/session-sync-auth-site/src/createDBTables.js [mysql_connection_string] [user_table_name] [session_table_name]`
npm install session-sync-auth-siteRun node ./node_modules/session-sync-auth-site/src/createDBTables.js [mysql_connection_string] [user_table_name] [session_table_name]
Example: node ./node_modules/session-sync-auth-site/src/createDBTables.js mysql://root@localhost/SessionSyncAuthSite users sessions
You may add on more fields to the user and session tables, if you like.
``js
const express = require('express')
const app = express()
const cors = require('cors')
const bodyParser = require('body-parser')
const { authenticate, setUpSessionSyncAuthRoutes } = require('session-sync-auth-site')
app.use(cors())
app.use(bodyParser.json())
app.use(authenticate({
// either connectionObj or connectionStr is required
connectionObj: {
host,
user,
password,
database,
port,
},
}))
setUpSessionSyncAuthRoutes({
app,
siteId,
authFrontendBaseUrl,
authBackendBaseUrl,
jwtSecret,
})
`
`jsconnectionObj
app.use(authenticate({
// either or connectionStr requiredextraUserTableValues
connectionObj: {
host,
user,
password,
database,
port,
},
userTableName: 'users',
sessionTableName: 'sessions',
userTableColNameMap: {
// Example:
// updated_at: 'updatedAt',
},
extraUserTableSelectValues: {
// Use this when the user table id column is not unique.
// (Often the case with a multi-tenacy setup.)
// In such a case, add other WHERE parameters here to combine with
// the id column such that combination is unique.
// Note: These parameters will typically coincide with below.`
// Example:
// tenantId: 34,
},
sessionTableColNameMap: {},
}))
`jsextraUserTableValues
setUpSessionSyncAuthRoutes({
app, // required
siteId, // required (unless getSetupInfo provided)
authFrontendBaseUrl, // required (unless getSetupInfo provided)
authBackendBaseUrl, // required (unless getSetupInfo provided)
jwtSecret, // required (unless getSetupInfo provided)
getSetupInfo: req => { // useful for multi-tenancy setups
// fetch the needed values based upon req
return {
siteId,
authFrontendBaseUrl,
authBackendBaseUrl,
jwtSecret,
extraUserTableValues, // optional
// Note: In a multi-tenancy setup, shouldextraUserTableSelectValues
// typically coincide with above.`
}
},
mergeUser: async ({ id, mergeToUserId, req }) => { // optional (when absent, merge requests will succeed even though no data is merged for this site)
// move all of user's data to mergeToUserId
},
deleteUser: async ({ id, req }) => { // optional (when absent, the appropriate rows from users and sessions are deleted)
// delete all of user's data, including appropriate rows from users and sessions tables
},
paths: {
getUser: '/get-user',
logIn: '/log-in',
logOut: '/log-out',
authSync: '/auth-sync',
},
languageColType: '639-3', // OPTIONS: '639-1', '639-3', 'IETF'
})
`js
const { createUser, getLoginLink, updateUserAccount, deleteUser } = require('session-sync-auth-site')
app.post(create-user, (req, res, next) => {
// first check that user is admin with permission to do this
const userId = await createUser({
email: req.body.email,
req,
})
res.send({ userId })
})
app.post(get-login-link, (req, res, next) => {https://my-backend-domain.com
// first check that user is admin with permission to do this
const loginLink = await getLoginLink({
email: req.body.email,
redirectUrl: req.body.redirectUrl, // must begin with the frontend domain (default: req.headers.origin)
origin: , // default: ${req.protocol}://${req.headers.host}
req,
})
res.send({ loginLink })
})
app.post(update-user-account, (req, res, next) => {
// first check that user is admin with permission to do this
await updateUserAccount({
userId: req.body.userId,
data: { // only include details being updated
name: req.body.name,
email: req.body.email,
image: req.body.image,
language: req.body.language,
terms: req.body.terms,
image: req.body.image,
gender: req.body.gender,
},
req,
})
res.send({ success: true })
})
app.post(delete-user, (req, res, next) => {`
// first check that user is admin with permission to do this
await deleteUser({
id: req.body.id,
mergeToUserId: req.body.mergeToUserId, // optional
req,
})
res.send({ success: true })
})
`html
``