[Linux] Execute other cmd from cmd 'find'

將目錄下所有size=0之檔案，調整其權限為777 "rwxrwxrwx"

find . -type f -size 0k -exec chmod 777 {} ;

將目錄下所有權限非777 "rwxrwxrwx"之檔案都列出

find . -type f ! -perm 777;

[C] File mappings and domain of NHibernate for SQLite DB

C#中針對SQLite使用NHibernate來存取DB資料

1. 在C#專案裡需安裝的Packages

NHibernate

Iesi.Collections

2. 額外使用到的軟體 (產出cs與xml檔案)

NHibernateMappingGenerator

設定參考

Entity不修改

Namespace (Domain)、Namespace (Map)、Assembly Name都設為專案名

 Connection選擇SQLite，並修改Data Source的路徑指向DB file

最後按下Generate All即可產出cs與xml檔案

3. 在C#專案中建立Domain與Mapping資料夾，分別放入cs檔案與xml檔案

4. 在C#專案中建立hibernate.cfg.xml

 

    NHibernate.Driver.SQLite20Driver

    Data Source=[DB檔案路徑];Version=3

    NHibernate.Dialect.SQLiteDialect

    true=1;false=0

    true

   

 

5. 在C#專案中新增一class 'NHibernateHelper'

namespace [專案名]
{
    public class NHibernateHelper
    {
        private static ISessionFactory _sessionFactory;
        private static ISessionFactory SessionFactory
        {
            get
            {
                if (_sessionFactory == null)
                {
                    var configuration = new Configuration();
                    configuration.Configure();
                    _sessionFactory = configuration.BuildSessionFactory();
                }
                return _sessionFactory;
            }
        }
        public static ISession OpenSession()
        {
            return SessionFactory.OpenSession();
        }
    }
}

完成以上設置即可開始實作相關DB存取程式

[C#] Auto load x86/x64 SQLite DLL for Platform

  How to Reference Platform Specific (X86/x64) Assemblies in Visual Studio Projects


Unload對想要有此功能之Project，Edit xxx.csproj，新增下方內容

<!--Start Code-->
<choose></choose>
<when condition="$(Platform) == 'x64'"></when>
<itemgroup></itemgroup><br />
<reference include="System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=AMD64"></reference>
<specificversion>False</specificversion>
<hintpath>..SQLiteX64System.Data.SQLite.DLL</hintpath>
<otherwise></otherwise>
<itemgroup></itemgroup>
<reference include="System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86"></reference>
<specificversion>False</specificversion>
<hintpath>..SQLiteX86System.Data.SQLite.DLL</hintpath>
<!--End Code-->

存檔後關閉，然後Reload此Project，選擇Platform (此時Reference的DLL路徑已經修正成你所選定的平台對應的DLL)，Rebuild即可。

[C#] Post-Build event command line

Copy file(s) from one project to another using post build event

Visual Studio provides customized cmd script functions after Building solution.

Project->Property->Build Events->Post-Build event command line:

copy "$(SolutionDir)xxx.xml" "$(TargetDir)xxx.xml"

如上設置，可指定將Solotion Item的檔案一同複製一份至Project out folder

[C#] Set version for all projects in one solution

C# version for all projects in one solution

The Right Way to Version Your Assemblies

1. Create an new "VersionInfo.cs" in solution item
2. Clear its content
3. Copy content of  one of your "AssemblyInfo.cs" in your project to "VersionInfo.cs" (Modify the content if you want)
4. Clear content of all "AssemblyInfo.cs" in all projects
5. Add Link to the "VersionInfo.cs" in each of your projects

VIM Settings for Visual Studio 2008

Vi Tool

ViEmu (Install-ViEmuVS-3.0.6.exe)

Key Binding

Tool->Option->General->KeyBoard 設定

View.NavigateBackward (Ctrl + T)

Edit.GoToDefinition (Ctrl+])

Theme

Tool->Import and Export Settings 設定

coding-instinct-theme_vs2008.vssettings (網路上找尋自己想要的)

使用PowerShell設定系統變數與ps1範例

以下ps1範例包含系統時間格式、程式(標準/錯誤)輸出重導、外部程式呼叫與ps1變數使用

$datestr = Get-Date -format yyyMMdd
$reporttype = "COMP"
$folder = "D:\reportFolder\"
$toolpath = "D:\scripts\Report.php"

$log = '{0}logs\{1}_{2}.log' -f $folder, $reporttype, $datestr
$err = '{0}logs\{1}_{2}.err' -f $folder, $reporttype, $datestr
php.exe $toolpath type=$reporttype folder=$folder >>$log 2>>$err

PowerShell ps1之語法遠優於舊有的bat，使用上更為便利與靈活、更為易讀。


直接透過PowerShell永久設定系統環境變數之指令
# example of adding a path to PATH
[System.Environment]::SetEnvironmentVariable("PATH", $Env:Path + ";C:\Program Files (x86)\PHP", "Machine")

# creates “myY” of category “User”, and set the value to “"la la"”
[Environment]::SetEnvironmentVariable("myY", "la la", "User")

# removing a env var from registry
[Environment]::SetEnvironmentVariable("myY", $null, "User")

# show value of “path”
$env:path