Package org.apache.torque.util.functions

Examples of org.apache.torque.util.functions.Count

106
107
108
109
110
111
112
113
114
115
116
        List<Class<?>> returnTypes = new ArrayList<Class<?>>();

        summary.addGroupBy ( Summarize1Peer.GROUP_BY1 );
        returnTypes.add(String.class);

        summary.addAggregate("COUNT_RECS", new Count(Summarize1Peer.ID));
        returnTypes.add(Integer.class);

        summary.addAggregate("AVG_INT1", new Avg(Summarize1Peer.INT_1));
        returnTypes.add(Integer.class);
View Full Code Here
185
186
187
188
189
190
191
192
193
194
195
        SummaryHelper summary = new SummaryHelper();

        summary.setExcludeExprColumns(true);
        List<Class<?>> returnTypes = new ArrayList<Class<?>>();

        summary.addAggregate("COUNT_RECS", new Count(Summarize1Peer.ID));
        returnTypes.add(Integer.class);

        summary.addAggregate("AVG_INT1", new Avg(Summarize1Peer.INT_1));
        returnTypes.add(Integer.class);
View Full Code Here
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
     */
    public static void assertNonPkOIntegerFksInDatabaseEquals(
                List<NonPkOIntegerFk> expected)
            throws TorqueException
    {
        Criteria criteria = new Criteria().addSelectColumn(new Count("*"));
        Assert.assertEquals(new Integer(expected.size()),
                NonPkOIntegerFkPeer.doSelectSingleRecord(
                criteria, new IntegerMapper()));
        for (NonPkOIntegerFk nonPkOIntegerFk : expected)
        {
            criteria = NonPkOIntegerFkPeer.buildCriteria(nonPkOIntegerFk);
            criteria.addSelectColumn(new Count("*"));
            Assert.assertEquals(
                    "Expected but not found : " + nonPkOIntegerFk,
                    new Integer(1),
                    NonPkOIntegerFkPeer.doSelectSingleRecord(
                            criteria, new IntegerMapper()));
View Full Code Here
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
     */
    public static void assertCompositeIntegerVarcharFksInDatabaseEquals(
                List<CompIntegerVarcharFk> expected)
            throws TorqueException
    {
        Criteria criteria = new Criteria().addSelectColumn(new Count("*"));
        Assert.assertEquals(new Integer(expected.size()),
                CompIntegerVarcharFkPeer.doSelectSingleRecord(
                criteria, new IntegerMapper()));
        for (CompIntegerVarcharFk compIntegerVarcharFk : expected)
        {
            criteria = CompIntegerVarcharFkPeer.buildCriteria(
                    compIntegerVarcharFk);
            criteria.addSelectColumn(new Count("*"));
            Assert.assertEquals(
                    "Expected but not found : " + compIntegerVarcharFk,
                    new Integer(1),
                    CompIntegerVarcharFkPeer.doSelectSingleRecord(
                            criteria, new IntegerMapper()));
View Full Code Here
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
     */
    public static void assertNullableOIntegerFksInDatabaseEquals(
                List<NullableOIntegerFk> expected)
            throws TorqueException
    {
        Criteria criteria = new Criteria().addSelectColumn(new Count("*"));
        Assert.assertEquals(new Integer(expected.size()),
                NullableOIntegerFkPeer.doSelectSingleRecord(
                criteria, new IntegerMapper()));
        for (NullableOIntegerFk nullableOIntegerFk : expected)
        {
            criteria = NullableOIntegerFkPeer.buildCriteria(nullableOIntegerFk);
            criteria.addSelectColumn(new Count("*"));
            Assert.assertEquals(
                    "Expected but not found : " + nullableOIntegerFk,
                    new Integer(1),
                    NullableOIntegerFkPeer.doSelectSingleRecord(
                            criteria, new IntegerMapper()));
View Full Code Here
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
     */
    public static void assertCompositePkOtherFksInDatabaseEquals(
                List<CompPkOtherFk> expected)
            throws TorqueException
    {
        Criteria criteria = new Criteria().addSelectColumn(new Count("*"));
        Assert.assertEquals(new Integer(expected.size()),
                CompPkOtherFkPeer.doSelectSingleRecord(
                criteria, new IntegerMapper()));
        for (CompPkOtherFk compPkOtherFk : expected)
        {
            criteria = CompPkOtherFkPeer.buildCriteria(compPkOtherFk);
            criteria.addSelectColumn(new Count("*"));
            Assert.assertEquals(
                    "Expected but not found : " + compPkOtherFk,
                    new Integer(1),
                    CompPkOtherFkPeer.doSelectSingleRecord(
                            criteria, new IntegerMapper()));
View Full Code Here
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
     */
    public static void assertCompositePkContainsFksInDatabaseEquals(
                List<CompPkContainsFk> expected)
            throws TorqueException
    {
        Criteria criteria = new Criteria().addSelectColumn(new Count("*"));
        Assert.assertEquals(new Integer(expected.size()),
                CompPkContainsFkPeer.doSelectSingleRecord(
                criteria, new IntegerMapper()));
        for (CompPkContainsFk compPkContainsFk : expected)
        {
            criteria = CompPkContainsFkPeer.buildCriteria(compPkContainsFk);
            criteria.addSelectColumn(new Count("*"));
            Assert.assertEquals(
                    "Expected but not found : " + compPkContainsFk,
                    new Integer(1),
                    CompPkContainsFkPeer.doSelectSingleRecord(
                            criteria, new IntegerMapper()));
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
     *
     * @throws Exception if the test fails
     */
    public void testSelectCount() throws Exception
    {
        Criteria criteria = new Criteria().addSelectColumn(new Count("*"));

        Integer count = peer.doSelectSingleRecord(criteria);

        assertEquals(new Integer(4), count);
    }
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
     * @throws Exception if the test fails
     */
    public void testSelectCountDistinct() throws Exception
    {
        Criteria criteria = new Criteria().addSelectColumn(
                new Count(Summarize1Peer.INT_1, true));

        Integer count = peer.doSelectSingleRecord(criteria);

        assertEquals(new Integer(2), count);
    }
View Full Code Here
315
316
317
318
319
320
321
322
323
324
325
        {
            criteriaSelectModifiers.remove(SqlEnum.DISTINCT.toString());
            distinct = true;
        }

        c.addSelectColumn(new Count(new ColumnImpl(columnName), distinct));

        String databaseName = (c.getDbName() == null)
                ? Torque.getDefaultDB()
                : c.getDbName();
View Full Code Here
TOP

Related Classes of org.apache.torque.util.functions.Count

  • org.apache.torque.ColumnImpl
  • org.apache.torque.ForeignKeySchemaData
  • org.apache.torque.generated.peer.SelectFunctionTest
  • org.apache.torque.util.CountHelper
  • org.apache.torque.util.SummaryHelperTest
    • 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.