// リスト 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 = "第１会議室",
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 = "第１会議室",
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 = "第１会議室",
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("第１会議室", "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), "第１会議室").Result;
Console.WriteLine(callResult);
}
// リスト 19
private static void CallFindByRoom2()
{
var manager = new DocumentDbManager();
List <RoomReservationInfo> roomReservationInfos = manager.FindByRoom2("第１会議室");
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("第１会議室", 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(
"第１会議室",
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("第１会議室");
}
