José Manuel Muñoz Manzano JoseManuelMunozManzano

🎃

Focusing

I love programming... and comics, too!

JoseManuelMunozManzano / BLOB_TO_CLOB.SQL

Last active April 25, 2025 06:51

DB2 - BLOB TO CLOB

	-- Dado FIELD con tipo de dato BLOB y tamaño 1Mb que contiene un XML, para pasarlo a un CLOB y que se pueda ver en una consulta SQL, se puede hacer la siguiente consulta

	SELECT XMLSERIALIZE(XMLPARSE(DOCUMENT FIELD) AS CLOB(1M)) FROM MY_TABLE WHERE FIELD IS NOT NULL FETCH FIRST 100 ROWS ONLY;


	-- Si se quiere obtener del XML un campo concreto

	WITH MYXML AS (SELECT XMLSERIALIZE(XMLPARSE(DOCUMENT PV_VALXML) AS CLOB(1M)) PV_VALXML FROM PERITOS_VALORACIONES WHERE PV_VALXML IS NOT NULL FETCH FIRST 300 ROWS ONLY)
	SELECT IFNULL(TOTAL_HORAS, '')
	FROM MYXML X, XMLTABLE(

JoseManuelMunozManzano / json2csv.bash

Created May 26, 2024 05:15 — forked from jenschurchill/json2csv.bash

JSON to CSV

	#!/usr/bin/env bash

	# Bash script to convert JSON data using jq.
	###############################################################################
	# MIT License
	#
	# Copyright (c) 2024 Jens Melgard Churchill <[email protected]>
	#
	# Permission is hereby granted, free of charge, to any person obtaining a copy
	# of this software and associated documentation files (the "Software"), to deal

JoseManuelMunozManzano / ChangeColorLogs.java

Created November 24, 2023 17:27

Spring Boot - Cambiar color de logs

	// Añadir al pom
	<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-logging</artifactId>
	</dependency>

	// Indicar estas propiedades en el fichero properties
	// El nivel de logging se verá en rojo en este caso
	spring.output.ansi.enabled=always
	logging.pattern.level=%clr(%5p){red}

JoseManuelMunozManzano / parse-jwt.js

Created June 26, 2023 04:40 — forked from Klerith/parse-jwt.js

Parse - JWT - Obtener Payload y fecha de creación y expiración

	function parseJwt (token) {
	var base64Url = token.split('.')[1];
	var base64 = base64Url.replace('-', '+').replace('_', '/');
	return JSON.parse(window.atob(base64));
	};

JoseManuelMunozManzano / Dockerfile

Created June 7, 2023 04:25 — forked from Klerith/Dockerfile

Preparar imagen de Docker - Node App

	# Install dependencies only when needed
	FROM node:18-alpine3.15 AS deps
	# Check https://github.com/nodejs/docker-node/tree/b4117f9333da4138b03a546ec926ef50a31506c3#nodealpine to understand why libc6-compat might be needed.
	RUN apk add --no-cache libc6-compat
	WORKDIR /app

	COPY package.json yarn.lock ./
	RUN yarn install --frozen-lockfile

JoseManuelMunozManzano / Dockerfile

Last active September 2, 2022 05:39 — forked from Klerith/Dockerfile

Preparar imagen de Docker - Node App

	# Install dependencies only when needed
	FROM node:18-alpine3.15 AS deps
	# Check https://github.com/nodejs/docker-node/tree/b4117f9333da4138b03a546ec926ef50a31506c3#nodealpine to understand why libc6-compat might be needed.
	RUN apk add --no-cache libc6-compat
	WORKDIR /app
	COPY package.json yarn.lock ./
	RUN yarn install --frozen-lockfile

	# Build the app with cache dependencies
	FROM node:18-alpine3.15 AS builder

JoseManuelMunozManzano / nvmCommands.js

Last active April 28, 2024 06:09 — forked from chranderson/nvmCommands.js

Useful NVM commands

	// check version
	node -v \|\| node --version

	// list installed versions of node (via nvm)
	nvm ls

	// install specific version of node
	nvm install 6.9.2

	// set default version of node