Shsha Windows development

Readme-Windows.md

Install Java

We are turning off PATH, JAVA_HOME modifications so we can install multiple versions of Java, and set PATH as needed per-project. However

• we do not provide instructions for this scenario (TODO jps)
• if this is the only Java on your workstation, you can let setup do these changes for you

winget install --interactive BellSoft.LibericaJDK.11

Interactively set this location C:\JDK\11, and turn off PATH, JAVA_HOME, and Jar assotiation

console output

Found Liberica JDK 11 [BellSoft.LibericaJDK.11] Version ...
Downloading https://download.bell-sw.com/java/11.0.18+10/bellsoft-jdk11.0.18+10-windows-amd64.msi
  ██████████████████████████████  ... MB / 183 MB
...

Note: flag --location "C:\JDK\11" has nearly zero effect, this empty dir is created, installition path is not changed

Install Git

winget install --interactive --id Git.Git

Found Git [Git.Git] Version 2.39.1
This application is licensed to you by its owner.
Microsoft is not responsible for, nor does it grant any licenses to, third-party packages.
Downloading https://github.com/git-for-windows/git/releases/download/v2.39.1.windows.1/Git-2.39.1-64-bit.exe
  ██████████████████████████████  50.5 MB / 50.5 MB
  Successfully verified installer hash

TODO Install MySQL 5.7, 8.0, mysqldump 8.0

• download and install mysql-installer-web-community-8.0.32.0.msi (2,506,752 Bytes)
• select Server 8.0.32 , Server 5.7.41, Workbench
• use Right Arrow button to add selected options
• set paths (official manual page)
• install
• configure
  • Server 8.0 - use Strong Password Encryption
  • disable binary log, chage names to distinguish between versions, lower slow log threshold

Install PostgreSQL 14

winget show PostgreSQL.PostgreSQL
Found PostgreSQL 14 [PostgreSQL.PostgreSQL]
Version: 14.5
Publisher: PostgreSQL Global Development Group
...
Installer:
  Installer Url: https://get.enterprisedb.com/postgresql/postgresql-14.5-1-windows-x64.exe
  Installer SHA256: e91b3aa882a0af54fda36043f492252e472c878904e2c3d92e6c799c33e75dea

winget install --version 14.5 --interactive PostgreSQL.PostgreSQL

  Downloading https://get.enterprisedb.com/postgresql/postgresql-14.5-1-windows-x64.exe
    ███████▊                        81.0 MB /  313 MB

!!! IMPORTANT !!! Set and save superuser 'postgres' password

TODO adjust PATH, (option) JAVA_HOME

JAVA_HOME may help when Gradle task was interrupted. TODO set it <shsha>\gradlew.bat

Create PostgreSQL user 'shsha'

chcp 1252

Avoids

WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.

have user postgres password ready, and run:

psql -U postgres
postgres=# CREATE USER shsha WITH PASSWORD '999' CREATEDB;

Configure IDEA JDK and Gradle

• in case Gradle is set up as above

• in case no Gradle is set up - selet 'wrapper' task in Gradle build script

• https://medium.com/javarevisited/how-to-introduce-spi-in-java-project-5232e02a587b
  • The driver package that implements java.sql.Driver, according to the SPI convention, specifies the specific driver class in the META-INF/services/java.sql.Driver file.
  • There are also some disadvantages (to using ServiceLoader):
    • Can’t load on demand.
    • The way to obtain an implementation class is not flexible enough
    • It is not safe to use an instance of the ServiceLoader class with multiple concurrent threads.
• https://www.infoq.com/articles/java11-aware-service-module/
  • ... the common module has no knowledge of the given service interface and since it doesn’t include the “uses” clause in its module descriptor, the ServiceLoader cannot locate providers
  • we will build a custom library called Susel to solve the issues mentioned above
