Skip to content

Instantly share code, notes, and snippets.

View ducfilan's full-sized avatar
🥷
Be careful! A ninja is around here!

Duc Filan ducfilan

🥷
Be careful! A ninja is around here!
25 followers · 3 following
View GitHub Profile
@ducfilan
ducfilan / iso3611-2 to FIPS.go
Created December 23, 2023 14:18
ISO 3611-2 to FIPS (regions)
var RegionCodeISO31662ToFIPS = map[string]string{
// From Maxmind's list.
"AD-2": "02",
"AD-3": "03",
"AD-4": "04",
"AD-5": "05",
"AD-6": "06",
"AD-7": "07",
"AD-8": "08",
@ducfilan
ducfilan / git bash open visual studio code.sh
Created February 26, 2019 02:40
Open Visual Studio Code from Git bash
echo alias code=\'/c/Windows/System32/cmd.exe //C code \$\*\' > ~/.bash_profile
@ducfilan
ducfilan / Base64 to XML.cs
Created December 28, 2018 03:23
Entity Framework Migration History Base64 to XML info
class Program
{
static void Main(string[] args)
{
const string modelBase64 = @"H4sIAAAAAAAEAOy92XIcObIo+D5m8w8yPc1M99Fa1d2nrWqucZPEalJiMylVnycamAlmxlFkRHYslFjX7pfNw3zS/MIAiA2BfYvISCqszFjKgLsDcPgGx/b//T//7y//4/s2fvYAszxKk1+fv37x6vkzmCzTVZSsf31eFvf/8bfn/+P//t//t1/OVtvvz740cG8xHMJM8l+fb4pi9/eXL/PlBm5B/mIbLbM0T++LF8t0+xKs0pdvXr36z5evX7+EiMRzROvZs1+uy6SItpD8QD9P0mQJd0UJ4st0BeO8/o5KFoTqs49gC/MdWMJfn78D8TJNXpwhAsXj82dHcQRQIxYwvn/+DCRJWoACNfHvn3O4KLI0WS926AOIbx53EMHdgziHddP/3oGb9uLVG9yLlx1iQ2pZ5kW6tST4+m3NlpcsuhNzn7dsQ4yr+IN7TZj36/OTdLstE8Iztra/n8QZhmSYi/63She/L160qH9+1gP4cysQSG7wf39+dlLGRZnBXxNYFhmI//zsqryLo+U/4ONN+hUmv67uf/r57uf71fLu7d/u/3q3otuMWo3geh/Qp6ss3cGseLyG92xPzlfPn73sE3jJUmjxRchVp5GcIGl//uwSfL+AybrYID34y/Nn76LvcNV8qOXmcxIh3UA4RVainx/LOAZ3MWzLX2rqThBTlkWahahcV1fdT/xTUdlffgpQ2Xl+lmA+tL06TtMYgsSaQ+dJjn6dggLeRF2zu9+W5D7vVgg1GLnrNI4/lts7mLEMxQaszDJkOR8vCdcIS3uMfvvGhdEfwUO0JkoqG99LiBuUP392DWMCmG+iXWUQXzBAt5QNeJelW9QfnlIHdHsDsjUsUF9THeQiLbOlVesbTVC3+5YGFDSZKm/bwLWWBmq6RDf0l5edsTQzo
@ducfilan
ducfilan / Migration to base64.sql
Created December 28, 2018 02:35
Entity Migration Table (__MigrationHistory) to Base64
declare @binaryContent varbinary(max);
select @binaryContent = Model
from [dbo].[__MigrationHistory]
where migrationId = '201810100357043_Name'
select cast('' as xml).value('xs:base64Binary(sql:variable("@binaryContent"))',
'varchar(max)') as base64Content
@ducfilan
ducfilan / rename_db_sql_server.sql
Created December 28, 2018 02:33
Rename SQL Server Database
ALTER DATABASE [DB_NAME]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
sp_rename 'DB_NAME', 'DB_NAME_NEW' ,'DATABASE';
GO
ALTER DATABASE [DB_NAME_NEW]
SET MULTI_USER
GO
@ducfilan
ducfilan / Remove .srt timing information regex
Created October 21, 2018 13:59
I created this regex:
\n*^\d+\n\n\d+:\d+:\d+,*\d+ --> \d+:\d+:\d+,\d+\n\n
@ducfilan
ducfilan / Set Proxy in Ubuntu & Anaconda
Last active October 19, 2018 02:58
To Set Proxy in Ubuntu:
Edit the /etc/apt/apt.conf file under root and add the following:
Acquire::http::proxy "http://ProxyHOST:ProxyPORT/";
Acquire::https::proxy "https://ProxyHOST:ProxyPORT/";
sudo gedit ~/.condarc
proxy_servers:
http: http://ProxyHOST:ProxyPORT
@ducfilan
ducfilan / Quick choose Vietjet Air textboxes.js
Last active February 18, 2019 06:44
$("#selectOrigin").val("KIX").trigger("change");
$("#selectDestination").val("HAN").trigger("change");
$("#ctl00_UcRightV31_TxtDepartDate").val("27/11/2018");
$("#ctl00_UcRightV31_TxtReturnDate").val("29/11/2018");
$("#ctl00_UcRightV31_CbbCurrency_TextBox").val("JPY");
$("#ctl00_UcRightV31_BtSearch").trigger("click");
@ducfilan
ducfilan / handle_huge_csv.php
Last active September 5, 2017 05:53
Handle huge CSV file
function file_get_contents_chunked($file, $chunk_size, $args, $callback) {
try {
$handle = fopen($file, "r");
$i = 0;
while (!feof($handle))
{
call_user_func_array($callback,array(fread($handle,$chunk_size),&$handle,$i, $args));
$i++;
}
@ducfilan
ducfilan / SingletonBase.vb
Last active March 10, 2017 06:47
A visual basic (VB) base class for Singleton pattern implementation including Lazy initialization
Imports System.Reflection
Namespace Base
Public MustInherit Class SingletonBase(Of T As SingletonBase(Of T))
Private Shared ReadOnly _instance As Lazy(Of T)
Public Shared ReadOnly Property Instance() As T
Get
Return _instance.Value
End Get