Package com.avaje.ebeaninternal.server.deploy

Examples of com.avaje.ebeaninternal.server.deploy.TableJoin

43
44
45
46
47
48
49
50
51
52
53
54
55
56
    if (p.isManyToMany()) {
      if (p.getMappedBy() != null) {
        // only create on other 'owning' side

      } else {
        TableJoin intersectionTableJoin = p.getIntersectionTableJoin();

        // check if the intersection table has already been created
        String intTable = intersectionTableJoin.getTable();
        if (ctx.isProcessIntersectionTable(intTable)) {
          // build the create table and fkey constraints
          // putting the DDL into ctx for later output as we are
          // in the middle of rendering the create table DDL
          new CreateIntersectionTable(ctx, p).build();
View Full Code Here
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
      // alter table {basetable} add foreign key (...) references {} (...) on delete restrict on update restrict;
      // Alter table o_address add Foreign Key (country_code) references o_country (code) on delete  restrict on update  restrict;

      String baseTable = p.getBeanDescriptor().getBaseTable();

      TableJoin tableJoin = p.getTableJoin();

      TableJoinColumn[] columns = tableJoin.columns();


      String tableName = p.getBeanDescriptor().getBaseTable();
      String fkName = ctx.getDdlSyntax().getForeignKeyName(tableName, p.getName(), ctx.incrementFkCount());
 
      ctx.write("alter table ").write(baseTable).write(" add ");
      if (fkName != null) {
        ctx.write("constraint ").write(fkName).write(" ");
      }
      ctx.write("foreign key (");
      for (int i = 0; i < columns.length; i++) {
        if (i > 0){
          ctx.write(",");
        }
        ctx.write(columns[i].getLocalDbColumn());
      }
      ctx.write(")");

      ctx.write(" references ");
      ctx.write(tableJoin.getTable());
      ctx.write(" (");
      for (int i = 0; i < columns.length; i++) {
        if (i > 0){
          ctx.write(",");
        }
View Full Code Here
387
388
389
390
391
392
393
394
395
396
397
398
399
400
  private void appendSelectTableJoins(DbSqlContext ctx) {

    String baseAlias = ctx.getTableAlias(prefix);

    for (int i = 0; i < tableJoins.length; i++) {
      TableJoin join = tableJoins[i];

      String alias = baseAlias + i;

      ctx.pushSecondaryTableAlias(alias);
      join.appendSelect(ctx, false);
      ctx.popTableAlias();
    }
  }
View Full Code Here
487
488
489
490
491
492
493
494
495
496
497
498
        String alias = ctx.getTableAlias(prefix);
        String[] split = SplitName.split(prefix);
        String parentAlias = ctx.getTableAlias(split[0]);
        String alias2 = alias + "z_";

        TableJoin manyToManyJoin = manyProp.getIntersectionTableJoin();
        manyToManyJoin.addJoin(joinType, parentAlias, alias2, ctx);

        return nodeBeanProp.addJoin(joinType, alias2, alias, ctx);
      }

    }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
        String alias = ctx.getTableAlias(prefix);
        String[] split = SplitName.split(prefix);
        String parentAlias = ctx.getTableAlias(split[0]);
        String alias2 = alias+"z_";
       
        TableJoin manyToManyJoin = manyProp.getIntersectionTableJoin();
        manyToManyJoin.addJoin(joinType, parentAlias, alias2, ctx);
       
        assocBeanProperty.addJoin(joinType, alias2, alias, ctx);
      }
    }
       
View Full Code Here
102
103
104
105
106
107
108
109
110
    }
   
    List<DeployTableJoin> deployTableJoins = deploy.getTableJoins();
    tableJoins = new TableJoin[deployTableJoins.size()];
    for (int i = 0; i < deployTableJoins.size(); i++) {
      tableJoins[i] = new TableJoin(deployTableJoins.get(i), propertyMap);
    }

  }
View Full Code Here
113
114
115
116
117
118
119
120
121
122
  /**
   * Create the immutable version of the intersection join.
   */
  public TableJoin createIntersectionTableJoin() {
    if (intersectionJoin != null){
      return new TableJoin(intersectionJoin, null);
    } else {
      return null;
    }
  }
View Full Code Here
124
125
126
127
128
129
130
131
132
133
  /**
   * Create the immutable version of the inverse join.
   */
  public TableJoin createInverseTableJoin() {
    if (inverseJoin != null){
      return new TableJoin(inverseJoin, null);
    } else {
      return null;
    }
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
                manyProp.addJoin(joinType, parentAlias, alias, ctx);
   
            } else {
                String alias2 = alias + "z_";
   
                TableJoin manyToManyJoin = manyProp.getIntersectionTableJoin();
                manyToManyJoin.addJoin(joinType, parentAlias, alias2, ctx);
                manyProp.addJoin(joinType, alias2, alias, ctx);
            }
        }
    }
View Full Code Here
TOP

Related Classes of com.avaje.ebeaninternal.server.deploy.TableJoin

  • com.avaje.ebeaninternal.server.ddl.AddForeignKeysVisitor$FkeyPropertyVisitor
  • com.avaje.ebeaninternal.server.ddl.CreateTableColumnVisitor
  • com.avaje.ebeaninternal.server.deploy.meta.DeployBeanPropertyAssocMany
  • com.avaje.ebeaninternal.server.deploy.meta.DeployBeanPropertyLists
  • com.avaje.ebeaninternal.server.query.SqlTreeNodeBean
  • com.avaje.ebeaninternal.server.query.SqlTreeNodeExtraJoin
  • com.avaje.ebeaninternal.server.query.SqlTreeNodeManyWhereJoin
    • 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.