// リスト 9 private static void CallCreateDocument() { var assignMembers = new List <AssignMember>(); assignMembers.Add(new AssignMember() { UserId = "tanaka", UserName = "******" }); assignMembers.Add(new AssignMember() { UserId = "sakamoto", UserName = "******" }); RoomReservationInfo item = new RoomReservationInfo() { Id = "00001", Room = "第1会議室", Title = "Cosmos DB移行についての打ち合わせ", ReservedUserId = "daigo", ReservedUserName = "******", Start = new DateTime(2017, 5, 30, 10, 0, 0), End = new DateTime(2017, 5, 30, 11, 0, 0), AssignMembers = assignMembers }; // ドキュメント作成メソッド呼び出し var manager = new DocumentDbManager(); manager.CreateDocument(item).Wait(); }
static void Main(string[] args) { Console.WriteLine("DocumentDbManagerクラスのEndpointUrlとPrimaryKeyをあなたの環境の値に設定の上で実行してください。"); Console.WriteLine("また、2,500 RUのコレクションを作成します。コレクションを作成すると、RUに比例したCosmos DB利用料金が課金されますのでご注意ください。"); Console.WriteLine("処理を続行して、よろしいですか?(y/n)"); if (Console.ReadLine().ToUpper() != "Y") { Console.WriteLine("処理を中断しました。"); return; } // データベースとコレクションを作成します。 var manager = new DocumentDbManager(); manager.CreateDatabase().Wait(); manager.CreateCollection().Wait(); // 利用する機能をコメントアウトしてください。 //CallCreateDocument(); //CallSaveDocument(); //CallFindByRoom(); //CallFindByRoom2(); //CallCountByRoom(); //CallFindByAssignMember(); //CallFindById(); //CallFindByIdWithParam(); //CallDeleteById(); //CallUpdateDocument(); //CallHelloStoredProcedure(); //CallBulkReserveStoredProcedure(); //UsePreTrigger(); //UsePostTrigger(); UseUdf(); }
private static void UsePreTrigger() { var manager = new DocumentDbManager(); var createResult = manager.CreatePreTrigger(@"..\..\\validatePreTrriger.js").Result; var assignMembers = new List <AssignMember>(); assignMembers.Add(new AssignMember() { UserId = "tanaka", UserName = "******" }); RoomReservationInfo item = new RoomReservationInfo() { Id = "Pre0000000001", Room = "第1会議室", Title = "プリトリガーについて打ち合わせ", ReservedUserId = "daigo", ReservedUserName = "******", Start = new DateTime(2017, 6, 30, 18, 09, 0), End = new DateTime(2017, 6, 30, 19, 0, 0), AssignMembers = assignMembers }; var callResult = manager.CreateDocumentWithPreTrigger(item).Result; Console.WriteLine(callResult); }
private static void UsePostTrigger() { var manager = new DocumentDbManager(); var createResult = manager.CreatePostTrigger(@"..\..\\postTriggerExample.js").Result; var assignMembers = new List <AssignMember>(); assignMembers.Add(new AssignMember() { UserId = "tanaka", UserName = "******" }); assignMembers.Add(new AssignMember() { UserId = "sakamoto", UserName = "******" }); RoomReservationInfo item = new RoomReservationInfo() { Id = "A00004", Room = "第1会議室", Title = "Cosmos DB移行についての打ち合わせ", ReservedUserId = "daigo", ReservedUserName = "******", Start = new DateTime(2017, 6, 3, 18, 09, 0), End = new DateTime(2017, 6, 3, 10, 0, 0), AssignMembers = assignMembers }; var callResult = manager.CreateDocumentWithPostTrigger(item).Result; Console.WriteLine(callResult); }
private static void CallUpdateDocument() { var manager = new DocumentDbManager(); var reservation = manager.FindById("第1会議室", "0000000001"); reservation.Title = "変更!" + DateTime.Now.ToString("yyyyMMddHms"); var doc = manager.ReplaceDocument(reservation).Result; }
private static void CallHelloStoredProcedure() { var manager = new DocumentDbManager(); var createResult = manager.CreateStoredProcedure(@"..\..\\helloStoredProcedure.js").Result; var callResult = manager.CallHelloStoredProcedure("Ryuichi Daigo").Result; Console.WriteLine(callResult); }
private static void CallBulkReserveStoredProcedure() { var manager = new DocumentDbManager(); var createResult = manager.CreateStoredProcedure(@"..\..\\bulkDeleteStoredProcedure.js").Result; var callResult = manager.CallBulkDeleteStoredProcedure(new DateTime(2017, 6, 4, 0, 0, 0), new DateTime(2017, 6, 7, 23, 59, 59), "第1会議室").Result; Console.WriteLine(callResult); }
// リスト 19 private static void CallFindByRoom2() { var manager = new DocumentDbManager(); List <RoomReservationInfo> roomReservationInfos = manager.FindByRoom2("第1会議室"); Console.WriteLine(string.Format("{0}件", roomReservationInfos.Count)); foreach (var info in roomReservationInfos) { Console.WriteLine( string.Format("{0} / {1} / {2} ~ {3}", info.Room, info.Title, info.Start, info.End)); } }
private static void UseUdf() { var manager = new DocumentDbManager(); var createResult = manager.CreateUdf(@"..\..\\calcTimeUdf.js").Result; var roomReservationInfos = manager.FindUsingUdf("第1会議室", 90); Console.WriteLine(string.Format("{0}件", roomReservationInfos.Count)); foreach (var info in roomReservationInfos) { Console.WriteLine( string.Format("{0} / {1} / {2} ~ {3}", info.Room, info.Title, info.Start, info.End)); } }
// リスト 22 private static void CallFindByAssignMember() { var manager = new DocumentDbManager(); List <RoomReservationInfo> roomReservationInfos = manager.FindByAssignMember( "第1会議室", new AssignMember() { UserId = "daigo", UserName = "******" }); Console.WriteLine(string.Format("{0}件", roomReservationInfos.Count)); foreach (var info in roomReservationInfos) { Console.WriteLine( string.Format("{0} / {1} / {2} ~ {3}", info.Room, info.Title, info.Start, info.End)); } }
private static void CallDeleteById() { var manager = new DocumentDbManager(); manager.DeleteById("スタンディングテーブル", "0000000004").Wait(); }
private static void CallFindByIdWithParam() { var manager = new DocumentDbManager(); RoomReservationInfo info = manager.FindByIdWithParam("スタンディングテーブル", "0000000004"); }
private static void CallCountByRoom() { var manager = new DocumentDbManager(); int count = manager.CountByRoom("第1会議室"); }