Package org.jtester.module.dbfit.db.model

Examples of org.jtester.module.dbfit.db.model.DbParameterAccessor

73
74
75
76
77
78
79
80
81
82
83
      while (rs.next()) {
        String paramName = rs.getString(1);
        if (paramName == null)
          paramName = "";
        String dataType = rs.getString(2);
        DbParameterAccessor dbp = new DbParameterAccessor(paramName, DbParameterAccessor.INPUT,
            getSqlType(dataType), getJavaClass(dataType), position++);
        allParams.put(NameNormaliser.normaliseName(paramName), dbp);
      }

      return allParams;
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
          token = s.nextToken();
        }
        String paramName = token;
        String dataType = s.nextToken();

        DbParameterAccessor dbp = new DbParameterAccessor(paramName, direction, getSqlType(dataType),
            getJavaClass(dataType), position++);
        allParams.put(NameNormaliser.normaliseName(paramName), dbp);
      }
      if ("FUNCTION".equals(type)) {
        StringTokenizer s = new StringTokenizer(returns.trim().toLowerCase(), " ()");
        String dataType = s.nextToken();
        allParams.put("", new DbParameterAccessor("", DbParameterAccessor.RETURN_VALUE, getSqlType(dataType),
            getJavaClass(dataType), -1));
      }
      return allParams;
    } finally {
      DBHelper.closeResultSet(rs);
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
        int paramDirection;
        if (paramName.trim().length() == 0)
          paramDirection = DbParameterAccessor.RETURN_VALUE;
        else
          paramDirection = getParameterDirection(direction);
        DbParameterAccessor dbp = new DbParameterAccessor(paramName, paramDirection, getSqlType(dataType),
            getJavaClass(dataType), position++);
        allParams.put(NameNormaliser.normaliseName(paramName), dbp);
      }
      return allParams;
    } finally {
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
          paramName = "";
        String dataType = rs.getString(2);
        // int length=rs.getInt(3);
        String direction = rs.getString(4);
        int paramDirection = getParameterDirection(direction);
        DbParameterAccessor dbp = new DbParameterAccessor(paramName, paramDirection, getSqlType(dataType),
            getJavaClass(dataType), paramDirection == DbParameterAccessor.RETURN_VALUE ? -1 : position++);
        allParams.put(NameNormaliser.normaliseName(paramName), dbp);
      }
      return allParams;
    } finally {
View Full Code Here
240
241
242
243
244
245
246
247
248
249
250
          paramDirection = DbParameterAccessor.RETURN_VALUE;
        } else {
          paramDirection = getParameterDirection(direction);
        }

        DbParameterAccessor dbp = new DbParameterAccessor(paramName, paramDirection, getSqlType(dataType),
            getJavaClass(dataType), paramDirection == DbParameterAccessor.RETURN_VALUE ? -1 : position++);
        allParams.put(NameNormaliser.normaliseName(paramName), dbp);
      }
      return allParams;
    } finally {
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
      Map<String, DbParameterAccessor> allParams = new HashMap<String, DbParameterAccessor>();
      int position = 0;
      while (rs.next()) {
        String columnName = rs.getString(1);
        String dataType = rs.getString(2);
        DbParameterAccessor dbp = new DbParameterAccessor(columnName, DbParameterAccessor.INPUT,
            typeMapper.getJDBCSQLTypeForDBType(dataType), getJavaClass(dataType), position++);
        allParams.put(NameNormaliser.normaliseName(columnName), dbp);
      }
      return allParams;
    } finally {
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
      if (accessors[i] == null)
        throw new SQLException("Cannot find parameter for column " + i + " name=\"" + paramName + "\"");
      boolean isOutput = headerCells.text().endsWith("?");
      if (accessors[i].getDirection() == DbParameterAccessor.INPUT_OUTPUT) {
        // clone, separate into input and output
        accessors[i] = new DbParameterAccessor(accessors[i]);
        accessors[i].setDirection(isOutput ? DbParameterAccessor.OUTPUT : DbParameterAccessor.INPUT);
      }
      if (isOutput) {
        columnBindings[i] = new SymbolAccessQueryBinding();
      } else {
        // sql server quirk. if output parameter is used in an input
        // column, then
        // the param should be cloned and remapped to IN/OUT
        if (accessors[i].getDirection() == DbParameterAccessor.OUTPUT) {
          accessors[i] = new DbParameterAccessor(accessors[i]);
          accessors[i].setDirection(DbParameterAccessor.INPUT);
        }
        columnBindings[i] = new SymbolAccessSetBinding();
      }
      columnBindings[i].adapter = accessors[i];
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
    for (int i = 0; headerCells != null; i++, headerCells = headerCells.more) {
      String name = headerCells.text();
      String paramName = NameNormaliser.normaliseName(name);
      // need to clone db param accessors here because same column may be
      // in the update and select part
      DbParameterAccessor orig = allParams.get(paramName);
      if (orig == null) {
        wrong(headerCells);
        throw new SQLException("Cannot find column " + paramName);
      }
      // clone parameter because there may be multiple usages of the same
      // column
      DbParameterAccessor acc = new DbParameterAccessor(orig);
      acc.setDirection(DbParameterAccessor.INPUT);
      if (headerCells.text().endsWith("="))
        updateAcc.add(acc);
      else
        selectAcc.add(acc);
      columnBindings[i] = new SymbolAccessSetBinding();
View Full Code Here
TOP

Related Classes of org.jtester.module.dbfit.db.model.DbParameterAccessor

  • org.jtester.module.database.environment.impl.DB2Environment
  • org.jtester.module.database.environment.impl.DerbyEnvironment
  • org.jtester.module.database.environment.impl.MySqlEnvironment
  • org.jtester.module.database.environment.impl.OracleEnvironment
  • org.jtester.module.database.environment.impl.SqlServerEnvironment
  • org.jtester.module.database.environment.normalise.TypeNormaliser
  • org.jtester.module.dbfit.db.fixture.ExecuteProcedureFixture
  • org.jtester.module.dbfit.db.fixture.UpdateFixture
  • java.lang.reflect.InvocationTargetException
  • java.io.InputStream
    • 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.