public void ClearExpiredClaimsAync()
{
List <Claim> claims = _database.GetAllExpiredClaims();
if (claims.Count == 0)
{
return;
}
_logger.LogError($"Clearing all these expired claims:\n{ObjectLogger.Dump(claims)}");
_database.ClearAllExpiredClaims();
}
public async Task CreateRefreshTokenAsync(TokenExtended token)
{
_logger.LogDebug($"Creating token for TokenExtended Object: {ObjectLogger.Dump(token)}");
_logger.LogInformation($"Creating token for refresh token: {token.RefreshToken}");
using (var connection = _context.CreateConnection())
{
var parameters = new { value = token.RefreshToken, created_at = token.CreatedAt, id_users = token.UserId };
string processQuery = "INSERT INTO token (value,created_at,id_users) VALUES (@value,@created_at,@id_users)";
await connection.ExecuteAsync(processQuery, parameters);
}
}
public async Task InsertPeopleInEpisodeAsync(List <PeopleInEpisode> people, int episodeId)
{
_logger.LogInformation($"Inserting people into episode with id: {episodeId}");
_logger.LogDebug($"Inserting people: {ObjectLogger.Dump(people)}");
foreach (PeopleInEpisode person in people)
{
using (var connection = _context.CreateConnection())
{
var parameters = new { created_at = DateTime.Now, id_person = person.PersonId, id_episodes = episodeId };
string processQuery = "INSERT INTO episode_person (created_at,id_person,id_episodes) VALUES (@created_at,@id_person,@id_episodes);";
await connection.ExecuteAsync(processQuery, parameters);
}
}
}
public void AddEpisodes(List <Episode> episodes)
{
using (var connection = _context.CreateConnection())
{
foreach (Episode item in episodes)
{
_logger.LogDebug($"Adding new episode: {ObjectLogger.Dump(item)}");
_logger.LogInformation($"Adding new episode with EpisodeNumber: {item.EpisodeNumber}");
var parameters = new { uuid = item.UUID, title = item.Title, episode_number = item.EpisodeNumber, subtitle = item.Subtitle, description = item.Description, media_file = item.MediaFile, spotify_file = item.SpotifyFile, duration = item.Duration, type = item.Type, image = item.Image, explicitItem = item.Explicit, published_at = item.PublishedAt, created_at = item.CreatedAt, updated_at = item.UpdatedAt, verified = item.Verified };
string processQuery = "INSERT INTO episodes (uuid,title,episode_number,subtitle,description,media_file,spotify_file,duration,type,image,explicit,published_at,created_at,updated_at,verified) VALUES (@uuid,@title,@episode_number,@subtitle,@description,@media_file,@spotify_file,@duration,@type,@image,@explicitItem,@published_at,@created_at,@updated_at,@verified)";
connection.Execute(processQuery, parameters);
}
}
}
public async Task InsertTopicAsync(ProcessedTopicPostRequest topic, int episodeId, int userId)
{
_logger.LogDebug($"Topic contributed by user with id: {userId} in episode with id: {episodeId} to insert: {ObjectLogger.Dump(topic)}");
_logger.LogInformation($"Inserting list of topics.");
var parameters = new
{
name = topic.Name,
timestamp_start = topic.TimestampStart,
timestamp_end = topic.TimestampEnd,
duration = topic.Duration,
community_contributed = topic.CommunityContributed,
ad = topic.Ad,
created_at = DateTime.Now,
epId = episodeId,
uId = userId
};
using (var connection = _context.CreateConnection())
{
string processQuery = "INSERT INTO topic (name,timestamp_start,timestamp_end,duration,community_contributed,ad,created_at,id_episodes,id_user) " +
"VALUES (@name,@timestamp_start,@timestamp_end,@duration,@community_contributed,@ad,@created_at,@epId,@uId); SELECT * FROM LASTVAL();";
int topicId = await connection.ExecuteScalarAsync <int>(processQuery, parameters);
for (int i = 0; i < topic.Subtopics.Count; i++)
{
await InsertSubtopicAsync(topic.Subtopics[i], topicId, userId);
}
}
}
