private async Task AddItem(Record pItem, ConcurrentDictionary <string, GeoZone> pDicToComplete, int pDataId) { GeoZone oGeoZone; CoVidData oCoviData; if (!pDicToComplete.ContainsKey(pItem.geoId)) { oGeoZone = new GeoZone(); oGeoZone.geoID = pItem.geoId; oGeoZone.code = pItem.countryterritoryCode; oGeoZone.dataList = new ConcurrentBag <CoVidData>(); oGeoZone.name = pItem.countriesAndTerritories; oGeoZone.population = pItem.popData2019; pDicToComplete.GetOrAdd(pItem.geoId, oGeoZone); } oCoviData = new CoVidData(); oCoviData.cases = pItem.cases; oCoviData.date = new CovidDate( ulong.Parse(pDataId.ToString()), pItem.dateRep, UtilsConstants.StringConstants.RIGHT_BAR, UtilsConstants.DateConstants.API_DATE_FORMAT); oCoviData.deaths = pItem.deaths; pDicToComplete[pItem.geoId].dataList.Add(oCoviData); }
private void SetCovidDataQuery(CoVidData pCovidData, GeoZone pGeoZone, Query oQuery) { StringBuilder oStringBuilder = new StringBuilder(); this.AddCovidDataInsertStatementToStringBuilder(oStringBuilder, pCovidData, pGeoZone, oQuery); oQuery.query = oQuery.query.Replace( UtilsConstants.QueryConstants.REPLACE_QUERY_CONSTANT, oStringBuilder.ToString()); }
public bool InsertCovidData(CoVidData pCovidData, GeoZone pGeoZone) { Query oQuery; this.SetQuery(_INSERT_DATES_QUERY_PATH, out oQuery); oQuery.query = oQuery.query.Replace(UtilsConstants.QueryConstants.COUNTRY_NAME, pGeoZone.name); this.SetCovidDataQuery(pCovidData, pGeoZone, oQuery); return(oConnectionPostgreSql.ExecuteCommand(oQuery.query)); }
public override bool InsertCovidData(CoVidData pCovidData, GeoZone pGeoZone) { ConnectionPostgreSql oConnection; this.SetConnection(out oConnection); _oPostgreSqlInsert = PostgreSqlInsert.GetInstance(oConnection); _oPostgreSqlInsert.InsertCovidData(pCovidData, pGeoZone); return(true); }
private void AddCovidDataInsertStatementToStringBuilder( StringBuilder oStringBuilder, CoVidData oCovidData, GeoZone pGeoZone, Query oQuery) { oStringBuilder.Append( oQuery.valuesFormat.Replace( UtilsConstants.QueryConstants.ZERO_STRING, string.Join( string.Empty, UtilsConstants.StringConstants.REPLACE_SINGLEQUOTE_CONSTANT, oCovidData.id.ToString(), UtilsConstants.StringConstants.REPLACE_SINGLEQUOTE_CONSTANT))); oStringBuilder.Replace( UtilsConstants.QueryConstants.ONE_STRING, string.Join( string.Empty, UtilsConstants.StringConstants.REPLACE_SINGLEQUOTE_CONSTANT, Utils.UtilsJSON.GetInstance().Serialize(oCovidData), UtilsConstants.StringConstants.REPLACE_SINGLEQUOTE_CONSTANT)); }
public abstract bool InsertCovidData(CoVidData pCovidData, GeoZone pGeoZone);