Jules T julestruong

🎯

Focusing

Passionate web engineer (back, front , mobile)

julestruong / gist:9955b11d53d3aec5152f96b574179497

Created May 16, 2023 15:41


	<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

	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) {

julestruong / sql

Created May 24, 2019 16:19

offers moderated more than once

	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

	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

julestruong / authent.ts

Created June 1, 2018 17:26

Groupama Authent bug

	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