• https://connect2id.com/products/server/docs/guides/spi-implementation-and-packaging
• http://metainf-services.kohsuke.org/
• SLF4J API version 2.0.0 relies on the ServiceLoader mechanism to find its logging back-end. See the relevant FAQ entry for more details.
• https://docs.oracle.com/javase/tutorial/sound/SPI-intro.html
• more examples
  • CurrencyNameProvider:
  • LocaleNameProvider: provides
  • TimeZoneNameProvider:
  • DateFormatProvider
  • NumberFormatProvider
  • Driver: version 4.0, the JDBC API supports the SPI pattern. Older versions uses the Class.forName() method to load drivers.
  • PersistenceProvider: provides JPA API implementations
  • JsonProvider: provides JSON processing objects.
  • JsonbProvider: provides JSON binding objects.
  • Extension: provides extensions for the CDI container.
  • ConfigSourceProvider: provides a source for retrieving configuration properties

Gradle stuff

• https://melix.github.io/blog/2022/03/gradle-conditional-dependencies.html
• https://docs.gradle.org/current/dsl/org.gradle.api.artifacts.dsl.ArtifactHandler.html

configurations {
  //declaring new configuration that will be used to associate with artifacts
  schema
}

task schemaJar(type: Jar) {
  //some imaginary task that creates a jar artifact with some schema
}

//associating the task that produces the artifact with the configuration
artifacts {
  //configuration name and the task:
  schema schemaJar
}

• https://docs.gradle.org/current/userguide/publishing_customization.html
• https://stackoverflow.com/questions/52744893/how-do-i-create-distributions-with-different-dependencies-using-gradle-applicati
• https://stackoverflow.com/questions/29374885/multiple-version-of-dependencies-in-gradle
• https://docs.gradle.org/current/userguide/organizing_gradle_projects.html#sec:build_sources
• https://docs.gradle.org/current/userguide/resolution_rules.html

configurations.all {
    resolutionStrategy.eachDependency { DependencyResolveDetails details ->
        if (details.requested.version == 'default') {
            def version = findDefaultVersionInCatalog(details.requested.group, details.requested.name)
            details.useVersion version.version
            details.because version.because
        }
    }
}

def findDefaultVersionInCatalog(String group, String name) {
    //some custom logic that resolves the default version into a specific version
    [version: "1.0", because: 'tested by QA']
}

• https://docs.gradle.org/current/userguide/cross_project_publications.html

configurations {
    instrumentedJars {
        canBeConsumed = true
        canBeResolved = false
        // If you want this configuration to share the same dependencies, otherwise omit this line
        extendsFrom implementation, runtimeOnly
    }
}

artifacts {
    instrumentedJars(instrumentedJar)
}

• https://docs.gradle.org/current/samples/sample_building_java_libraries.html#header
• https://docs.gradle.org/current/javadoc/org/gradle/api/artifacts/Configuration.html

diff

• https://github.com/apache/commons-text/tree/master
• https://itsallbinary.com/compare-files-side-by-side-and-hightlight-diff-using-java-apache-commons-text-diff-myers-algorithm/
• https://stackoverflow.com/questions/319479/generate-formatted-diff-output-in-java

fucking streams

http://programmingbb.blogspot.com/2017/07/java-8-use-lambda-to-create-pivot.html

mix

• bug #76306
• store complex DSG XML messages as a String
• https://gitlab.exactpro.com/-/snippets/74
• client 15.x
• SWT deps
• https://medium.com/javarevisited/why-does-java-serialization-implement-the-serializable-interface-and-display-the-value-of-the-5672a903ab26
• How Ukraine Became Part of the USSR - The Soviet–Ukrainian War (Documentary)
• https://www.user.tu-berlin.de/laurmaedje/programmable-markup-language-for-typesetting.pdf

https://github.com/google/auto/tree/main/service
https://search.maven.org/artifact/com.google.auto.service/auto-service
com.google.auto.service:auto-service:1.0.1
2021-11-03 https://github.com/google/auto/releases/tag/auto-service-1.0.1

import com.google.auto.service.AutoService;

@AutoService(SimpleService.class)
public class SimpleServiceImpl implements SimpleService {
    public String echo(final String value) {
        return value;
    }
}

In the implementation we “register” an instance of the service with the annotation @AutoService. This is only needed at compile time as the annotation is used by a javac annotation processor to automatically generate the service registration file:
META-INF/services/io.github.efenglu.serviceLoader.example.SimpleService
The file contains a list of Classes that implement the service:
io.github.efenglu.serviceLoader.example.SimpleServiceImpl
The implementation classes MUST have a no-arg constructor.

Erik Englund 2019-04-04 ServiceLoader: The Built in DI Framework ...