Skip to content

Instantly share code, notes, and snippets.

View hoangvanthien's full-sized avatar
🏳️‍🌈

Thien Hoang hoangvanthien

🏳️‍🌈
41 followers · 11 following
View GitHub Profile
@hoangvanthien
hoangvanthien / 760.cpp
Created April 15, 2016 16:59
#include <bits/stdc++.h>
using namespace std;
#define FOR(i,x,y) for(int i = (x); i<=(y); ++i)
#define REP(i,r) for(int i = 0; i < (r); ++i)
#define DFOR(i,x,y) for(int i = (x); i>=(y); --i)
#define db(x) cout << #x << " = " << x << endl;
#define forit(it, var) for(__typeof(var.begin()) it = var.begin(); it!=var.end(); ++it)
#define forrit(it, var) for(__typeof(var.rbegin()) it = var.rbegin(); it!=var.rend(); ++it)
#define pb push_back
@hoangvanthien
hoangvanthien / SARRAY.cpp
Created April 16, 2016 05:02
#include <bits/stdc++.h>
using namespace std;
#define FOR(i,x,y) for(int i = (x); i<=(y); ++i)
#define REP(i,r) for(int i = 0; i < (r); ++i)
#define DFOR(i,x,y) for(int i = (x); i>=(y); --i)
#define db(x) cout << #x << " = " << x << endl;
#define forit(it, var) for(__typeof(var.begin()) it = var.begin(); it!=var.end(); ++it)
#define forrit(it, var) for(__typeof(var.rbegin()) it = var.rbegin(); it!=var.rend(); ++it)
#define pb push_back
@hoangvanthien
hoangvanthien / Hoang Van Thien.md
Last active July 20, 2016 22:41

VNOI Contributor Information

===== Họ và tên: Hoàng Văn Thiên

Link:

Kinh nghiệm:

@hoangvanthien
hoangvanthien / Template.cpp
Last active August 19, 2016 06:49
#include "bits/stdc++.h"
using namespace std;
#define FOR(i, x, y) for(int i = (x); i<=(y); ++i)
#define REP(i, r) for(int i = 0; i < (r); ++i)
#define DFOR(i, x, y) for(int i = (x); i>=(y); --i)
#define db(x) cout << #x << " = " << x << endl;
#define forit(it, var) for(__typeof(var.begin()) it = var.begin(); it!=var.end(); ++it)
#define forrit(it, var) for(__typeof(var.rbegin()) it = var.rbegin(); it!=var.rend(); ++it)
@hoangvanthien
hoangvanthien / kruskal.cpp
Created September 26, 2016 09:46
// QBMST on SPOJ
#include <bits/stdc++.h>
using namespace std;
#define FOR(i,x,y) for(int i = (x); i<=(y); ++i)
#define REP(i,r) for(int i = 0; i < (r); ++i)
#define DFOR(i,x,y) for(int i = (x); i>=(y); --i)
#define db(x) cout << #x << " = " << x << endl;
#define forit(it, var) for(__typeof(var.begin()) it = var.begin(); it!=var.end(); ++it)
#define forrit(it, var) for(__typeof(var.rbegin()) it = var.rbegin(); it!=var.rend(); ++it)
@hoangvanthien
hoangvanthien / numpy-pima-interview.ipynb
Last active April 27, 2019 17:29
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@hoangvanthien
hoangvanthien / solution.cpp
Last active June 7, 2020 07:01
[Solution] 1461. Check If a String Contains All Binary Codes of Size K
class Solution {
public:
bool hasAllCodes(string s, int k) {
if (k > s.size()) return false;
int x = 0;
for (int i = 0; i < k; ++i) {
x <<= 1;
x += (s[i] == '1');
}
bool a[1<<k];
@hoangvanthien
hoangvanthien / clone-postgresql-database.md
Created June 21, 2022 03:14
Clone Postgresql database

Terminate any connections to sourceDB

SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity 
WHERE pg_stat_activity.datname = 'sourceDB' AND pid <> pg_backend_pid();

Then clone sourceDB into newDB

@hoangvanthien
hoangvanthien / generate-liquibase-changelog.md
Last active June 21, 2022 11:11

Clone database k1 to k1clone (see guide), make changes to k1, then run this:

liquibase diffchangelog --url="jdbc:postgresql://localhost/k1clone" --username=postgres --password=admin --defaultSchemaName=organization --referenceUrl="jdbc:postgresql://localhost/k1" --referenceUsername=postgres --referencePassword=admin --referenceDefaultSchemaName=organization --changelog-file="hello.xml"