Project

General

Profile

« Previous | Next » 

Revision 46350

Added by Panagiotis Kanakakis about 7 years ago

View differences:

unitest.MonitorTest-output.txt
1 1 
Hibernate:
2 2 
    select
3 
        this_.id as id1_4_13_,
4 
        this_.amountGranted as amountGr2_4_13_,
5 
        this_.amountRequested as amountRe3_4_13_,
6 
        this_.bankAccount as bankAcc13_4_13_,
7 
        this_.bankReceipt as bankRec14_4_13_,
8 
        this_.beneficiarysignedcontract as benefic15_4_13_,
9 
        this_.currency as currency4_4_13_,
10 
        this_.date as date5_4_13_,
11 
        this_.datePaid as datePaid6_4_13_,
12 
        this_.enddate as enddate7_4_13_,
13 
        this_.initialcontractfile as initial16_4_13_,
14 
        this_.invoice as invoice17_4_13_,
15 
        this_.organization as organiz18_4_13_,
16 
        this_.otherCost as otherCos8_4_13_,
17 
        this_.publisher as publish19_4_13_,
18 
        this_.remaining as remainin9_4_13_,
19 
        this_.signedcontract as signedc20_4_13_,
20 
        this_.startdate as startda10_4_13_,
21 
        this_.status as status11_4_13_,
22 
        this_.transferCost as transfe12_4_13_,
23 
        this_."user" as user21_4_13_,
24 
        bankaccoun2_.id as id1_2_0_,
25 
        bankaccoun2_.accountHolder as accountH2_2_0_,
26 
        bankaccoun2_.bankAddress as bankAddr3_2_0_,
27 
        bankaccoun2_.bankCode as bankCode4_2_0_,
28 
        bankaccoun2_.bankName as bankName5_2_0_,
29 
        bankaccoun2_.iban as iban6_2_0_,
30 
        banktransf3_.id as id1_3_1_,
31 
        banktransf3_.content as content2_3_1_,
32 
        banktransf3_.contentType as contentT3_3_1_,
33 
        budgetcont4_.id as id1_5_2_,
34 
        budgetcont4_.content as content2_5_2_,
35 
        budgetcont4_.contentType as contentT3_5_2_,
36 
        budgetfile5_.id as id1_6_3_,
37 
        budgetfile5_.content as content2_6_3_,
38 
        budgetfile5_.contenttype as contentt3_6_3_,
39 
        invoice6_.id as id1_13_4_,
40 
        invoice6_.alternativeid as alternat2_13_4_,
41 
        invoice6_.date as date3_13_4_,
42 
        invoice6_.file as file7_13_4_,
43 
        invoice6_.number as number4_13_4_,
44 
        invoice6_.source as source5_13_4_,
45 
        invoice6_.status as status6_13_4_,
46 
        file7_.id as id1_10_5_,
47 
        file7_.file as file2_10_5_,
48 
        file7_.mimetype as mimetype3_10_5_,
49 
        organizati8_.id as id1_16_6_,
50 
        organizati8_.country as country5_16_6_,
51 
        organizati8_.name as name2_16_6_,
52 
        organizati8_.shortname as shortnam3_16_6_,
53 
        organizati8_.source as source4_16_6_,
54 
        country9_.id as id1_9_7_,
55 
        country9_.name as name2_9_7_,
56 
        publisher10_.id as id1_19_8_,
57 
        publisher10_.apc as apc2_19_8_,
58 
        publisher10_.apcCurrency as apcCurre3_19_8_,
59 
        publisher10_.bankAccount as bankAcco8_19_8_,
60 
        publisher10_.contact as contact9_19_8_,
61 
        publisher10_.discount as discount4_19_8_,
62 
        publisher10_.email as email5_19_8_,
63 
        publisher10_.name as name6_19_8_,
64 
        publisher10_.source as source7_19_8_,
65 
        bankaccoun11_.id as id1_2_9_,
