summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--ApiController.cs25
1 files changed, 13 insertions, 12 deletions
diff --git a/ApiController.cs b/ApiController.cs
index 47a15d9..d373702 100644
--- a/ApiController.cs
+++ b/ApiController.cs
@@ -32,9 +32,16 @@ public class ApiController : Controller
return StatusCode((int)HttpStatusCode.NotFound, String.Empty);
}
+ string ip_address = String.Format
+ ("IP Address: {0}",
+ Request?.HttpContext?.Connection?.RemoteIpAddress?.ToString() ?? "unknown");
+
+ string user_agent = String.Format
+ ("User Agent: {0}",
+ Request?.Headers?.UserAgent.ToString() ?? "unknown");
+
RecordDownload(key,
- Request?.HttpContext?.Connection?.RemoteIpAddress?.ToString() ?? "IP address unknown",
- Request?.Headers?.UserAgent.ToString() ?? "User agent unknown",
+ new string[] {ip_address, user_agent},
DateTime.UtcNow);
return File(file.Data, file.MimeType, file.FileName);
@@ -67,7 +74,7 @@ public class ApiController : Controller
return ret;
}
- private void RecordDownload(string key, string ip_address, string user_agent, DateTime time)
+ private void RecordDownload(string key, string[] info, DateTime time)
{
try
{
@@ -75,17 +82,11 @@ public class ApiController : Controller
conn.Open();
- using var cmd = new NpgsqlCommand("INSERT INTO file_object (key, ip_address, user_agent, time) VALUES (@key, @ip_address, @user_agent, @time)", conn);
-
- if (user_agent.Length > 256)
- {
- user_agent = user_agent.Substring(0,256);
- }
+ using var cmd = new NpgsqlCommand("INSERT INTO download (key, info, time) VALUES (@key, @info, @time)", conn);
cmd.Parameters.AddWithValue("key", NpgsqlTypes.NpgsqlDbType.Varchar, key);
- cmd.Parameters.AddWithValue("ip_address", NpgsqlTypes.NpgsqlDbType.Varchar, ip_address);
- cmd.Parameters.AddWithValue("user_agent", NpgsqlTypes.NpgsqlDbType.Varchar, user_agent);
- cmd.Parameters.AddWithValue("time", NpgsqlTypes.NpgsqlDbType.Timestamp, time);
+ cmd.Parameters.AddWithValue("info", NpgsqlTypes.NpgsqlDbType.Array|NpgsqlTypes.NpgsqlDbType.Text, info);
+ cmd.Parameters.AddWithValue("time", NpgsqlTypes.NpgsqlDbType.TimestampTz, time);
cmd.ExecuteNonQuery();
}