Package core

Examples of core.Cell

52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
        //dummies (nierozciagalne)
        Column a = inputRelation1.getFirstCol();
        Column c = inputRelation2.getFirstCol();
        Column e = dummyRelation.getFirstCol();
        Column f = e.getNext();
        Cell e1 = e.getCell(1);
        Cell f1 = e1.nextInRow();
        formulas.put(e1, fillCount(c));
        formulas.put(f1, fillCount(a));

        for (int row = 1; row <= 2; row++) {
            Cell g1 = resultRelation.getFirstCol().getCell(row);
            Cell ghij1 = g1;
            for (Column ab : inputRelation1) {
                formulas.put(ghij1, fillIndex(ab, e, f));
                ghij1 = ghij1.nextInRow();
            }
            for (Column cd : inputRelation2) {
                formulas.put(ghij1, fillIf(g1, cd, e));
                ghij1 = ghij1.nextInRow();
            }
        }
    }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
        resultRelation = caf.getSpaceForNewRelation(inRelation1.getCardinality());
        labelResult(resultRelation, "Union of "+inRelation1.toString(caf)+" and "+inRelation2.toString(caf));
        Column b = inRelation2.getFirstCol();
        formulas.put(g.getCell(1), fillCount(b));

        Cell hij1 = caf.getLeftTopCellInRelation(resultRelation);
        Cell def1 = caf.getLeftTopCellInRelation(inRelation2);
        for (Column abc : inRelation1) {
            formulas.put(hij1, fillIf(g, def1, abc));
            def1 = def1.nextInRow();
            hij1 = hij1.nextInRow();
        }

        Cell hij2 = caf.getLeftTopCellInRelation(resultRelation).nextInColumn();
        Cell def2 = caf.getLeftTopCellInRelation(inRelation2).nextInColumn();
        for (Column abc : inRelation1) {
            formulas.put(hij2, fillIf(g, def2, abc));
            def2 = def2.nextInRow();
            hij2 = hij2.nextInRow();
        }
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
        labelResult(resultRelation, "Sorting of "+inputRelation.toString(caf));

        Column a = inputRelation.getCol(sortingColIndexInInput);
        Column c = dummyRelation.getFirstCol();
        Column d = c.getNext();
        Cell a1 = a.getCell(1);
        Cell c1 = caf.getLeftTopCellInRelation(dummyRelation);
        Cell d1 = c1.nextInRow();
        Cell e1 = d1.nextInRow();
        Cell fg1 = e1.nextInRow();

        formulas.put(c1, fillCount(a));
        formulas.put(d1, fillIf(a1, c, a, getSortingOper()));
        formulas.put(e1, fillMatch(d));
        for (Column ab : inputRelation) {
            formulas.put(fg1, fillIndex(ab, e1));
            fg1 = fg1.nextInRow();
        }

        Cell a2 = a1.nextInColumn();
        Cell d2 = d1.nextInColumn();
        Cell e2 = e1.nextInColumn();
        Cell fg2 = e2.nextInRow();

        formulas.put(d2, fillIf(a2, c, a, getSortingOper()));
        formulas.put(e2, fillMatch(d));
        for (Column ab : inputRelation) {
            formulas.put(fg2, fillIndex(ab, e2));
            fg2 = fg2.nextInRow();
        }
    }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
                sbWklejka1.append(",");
                sbWklejka2.append(",");
            }
            Column r1Col = inputRelation1.getCol(i);
            Column r2Col = inputRelation2.getCol(i);
            Cell r1Cell1 = r1Col.getCell(1);
            sbWklejka1.append(fillInsert1(r2Col, r1Cell1));
            sbWklejka2.append(fillInsert2(r1Col, r1Cell1));
        }
        Cell g1 = caf.getLeftTopCellInRelation(resultRelation);
        Cell h1 = g1.nextInRow();
        Cell a1 = caf.getLeftTopCellInRelation(inputRelation1);
        formulas.put(g1, fillComparison(sbWklejka1.toString(), sbWklejka2.toString(), a1));
        for (int i = 2; i <= inputRelation1.getCardinality(); i++) {
            a1 = a1.nextInRow();
            formulas.put(h1, fillCopy(g1, a1));
            h1 = h1.nextInRow();
        }

        skipFirstComma = true;
        sbWklejka1 = new StringBuilder();
        sbWklejka2 = new StringBuilder();
        for (int i = 1; i <= inputRelation1.getCardinality(); i++) {
            if (skipFirstComma) {
                skipFirstComma = false;
            } else {
                sbWklejka1.append(",");
                sbWklejka2.append(",");
            }
            Column r1Col = inputRelation1.getCol(i);
            Column r2Col = inputRelation2.getCol(i);
            Cell r1Cell2 = r1Col.getCell(2);
            sbWklejka1.append(fillInsert1(r2Col, r1Cell2));
            sbWklejka2.append(fillInsert2(r1Col, r1Cell2));
        }
        Cell g2 = caf.getLeftTopCellInRelation(resultRelation).nextInColumn();
        Cell h2 = g2.nextInRow();
        Cell a2 = caf.getLeftTopCellInRelation(inputRelation1).nextInColumn();
        formulas.put(g2, fillComparison(sbWklejka1.toString(), sbWklejka2.toString(), a2));
        for (int i = 2; i <= inputRelation1.getCardinality(); i++) {
            a2 = a2.nextInRow();
            formulas.put(h2, fillCopy(g2, a2));
            h2 = h2.nextInRow();
        }
    }
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
            pred = caf.replaceAll(inputRelation, predicate, row);