66 
        bankaccoun11_.accountHolder as accountH2_2_9_,
67 
        bankaccoun11_.bankAddress as bankAddr3_2_9_,
68 
        bankaccoun11_.bankCode as bankCode4_2_9_,
69 
        bankaccoun11_.bankName as bankName5_2_9_,
70 
        bankaccoun11_.iban as iban6_2_9_,
71 
        user12_.email as email1_22_10_,
72 
        user12_.active as active2_22_10_,
73 
        user12_.firstname as firstnam3_22_10_,
74 
        user12_.id as id4_22_10_,
75 
        user12_.initials as initials5_22_10_,
76 
        user12_.lastname as lastname6_22_10_,
77 
        user12_.orcidid as orcidid7_22_10_,
78 
        user12_.password as password8_22_10_,
79 
        user12_.source as source9_22_10_,
80 
        user12_.telephone as telepho10_22_10_,
81 
        budgetcont13_.id as id1_5_11_,
82 
        budgetcont13_.content as content2_5_11_,
83 
        budgetcont13_.contentType as contentT3_5_11_,
84 
        user14_.email as email1_22_12_,
85 
        user14_.active as active2_22_12_,
86 
        user14_.firstname as firstnam3_22_12_,
87 
        user14_.id as id4_22_12_,
88 
        user14_.initials as initials5_22_12_,
89 
        user14_.lastname as lastname6_22_12_,
90 
        user14_.orcidid as orcidid7_22_12_,
91 
        user14_.password as password8_22_12_,
92 
        user14_.source as source9_22_12_,
93 
        user14_.telephone as telepho10_22_12_
3 
        this_.id as id1_4_6_,
4 
        this_.amountGranted as amountGr2_4_6_,
5 
        this_.amountRequested as amountRe3_4_6_,
6 
        this_.bankAccount as bankAcc13_4_6_,
7 
        this_.bankReceipt as bankRec14_4_6_,
8 
        this_.beneficiarysignedcontract as benefic15_4_6_,
9 
        this_.currency as currency4_4_6_,
10 
        this_.date as date5_4_6_,
11 
        this_.datePaid as datePaid6_4_6_,
12 
        this_.enddate as enddate7_4_6_,
13 
        this_.initialcontractfile as initial16_4_6_,
14 
        this_.invoice as invoice17_4_6_,
15 
        this_.organization as organiz18_4_6_,
16 
        this_.otherCost as otherCos8_4_6_,
17 
        this_.publisher as publish19_4_6_,
18 
        this_.remaining as remainin9_4_6_,
19 
        this_.signedcontract as signedc20_4_6_,
20 
        this_.startdate as startda10_4_6_,
21 
        this_.status as status11_4_6_,
22 
        this_.transferCost as transfe12_4_6_,
23 
        this_."user" as user21_4_6_,
24 
        organizati2_.id as id1_16_0_,
25 
        organizati2_.country as country5_16_0_,
26 
        organizati2_.name as name2_16_0_,
27 
        organizati2_.shortname as shortnam3_16_0_,
28 
        organizati2_.source as source4_16_0_,
29 
        country3_.id as id1_9_1_,
30 
        country3_.name as name2_9_1_,
31 
        publisher4_.id as id1_19_2_,
32 
        publisher4_.apc as apc2_19_2_,
33 
        publisher4_.apcCurrency as apcCurre3_19_2_,
34 
        publisher4_.bankAccount as bankAcco8_19_2_,
35 
        publisher4_.contact as contact9_19_2_,
36 
        publisher4_.discount as discount4_19_2_,
37 
        publisher4_.email as email5_19_2_,
38 
        publisher4_.name as name6_19_2_,
39 
        publisher4_.source as source7_19_2_,
40 
        bankaccoun5_.id as id1_2_3_,
41 
        bankaccoun5_.accountHolder as accountH2_2_3_,
