Caching multiple entities

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Caching multiple entities

Per Newgro
Hello,

we are implementing a questionnaire tool for companies. I would like to
import the data using a DIH.

To increase performance i would like to use some caching. But my
solution is not working. The score of my

questionnaire is empty. But there is a value in the database. I've
checked that.

We can mark questionnaires for special purposes. I need to import the
special mpc score. The mpc questionnaire

is not changing while importing. So i thaught i can can cache this value
for usage in mpc_score queries.

Can you please help me, to find out what i'm doing wrong here?

Thanks

Per

     <document>
         <entity
             name="company"
             query="SELECT id as ID,
                           customer_number as CUSTOMER_NUMBER
                     FROM  companies
                    WHERE  '${dataimporter.request.clean}' != 'false'
                       OR  last_modified >
'${dataimporter.last_index_time}'">
             <entity
                 name="mpc"
                 processor="SqlEntityProcessor"
cacheImpl="SortedMapBackedCache"
                 query="select qp.questionnaire AS ID
                        from questionnaire_purposes qp
                        join purposes p ON qp.id = p.id
                        where p.name = 'mpc';">
                 <entity
                     name="mpc_score"
                     query="select c.score as SCORE
                            FROM basfcdi.census c
                            where c.company=${company.ID}
                            and c.questionnaire = ${mpc.ID};">
                     <field name="mpc_score" column="SCORE" />
                 </entity>
             </entity>
     </entity>

</document>

Reply | Threaded
Open this post in threaded view
|

Re: Caching multiple entities

Billnbell
I am not sure, but it looks like your XML is invalid.

last_modified > XYZ

You need to switch to  &gt; or use something like a database view so that
the > and other < will not cause problems.


On Sat, Dec 17, 2016 at 7:01 AM, Per Newgro <[hidden email]> wrote:

> Hello,
>
> we are implementing a questionnaire tool for companies. I would like to
> import the data using a DIH.
>
> To increase performance i would like to use some caching. But my solution
> is not working. The score of my
>
> questionnaire is empty. But there is a value in the database. I've checked
> that.
>
> We can mark questionnaires for special purposes. I need to import the
> special mpc score. The mpc questionnaire
>
> is not changing while importing. So i thaught i can can cache this value
> for usage in mpc_score queries.
>
> Can you please help me, to find out what i'm doing wrong here?
>
> Thanks
>
> Per
>
>     <document>
>         <entity
>             name="company"
>             query="SELECT id as ID,
>                           customer_number as CUSTOMER_NUMBER
>                     FROM  companies
>                    WHERE  '${dataimporter.request.clean}' != 'false'
>                       OR  last_modified > '${dataimporter.last_index_tim
> e}'">
>             <entity
>                 name="mpc"
>                 processor="SqlEntityProcessor"
> cacheImpl="SortedMapBackedCache"
>                 query="select qp.questionnaire AS ID
>                        from questionnaire_purposes qp
>                        join purposes p ON qp.id = p.id
>                        where p.name = 'mpc';">
>                 <entity
>                     name="mpc_score"
>                     query="select c.score as SCORE
>                            FROM basfcdi.census c
>                            where c.company=${company.ID}
>                            and c.questionnaire = ${mpc.ID};">
>                     <field name="mpc_score" column="SCORE" />
>                 </entity>
>             </entity>
>     </entity>
>
> </document>
>
>


--
Bill Bell
[hidden email]
cell 720-256-8076