julestruong
/ gist:9955b11d53d3aec5152f96b574179497
Created
May 16, 2023 15:41
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <body style="height: 100%; margin: 0; -webkit-text-size-adjust: none; font-family: "Nunito Sans", Helvetica, Arial, sans-serif; background-color: #FFFFFF; color: #333333; width: 100% !important;"> | |
| <table class="email-wrapper" width="100%" cellpadding="0" cellspacing="0" role="presentation" style="width: 100%; margin: 0; padding: 0; -premailer-width: 100%; -premailer-cellpadding: 0; -premailer-cellspacing: 0;"> | |
| <tbody><tr> | |
| <td align="center" style="font-family: "Nunito Sans", Helvetica, Arial, sans-serif; font-size: 16px;"> | |
| <table class="email-content" width="100%" cellpadding="0" cellspacing="0" role="presentation" style="width: 100%; margin: 0; padding: 0; -premailer-width: 100%; -premailer-cellpadding: 0; -premailer-cellspacing: 0;"> | |
| <tbody><tr> | |
| <td class="email-masthead" style="font-family: "Nunito Sans", Helvetica, Arial, sans-serif; font-size: 16px; padding: 35px 0 5px; text-align: center;"> | |
| <a hre |
julestruong
/ build-mercurius-federated-schema.util.ts
Created
December 4, 2022 22:30
— forked from tugascript/build-mercurius-federated-schema.util.ts
Mercurius drivers with plugins
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import { loadPackage } from '@nestjs/common/utils/load-package.util'; | |
| import { transformSchema } from '@nestjs/graphql'; | |
| import { BuildFederatedSchemaOptions } from '@nestjs/graphql'; | |
| import { GraphQLSchema, isObjectType, buildASTSchema } from 'graphql'; | |
| import { forEach } from 'lodash'; | |
| export function buildMercuriusFederatedSchema({ | |
| typeDefs, | |
| resolvers, | |
| }: BuildFederatedSchemaOptions) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| COUNT(count) nb_remoderation, | |
| month | |
| FROM | |
| ( | |
| SELECT count(1) count, | |
| DATE_FORMAT(logged_at, '%Y-%m') month | |
| FROM office_offer oo | |
| INNER JOIN office_offer_log log ON log.object_id = oo.id | |
| WHERE JSON_CONTAINS(log.data, '"moderation"', '$.state') |
julestruong
/ gist:c98b8e4ac1705822739dabb8b7bd35db
Created
May 24, 2019 16:18
offers nb moderation by month
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| COUNT(count), | |
| month | |
| FROM | |
| (SELECT COUNT(1) count, DATE_FORMAT(logged_at, '%Y-%m') month | |
| FROM office_offer oo | |
| INNER JOIN office_offer_log log ON log.object_id = oo.id | |
| WHERE JSON_CONTAINS(log.data, '"moderation"', '$.state') | |
| GROUP BY oo.id, month | |
| ) sub |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| async function validateCredentials(request: any) { | |
| const logClient = console; | |
| // Always Trace the Lambda event and context | |
| logClient.log(`request : [${JSON.stringify(request)}]`); | |
| const body = (request.body && JSON.parse(request.body)) || undefined; | |
| // Check that the received body contains the required informations | |
| // For security reasons do not return a menaingfull message to the caller |