emilsedgh

<a href="javascript:(function()%7B(function() %7Blet j %3D 0%3Blet setters %3D %7Bcheckbox%3A i %3D> %7Bif (!i.checked)i.click()%7D%2Ctext%3A i %3D> %7Blet lastValue %3D i.value%3Bi.value %3D %60F%3A %24%7Bj%2B%2B%7D%60%3Blet event %3D new Event('input'%2C %7B bubbles%3A true %7D)%3Blet tracker %3D i._valueTracker%3Bif (tracker) %7Btracker.setValue(lastValue)%3B%7Di.dispatchEvent(event)%3B%7D%7D%3Bdocument.querySelectorAll('input').forEach(i %3D> %7Bif (setters%5Bi.type%5D)setters%5Bi.type%5D(i)%3B%7D)%7D)()%7D)()">Bookmarklet</a>

emilsedgh

<script
src="https://code.jquery.com/jquery-3.3.1.min.js"
integrity="sha256-FgpCb/KJQlLNfOu91ta32o/NMZxltwRo8QtmkMRdAu8="
crossorigin="anonymous">
</script>

<style>
  #types {
    margin-bottom: 10px;
  }

emilsedgh

image: docker:git

stages:
  - build
  - test

variables:
  CONTAINER_IMAGE: registry.gitlab.com/rechat/server:$CI_BUILD_REF_NAME
  POSTGRES_DB: rechat
  POSTGRES_USER: rechat

emilsedgh

image: docker:git

stages:
  - build
  - test

variables:
  CONTAINER_IMAGE: registry.gitlab.com/rechat/server:$CI_BUILD_REF_NAME
  POSTGRES_DB: rechat
  POSTGRES_USER: rechat

emilsedgh

image: docker:git

stages:
  - build
  - test

variables:
  CONTAINER_IMAGE: registry.gitlab.com/rechat/server:$CI_BUILD_REF_NAME

before_script:

emilsedgh

SELECT DISTINCT agents.id AS id FROM agents
    LEFT JOIN users          ON agents.id = users.agent
    LEFT JOIN offices        ON agents.office_mui = offices.matrix_unique_id
    LEFT JOIN brands_offices ON offices.id = brands_offices.office
    LEFT JOIN brands_users   ON users.id = brands_users.user
  WHERE (
    (
      brands_offices.brand = '745e77aa-4ddf-11e6-a07d-f23c91b0d077'
    )
    OR

emilsedgh

SELECT alerts.*,
       'alert' AS type,
       (
         SELECT COUNT(recommendations.id)
         FROM recommendations
         LEFT JOIN recommendations_eav
           ON recommendations.id = recommendations_eav.recommendation AND
           (
             CASE WHEN 'c5d7d53e-5cb0-11e5-a1b3-f23c91c841bd'::uuid IS NOT NULL THEN recommendations_eav."user" = 'c5d7d53e-5cb0-11e5-a1b3-f23c91c841bd' ELSE FALSE END
           ) AND

emilsedgh

SELECT 'message' AS type,
       messages.id AS mid,
       messages.id AS id,
       messages.*,
       (
         SELECT ARRAY_AGG(attachment)
         FROM attachments_eav
         WHERE object = messages.id
       ) AS attachments,
       (

emilsedgh

Token.get = async token => {
  const res = await db.query.promise('token/get', [token])

  const e = new Error(`Token ${token} not found`)

  if (res.rows.length < 1)
    throw e

  return res.rows[0]
}

emilsedgh

Token.get = async token => {
  const res = await db.query.promise('token/get', [token])

  if (res.rows.length < 1)
    throw Error.ResourceNotFound(`Token ${token} not found`)

  return res.rows[0]
}