//            for (int i = 1; i <= inputRelation.getCardinality(); i++) {
//                pred = pred.replaceAll(ESCAPE_SEQ + i, inputRelation.getCol(i).toString(caf)+row);
//            }

            Cell dummyCell = dummyRelation.getFirstCol().getCell(row);
            formulas.put(dummyCell, pred);

            String strDummyCell = dummyCell.toString(caf);
            Cell in = inputRelation.getFirstCol().getCell(row);
            Cell out = resultRelationToStandarize.getFirstCol().getCell(row);
            for (int i = 1; i <= inputRelation.getCardinality(); i++) {
                String strInputCell = inputRelation.getCol(i).getCell(row).toString(caf);
                formulas.put(out, fillIf(strInputCell, strDummyCell, in));
                out = out.nextInRow();
                in = in.nextInRow();
            }
        }

        StandarizationOperator standOper = new StandarizationOperator(caf, resultRelationToStandarize);
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
                sbWklejka1row2.append(",");
                sbWklejka2.append(",");
            }
            Column r1Col = inputRelation1.getCol(i);
            Column r2Col = inputRelation2.getCol(i);
            Cell r1Cell1 = r1Col.getCell(1);
            Cell r1Cell2 = r1Col.getCell(2);
            sbWklejka1row1.append(fillInsert1(r2Col, r1Cell1));
            sbWklejka1row2.append(fillInsert1(r2Col, r1Cell2));
            sbWklejka2.append(fillInsert2(r1Col, r1Cell2));
        }
       
        Cell e1 = caf.getLeftTopCellInRelation(dummyRelation);
        Cell f1 = e1.nextInRow();
        Cell a1 = caf.getLeftTopCellInRelation(inputRelation1);
        formulas.put(e1, fillIf1(a1,sbWklejka1row1.toString()));
        formulas.put(f1, fillMatch(e1.getColumnO()));
               
        Cell gh1 = f1.nextInRow();
        for (int i = 1; i <= inputRelation1.getCardinality(); i++) {
            formulas.put(gh1, fillCopy(inputRelation1.getCol(i), f1));
            gh1 = gh1.nextInRow();
        }

        Cell e2 = e1.nextInColumn();
        Cell f2 = f1.nextInColumn();
        Cell a2 = a1.nextInColumn();
        formulas.put(e2,fillIf2(a2, sbWklejka2.toString(), sbWklejka1row2.toString(), e1));
        formulas.put(f2,fillMatch(e2.getColumnO()));
       
        Cell gh2 = f2.nextInRow();
        for (int i = 1; i <= inputRelation1.getCardinality(); i++) {
            formulas.put(gh2, fillCopy(inputRelation1.getCol(i), f2));
            gh2 = gh2.nextInRow();
        }
    }
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
        dummyRelation = caf.getSpaceForNewRelation(2);
        labelDummy(dummyRelation, "Duplicate Removal of "+inputRelation.toString(caf));
        resultRelation = caf.getSpaceForNewRelation(inputRelation.getCardinality());
        labelResult(resultRelation, "Duplicate Removal of "+inputRelation.toString(caf));

        Cell a1 = caf.getLeftTopCellInRelation(inputRelation);
        Cell c1 = caf.getLeftTopCellInRelation(dummyRelation);
        Cell d1 = c1.nextInRow();
        Column c = dummyRelation.getFirstCol();
        String strC = c.toString(caf);
        String strMATCH = String.format(MATCH, strC, strC);
        String strD1 = d1.toString(caf);
        formulas.put(c1, String.format(FR_IF, a1.toString(caf)));
        formulas.put(d1, strMATCH);

        Cell ef1 = d1.nextInRow();
        for (Column ab : inputRelation) {
            String strAb = ab.toString(caf);
            formulas.put(ef1, String.format(INDEX, strAb, strAb, strD1));
            ef1 = ef1.nextInRow();
        }

        Cell a2 = a1.nextInColumn();
        Cell c2 = c1.nextInColumn();
        Cell d2 = d1.nextInColumn();
        String strC1 = c1.toString(caf);
        StringBuilder sb = new StringBuilder(String.format(SR_TO_REPEAT, a1.getColumnO().toString(caf), a1.getRowO().toString(caf), a2.toString(caf), a2.toString(caf)));
        boolean skipFirst = true;
        for (Column ab : inputRelation) {
            if (skipFirst) {
                skipFirst = false;
                continue;
            }
            Cell cell1 = new Cell(ab, new Row(1));
            Cell cell2 = cell1.nextInColumn();
            sb.append(",");
            sb.append(String.format(SR_TO_REPEAT, cell1.getColumnO().toString(caf), cell1.getRowO().toString(caf), cell2.toString(caf), cell2.toString(caf)));
        }

        formulas.put(c2, String.format(SR_IF, a2.toString(caf), sb.toString(), strC1, strC1));
        formulas.put(d2, strMATCH);

        Cell ef2 = d1.nextInRow().nextInColumn();
        String strD2 = d1.nextInColumn().toString(caf);
        for (Column ab : inputRelation) {
            String strAb = ab.toString(caf);
            formulas.put(ef2, String.format(INDEX, strAb, strAb, strD2));
            ef2 = ef2.nextInRow();
        }

    }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
        dummyRelation = caf.getEmptyRelation();
        resultRelation = caf.getSpaceForNewRelation(inputRelation1.getCardinality());
        labelResult(resultRelation, "Semi Join of "+ inputRelation1.toString(caf) + " and " + inputRelation2.toString(caf));

        for (int row = 1; row <= 2; row++) {
            Cell keyResult = resultRelation.getFirstCol().getCell(row);
            Cell keyFirstRel = inputRelation1.getCol(index1).getCell(row);
            Column keyColSecondRel = inputRelation2.getCol(index2);
            formulas.put(keyResult, fillIf(keyFirstRel, keyColSecondRel));

            Cell res = keyResult.nextInRow();
            int i = 1;
            for (Column c : inputRelation1) {
                if (i++ == index1) {
                    continue;
                }
                formulas.put(res, fillCopy(keyResult, c.getCell(row)));
                res = res.nextInRow();
            }
        }
    }
View Full Code Here
TOP

Related Classes of core.Cell

  • com.jacobpatterson.csci446.program1.core.agents.KonaneUI
  • operators.CartesianProductOperator
  • operators.DifferenceBagOperator
  • operators.DifferenceOperatorTest
  • operators.DifferenceSetOperator
  • operators.DuplicateRemovalOperator
  • operators.DuplicateRemovalOperatorTest
  • operators.FilterOperator
  • operators.SemiJoinOperator
  • operators.SortingOperator
    • 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.