KDamir

C:\servers\wildfly-10.0.0.Final\bin\standalone.bat
"C:\Program Files\Java\jdk1.8.0_111\bin\java" -classpath "C:\IDEA\IntelliJ IDEA 2016.3\lib\idea_rt.jar;C:\IDEA\IntelliJ IDEA 2016.3\lib\util.jar" -Dfile.encoding=windows-1251 com.intellij.rt.execution.CommandLineWrapper C:\Users\damir.keldibekov\AppData\Local\Temp\classpath com.intellij.javaee.oss.process.JavaeeProcess 56103 com.intellij.javaee.oss.jboss.agent.JBoss71Agent
Detected server admin port: 9990
Detected server http port: 8080
Calling "C:\servers\wildfly-10.0.0.Final\bin\standalone.conf.bat"
"JAVA_OPTS already set in environment; overriding default settings with values: -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:60839,suspend=y,server=n -Xmx1024m -XX:MaxPermSize=256m -Dfile.encoding=UTF8 "
Setting JAVA property to "C:\Program Files\Java\jdk1.8.0_111\bin\java"
[2017-04-05 04:16:30,108] Artifact stomagic-idp-app:war exploded: Server is not connected. Deploy is not available.
[2017-04-05 04:16:30,108] Artifact stomagic-almadentic-manager-app:

KDamir

@MappedSuperclass
@NamedQueries({
        @NamedQuery(name = "findPersonByNameAndPhone", query = "select person from ContactPerson person " +
                "where person.phoneNumber =:phoneNumber and person.name = :name"),
        @NamedQuery(name = "findAllPersonsByBranch", query = "select person from ContactPerson person " +
                "join treat(person.appointments as Appointment) app where app.branchId = :branchId")
})
public abstract class AbstractContactPerson<E extends AbstractAppointment> extends AbstractEntity {
    private String name;
    private String phoneNumber;

KDamir

Caused by: org.hibernate.AnnotationException: Property kz.inessoft.stomagic.common.data.entity.AbstractContactPerson.appointments has an unbound type and no explicit target entity. Resolve this Generic usage issue or set an explicit target attribute (eg @OneToMany(target=) or use an explicit @Type"}}

KDamir

package kz.inessoft.stomagic.common.data.repository;

import kz.inessoft.stomagic.common.data.entity.AbstractContactPerson;
import kz.inessoft.stomagic.common.data.entity.search.ContactSearchParams;
import org.jetbrains.annotations.NotNull;

import javax.persistence.NoResultException;
import java.util.List;
import java.util.Optional;

KDamir

package kz.inessoft.stomagic.common.data.util;

import org.hibernate.dialect.PostgreSQL9Dialect;
import org.hibernate.dialect.function.StandardSQLFunction;

/**
 * Created by damir.keldibekov on 24.04.2017.
 */
public class CustomPostgreSQL9Dialect extends PostgreSQL9Dialect {

KDamir

private <W extends AbstractWorkingDay> List<WorkplaceAtTimeInterval> toTimeIntervals(List<W> workingDays, LocalDate date) {
        LocalDateTime branchStartDatetime = date.atTime(getTimetableDisplayStartTime());
        LocalDateTime branchEndDatetime = date.atTime(getTimetableDisplayEndTime());

        LocalDateTime from = getIsWorkdayEndsNextDay() ? branchStartDatetime.toLocalDate().atStartOfDay() : branchStartDatetime;
        LocalDateTime to = getIsWorkdayEndsNextDay() ? from.plusDays(1) : branchEndDatetime;

        List<WorkplaceAtTimeInterval> result = new ArrayList<>();

        while (from.isBefore(to)) {

KDamir

2017-05-11 14:43:22,832 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) WFLYJCA0001: Bound data source [java:/jboss/datasources/StomagicAishaDS]
2017-05-11 14:48:00,515 INFO  [org.jboss.as.repository] (management task-1) WFLYDR0002: Content removed from location /opt/wildfly-10.0.0.Final/standalone/data/content/6e/e6d107ff16220a970331b87e9c9737a6f3e13c/content
2017-05-11 14:48:41,307 INFO  [org.jboss.as.repository] (management task-2) WFLYDR0002: Content removed from location /opt/wildfly-10.0.0.Final/standalone/data/content/ab/16a7d87416d1fd980184bcf1db8414c812788c/content
2017-05-11 14:51:19,014 INFO  [org.jboss.as.repository] (management task-10) WFLYDR0002: Content removed from location /opt/wildfly-10.0.0.Final/standalone/data/content/57/60c724217e511f41563559cb82982997fea95e/content
2017-05-11 14:51:31,143 INFO  [org.jboss.as.repository] (management task-6) WFLYDR0002: Content removed from location /opt/wildfly-10.0.0.Final/standalone/data/content/c3/bbe952f202bcc6f5ce5562

KDamir

Backup:
docker exec -t -u postgres your-db-container pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

Restore:
cat your_dump.sql | docker exec -i your-db-container psql -Upostgres

KDamir

select questoin_id, question_text, prev, next from
(select t0.questoin_id,t0.question_text,
lag(t0.questoin_id) over (order by t0.questoin_id, t0.questoin_id rows between current row and unbounded following) as prev,
lead(t0.questoin_id) over (order by t0.questoin_id, t0.questoin_id rows between current row and unbounded following) as next
from public.result_question t0 inner join public.question t1
inner join public.scenario_subject t2 on t1.scenario_id = t2.scenario_id
and t1.subject_id = t2.subject_id
on t0.questoin_id = t1.question_id
where t0.event_record_id = 42 order by t0.questoin_id) as tbl
where questoin_id = 33

KDamir

ResultQuestion resultQuestion = new ResultQuestion();

            ScenarioSubject scenarioSubject = resultQuestion.questoin_id.innerQuestion().scenario_id_subject_id.innerScenarioSubject();
            resultQuestion.where(resultQuestion.event_record_id.eq(param(eventRecordId)));

            Select select = Utils.createSelect();
            select.select(resultQuestion.questoin_id);
            select.select(resultQuestion.question_text);
            select.select(PostgresFunction.lag(resultQuestion.questoin_id).as("prev"));
            select.select(PostgresFunction.lead(resultQuestion.questoin_id).as("next"));