public static Task PackByAsync <TValue>(this Stream?stream, TValue?value, Options?options = null,
Encoding?encoding = null) =>
JilHelper.PackAsync(value, stream, options, encoding);
public static MemoryStream ToStream(this object?value, Options?options = null, Encoding?encoding = null) => JilHelper.ToStream(value, options, encoding);
// CoinBaseSharp.ExchangeRates.Test();
public static void Test()
{
// https://docs.google.com/document/d/13rwJuIzL22bUILemGlZ6zf64Ej0CayPnKBcz1-zKjO0
string sql = @"
SELECT
-- api_uid
--,api_name
--,api_app_id
--,api_href,
REPLACE(api_href, '{@api_app_id}', api_app_id) AS api_url
--,api_comment
FROM t_api_configurations
";
//string url = SQL.ExecuteScalar<string>(sql);
//System.Console.WriteLine(url);
string fileName = MapProjectPath(@"~CoinBaseSharp\ExchangeRates\OpenExchangeRates_Data.txt");
//string fileName = MapProjectPath(@"~CoinBaseSharp\ExchangeRates\OpenExchangeRates_Error.txt");
System.Console.WriteLine(fileName);
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
sw.Start();
OpenExchangeRatesData oed = EasyJSON.JsonHelper.DeserializeFromFile <OpenExchangeRatesData>(fileName);
sw.Stop();
System.Console.WriteLine(sw.Elapsed);
System.Console.WriteLine(oed);
#if BENCHMARK || false
// OpenExchangeRatesData oed = JilHelper.DeserializeUrl<OpenExchangeRatesData>(url);
System.Diagnostics.Stopwatch swJil1 = new System.Diagnostics.Stopwatch();
swJil1.Start();
OpenExchangeRatesData oedJil = JilHelper.DeserializeFromFile <OpenExchangeRatesData>(fileName);
swJil1.Stop();
System.Console.WriteLine(swJil1.Elapsed);
System.Console.WriteLine(oedJil);
System.Diagnostics.Stopwatch swJil = new System.Diagnostics.Stopwatch();
swJil.Start();
OpenExchangeRatesData oedJil2 = JilHelper.DeserializeFromFile <OpenExchangeRatesData>(fileName);
swJil.Stop();
System.Console.WriteLine(swJil.Elapsed);
System.Console.WriteLine(oedJil2);
System.Diagnostics.Stopwatch sw2 = new System.Diagnostics.Stopwatch();
sw2.Start();
OpenExchangeRatesData oed2 = ServiceStackHelper.DeserializeFromFile <OpenExchangeRatesData>(fileName);
sw2.Stop();
System.Console.WriteLine(sw2.Elapsed);
System.Console.WriteLine(oed2);
System.Diagnostics.Stopwatch sw3 = new System.Diagnostics.Stopwatch();
sw3.Start();
OpenExchangeRatesData oed3 = EasyJSON.JsonHelper.DeserializeFromFile <OpenExchangeRatesData>(fileName);
sw3.Stop();
System.Console.WriteLine(sw3.Elapsed);
System.Console.WriteLine(oed3);
System.Diagnostics.Stopwatch sw4 = new System.Diagnostics.Stopwatch();
sw4.Start();
OpenExchangeRatesData oed4 = ServiceStackHelper.DeserializeFromFile <OpenExchangeRatesData>(fileName);
sw4.Stop();
System.Console.WriteLine(sw4.Elapsed);
System.Console.WriteLine(oed4);
#endif
if (oed.error)
{
System.Console.WriteLine("Error {0}: {1}", oed.status, oed.message);
System.Console.WriteLine(oed.description);
return;
} // End if (oed.error)
sql = @"
INSERT INTO t_map_currency_rate(cur_uid,cur_rate,cur_name,cur_time)
VALUES
(
@cur_uid -- uniqueidentifier
,@cur_rate -- decimal(35,15)
,@cur_name -- char(3)
,@cur_time -- datetime
);
";
System.DateTime localShapshotTime = oed.SnapshotTime.ToLocalTime();
System.Console.WriteLine(localShapshotTime);
foreach (System.Collections.Generic.KeyValuePair <string, decimal> kvp in oed.RatesList)
{
System.Console.WriteLine(kvp.Key);
System.Console.WriteLine(kvp.Value);
/*
* using (System.Data.IDbCommand cmd = SQL.CreateCommand(sql))
* {
* SQL.AddParameter(cmd, "cur_uid", System.Guid.NewGuid());
* SQL.AddParameter(cmd, "cur_time", oed.SnapshotTime);
* SQL.AddParameter(cmd, "cur_name", kvp.Key);
* SQL.AddParameter(cmd, "cur_rate", kvp.Value);
*
* SQL.ExecuteNonQuery(cmd);
* } // End Using cmd
*/
} // Next kvp
} // End Sub Test
public static string GetExceptionText(ResultEnum result)
{
return(JilHelper.Serialize(new GlobalExceptionModel(ResultEnum.MissingBearerToken)));
}
public static string GetExceptionText(string exceptionMessage = null)
{
return(JilHelper.Serialize(new GlobalExceptionModel(ResultEnum.Exception, exceptionMessage)));
}
public static string ToJson(this object?value, Options?options = null) => JilHelper.ToJson(value, options);
public static string ToJson <TValue>(this TValue?value, Options?options = null) => JilHelper.ToJson(value, options);
public static Task <object?> FromStreamAsync(this Stream?stream, Type type, Options?options = null,
Encoding?encoding = null) =>
JilHelper.FromStreamAsync(type, stream, options, encoding);
public static Task <TValue?> FromStreamAsync <TValue>(this Stream?stream, Options?options = null,
Encoding?encoding = null) =>
JilHelper.FromStreamAsync <TValue>(stream, options, encoding);
public static void WriteJson(this TextWriter?textWriter, object?value, Options?options = null) => JilHelper.Serialize(value, textWriter, options);
