-
Notifications
You must be signed in to change notification settings - Fork 0
/
PushWebHookFunction.cs
69 lines (62 loc) · 2.44 KB
/
PushWebHookFunction.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
using System;
using System.IO;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Azure.WebJobs;
using Microsoft.Azure.WebJobs.Extensions.Http;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
using System.IO.Enumeration;
using System.Collections.Generic;
using System.Data.SqlClient;
namespace PushWebHook
{
public static class PushWebHookFunction
{
[FunctionName("PushWebHookFunction")]
public static async Task<IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequest req,
ILogger log)
{
string t = "";
try
{
string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
dynamic data = JsonConvert.DeserializeObject(requestBody);
string repoURL = data.repository.html_url + "/master"; //Assume we only consider master branch pushes
List<string> imageFileURLs = new List<string>();
dynamic commits = data?.commits;
foreach (dynamic comm in commits)
{
foreach (string file in comm.added)
if (file.Trim().EndsWith(".png")) imageFileURLs.Add(string.Format("{0}/{1}", repoURL, file));
}
t += "a";
using (SqlConnection sqlConn = new System.Data.SqlClient.SqlConnection(Environment.GetEnvironmentVariable("DatabaseConnection")))
{
sqlConn.Open();
t += "b";
foreach (string imgURL in imageFileURLs)
{
t += "c";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = string.Format("INSERT Images (FileUrl) VALUES ('{0}')", imgURL);
cmd.Connection = sqlConn;
t += "d";
cmd.ExecuteNonQuery();
t += "e";
}
sqlConn.Close();
t += "f";
}
}
catch(Exception ex)
{
t += ", " + ex.Message;
}
return new OkObjectResult(t);
}
}
}