zhangyuan

ffmpeg -i input.avi -c:v libx264 -crf 19 -preset slow -c:a aac -strict experimental -b:a 192k -ac 2 out.mp4

zhangyuan

declare @ids table (id int)
insert into @ids 
select [id] as ids from [table_name] where [column_name] is not null

SELECT * FROM [another_table_name] where [id] in (select top 2000 id from @ids)

zhangyuan

$username = ""
$password = ""
$url = ""

$securePassword = ConvertTo-SecureString $password -AsPlainText -Force
$credential = New-Object System.Management.Automation.PSCredential ($username, $securePassword)

$stream  = Invoke-WebRequest -Uri url -Credential $credential

Write-Host $stream.content

zhangyuan

GO_SERVER_DATE %{YEAR}-%{MONTHNUM}-%{MONTHDAY} %{HOUR}:%{MINUTE}:%{SECOND},%{INT}
GO_SERVER %{GO_SERVER_DATE:timestamp}%{SPACE}%{LOGLEVEL:log_level} \[%{DATA:field1}\] %{NOTSPACE:field2}

zhangyuan

cmd /c "rmdir /S /Q \\remote_hostname_or_ip\c$\target_directory"

zhangyuan

#!/usr/bin/env bash

for file in *.mp4;
do
  ffmpeg -i "$file" -codec:a libmp3lame -qscale:a 2 "${file:0:${#file} - 4}".mp3
done

zhangyuan

brew tap homebrew/versions
brew install v8-315

bundle config build.libv8 --with-system-v8 --with-v8-dir=/usr/local/opt/v8-315
bundle config build.therubyracer --with-system-v8 --with-v8-dir=/usr/local/opt/v8-315

bundle

zhangyuan

public class QueryableActiveRecord<T> : ActiveRecordBase<T>
{
    public static IOrderedQueryable<T> Queryable()
    {
        ISession session = holder.CreateSession(typeof(T));
        return new NhQueryable<T>((ISessionImplementor)session);
    }
}

zhangyuan

buildscript {
    repositories {
        maven {
            url "http://127.0.0.1:8021/nexus/content/repositories/gradle/"
        }
    }
}

repositories {
    maven {

zhangyuan

backend default {
  .host = "www.tonghaohui.com";
  .port = "80";
}

sub vcl_recv {
  set req.backend = default;
  if (req.url ~ "^/w/") {
    return(pass);
  }