SELECT* FROM history_data
WHERE ts BETWEEN '2022-01-01 06:00:00' AND '2022-12-31 07:00:00'
AND
id %
( Select FLOOR( count(id) / 50 ) FROM history_data
WHERE ts between '2022-01-01 06:00:00' AND '2022-12-31 07:00:00' ) = 0
ORDER BY id
Egyéb kategória bejegyzései
SpringBoot2.0 Kotlin build.gradle IntelliJ IDEA
buildscript {
ext {
kotlinVersion = ‘1.2.70’
springBootVersion = ‘2.0.5.RELEASE’
}
repositories {
mavenCentral()
}
dependencies {
classpath(„org.springframework.boot:spring-boot-gradle-plugin:${springBootVersion}”)
classpath(„org.jetbrains.kotlin:kotlin-gradle-plugin:1.2.70”)
classpath(„org.jetbrains.kotlin:kotlin-allopen:${kotlinVersion}”)
}
}
apply plugin: ‘kotlin’
apply plugin: ‘kotlin-spring’
apply plugin: ‘org.springframework.boot’
apply plugin: ‘io.spring.dependency-management’
group ‘home’
version ‘1.0-SNAPSHOT’
repositories {
mavenCentral()
}
dependencies {
compile(‘org.springframework.boot:spring-boot-starter-web’)
compile(„org.jetbrains.kotlin:kotlin-stdlib-jdk8”)
compile(„org.jetbrains.kotlin:kotlin-reflect”)
testCompile(‘org.springframework.boot:spring-boot-starter-test’)
}
sourceCompatibility = 1.8
compileKotlin {
kotlinOptions {
freeCompilerArgs = [„-Xjsr305=strict”]
jvmTarget = „1.8”
}
}
compileTestKotlin {
kotlinOptions {
freeCompilerArgs = [„-Xjsr305=strict”]
jvmTarget = „1.8”
}
}
Java Security Encryption with PublicKey
keytool -genkeypair -alias kulcsnev -keyalg RSA -keystore keystore.jks
Fugatisztítás
http://www.mindenegybenblog.hu/kreativ-kutyuk/ezzel-a-modszerrel-szeretni-fogjuk
Test és lélek
HAMA 4 digit code
Hama 8 in 1 távírányító kód lista.
Software Design
Software Laws
Change: certanity in the future
Defect: if change the code
Simplicity: individual piece as simple
Testing: show how behaves as you tested.
Software Fact
Sérült Outlook
ProgramFiles/Microsoft/Office/Office12/scanpst.exe
Na ez javítja.
Asus O!Play Mini Plus
Vásároltam egy ilyen terméket.