由於 protobuf 撰寫定義檔時，針對 message 的每一個 field 都要明確的給定 id，其實大多開發人員都不在意這點但又覺得很擾人，這時此套件就可以幫你快速填上或是重整摟．
即可馬上變成下面：
這個套件再多屬性的 message 開發中，根本是神器，以往不敢亂改的 field 順序現在就可以隨便移動摟
]]>
<p>紀錄一下 Visual Studio 如何支援 .proto 檔案的撰寫</p>
Running consul in a container with UI and Development Modehttps://blackie1019.github.io/2019/03/21/Running-consul-in-a-container-with-UI-and-Development-Mode/2019-03-21T16:31:22.000Z2021-06-15T03:56:53.493Z記錄如何在容器內簡單啟動 Consul 的 Development Mode 與 UI 的指令
]]>
<p>記錄如何在容器內簡單啟動 Consul 的 Development Mode 與 UI 的指令</p>
gRPC development on .NET Core - Integration into .NET Build(.csproj)https://blackie1019.github.io/2019/03/18/gRPC-development-on-NET-Core-Integration-into-NET-Build-csproj/2019-03-18T15:29:30.000Z2021-06-15T03:56:53.737Z介紹如何將 gRPC 整合至 .NET Core 的專案檔(.csproj) 內．
package Demo.Message; //will be placed in a namespace matching the package name if csharp_namespace is not specified option csharp_namespace = "Demo.Message";
package Demo.Message; //will be placed in a namespace matching the package name if csharp_namespace is not specified option csharp_namespace = "Demo.Message"; import "message.proto";
namespaceDemo.Server { public class DemoServiceImpl:DemoService.DemoServiceBase { publicoverride Task<GreetingResponse> Say(GreetingMsg request, ServerCallContext context) { var response = new GreetingResponse { MsgValue = request.Value, ReturnValue = $"Received on {DateTime.Now:O}", }; return Task.FromResult(response); }
publicoverride Task<TestResponse> TestWithEmpty(EmptyMsg request, ServerCallContext context) { var response = new TestResponse();//new List<int>(); var randon = new Random(DateTime.Now.Millisecond); for (var i = 0; i < 10; i++) { response.Values.Add(randon.Next(0, 100)); }
namespaceDemo.Client { classProgram { staticvoidMain(string[] args) { Console.WriteLine("Demo Client is Ready..."); var host = "127.0.0.1"; var port = "9999";
var channel = new Channel($"{host}:{port}", ChannelCredentials.Insecure); var serviceClient = new DemoService.DemoServiceClient(channel);
var result1 = serviceClient.TestWithEmpty(new EmptyMsg()); Console.WriteLine($"Calling Say and return response is {result1.Values.ToString()}"); Console.WriteLine("Please type input for calling Say:"); var msg = Console.ReadLine(); var result2 = serviceClient.Say(new GreetingMsg { Value = msg}); Console.WriteLine($"Calling Say and return response is {result2.MsgValue},{result2.ReturnValue}"); } } }
完成後並且運行起來後看到的結果如下：
如此一來gRPC的開發就完成串接呼叫了！
由於功能與效能的強大，讓 gRPC 也正式被承諾會被整合進入 ASP.NET Core 中並在 .NET Core 3 發行．
local targetKey = KEYS[1] -- target key for redis local initValue = tonumber(ARGV[1]) -- initial value for target key if not exist and need to create local incrementValue = tonumber(ARGV[2]) -- increment value for target key when exist and calling for each time
local currentValue = initValue
-- create key with 0 if key is not exist local isNewKey = redis.call('SETNX',targetKey,currentValue)
-- add current value if key is exist if isNewKey == initValue then
using System; using System.Collections.Generic; using System.Threading; using System.Threading.Tasks; using System.Xml; using StackExchange.Redis;
namespaceConsoleApp1 { classProgram { staticvoidMain(string[] args) { var redisHost = "localhost:32768"; Console.WriteLine("App Start..."); using (var conn = ConnectionMultiplexer.Connect(redisHost)) { var db = conn.GetDatabase(); Console.WriteLine($"Current Value:{db.StringGet("test").ToString()}"); var loadedLuaScripts = new Dictionary<LuaScriptEnum, LoadedLuaScript>(); loadedLuaScripts.Add(LuaScriptEnum.AddValueWithTargetKey, PrepareLuaScript(conn, redisHost, @"local targetKey = KEYS[1] -- target key for redis local initValue = tonumber(ARGV[1]) -- initial value for target key if not exist and need to create local incrementValue = tonumber(ARGV[2]) -- increment value for target key when exist and calling for each time local currentValue = initValue -- create key with 0 if key is not exist local isNewKey = redis.call('SETNX',targetKey,currentValue) -- add current value if key is exist if isNewKey == initValue then currentValue = redis.call('GET',targetKey) if currentValue then currentValue = currentValue + incrementValue end redis.call('SET',targetKey, currentValue) end -- return key value return currentValue"));
var executedReturn = db.ScriptEvaluate(loadedLuaScripts[LuaScriptEnum.AddValueWithTargetKey].Hash, new RedisKey[] {"test"}, new RedisValue[] {0, 50}); Console.WriteLine(executedReturn); } } privatestatic LoadedLuaScript PrepareLuaScript(ConnectionMultiplexer redis, string defaultServer, string luaScriptContent) { return LuaScript .Prepare(luaScriptContent) .Load(redis.GetServer(defaultServer)); } }
using (var connection = new MySqlConnection(...)) { connection.Open(); using (var transaction = connection.BeginTransaction()) using (var command = connection.CreateCommand()) { command.CommandText = "SELECT ...";
// *** ADD THIS LINE *** command.Transaction = transaction;
// otherwise, this will throw System.InvalidOperationException: The transaction associated with this command is not the connection's active transaction. command.ExecuteScalar(); } }
這邊需要注意如果是 ExecuteReaderAsync() 將 DataReader 資料讀出，一定要記得 dispose 或是透過範例的方式正確的透過 using 的預設呼叫 dispose 來避免程式運行時發生 System.InvalidOperationException : This MySqlConnection is already in use 這類的問題！
publicasync Task<UserEntity> GetUserById(int id) { using (var conn = new MySqlConnection(_connStrinng)) { await conn.OpenAsync(); using (var cmd = new MySqlCommand()) { cmd.Connection = conn; cmd.CommandText = "SELECT Id, Name, BalanceAmount, DateCreated, DateUpdated FROM User WHERE Id = @Id"; cmd.Parameters.AddWithValue("Id", id);
publicasync Task CreateUser(UserDto inputObj) { using (var conn = new MySqlConnection(_connStrinng)) { await conn.OpenAsync(); // Insert some data using (var cmd = new MySqlCommand()) { cmd.Connection = conn; cmd.CommandText = "INSERT INTO User (Name) VALUES (@Name)"; cmd.Parameters.AddWithValue("Name", inputObj.Name); await cmd.ExecuteNonQueryAsync(); } } }
publicasync Task UpdateUser(UserDto inputObj) { using (var conn = new MySqlConnection(_connStrinng)) { await conn.OpenAsync(); // Insert some data using (var cmd = new MySqlCommand()) { cmd.Connection = conn; cmd.CommandText = "UPDATE User SET Name = @Name, BalanceAmount = @BalanceAmount, DateUpdated = NOW() WHERE Id = @Id"; cmd.Parameters.AddWithValue("Name", inputObj.Name); cmd.Parameters.AddWithValue("BalanceAmount", inputObj.BalanceAmount); cmd.Parameters.AddWithValue("Id", inputObj.Id); await cmd.ExecuteNonQueryAsync(); } } } publicasync Task DeleteUser(int id) { using (var conn = new MySqlConnection(_connStrinng)) { await conn.OpenAsync(); // Insert some data using (var cmd = new MySqlCommand()) { cmd.Connection = conn; cmd.CommandText = "DELETE FROM User WHERE Id = @Id"; cmd.Parameters.AddWithValue("Id", id); await cmd.ExecuteNonQueryAsync(); } } }
這邊參考了官方的建議使用在每一個操作後就透過 conn 外面包裹的 using 架構，直接 Dispose 時關閉 DB 連線，避免有漏關的狀況發生。
]]>
<p>分享如何解決在 macOS 安裝其他軟體或工具遇到 missing xcrun 的問題</p>
Short-cut for C# Implement Methods of an Interface or Abstract Classhttps://blackie1019.github.io/2018/09/16/Short-cut-for-C-Sharp-Implement-Methods-of-an-Interface-or-Abstract-Class/2018-09-16T02:20:41.000Z2021-06-15T03:56:53.505Z記錄如何在開發工具使用快捷鍵實作繼承抽象類別與方法
]]>
<p>分享 git ignore CLI 工具與 Rider 的 .gitignore 擴充套件(plugin)</p>
[Git] Switch from HEAD to master branch cause to disappear of part of the projecthttps://blackie1019.github.io/2018/08/31/Git-Switch-from-Head-branch-to-Master-branch-cause-to-disappear-of-part-of-the-project/2018-08-31T10:31:28.000Z2021-06-15T03:56:53.233Z記錄如何解決 Git 從 HEAD 切換到 master 分支部分交付不見/不見的問題
前陣子再一個經常操作的專案上做了 git commit 後，從當前的 HEAD 切換到 master 分支，部分交付的 commits 在 HEAD 操作的就全部遺失了，在 git cli 或 sourcetree 上都無法透過指令顯示不見的 HEAD 分支．