// GET api/values
//public IEnumerable<master_record> Get()
public async System.Threading.Tasks.Task <mmria.common.model.couchdb.case_view_response> Get
(
int skip = 0,
int take = 25,
string sort = "by_date_created",
string search_key = null,
bool descending = false
)
{
/*
*
* http://localhost:5984/de_id/_design/sortable/_view/conflicts
*
* by_date_created
* by_date_last_updated
* by_last_name
* by_first_name
* by_middle_name
* by_year_of_death
* by_month_of_death
* by_committe_review_date
* by_created_by
* by_last_updated_by
* by_state_of_death
*
*
*/
string sort_view = sort != null?sort.ToLower() : "by_date_created";
switch (sort_view)
{
case "by_date_created":
case "by_date_last_updated":
case "by_last_name":
case "by_first_name":
case "by_middle_name":
case "by_year_of_death":
case "by_month_of_death":
case "by_committe_review_date":
case "by_created_by":
case "by_last_updated_by":
case "by_state_of_death":
break;
default:
sort_view = "by_date_created";
break;
}
try
{
System.Text.StringBuilder request_builder = new System.Text.StringBuilder();
request_builder.Append(Program.config_couchdb_url);
request_builder.Append($"/de_id/_design/sortable/_view/{sort_view}?");
if (string.IsNullOrWhiteSpace(search_key))
{
if (skip > -1)
{
request_builder.Append($"skip={skip}");
}
else
{
request_builder.Append("skip=0");
}
if (take > -1)
{
request_builder.Append($"&limit={take}");
}
if (descending)
{
request_builder.Append("&descending=true");
}
}
else
{
request_builder.Append("skip=0");
if (descending)
{
request_builder.Append("&descending=true");
}
}
string request_string = request_builder.ToString();
System.Net.WebRequest request = System.Net.WebRequest.Create(new Uri(request_string));
request.PreAuthenticate = false;
if (this.Request.Headers.Contains("Cookie") && this.Request.Headers.GetValues("Cookie").Count() > 0)
{
string[] cookie_set = this.Request.Headers.GetValues("Cookie").First().Split(';');
for (int i = 0; i < cookie_set.Length; i++)
{
string[] auth_session_token = cookie_set[i].Split('=');
if (auth_session_token[0].Trim() == "AuthSession")
{
request.Headers.Add("Cookie", "AuthSession=" + auth_session_token[1]);
request.Headers.Add("X-CouchDB-WWW-Authenticate", auth_session_token[1]);
break;
}
}
}
System.Net.WebResponse response = await request.GetResponseAsync();
System.IO.Stream dataStream = response.GetResponseStream();
System.IO.StreamReader reader = new System.IO.StreamReader(dataStream);
string responseFromServer = reader.ReadToEnd();
mmria.common.model.couchdb.case_view_response case_view_response = Newtonsoft.Json.JsonConvert.DeserializeObject <mmria.common.model.couchdb.case_view_response>(responseFromServer);
if (string.IsNullOrWhiteSpace(search_key))
{
return(case_view_response);
}
else
{
string key_compare = search_key.ToLower().Trim(new char [] { '"' });
mmria.common.model.couchdb.case_view_response result = new mmria.common.model.couchdb.case_view_response();
result.offset = case_view_response.offset;
result.total_rows = case_view_response.total_rows;
foreach (mmria.common.model.couchdb.case_view_item cvi in case_view_response.rows)
{
bool add_item = false;
if (cvi.value.first_name != null && cvi.value.first_name.IndexOf(key_compare, StringComparison.OrdinalIgnoreCase) > -1)
{
add_item = true;
}
if (cvi.value.middle_name != null && cvi.value.middle_name.IndexOf(key_compare, StringComparison.OrdinalIgnoreCase) > -1)
{
add_item = true;
}
if (cvi.value.last_name != null && cvi.value.last_name.IndexOf(key_compare, StringComparison.OrdinalIgnoreCase) > -1)
{
add_item = true;
}
if (cvi.value.record_id != null && cvi.value.record_id.IndexOf(key_compare, StringComparison.OrdinalIgnoreCase) > -1)
{
add_item = true;
}
if (cvi.value.agency_case_id != null && cvi.value.agency_case_id.IndexOf(key_compare, StringComparison.OrdinalIgnoreCase) > -1)
{
add_item = true;
}
if (cvi.value.created_by != null && cvi.value.created_by.IndexOf(key_compare, StringComparison.OrdinalIgnoreCase) > -1)
{
add_item = true;
}
if (cvi.value.last_updated_by != null && cvi.value.last_updated_by.IndexOf(key_compare, StringComparison.OrdinalIgnoreCase) > -1)
{
add_item = true;
}
if (cvi.value.date_of_death_month != null && cvi.value.date_of_death_month.HasValue && cvi.value.date_of_death_month.Value.ToString().IndexOf(key_compare, StringComparison.OrdinalIgnoreCase) > -1)
{
add_item = true;
}
if (cvi.value.date_of_death_year != null && cvi.value.date_of_death_year.HasValue && cvi.value.date_of_death_year.Value.ToString().IndexOf(key_compare, StringComparison.OrdinalIgnoreCase) > -1)
{
add_item = true;
}
if (cvi.value.date_of_committee_review != null && cvi.value.date_of_committee_review.HasValue && cvi.value.date_of_committee_review.Value.ToString().IndexOf(key_compare, StringComparison.OrdinalIgnoreCase) > -1)
{
add_item = true;
}
if (add_item)
{
result.rows.Add(cvi);
}
}
result.total_rows = result.rows.Count;
result.rows = result.rows.Skip(skip).Take(take).ToList();
return(result);
}
/*
* < HTTP/1.1 200 OK
* < Set-Cookie: AuthSession=YW5uYTo0QUIzOTdFQjrC4ipN-D-53hw1sJepVzcVxnriEw;
* < Version=1; Path=/; HttpOnly
* > ...
* <
* {"ok":true}*/
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(null);
}
public async Task Execute(string[] args)
{
if (args.Length > 1)
{
for (var i = 1; i < args.Length; i++)
{
string arg = args[i];
int index = arg.IndexOf(':');
string val = arg.Substring(index + 1, arg.Length - (index + 1)).Trim(new char[] { '\"' });
if (arg.ToLower().StartsWith("auth_token"))
{
this.auth_token = val;
}
else if (arg.ToLower().StartsWith("user_name"))
{
this.user_name = val;
}
else if (arg.ToLower().StartsWith("password"))
{
this.password = val;
}
else if (arg.ToLower().StartsWith("source_file_path"))
{
this.source_file_path = val;
}
else if (arg.ToLower().StartsWith("url"))
{
this.mmria_url = val;
}
}
}
if (string.IsNullOrWhiteSpace(this.source_file_path))
{
System.Console.WriteLine("missing source_file_path");
System.Console.WriteLine(" form source_file_path:[file path]");
System.Console.WriteLine(" example 1 source_file_path:c:/temp/");
System.Console.WriteLine(" example 2 source_file_path:\"c:/temp folder/\"");
System.Console.WriteLine(" example 3 source_file_path:mapping-file-set\\\"");
System.Console.WriteLine(" mmria-console.exe export user_name:user1 password:secret url:http://localhost:12345 source_file_path:\"c:\\temp folder\\\"");
return;
}
if (string.IsNullOrWhiteSpace(this.mmria_url))
{
System.Console.WriteLine("missing url");
System.Console.WriteLine(" form url:[website_url]");
System.Console.WriteLine(" example url:http://localhost:12345");
return;
}
if (string.IsNullOrWhiteSpace(this.user_name))
{
System.Console.WriteLine("missing user_name");
System.Console.WriteLine(" form user_name:[user_name]");
System.Console.WriteLine(" example user_name:user1");
return;
}
if (string.IsNullOrWhiteSpace(this.password))
{
System.Console.WriteLine("missing password");
System.Console.WriteLine(" form password:[password]");
System.Console.WriteLine(" example password:secret");
return;
}
if (!Directory.Exists(this.source_file_path))
{
System.Console.WriteLine($"source_file_path does NOT exist: {this.source_file_path}");
return;
}
string login_url = this.mmria_url + "/api/session/";
var login_data = new { userid = this.user_name, password = this.password };
var login_curl = new cURL("POST", null, login_url, Newtonsoft.Json.JsonConvert.SerializeObject(login_data));
string login_result_string = null;
try
{
login_result_string = await login_curl.executeAsync();
}
catch (Exception ex)
{
System.Console.WriteLine(ex);
}
var login_result_data = Newtonsoft.Json.JsonConvert.DeserializeObject <IList <System.Dynamic.ExpandoObject> >(login_result_string);
IDictionary <string, object> login_result_dictionary = login_result_data[0] as IDictionary <string, object>;
string auth_session = null;
//{"ok":true,"userCtx":{"name":null,"roles":[]},"info":{"authentication_db":"_users","authentication_handlers":["oauth","cookie","default"]}}
if (!login_result_dictionary.ContainsKey("ok") && login_result_dictionary["ok"].ToString().ToLower() != "true")
{
System.Console.WriteLine($"Unable to login to {this.mmria_url}:\n{login_result_dictionary}");
return;
}
auth_session = login_result_dictionary ["auth_session"].ToString();
/*var case_view_url = location.protocol + '//' + location.host + '/api/case_view' + g_ui.case_view_request.get_query_string();
* get_query_string : function(){
* var result = [];
* result.push("?skip=" + (this.page - 1) * this.take);
* result.push("take=" + this.take);
* result.push("sort=" + this.sort);
*/
string document_url = this.mmria_url + $"/api/case_view?take={int.MaxValue}";
var document_curl = new cURL("GET", null, document_url, null, null, null);
document_curl.AddCookie("AuthSession", auth_session);
string document_json = null;
document_json = document_curl.execute();
//System.IO.File.WriteAllText(this.source_file_path + "test.json",document_json);
mmria.common.model.couchdb.case_view_response case_view_response = Newtonsoft.Json.JsonConvert.DeserializeObject <mmria.common.model.couchdb.case_view_response>(document_json);
foreach (mmria.common.model.couchdb.case_view_item cvi in case_view_response.rows)
{
try
{
var get_case_curl = new cURL("GET", null, this.mmria_url + $"/api/case?case_id={cvi.id}", null, null, null);
get_case_curl.AddCookie("AuthSession", auth_session);
//get_case_curl.AddCookie("AuthSession", auth_session);
document_json = get_case_curl.execute();
System.IO.File.WriteAllText(this.source_file_path + $"/{cvi.id}.json", document_json);
}
catch (Exception ex)
{
System.Console.Write(ex);
}
}
/*
* foreach (var file_name in System.IO.Directory.GetFiles(this.source_file_path))
* {
*
*
* string global_record_id = null;
*
* string case_json_string = System.IO.File.ReadAllText(file_name);
*
* var case_data = Newtonsoft.Json.JsonConvert.DeserializeObject<System.Dynamic.ExpandoObject>(case_json_string);
* IDictionary<string, object> case_data_dictionary = case_data as IDictionary<string, object>;
*
* if (case_data_dictionary.ContainsKey ("_id"))
* {
* global_record_id = case_data_dictionary ["_id"].ToString();
* }
*
*
* try
* {
* // check if doc exists
* string document_url = this.mmria_url + "/api/case?case_id=" + global_record_id;
* var document_curl = new cURL("GET", null, document_url, null, null, null);
* document_curl.AddCookie("AuthSession", auth_session);
* string document_json = null;
*
* document_json = document_curl.execute();
* var result_expando = Newtonsoft.Json.JsonConvert.DeserializeObject<System.Dynamic.ExpandoObject>(document_json);
* var result = result_expando as IDictionary<string, object>;
* if (result != null && result.ContainsKey ("_rev"))
* {
* case_data_dictionary ["_rev"] = result ["_rev"];
*
*
* case_json_string = Newtonsoft.Json.JsonConvert.SerializeObject (case_data, new Newtonsoft.Json.JsonSerializerSettings () {
* Formatting = Newtonsoft.Json.Formatting.Indented,
* DateFormatHandling = Newtonsoft.Json.DateFormatHandling.IsoDateFormat,
* DateTimeZoneHandling = Newtonsoft.Json.DateTimeZoneHandling.Utc
* });
* //System.Console.WriteLine ("json\n{0}", case_json_string);
* }
*
* var update_curl = new cURL ("POST", null, this.mmria_url + "/api/case", case_json_string, null, null);
* update_curl.AddCookie("AuthSession", auth_session);
* try
* {
* string update_result_string = update_curl.execute ();
*
* /*
* var update_result_expando = Newtonsoft.Json.JsonConvert.DeserializeObject<System.Dynamic.ExpandoObject>(update_result_string);
* var update_result = result_expando as IDictionary<string, object>;
* if (update_result != null && update_result.ContainsKey ("_rev"))
* {
*
* case_data_dictionary ["_rev"] = result ["_rev"];
*
*
* case_json_string = Newtonsoft.Json.JsonConvert.SerializeObject (case_data, new Newtonsoft.Json.JsonSerializerSettings () {
* Formatting = Newtonsoft.Json.Formatting.Indented,
* DateFormatHandling = Newtonsoft.Json.DateFormatHandling.IsoDateFormat,
* DateTimeZoneHandling = Newtonsoft.Json.DateTimeZoneHandling.Utc
* });
* System.Console.WriteLine ("json\n{0}", case_json_string);
*
* }
* /
* System.Console.WriteLine ($"Succesfully imported id {global_record_id}");
* //System.Console.WriteLine (update_result_string);
*
* }
* catch (Exception ex)
* {
* System.Console.WriteLine ($"Id {global_record_id}");
* System.Console.WriteLine (ex);
* }
*
* }
* catch (Exception ex)
* {
* System.Console.WriteLine("Get case");
* System.Console.WriteLine(ex);
* System.Console.WriteLine("json\n{0}", case_json_string);
*
* }
* }
*/
Console.WriteLine("Export Finished");
}
