Skip to content

Instantly share code, notes, and snippets.

View yonelacort's full-sized avatar

Yone Lacort Collado yonelacort

View GitHub Profile
@yonelacort
yonelacort / fix_payment_tables_sequence.sql
Created March 31, 2020 06:52
Restart serial ID sequence for payment tables
CREATE OR REPLACE FUNCTION fix_sequence(tableName text, columnName text)
RETURNS BOOLEAN AS $$
DECLARE
nextValue int;
expectedNextValue int;
sequenceName text;
BEGIN
EXECUTE 'SELECT pg_get_serial_sequence(''' || tableName || ''', ''' || columnName || ''')' INTO sequenceName;
SELECT nextval(sequenceName) INTO nextValue;
EXECUTE 'SELECT COALESCE(MAX(' || columnName || ') + 1, 1) FROM ' || tableName INTO expectedNextValue;
@yonelacort
yonelacort / .eslintrc.js
Created November 14, 2016 13:32 — forked from nkbt/.eslintrc.js
Strict ESLint config for React, ES6 (based on Airbnb Code style)
{
"env": {
"browser": true,
"node": true,
"es6": true
},
"plugins": ["react"],
"ecmaFeatures": {