Spring Data and JpaRepository method naming convention

Laisser un commentaire

Spring Data can infer SQL queries from JpaRepository method name. That’s a great tool to uniformize query generations, and make code more readable. Obviously, this only works for simple SQL queries, wchich is indeed what you should strive for.

The documentation about the JpaRepository method naming convention is available here :

https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#jpa.query-methods

Key points :

  • « Order by » is represented by the keyword « OrderBy », followed by the name of the entity member variable. Keyword « Asc » and « Desc » indicates the sort direction. You can sort by multiple columns by specifying each colum and its sort direction.
    Ex : findByDossierOrderByDateAscIdAsc(Dossier dossier)

Not using the local TSLint version found

Laisser un commentaire

When the following message is displayed by Visual Studio Code for an angular project, it’s time to switch from TSMint to ESLint, as TSLint has been deprecated for a while now.

Not using the local TSLint version found for 'c:/Users/nicol/Documents/GitHub/Bartleby/frontend/src/app/create-dossier/create-dossier.component.ts'
 To enable code execution from the current workspace you must enable workspace library execution.

This documentation from Microsoft describes the process : https://code.visualstudio.com/api/advanced-topics/tslint-eslint-migration

Displaying an asycnhronous loader in angular

Laisser un commentaire

To display a loader while waiting for an AJAX call to be processed, use a template, and an *ngIf / else condition on a container.

Example, with ng zorro :

<ng-container *ngIf="!saving else loading">
Will be displayed once the "saving" variable is false.
</ng-container>

<ng-template #loading>
  <div nz-row nzJustify="center">
    <nz-spin nzSimple></nz-spin> Displayed as long as the "saving" variable is true ...
  </div>
</ng-template>

Backingup WordPress with UpdraftPlus

Laisser un commentaire

I had a couple of bad surprises with wordpress websites getting compromised because WordPress was not thouroughly updated.

Since, I looked for an easy WordPress backup solution, one that would take care of backing up not only posts, but plugins, pictures, etc. And ideally, that would be free.

UpdraftPlus has since saved my life more than once, not only from hackers, but also from erroneous configuration changes.

UpdraftPlus : Extension WordPress de sauvegarde et migration