Package siena.core.options

Examples of siena.core.options.QueryOptionState

348
349
350
351
352
353
354
355
    QueryOptionState opt = (QueryOptionState)(options.get(QueryOptionState.ID)).activate();
    opt.lifeCycle = QueryOptionState.LifeCycle.STATEFUL;
  }
 
  protected void optionStateless() {
    QueryOptionState opt = (QueryOptionState)(options.get(QueryOptionState.ID)).activate();
    opt.lifeCycle = QueryOptionState.LifeCycle.STATELESS;
  }
View Full Code Here
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
    if(gaeCtx==null){
      gaeCtx = new QueryOptionGaeContext();
      query.customize(gaeCtx);
    }
   
    QueryOptionState state = (QueryOptionState)query.option(QueryOptionState.ID);
    QueryOptionFetchType fetchType = (QueryOptionFetchType)query.option(QueryOptionFetchType.ID);
    FetchOptions fetchOptions = FetchOptions.Builder.withDefaults();

    QueryOptionPage pag = (QueryOptionPage)query.option(QueryOptionPage.ID);
    if(!pag.isPaginating()){
      // no pagination but pageOption active
      if(pag.isActive()){
        // if local limit is set, it overrides the pageOption.pageSize
        if(limit!=Integer.MAX_VALUE){
          gaeCtx.realPageSize = limit;
          fetchOptions.limit(gaeCtx.realPageSize);
          // pageOption is passivated to be sure it is not reused
          pag.passivate();
        }
        // using pageOption.pageSize
        else {
          gaeCtx.realPageSize = pag.pageSize;
          fetchOptions.limit(gaeCtx.realPageSize);
          // passivates the pageOption in stateless mode not to keep anything between 2 requests
          if(state.isStateless()){
            pag.passivate();
          }           
        }
      }
      else {
        if(limit != Integer.MAX_VALUE){
          gaeCtx.realPageSize = limit;
          fetchOptions.limit(gaeCtx.realPageSize);
        }
      }
    }else {
      // paginating so use the pagesize and don't passivate pageOption
      // local limit is not taken into account
      gaeCtx.realPageSize = pag.pageSize;
      fetchOptions.limit(gaeCtx.realPageSize);
    }

    QueryOptionOffset off = (QueryOptionOffset)query.option(QueryOptionOffset.ID);
    // if local offset has been set, uses it
    if(offset!=0){
      off.activate();
      off.offset = offset;
    }
           
    // if previousPage has detected there is no more data, simply returns an empty list
    if(gaeCtx.noMoreDataBefore){
      return new ArrayList<T>();
    }
           
    if(state.isStateless()) {
      if(pag.isPaginating()){
        if(off.isActive()){
          gaeCtx.realOffset+=off.offset;
          fetchOptions.offset(gaeCtx.realOffset);
          off.passivate();
View Full Code Here
1728
1729
1730
1731
1732
1733
1734
1735
1736
1737
1738
1739
1740
1741
1742
1743
1744
1745
1746
1747
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1785
1786
1787
1788
1789
1790
1791
1792
1793
1794
  }
 
 
  private <T> Iterable<T> doFetchIterable(Query<T> query, int limit, int offset) {
    QueryOptionGaeContext gaeCtx = (QueryOptionGaeContext)query.option(QueryOptionGaeContext.ID);
    QueryOptionState state = (QueryOptionState)query.option(QueryOptionState.ID);
    QueryOptionFetchType fetchType = (QueryOptionFetchType)query.option(QueryOptionFetchType.ID);
       
    if(gaeCtx==null){
      gaeCtx = new QueryOptionGaeContext();
      query.customize(gaeCtx);
    }

    FetchOptions fetchOptions = FetchOptions.Builder.withDefaults();

    QueryOptionPage pag = (QueryOptionPage)query.option(QueryOptionPage.ID);
    if(!pag.isPaginating()){
      // no pagination but pageOption active
      if(pag.isActive()){
        // if local limit is set, it overrides the pageOption.pageSize
        if(limit!=Integer.MAX_VALUE){
          gaeCtx.realPageSize = limit;
          fetchOptions.limit(gaeCtx.realPageSize);
          // pageOption is passivated to be sure it is not reused
          pag.passivate();
        }
        // using pageOption.pageSize
        else {
          gaeCtx.realPageSize = pag.pageSize;
          fetchOptions.limit(gaeCtx.realPageSize);
          // passivates the pageOption in stateless mode not to keep anything between 2 requests
          if(state.isStateless()){
            pag.passivate();
          }           
        }
      }
      else {
        if(limit != Integer.MAX_VALUE){
          gaeCtx.realPageSize = limit;
          fetchOptions.limit(gaeCtx.realPageSize);
        }
      }
    }else {
      // paginating so use the pagesize and don't passivate pageOption
      // local limit is not taken into account
      gaeCtx.realPageSize = pag.pageSize;
      fetchOptions.limit(gaeCtx.realPageSize);
    }

    QueryOptionOffset off = (QueryOptionOffset)query.option(QueryOptionOffset.ID);
    // if local offset has been set, uses it
    if(offset!=0){
      off.activate();
      off.offset = offset;
    }
   
    // if previousPage has detected there is no more data, simply returns an empty list
    if(gaeCtx.noMoreDataBefore){
      return new ArrayList<T>();
    }
           
    if(state.isStateless()) {
      if(pag.isPaginating()){     
        if(off.isActive()){
          gaeCtx.realOffset+=off.offset;
          fetchOptions.offset(gaeCtx.realOffset);
          off.passivate();
View Full Code Here
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
    return fieldMap;
  }

  public static <T> void paginate(QueryData<T> query) {
    QueryOptionGaeContext gaeCtx = (QueryOptionGaeContext)query.option(QueryOptionGaeContext.ID);
    QueryOptionState state = (QueryOptionState)query.option(QueryOptionState.ID);
    if(gaeCtx==null){
      gaeCtx = new QueryOptionGaeContext();
      query.options().put(gaeCtx.type, gaeCtx);
    }
   
    // resets the realoffset to 0 if stateless
    if(state.isStateless()){
      gaeCtx.realOffset = 0;
    }
  }
View Full Code Here
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
    }
  }
 
  public static <T> void nextPage(QueryData<T> query) {
    QueryOptionPage pag = (QueryOptionPage)query.option(QueryOptionPage.ID);
    QueryOptionState state = (QueryOptionState)query.option(QueryOptionState.ID);
    QueryOptionGaeContext gaeCtx = (QueryOptionGaeContext)query.option(QueryOptionGaeContext.ID);
    if(gaeCtx==null){
      gaeCtx = new QueryOptionGaeContext();
      query.options().put(gaeCtx.type, gaeCtx);
    }
   
    // if no more data after, doesn't try to go after
    if(gaeCtx.noMoreDataAfter){
      return;
    }
   
    // if no more data before, removes flag to be able and stay there
    if(gaeCtx.noMoreDataBefore){
      gaeCtx.noMoreDataBefore = false;
      return;
    }
   
    if(pag.isPaginating()){
      gaeCtx.realPageSize = pag.pageSize;
      if(state.isStateless()) {
        //QueryOptionOffset offset = (QueryOptionOffset)query.option(QueryOptionOffset.ID);
        //if(offset.isActive()){
        gaeCtx.realOffset+=pag.pageSize;
        //}
      }     
View Full Code Here
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
    }
  }

  public static <T> void previousPage(QueryData<T> query) {
    QueryOptionPage pag = (QueryOptionPage)query.option(QueryOptionPage.ID);
    QueryOptionState state = (QueryOptionState)query.option(QueryOptionState.ID);
    QueryOptionGaeContext gaeCtx = (QueryOptionGaeContext)query.option(QueryOptionGaeContext.ID);
    if(gaeCtx==null){
      gaeCtx = new QueryOptionGaeContext();
      query.options().put(gaeCtx.type, gaeCtx);
    }
   
    // if no more data before, doesn't try to go before
    if(gaeCtx.noMoreDataBefore){
      return;
    }
   
    // if no more data after, removes flag to be able to go before
    if(gaeCtx.noMoreDataAfter){
      gaeCtx.noMoreDataAfter = false;
    }
   
    if(pag.isPaginating()){
      gaeCtx.realPageSize = pag.pageSize;
      if(state.isStateless()) {
        //QueryOptionOffset offset = (QueryOptionOffset)query.option(QueryOptionOffset.ID);
        //if(offset.isActive()){
          if(gaeCtx.realOffset>=pag.pageSize) {
            gaeCtx.realOffset-=pag.pageSize;
          }
View Full Code Here
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
    // if local offset has been set, uses it
    if(offset!=0){
      offsetOpt.activate();
      offsetOpt.offset = offset;
    }
    QueryOptionState state = (QueryOptionState)query.option(QueryOptionState.ID);
   
    // if previousPage has detected there is no more data, simply returns an empty list
    if(jdbcCtx.noMoreDataBefore){
      return new ArrayList<T>();
    }
       
    if(state.isStateless()
        || (state.isStateful() && !jdbcCtx.isActive())
        || (state.isStateful() && jdbcCtx.isActive() && jdbcCtx.isClosed())) {
      if(state.isStateless()){
        if(pag.isPaginating()){
          if(offsetOpt.isActive()){
            jdbcCtx.realOffset+=offsetOpt.offset;
            offsetOpt.passivate();
          }else {
            // keeps realOffset
          }
        }else {
          // if page is active, immediately passivates it not to keep is active
          if(pag.isActive()) {
            pag.passivate();
          }
          if(offsetOpt.isActive()){
            jdbcCtx.realOffset=offsetOpt.offset;
            offsetOpt.passivate();
          }else{
            jdbcCtx.realOffset = 0;
          }
        }
      } else {
        if(offsetOpt.isActive()){
          jdbcCtx.realOffset+=offsetOpt.offset;
          offsetOpt.passivate();
        }else {
          // keeps realOffset
        }
      }
      Class<T> clazz = query.getQueriedClass();
      List<Object> parameters = new ArrayList<Object>();
      StringBuilder sql = JdbcDBUtils.buildSqlSelect(query);
      appendSqlWhere(query, sql, parameters);
      JdbcDBUtils.appendSqlOrder(query, sql);
      JdbcDBUtils.appendSqlLimitOffset(query, sql, parameters);
      //sql.append(suffix);
      PreparedStatement statement = null;
      ResultSet rs = null;
      try {
        statement = createStatement(sql.toString(), parameters);
        if(pag.isPaginating()) {
          // this is just a hint to the DB so wonder if it should be used
          statement.setFetchSize(jdbcCtx.realPageSize);
        }
        rs = statement.executeQuery();
        List<T> result = JdbcMappingUtils.mapList(clazz, rs, ClassInfo.getClassInfo(clazz).tableName,
            JdbcMappingUtils.getJoinFields(query), jdbcCtx.realPageSize);
       
        if(pag.isPaginating()){
          if(result.size() == 0){
            jdbcCtx.noMoreDataAfter = true;
          }
          else {
            jdbcCtx.noMoreDataAfter = false;
          }
        }else {
          if(state.isStateful()){
            jdbcCtx.realOffset += result.size();
          }
        }
       
        if(state.isStateless()){
          JdbcDBUtils.closeResultSet(rs);
          JdbcDBUtils.closeStatementAndConnection(this, statement);
        }else {
          Integer offsetParamIdx = parameters.size();
          Integer limitParamIdx = offsetParamIdx - 1;
View Full Code Here
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
    // if local offset has been set, uses it
    if(offset!=0){
      offsetOpt.activate();
      offsetOpt.offset = offset;
    }
    QueryOptionState state = (QueryOptionState)query.option(QueryOptionState.ID);
   
   
    // if previousPage has detected there is no more data, simply returns an empty list
    if(jdbcCtx.noMoreDataBefore){
      return new ArrayList<T>();
    }
       
    if(state.isStateless() || (state.isStateful() && !jdbcCtx.isActive())) {
      if(state.isStateless()){
        if(pag.isPaginating()){
          if(offsetOpt.isActive()){
            jdbcCtx.realOffset+=offsetOpt.offset;
            offsetOpt.passivate();
          }else {
            // keeps realOffset
          }
        }else {
          // if page is active, immediately passivates it not to keep is active
          if(pag.isActive()) {
            pag.passivate();
          }
          if(offsetOpt.isActive()){
            jdbcCtx.realOffset=offsetOpt.offset;
            offsetOpt.passivate();
          }else{
            jdbcCtx.realOffset = 0;
          }
        }
      } else {
        if(offsetOpt.isActive()){
          jdbcCtx.realOffset+=offsetOpt.offset;
          offsetOpt.passivate();
        }else {
          // keeps realOffset
        }
      }
     
      Class<T> clazz = query.getQueriedClass();
      List<Object> parameters = new ArrayList<Object>();
      StringBuilder sql = JdbcDBUtils.buildSqlSelect(query);
      appendSqlWhere(query, sql, parameters);
      JdbcDBUtils.appendSqlOrder(query, sql);
      JdbcDBUtils.appendSqlLimitOffset(query, sql, parameters);
      //sql.append(suffix);
      PreparedStatement statement = null;
      ResultSet rs = null;
      try {
        statement = createStatement(sql.toString(), parameters);
        if(pag.isActive()) {
          // this is just a hint to the DB so wonder if it should be used
          statement.setFetchSize(jdbcCtx.realPageSize);
        }
        rs = statement.executeQuery();
        List<T> result = JdbcMappingUtils.mapListKeys(clazz, rs, ClassInfo.getClassInfo(clazz).tableName,
            JdbcMappingUtils.getJoinFields(query), jdbcCtx.realPageSize);
       
        if(pag.isPaginating()){
          if(result.size() == 0){
            jdbcCtx.noMoreDataAfter = true;
          }
          else {
            jdbcCtx.noMoreDataAfter = false;
          }
        }else {
          if(state.isStateful()){
            jdbcCtx.realOffset += result.size();
          }
        }
       
        if(state.isStateless()){
          JdbcDBUtils.closeResultSet(rs);
          JdbcDBUtils.closeStatementAndConnection(this, statement);
        }else {
          Integer offsetParamIdx = parameters.size();
          Integer limitParamIdx = offsetParamIdx - 1;
View Full Code Here
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
    // if local offset has been set, uses it
    if(offset!=0){
      offsetOpt.activate();
      offsetOpt.offset = offset;
    }
    QueryOptionState state = (QueryOptionState)query.option(QueryOptionState.ID);

    // if previousPage has detected there is no more data, simply returns an empty list
    if(jdbcCtx.noMoreDataBefore){
      return new ArrayList<T>();
    }
   
    // forces the reusable option since iteration requires it!!!
    //query.stateful();   
   
    if(state.isStateless() || (state.isStateful() && !jdbcCtx.isActive())) {
      if(state.isStateless()){
        if(pag.isPaginating()){
          if(offsetOpt.isActive()){
            jdbcCtx.realOffset+=offsetOpt.offset;
            offsetOpt.passivate();
          }else {
            // keeps realOffset
          }
        }else {
          // if page is active, immediately passivates it not to keep is active
          if(pag.isActive()) {
            pag.passivate();
          }
          if(offsetOpt.isActive()){
            jdbcCtx.realOffset=offsetOpt.offset;
            offsetOpt.passivate();
          }else{
            jdbcCtx.realOffset = 0;
          }
        }
      } else {
        if(offsetOpt.isActive()){
          jdbcCtx.realOffset+=offsetOpt.offset;
          offsetOpt.passivate();
        }else {
          // keeps realOffset
        }
      }
     
      List<Object> parameters = new ArrayList<Object>();
      StringBuilder sql = JdbcDBUtils.buildSqlSelect(query);
      appendSqlWhere(query, sql, parameters);
      JdbcDBUtils.appendSqlOrder(query, sql);
      JdbcDBUtils.appendSqlLimitOffset(query, sql, parameters);
      //sql.append(suffix);
      PreparedStatement statement = null;
      ResultSet rs = null;
      try {
        statement = createStatement(sql.toString(), parameters);
        if(pag.isActive()) {
          // this is just a hint to the DB so wonder if it should be used
          statement.setFetchSize(jdbcCtx.realPageSize);
        }
        rs = statement.executeQuery();
       
        if(state.isStateless()){
          //in iteration, doesn't close the resultset to reuse it
          //JdbcDBUtils.closeResultSet(rs);
          //JdbcDBUtils.closeStatement(statement);
        }else {
          Integer offsetParamIdx = parameters.size();
View Full Code Here
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
  }

  @Override
  public <T> void paginate(Query<T> query) {
    QueryOptionJdbcContext jdbcCtx = (QueryOptionJdbcContext)query.option(QueryOptionJdbcContext.ID);
    QueryOptionState state = (QueryOptionState)query.option(QueryOptionState.ID);
    if(jdbcCtx==null){
      jdbcCtx = new QueryOptionJdbcContext();
      query.customize(jdbcCtx);
    }
   
    // resets the realoffset to 0 if stateless
    if(state.isStateless()){
      jdbcCtx.realOffset = 0;
    }
  }
View Full Code Here
TOP

Related Classes of siena.core.options.QueryOptionState

  • siena.BaseQueryData
  • siena.gae.GaePersistenceManager
  • siena.gae.GaePersistenceManagerAsync
  • siena.gae.GaeQueryUtils
  • siena.jdbc.JdbcPersistenceManager
  • siena.sdb.SdbMappingUtils
  • siena.sdb.SdbPersistenceManager
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.