How to use the Raw function from typeorm

bizplace-generator.js

GitHub: things-factory/opa-app

19
20
21
22
23
24
25
26
27
28
},
email: async email => {
  if (/.+\@.+\..+/.test(email)) {
    const { User } = require('@things-factory/auth-base')
    const user = await getRepository(User).findOne({
      where: { email: Raw(alias => `LOWER(${alias}) LIKE '${email.toLowerCase()}'`) }
    })
    return user ? true : chalk.redBright(`There's no user has ${chalk.cyan(email)} as email.`)
  } else {
    return chalk.redBright('Please type right format of email')

0

0

8

+ 31 other calls in file

system-domain-generator.js

GitHub: things-factory/opa-app

52
53
54
55
56
57
58
59
60
61
subdomain: async subdomain => {
  if (/^[a-z0-9]+$/.test(subdomain)) {
    const { Domain } = require('@things-factory/shell')
    const domain = await getRepository(Domain).findOne({
      where: {
        name: Raw(alias => `LOWER(${alias}) LIKE '${subdomain.toLowerCase()}'`)
      }
    })
    return domain ? chalk.redBright(`There's a domain has ${chalk.cyan(name)} as subdomain already.`) : true
  } else {

0

0

8

+ 47 other calls in file