Posted on | Edited on |

https://vim.rtorr.com/

Use relative line mode with vim

In vim, you will frequently need to manipulate multi line with 3dd 4yy or something else, relative line mode in IDE could help you easy to count the line number.
if you are using VScode like me, you could enable it by add the line to user setting:

1
"editor.lineNumbers": "relative",

Get difference before save

1
:w !diff % -

Explanation

  • w without filename will save to stdin
  • ! will excute bash in vim
  • % is current file in vim
  • diff with - will read content from stdin

Useful vim command combination list

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
# Make a word uppercase
gUe

# edit neariest word inside symbol, e.g. }
ci}

# edit neariest word outside symbol, e.g. ]
ca]

# edit and delete from cursor to next symbol, e.g. )
ct)

# edit and delete from cursor to previos symbol, e.g. )
cT)

# replace word with yanked word
viwp

# Comment multi line, for example using # for comment
1. Ctrl + v to enter "Visual block mode"
2. Move cursor to select lines that need to be edited
2. Shift + i
3. #
4. Esc

Common command

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
# get recent command list
q:

# Replace word A with word B
:%s/A/B/g

# Next word
w

# Previous word
b

# copy (yank)
y

# copy line
yy

# paste
p

# delete
d

# Undo
u

# Redo
ctrl + r

# Show Line numbers
set number

Posted on | Edited on |

When creating fixed navigation bar with padding, we got :

1
2
3
position: fixed;
width: 100%;
padding: 15px;

However you will find padding-right disappear, the reason is the width is window width + padding-left + padding-right. It is exceed the window, to fix it just use width: calc(100% - 30px) to reduce the width

1
2
3
position: fixed;
width: calc(100% - 30px);
padding: 15px;

See the Pen Fixed nav with correct padding by AsinChen (@Asing1001) on CodePen.

Posted on | Edited on |
  1. Go to create my applet page in IFTTT
  2. Choose this > Webhooks > Receive a web request
  3. Set any event name and click create trigger
  4. Choose that > Line > Send message
  5. Set Message as value1
  6. Go to Webhooks
  7. Click Documentation on the top right corner
  8. Fill up the event name and value1 then try the curl example on the page
  9. You could see a message deliver to LINE immdiately!

Posted on | Edited on |

Steps to install windows service

  1. Create a start.bat file with content npm start
  2. Download nssm
  3. Extract it and go to nssm/win64 folder
  4. Type nssm install service-name from command prompt
  5. Select start.bat as Application Path, you could also add your startup Arguments here
  6. Start service with nssm start service-name
  7. You could find it already registered as windows service :)

NSSM commands reference

You could type nssm anytime to see this document

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
M:\nssm-2.24\win64>nssm
NSSM: The non-sucking service manager
Version 2.24 64-bit, 2014-08-31
Usage: nssm <option> [<args> ...]

To show service installation GUI:

        nssm install [<servicename>]

To install a service without confirmation:

        nssm install <servicename> <app> [<args> ...]

To show service editing GUI:

        nssm edit <servicename>

To retrieve or edit service parameters directly:

        nssm get <servicename> <parameter> [<subparameter>]

        nssm set <servicename> <parameter> [<subparameter>] <value>

        nssm reset <servicename> <parameter> [<subparameter>]

To show service removal GUI:

        nssm remove [<servicename>]

To remove a service without confirmation:

        nssm remove <servicename> confirm

To manage a service:

        nssm start <servicename>

        nssm stop <servicename>

        nssm restart <servicename>

        nssm status <servicename>

        nssm rotate <servicename>

Reference

http://nssm.cc

Posted on | Edited on |

ECONNRESET when making thousands requests

In situation doing thousands of http requests, it is easy to get error ECONNRESET, for example :

1
2
3
4
5
6
7
8
require('isomorphic-fetch');

const promises = []
for(var i=0; i<10000; i++){
    promises.push(fetch('http://example.com/'+i));
}

const results = await Promise.all(promises)
Read more »

Posted on | Edited on | 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
-- Get current datetime
GETDATE()

-- Get year of datetime
YEAR(GETDATE())

-- Get difference between dates
DATEDIFF(dateformat, startdate, enddate)

-- Subtract date, e.g.: DATEADD(HOUR, -11, GETDATE())
DATEADD(Unit of time, value, date)

-- Avalable Unit of time value
NANOSECOND, MICROSECOND, MILLISECOND, SECOND, MINUTE, HOUR, WEEKDAY, WEEK, DAY, DAYOFYEAR, MONTH, QUARTER, YEAR

-- Between
select * from User where CreatedDate between '2016-09-26' and '2016-09-27'

-- Order by
select * from User order by column desc

-- Group by
select UserCode, Count(*) from User group by UserCode

-- Select top 10
SELECT TOP (10) * from User

Posted on | Edited on |

Today When I connect to Windows through Remote Desktop Viewer got error connecting to host prompt.
After searching the solution is to remove the server I’m having issue in $home/.freerdp/known_hosts and reconnecting again.

1
2
[[email protected] ~]$ vi ~/.freerdp/known_hosts
# In Vim, remove the line start with server ip you are connecting to by `dd`, and `:wq` to save the file.

Reference: https://superuser.com/questions/834447/vinagre-remote-desktop-viewer-for-gnome-isnt-working-out-of-box

Posted on | Edited on |

PostAsync

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
static readonly HttpClient Client = new HttpClient();
public async Task<T> PostAsync<T>(string url, object data) where T : class, new()
{
    try
    {
        string content = JsonConvert.SerializeObject(data);
        var buffer = Encoding.UTF8.GetBytes(content);
        var byteContent = new ByteArrayContent(buffer);
        byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
        var response = await Client.PostAsync(url, byteContent).ConfigureAwait(false);
        string result = await response.Content.ReadAsStringAsync();
        if (response.StatusCode != HttpStatusCode.OK)
        {
            logger.Error($"GetAsync End, url:{url}, HttpStatusCode:{response.StatusCode}, result:{result}");
            return new T();
        }
        logger.Info($"GetAsync End, url:{url}, result:{result}");
        return JsonConvert.DeserializeObject<T>(result);
    }
    catch (WebException ex)
    {
        if (ex.Response != null)
        {
            string responseContent = new StreamReader(ex.Response.GetResponseStream()).ReadToEnd();
            throw new System.Exception($"response :{responseContent}", ex);
        }
        throw;
    }
}

GetAsync

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
static readonly HttpClient Client = new HttpClient();
public async Task<string> GetAsync(string url, object data)
{
    try
    {
        string requestUrl = $"{url}?{GetQueryString(data)}";
        logger.Info($"GetAsync Start, requestUrl:{requestUrl}");
        var response = await Client.GetAsync(requestUrl).ConfigureAwait(false);
        string result = await response.Content.ReadAsStringAsync();
        logger.Info($"GetAsync End, requestUrl:{requestUrl}, HttpStatusCode:{response.StatusCode}, result:{result}");
        return result;
    }
    catch (WebException ex)
    {
        if (ex.Response != null)
        {
            string responseContent = new StreamReader(ex.Response.GetResponseStream()).ReadToEnd();
            throw new Exception($"Response :{responseContent}", ex);
        }
        throw;
    }
}

private static string GetQueryString(object obj)
{
    var properties = from p in obj.GetType().GetProperties()
                        where p.GetValue(obj, null) != null
                        select p.Name + "=" + HttpUtility.UrlEncode(p.GetValue(obj, null).ToString());

    return String.Join("&", properties.ToArray());
}