Сообщения

Сообщения за май, 2022

gRPC - Remote Procedure Calls

 Java Type -- Proto Type int -- int32 long -- int64 float -- float double -- double boolean -- bool String -- string byte[] -- bytes Collection / List -- repeated Map -- map Default Values int32 / any number type -- 0 bool -- false string -- empty string enum -- first value repeated -- empty string map -- wrapped / empty map

JOOQ(Java Object Oriented Querying)

 build.gradle file for jooq configuration: plugins { id 'org.springframework.boot' version '2.7.0' id 'io.spring.dependency-management' version '1.0.11.RELEASE' id 'java' id 'nu.studer.jooq' version '7.1.1' } group = 'com.example' version = '0.0.1-SNAPSHOT' sourceCompatibility = '11' configurations { compileOnly { extendsFrom annotationProcessor } } repositories { mavenCentral() } dependencies { implementation 'org.springframework.boot:spring-boot-starter-jooq' implementation 'org.springframework.boot:spring-boot-starter-web' compileOnly 'org.projectlombok:lombok' runtimeOnly 'org.postgresql:postgresql' annotationProcessor 'org.projectlombok:lombok' testImplementation 'org.springframework.boot:spring-boot-starter-test' jooqGenerator 'org.postgresql:postgresql:42.3.1' jooqGenerator '

SQL - Structured Query Language

 1. create database "database_name": create database learning with owner = postgres encoding = 'UTF8' connection limit = - 1 ; 2. create table "table_name": create table customers ( customer_id serial primary key, first_name varchar(50), last_name varchar(50), email varchar(150), age int ); 3. select * from "table_name": select * from customers; 4. insert into "table_name" (column_name1, column_name2...) values ('value1', 'value2'): insert into customers (first_name, last_name, email, age) values ('Adnan', 'Waheed', 'a@b.com', 40); 5. insert into "table_name" (column_name1, column_name2...)  values  ('value1', 'value2'), ('value1', 'value2'), ('value1', 'value2'): insert into customers (first_name, last_name) values ('Adnan', 'Oktar'), ('John', 'Adams'), ('Linda', 'Abe'); 6. insert a d