Autor: jpicon

{«Version»: «2012-10-17»,«Statement»: [{«Effect»: «Allow»,«Action»: [«s3:GetBucketLocation»,«s3:ListAllMyBuckets»],«Resource»: «arn:aws:s3:::» }, { «Effect»: «Allow», «Action»: «s3:«,«Resource»: [«arn:aws:s3:::licitar-backend»,«arn:aws:s3:::licitar-backend/«, «arn:aws:s3:::licitar-backend-test», «arn:aws:s3:::licitar-backend-test/«,«arn:aws:s3:::licitar-content»,«arn:aws:s3:::licitar-content/*»]}]}

SELECT * from information_schema.TABLES where TABLE_SCHEMA!=’performance_schema’ and TABLE_SCHEMA!=’sys’ and TABLE_SCHEMA!=’information_schema’ and TABLE_SCHEMA!=’mysql’ and TABLE_COLLATION!=’utf8mb4_unicode_ci’; SELECT table_schema, table_name, column_name, character_set_name, collation_nameFROM information_schema.columnsWHERE collation_name != ‘utf8mb4_unicode_ci’ and TABLE_SCHEMA!=’performance_schema’ and TABLE_SCHEMA!=’sys’ and TABLE_SCHEMA!=’information_schema’ and TABLE_SCHEMA!=’mysql’ORDER BY table_schema, table_name,ordinal_position;

enviroment local: export const environment = { production: false, coreUrl: ‘https://core-api.saas.com.ar/api/’, UrlHttpType: ‘https://’, apiUrlOverride: ‘dev-client-api.saas.com.ar’, npm run-script start-local

select concat(CUIT,’;’,PtoVta,’;’,cco_Nro,’;;’,cast(GananciasMonto as numeric(10,2)),’;’,cast(IngresosBrutosMonto as numeric(10,2)),’;;’,OPNumero,’;’) from ( select CUIT,cast(cco_CodPvt as integer) as PtoVta, cast(cco_Nro as integer) as cco_Nro, GananciasMonto, isnull(IIBBMonto,0)+isnull(IBTMonto,0) as IngresosBrutosMonto, cast(OPNumero as integer) as OPNumero from (SELECT DISTINCT TablaFacturas.cco_Letra, TablaFacturas.cco_CodPvt, TablaFacturas.cco_Nro, TablaFacturas.ccotco_Cod as Codigo, TablaFacturas.ccopro_CUIT as CUIT, TablaFacturas.cco_ImpMonEmis as Monto, TablaFacturas.cco_Nro as Numero, TablaOP.cco_ImpMonEmis as OPMonto, TablaOP.cco_Nro as OPNumero, TablaGananciasUnida.cco_ImpMonEmis as GananciasMonto,…

sudo apt-get install zbar-tools imagemagick   zbarimg 2.png -q       para pdf hay que editar vim /etc/ImageMagick-6/policy.xml   ahi hay que comentar: <policy domain=»coder» rights=»none» pattern=»PDF» />

https://stackoverflow.com/questions/35912904/how-to-get-sqlsrv-on-xampp-working-with-medoo instalas en xampp/php/ext la libreria y la declaras en el php inii extension=sqlsrv_74_ts_x64 extension=pdo_sqlsrv_74_ts_x64 extension=pdo_odbc   luego tenes que instalar los drivers de odbc —   As you can see you need version 3.2 for PHP 5.6 support. I found download link and information about adding SQLSRV extension to php.ini for you. https://www.microsoft.com/en-us/download/details.aspx?id=20098 https://msdn.microsoft.com/en-us/library/cc296203(v=sql.105).aspx…

instalar composer: con hombrew instalar bref: npm install -g serverless configurar credenciales: serverless config credentials –provider aws –key <key> –secret <secret> installar bref composer require bref/bref ir a la carpeta del proyecto y ejecutar bref con OPCION 1 vendor/bin/bref init luego se ejecuta la subida serverless deploy —- si esta ya instalado como en este…

pip3 install requests -t .

haces un bat con este contenido. tenes que crear primero la carpeta logs. va a escribir un file llamado nube.log pegandole la fecha del backup. y el contenido   @echo off set logfile=F:logsnube set fecha=%date:~-4%%date:~3,2%%date:~0,2% set extension=.log echo starting nube at %date% %time% >> %logfile%%fecha%%extension% aws s3 sync E:BackupsSQL s3://osceara-backups/bejerman-2012-new7d –storage-class STANDARD_IA >> %logfile%%fecha%%extension%  …