42 
        bankaccoun5_.bankAddress as bankAddr3_2_3_,
43 
        bankaccoun5_.bankCode as bankCode4_2_3_,
44 
        bankaccoun5_.bankName as bankName5_2_3_,
45 
        bankaccoun5_.iban as iban6_2_3_,
46 
        user6_.email as email1_22_4_,
47 
        user6_.active as active2_22_4_,
48 
        user6_.firstname as firstnam3_22_4_,
49 
        user6_.id as id4_22_4_,
50 
        user6_.initials as initials5_22_4_,
51 
        user6_.lastname as lastname6_22_4_,
52 
        user6_.orcidid as orcidid7_22_4_,
53 
        user6_.password as password8_22_4_,
54 
        user6_.source as source9_22_4_,
55 
        user6_.telephone as telepho10_22_4_,
56 
        user7_.email as email1_22_5_,
57 
        user7_.active as active2_22_5_,
58 
        user7_.firstname as firstnam3_22_5_,
59 
        user7_.id as id4_22_5_,
60 
        user7_.initials as initials5_22_5_,
61 
        user7_.lastname as lastname6_22_5_,
62 
        user7_.orcidid as orcidid7_22_5_,
63 
        user7_.password as password8_22_5_,
64 
        user7_.source as source9_22_5_,
65 
        user7_.telephone as telepho10_22_5_
94 66 
    from
95 67 
        Budget this_
96 68 
    left outer join
97 
        BankAccount bankaccoun2_
98 
            on this_.bankAccount=bankaccoun2_.id
69 
        Organization organizati2_
70 
            on this_.organization=organizati2_.id
99 71 
    left outer join
100 
        BankTransferReceipt banktransf3_
101 
            on this_.bankReceipt=banktransf3_.id
72 
        Country country3_
73 
            on organizati2_.country=country3_.id
102 74 
    left outer join
103 
        BudgetContract budgetcont4_
104 
            on this_.beneficiarysignedcontract=budgetcont4_.id
75 
        Publisher publisher4_
76 
            on this_.publisher=publisher4_.id
105 77 
    left outer join
106 
        Budgetfile budgetfile5_
107 
            on this_.initialcontractfile=budgetfile5_.id
78 
        BankAccount bankaccoun5_
79 
            on publisher4_.bankAccount=bankaccoun5_.id
108 80 
    left outer join
109 
        Invoice invoice6_
110 
            on this_.invoice=invoice6_.id
81 
        "user" user6_
82 
            on publisher4_.contact=user6_.email
111 83 
    left outer join
112 
        File file7_
113 
            on invoice6_.file=file7_.id
84 
        "user" user7_
85 
            on this_."user"=user7_.email
86 
    order by
87 
        this_.date asc
88 
Hibernate:
89 
    select
90 
        publisher0_.id as id1_19_2_,
91 
        publisher0_.apc as apc2_19_2_,
92 
        publisher0_.apcCurrency as apcCurre3_19_2_,
93 
        publisher0_.bankAccount as bankAcco8_19_2_,
94 
        publisher0_.contact as contact9_19_2_,
95 
        publisher0_.discount as discount4_19_2_,
96 
        publisher0_.email as email5_19_2_,
97 
        publisher0_.name as name6_19_2_,
98 
        publisher0_.source as source7_19_2_,
99 
        bankaccoun1_.id as id1_2_0_,
100 
        bankaccoun1_.accountHolder as accountH2_2_0_,
101 
        bankaccoun1_.bankAddress as bankAddr3_2_0_,
102 
        bankaccoun1_.bankCode as bankCode4_2_0_,
103 
        bankaccoun1_.bankName as bankName5_2_0_,
104 
        bankaccoun1_.iban as iban6_2_0_,
105 
        user2_.email as email1_22_1_,
106 
        user2_.active as active2_22_1_,
107 
        user2_.firstname as firstnam3_22_1_,
