Jviejo’s gists

Jviejo / agent http.txt

Created March 24, 2023 17:17

	COMIENZO
	fin de creacion de agentes
	{
	'content-type': 'application/didcomm-envelope-enc',
	accept: '/',
	'content-length': '2726',
	'user-agent': 'node-fetch/1.0 (+https://github.com/bitinn/node-fetch)',
	'accept-encoding': 'gzip,deflate',
	connection: 'close',
	host: 'localhost:5555'

Jviejo / aries.connection.indicio.ts

Created March 11, 2023 10:58

	import { AskarModule } from '@aries-framework/askar';
	import {
	Agent, ConsoleLogger, DidsModule, HttpOutboundTransport,
	InitConfig, KeyDidResolver, LogLevel,
	PeerDidResolver, WsOutboundTransport
	} from "@aries-framework/core";
	import { agentDependencies } from "@aries-framework/node";
	import { AskarWalletPostgresStorageConfig } from "@aries-framework/askar/build/wallet";

	const storageConfig: AskarWalletPostgresStorageConfig = {

Jviejo / test.askar.ts

Created March 10, 2023 16:17

	import '@hyperledger/aries-askar-nodejs'
	import { ariesAskar, LogLevel, Store, StoreKeyMethod } from '@hyperledger/aries-askar-shared'
	const getRawKey = () => "9Lgah8ykGoxDNLxoEBKRFxrdV9JCU98w6jXz4xp3Z7kP" \|\| Store.generateRawKey(Buffer.from('00000000000000000000000000000My1'))
	console.log(getRawKey())
	export const testStoreUri = 'postgres://postgres:postgres@localhost:5432/postgres' \|\| 'sqlite://:memory:'
	export const setupWallet = async () => {
	const key = getRawKey()

	return await Store.provision({
	recreate: true,

Jviejo / radiografia de send message aries javasacript framework,txt

Created March 8, 2023 08:11

	2023-03-08T08:05:09.692Z BEGIN

	2023-03-08T08:05:09.717Z BEFORE GET ARIES AGENT

	2023-03-08T08:05:09.720Z Getting tenant agent for tenant '63ff1400-a8f6-480b-b510-1fa5a3f4c3b5' undefined
	2023-03-08T08:05:10.024Z Getting context for session with tenant '63ff1400-a8f6-480b-b510-1fa5a3f4c3b5' undefined
	2023-03-08T08:05:10.030Z Acquiring tenant session undefined
	2023-03-08T08:05:10.030Z Increasing current session count to 1 (max: 100) undefined
	2023-03-08T08:05:10.031Z Acquired tenant session (1 / 100) undefined
	2023-03-08T08:05:10.031Z Created tenant agent context for tenant '63ff1400-a8f6-480b-b510-1fa5a3f4c3b5' undefined

Jviejo / Dockerfile

Created March 6, 2023 09:35

Dockerfile para ubuntu 2204 and aries

	FROM ubuntu:22.04 as base

	ENV DEBIAN_FRONTEND noninteractive

	RUN apt-get update -y && apt-get install -y \
	software-properties-common \
	apt-transport-https \
	curl \
	# Only needed to build indy-sdk
	build-essential \

Jviejo / northwind oracle

Created October 10, 2022 10:47

	CREATE TABLE CATEGORIES
	(
	CATEGORY_ID NUMBER(9) NOT NULL,
	CATEGORY_NAME VARCHAR2(15 BYTE) NOT NULL,
	DESCRIPTION VARCHAR2(2000 BYTE),
	PICTURE VARCHAR2(255 BYTE),
	CONSTRAINT PK_CATEGORIES PRIMARY KEY (CATEGORY_ID)
	);

	CREATE UNIQUE INDEX UIDX_CATEGORY_NAME ON CATEGORIES(CATEGORY_NAME);

Jviejo / mongo.js

Created November 2, 2021 13:47

	var url = "mongodb+srv://database:aqui va la password@ip/myFirstDatabase?retryWrites=true&w=majority"
	var MongoClient = require('mongodb').MongoClient;

	MongoClient.connect(url, function(err, client) {
	if (err){
	console.log(err);
	return;
	}
	var db = client.db('data');
	var cursor = db.collection('ciudades').find();

Jviejo / firestore.js

Created November 2, 2021 13:10

	// Import only what you need
	const admin = require('firebase-admin');

	process.env['FIRESTORE_EMULATOR_HOST'] = 'localhost:8081';

	var serviceAccount = require('./curso_inicio.json')
	admin.initializeApp({
	credential: admin.credential.cert(serviceAccount),
	projectId: "curso-de-inicio",
	});

Jviejo / loles.txt

Created April 22, 2021 12:08

problema de años entre dos fechas con firebird

	Supongo por la foto que la base de datos es firebird.

	La documentación para obtener el numero de años dice que hay que poner

	datediff(YEAR FROM FECHA_NACIMIENTO TO CURDATE())

	NO SE SI A LA HORA DE PONERLO EN LA INTERFAZ DEL PROGRAMA (QUE NO TENGO INSTALADO), SE PUEDE PONER ASÍ
	O HAY QUE PONERLO

	datediff(YEAR, "FECHA_NACIMIENTO", CURDATE)

Jviejo / javea.csv

Last active July 27, 2020 07:59

We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 36 columns, instead of 14 in line 9.

	orden,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34
	0,630,JAVEA,Masculino,0,1,,BLANCAS,1,2,3,4,5,6,7,8,9,Ida,Vc,Vs,10,11,12,13,14,15,16,17,18,Vuelta,Vc,Vs,Total,Vc,Vs,
	1,630,JAVEA,Masculino,0,2,,Metros,158,322,465,390,469,355,130,312,383,2984,,,184,343,379,432,450,326,111,312,383,2920,,,5904,,,
	2,630,JAVEA,Masculino,0,3,,Par,3,4,5,4,5,4,3,4,4,36,35.5,127,3,4,4,5,5,4,3,4,4,36,35.1,129,72,70.5,128,
	3,630,JAVEA,Masculino,0,4,,Handicap,15,9,7,1,13,3,17,11,5,,,,10,8,2,16,14,4,18,12,6,,,,,,,
	4,630,JAVEA,Masculino,1,1,,AMARILLAS,1,2,3,4,5,6,7,8,9,Ida,Vc,Vs,10,11,12,13,14,15,16,17,18,Vuelta,Vc,Vs,Total,Vc,Vs,
	5,630,JAVEA,Masculino,1,2,,Metros,149,308,432,372,455,344,119,302,371,2852,,,172,319,373,421,438,322,104,302,371,2822,,,5674,,,
	6,630,JAVEA,Masculino,1,3,,Par,3,4,5,4,5,4,3,4,4,36,34.9,121,3,4,4,5,5,4,3,4,4,36,34.5,126,72,69.4,124,
	7,630,JAVEA,Masculino,1,4,,Handicap,15,9,7,1,13,3,17,11,5,,,,10,8,2,16,14,4,18,12,6,,,,,,,
	8,630,JAVEA,Masculino,2,1,,ROJAS,1,2,3,4,5,

José Viejo HUerta Jviejo