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
<link rel="import" href="../chart-js/chart-js.html"> | |
<link rel="import" href="../topeka-elements/category-icons.html"> | |
<link rel="import" href="../core-icon/core-icon.html"> | |
<link rel="import" href="../paper-toast/paper-toast.html"> | |
<link rel="import" href="../code-mirror/code-mirror.html"> | |
<polymer-element name="my-element"> | |
<template> | |
<style> |
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
// reduce() awesomeness | |
var a = [1, 2, 3, 4, 5, 5, 3]; | |
var b = [{key: 1, value: 'a'}, {key: 2, value: 'b'}]; | |
var c = [promise1, promise2, promise3...]; | |
// Max | |
a.reduce((x, y) => x > y ? x : y); // 5 | |
// Min | |
a.reduce((x, y) => x < y ? x : y); // 1 |
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 "reflect-metadata"; | |
import * as moment from "moment"; | |
import * as _ from "lodash"; | |
moment.locale("es"); | |
try { | |
const formatMetadataKey = Symbol("churro"); | |
enum TIPOS { | |
tributo, |
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
var express = require('express'); | |
var app = express(); | |
var process = require("process"); | |
// nombre del modulo | |
var nombreapp = "gt" | |
var args = process.argv.slice(2); | |
// creación de rutas | |
var k = (modulo, rutas) => | |
{ | |
var r1 = express.Router(); |
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
//================================================================================================= | |
// el esquema es el siguiente: | |
// tenemos una aplicación web instalada en una máquina | |
// tenemos una aplicación api instalada en otra máquina | |
// tenemos módulos que se instalan via npm en la aplicación web y en el api (son los mismos módulos) | |
// en desarrollo trabajaremos solo con lo aplicación web y los modulos se instalarán localmente | |
// en producción los modulos los instalamos junto con el web api | |
// en producción tambien se podrían desplegar junto con la web | |
//================================================================================================= |
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
-- generacion de interfaces agrupadas por schema+tabla | |
WITH INTERFACES AS (SELECT | |
CHR(9)|| 'interface ' || table_name || ' {' || CHR(10) || | |
string_agg(CHR(9) ||CHR(9)|| column_name || ': ' || | |
CASE WHEN udt_name IN | |
('jsonb', 'json') | |
THEN 'any' | |
WHEN udt_name = 'varchar' | |
THEN 'string' |
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
create or replace function clobToBlob( c IN CLOB ) RETURN BLOB is | |
b BLOB; | |
warn VARCHAR2(255); | |
cs_id NUMBER := NLS_CHARSET_ID('WE8MSWIN1252'); | |
do NUMBER := 1; -- dest offset | |
so NUMBER := 1; -- src offset | |
lc NUMBER := 0; -- lang context | |
BEGIN | |
DBMS_LOB.createTemporary(b, TRUE ); | |
DBMS_LOB.CONVERTTOBLOB(b, UTL_URL.UNESCAPE(c), DBMS_LOB.LOBMAXSIZE, do, so, cs_id, lc, warn); |
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
declare | |
v varchar2(32000) := ' | |
<r> | |
<k1>dddd</k1> | |
<k2>dddd</k2> | |
<k3>dddd</k3> | |
<k4>dddd</k4> | |
<k5>dddd</k5> | |
<k6>dddd</k6> | |
<k7>dddd</k7> |
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
_asm{ | |
mov eax,0 | |
mov ebx,0 | |
mov ah,3 | |
mov al,0 | |
b_1: cmp al,ah | |
jge e_1 | |
; segundo bucle | |
mov bl,al | |
inc bl |
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
INSERT INTO app.messervicio as acum(id, NUMEROCOBROS, IMPORTECOBROS, ant, cargo, abono, actual, aaaa, mm, idservicios, idfactuaaaamm) | |
select idfactuaaaamm || '-' || idservicios id, | |
count(*) NUMEROCOBROS, | |
sum(monto) IMPORTECOBROS, | |
0,0,0,0, | |
aaaa,mm, | |
idservicios, | |
idfactuaaaamm | |
from app.cobros a | |
where a.idfactuaaaamm = '201301' |
OlderNewer