Category: .NET Core

To see if two TILTS are in the same day, it is not enough to see if the difference is less than one day. Could be less than 1 day in UTC – but in Europe/Bucharest can be the next day ( suppose that I put one TILT at 23:59:59 local time – the next TILT could be in 2 seconds )

In JavaScript one can have the IANA codes ( https://en.wikipedia.org/wiki/List_of_tz_database_time_zones ) by

Intl.DateTimeFormat().resolvedOptions().timeZone

In C# there I am receiving this and convert to TimeZoneInfo

var tz = TimeZoneInfo.FindSystemTimeZoneById(timeZone);
if (tz == null)
    return NotFound("cannot find timezone:" + timeZone);
var ser = tz.ToSerializedString();

Also, now we can verify to see that the time zone difference is ok

var tz = TimeZoneInfo.FromSerializedString(timezone);
if (tz == null)
    throw new TimeZoneNotFoundException(" cannote deserialize " + timezone);

var localTimeNow= TimeZoneInfo.ConvertTimeFromUtc(dateNowUTC, tz);

And the fact that I was thinking later – that means

1. Database modification ( alter table , update )

2. Backend verifications modified

3. Sending data modified

4. Tests added

And , of course, does not work in production . Added Hellang.Middleware.ProblemDetails to can debug more easy the error ( instead of 500 )

That comes from updating the existing database with default values

So reverting to the default timezone ( e.g. Europe/Bucharest) and now the tests are failing into CI ( that has not the time zone , being a stripped linux)

Adding to the CI

- name: Setup timezone
    uses: zcong1993/setup-timezone@master
    with:
    timezone: Asia/Shanghai

and now it works

Tools used

Visual Studio

Visual Studio Code

SSMS

Hellang.Middleware.ProblemDetails

zcong1993/setup-timezone@master

If you want to read about, see https://docs.microsoft.com/en-us/azure/architecture/patterns/cache-aside

So , the public TILTS must be cached. Also, when a user makes a new TILT, the cache should be destroyed

The code for Memory Cache is very simple:

1. Add to services

builder.Services.AddMemoryCache();

2. Add an MemoryCache cache to the constructor

public MyTilts(IMemoryCache cache, 

3. add caching to the function

 if (cache.TryGetValue<TILT_Note_Table[]>(urlPart, out var result))
            {
                return result;
            }
            
//code to retrieve
cache.Set(urlPart, ret,DateTimeOffset.Now.AddMinutes(10));
return ret;

4. add destroy cache

await insert.InsertTILT_Note(noteOrig);
note.CopyFrom(noteOrig);
cache.Remove(url);   

5. Modify tests to see this feature

Now the easy way for me is to create a web interface with Angular.

Nothing too complicated. This is how it looks for the TILTS at https://tiltwebapp.azurewebsites.net/AngTilt/tilt/public

Now , if I am going to a TILT Url , I can see the TILTs in the browser: https://tiltwebapp.azurewebsites.net/AngTilt/tilt/public/ignatandrei

For creating new TILTS , I can use the web interface https://tiltwebapp.azurewebsites.net/AngTilt/tilt/my

I enter a user name and a pasword and I can start adding the TILTS.

Tools Used

VSCode

Angular

The code coverage should be simple – just run tests and that’s all, right ?

For a reason, the coverlet console , dotnet-coverage ,dotnet test do not work – means that code coverage generated was 0% ( I have verified with dotnet-reportgenerator-globaltool )

The only that worked was altCover and this is the code into the yml:

dotnet test --no-build src/backend/Net6/NetTilt/NetTilt.sln  /p:AltCover=true /p:AltCoverAssemblyExcludeFilter="Humanizer|Moq|NUnit3|System|DB2GUI|AltCover|NetTilt.Tests" 

It was a good exercise. And now I have this:

And for some tests written already, the code coverage is 46 %. A good one, I think …

Tools used

https://codecov.io

Moq

NUnit3

AltCover

Visual Studio