Skip to content

Instantly share code, notes, and snippets.

View alexander-arce's full-sized avatar

Alex Arce alexander-arce

View GitHub Profile
@alexander-arce
alexander-arce / init.vm
Created October 30, 2017 19:45
Neovim Configuration
" Place in ~/.config/nvim
" vim-bootstrap
"*****************************************************************************
"" Vim-PLug core
"*****************************************************************************
if has('vim_starting')
set nocompatible " Be iMproved
endif
https://www.ianlewis.org/en/reversing-django-admin-urls
https://github.com/jsocol/django-adminplus
https://github.com/frankwiles/django-admin-views
http://www.pabloleanomartinet.com/adding-custom-admin-pages-django/
eval "$(ssh-agent -s)"
@alexander-arce
alexander-arce / Create user
Last active March 8, 2023 14:24
Etherpad Lite Install + Postgresql
sudo adduser --system --home=/opt/etherpad --group etherpad
@alexander-arce
alexander-arce / Reset stock
Created November 26, 2015 23:45
OpenERP/Odoo
DELETE FROM stock_move;
DELETE FROM mrp_production;
DELETE FROM stock_picking;
DELETE FROM sale_order;
DELETE FROM procurement_order;
@alexander-arce
alexander-arce / Excel
Last active November 26, 2015 22:13
EAN13 check digit
Español
=B1&(REDONDEAR.MAS(((MED(B1,2,1)+MED(B1,4,1)+MED(B1,6,1)+MED(B1,8,1)+MED(B1,10,1)+MED(B1,12,1))*3)+(MED(B1,1,1)+MED(B1,3,1)+MED(B1,5,1)+MED(B1,7,1)+MED(B1,9,1)+MED(B1,11,1)),-1)-(((MED(B1,2,1)+MED(B1,4,1)+MED(B1,6,1)+MED(B1,8,1)+MED(B1,10,1)+MED(B1,12,1))*3)+(MED(B1,1,1)+MED(B1,3,1)+MED(B1,5,1)+MED(B1,7,1)+MED(B1,9,1)+MED(B1,11,1))))
Ingles
=C4&(ROUNDUP(((MID(C4,2,1)+MID(C4,4,1)+MID(C4,6,1)+MID(C4,8,1)+MID(C4,10,1)+MID(C4,12,1))*3)+(MID(C4,1,1)+MID(C4,3,1)+MID(C4,5,1)+MID(C4,7,1)+MID(C4,9,1)+MID(C4,11,1)),-1)-(((MID(C4,2,1)+MID(C4,4,1)+MID(C4,6,1)+MID(C4,8,1)+MID(C4,10,1)+MID(C4,12,1))*3)+(MID(C4,1,1)+MID(C4,3,1)+MID(C4,5,1)+MID(C4,7,1)+MID(C4,9,1)+MID(C4,11,1))))
Libre Office
Español
=B1&(REDONDEAR.MAS(((EXTRAEB(B1,2,1)+EXTRAEB(B1,4,1)+EXTRAEB(B1,6,1)+EXTRAEB(B1,8,1)+EXTRAEB(B1,10,1)+EXTRAEB(B1,12,1))*3)+(EXTRAEB(B1,1,1)+EXTRAEB(B1,3,1)+EXTRAEB(B1,5,1)+EXTRAEB(B1,7,1)+EXTRAEB(B1,9,1)+EXTRAEB(B1,11,1)),-1)-(((EXTRAEB(B1,2,1)+EXTRAEB(B1,4,1)+EXTRAEB(B1,6,1)+EXTRAEB(B1,8,1)+EXTRAEB(B1,10,1)+EXTRAEB(B1,
@alexander-arce
alexander-arce / select row numbers
Created September 21, 2015 22:19
Row numbers, Postgresql
SELECT
row_number() over() as row_number, ..
FROM ...
@alexander-arce
alexander-arce / Export ODBC
Created July 5, 2015 15:25
MIgrate DB Acess
Private Sub Comando17_Click()
Dim sTblNm As String
Dim sTypExprt As String
Dim sCnxnStr As String, vStTime As Variant
Dim db As Database, tbldef As DAO.TableDef
On Error GoTo ExportTbls_Error
sTypExprt = "ODBC Database"
sCnxnStr = "ODBC;DSN=PostgreSQL35W;DATABASE=siafu;SERVER=127.0.0.1;PORT=5432;UID=postgres;PWD=postgres;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1c20502bb;A1=7.4-1"
@alexander-arce
alexander-arce / Append key to remote host
Last active August 29, 2015 14:20
AutoSSH tunnel mysql
cat ~/.ssh/id_rsa.pub | ssh user@hostname 'cat >> .ssh/authorized_keys'
@alexander-arce
alexander-arce / Bulk update
Created April 2, 2015 19:50
Postgresql, change owner
--Tables
SELECT 'ALTER TABLE '|| schemaname || '.' || tablename ||' OWNER TO ccaprod;'
FROM pg_tables WHERE NOT schemaname IN ('pg_catalog', 'information_schema')
ORDER BY schemaname, tablename;
--Sequences
SELECT 'ALTER SEQUENCE '|| sequence_schema || '.' || sequence_name ||' OWNER TO ccaprod;'
FROM information_schema.sequences WHERE NOT sequence_schema IN ('pg_catalog', 'information_schema')
ORDER BY sequence_schema, sequence_name;
--Views
SELECT 'ALTER VIEW '|| table_schema || '.' || table_name ||' OWNER TO ccaprod;'