public static int UpdateRepoStatus(SqlConnection connection, ProcessRepositoryRequest repo, int parseStatus)
{
var command = new SqlCommand($"UPDATE RepoStats.{TABLE_REPOS} SET {COLUMN_PARSE_STATUS} = @0 WHERE {COLUMN_REPO_ID} = @1", connection);
command.Parameters.AddWithValue("@0", parseStatus);
command.Parameters.AddWithValue("@1", repo.Id);
return command.ExecuteNonQuery();
}
public static int InsertContributor(SqlConnection connection, ProcessRepositoryRequest repo, RepositoryContributor contributor)
{
var command = new SqlCommand($"INSERT INTO RepoStats.{TABLE_CONTRIBUTORS} ({COLUMN_REPO_ID}, {COLUMN_USERNAME}, {COLUMN_CONTRIBUTIONS}) VALUES (@0, @1, @2)", connection);
command.Parameters.AddWithValue("@0", repo.Id);
command.Parameters.AddWithValue("@1", contributor.Login);
command.Parameters.AddWithValue("@2", contributor.Contributions);
return command.ExecuteNonQuery();
}
public static int InsertLanguage(SqlConnection connection, ProcessRepositoryRequest repo, RepositoryLanguage language)
{
var command = new SqlCommand($"INSERT INTO RepoStats.{TABLE_LANGUAGES} ({COLUMN_REPO_ID}, {COLUMN_LANGUAGE}, {COLUMN_BYTES}) VALUES (@0, @1, @2)", connection);
command.Parameters.AddWithValue("@0", repo.Id);
command.Parameters.AddWithValue("@1", language.Name);
command.Parameters.AddWithValue("@2", language.NumberOfBytes);
return command.ExecuteNonQuery();
}