108 
        user2_.id as id4_22_1_,
109 
        user2_.initials as initials5_22_1_,
110 
        user2_.lastname as lastname6_22_1_,
111 
        user2_.orcidid as orcidid7_22_1_,
112 
        user2_.password as password8_22_1_,
113 
        user2_.source as source9_22_1_,
114 
        user2_.telephone as telepho10_22_1_
115 
    from
116 
        Publisher publisher0_
114 117 
    left outer join
115 
        Organization organizati8_
116 
            on this_.organization=organizati8_.id
118 
        BankAccount bankaccoun1_
119 
            on publisher0_.bankAccount=bankaccoun1_.id
117 120 
    left outer join
118 
        Country country9_
119 
            on organizati8_.country=country9_.id
120 
    left outer join
121 
        Publisher publisher10_
122 
            on this_.publisher=publisher10_.id
123 
    left outer join
124 
        BankAccount bankaccoun11_
125 
            on publisher10_.bankAccount=bankaccoun11_.id
126 
    left outer join
127 
        "user" user12_
128 
            on publisher10_.contact=user12_.email
129 
    left outer join
130 
        BudgetContract budgetcont13_
131 
            on this_.signedcontract=budgetcont13_.id
132 
    left outer join
133 
        "user" user14_
134 
            on this_."user"=user14_.email
135 
    order by
136 
        this_.date asc
121 
        "user" user2_
122 
            on publisher0_.contact=user2_.email
123 
    where
124 
        publisher0_.contact=?
125 
Hibernate:
126 
    select
127 
        bankaccoun0_.id as id1_2_0_,
128 
        bankaccoun0_.accountHolder as accountH2_2_0_,
129 
        bankaccoun0_.bankAddress as bankAddr3_2_0_,
130 
        bankaccoun0_.bankCode as bankCode4_2_0_,
131 
        bankaccoun0_.bankName as bankName5_2_0_,
132 
        bankaccoun0_.iban as iban6_2_0_
133 
    from
134 
        BankAccount bankaccoun0_
135 
    where
136 
        bankaccoun0_.id=?
137 137 
select r.id as rid, r.status, r.date, u.firstname, u.lastname, o.name as organization, c.name as country, p.id as pid, p.acronym, p.startdate, p.enddate, p.scientificarea, pub.title, pub.type, j.title as journal,(case when jp.id is not null then jp.name else mp.name end) as publisher,  r.approvaldate as approvaldate, r.apc as apc,r.currency as currency,r.datepaid, r.apcpaid, r.transfercost,  r.othercost, comment.comment as comment from (select * from request r   order by  r.date  desc) r left join "user" u on r.researcher = u.email left join project p on r.project=p.id left join publication pub on r.publication=pub.id left join journal j on j.id=r.journal left join publisher jp on j.publisher=jp.id left join publisher mp on mp.id=r.publisher left join organization o on o.id=r.organization left join country c on c.id=o.country left join (select rid , comments[1] as comment             from (select rid, array_agg(comments) as comments                 from (select rc.request as rid, c.comment as comments                        from comment c                             join request_comment rc on rc.comment=c.id                             join request r on r.id=rc.request                             and r.status = 8  order by rid, c.date desc                       ) foo                        group by rid                 ) bar order by rid
138 138 
           ) as comment on r.id=comment.rid
139 139 
Hibernate:
......
245 245 
            request r
246 246 
        order by
247 247 
            r.date  desc) foo
248 
{"requests":[],"total":0,"from":0,"to":10}
249 
class eu.dnetlib.goldoa.domain.RequestPage
248 250 
--------------------------
249 251 
Hibernate:
250 252 
    select
......
275 277 
            )
276 278 
        order by
277 279 
            r.date  desc) foo
280 
{"requests":[],"total":0,"from":0,"to":10}
281 
class eu.dnetlib.goldoa.domain.RequestPage

Also available in: Unified diff