in spanner-data-validator-java/src/main/java/com/google/migration/TableSpecList.java [51:83]
public static List<TableSpec> getTableSpecs() {
ArrayList<TableSpec> tableSpecs = new ArrayList<>();
// Must use p1 and p2 here because that's what the query expression
// binder expects downstream
TableSpec spec = new TableSpec(
"member_events_type_mapping",
"select id, name, durationInDays from member_events_type_mapping where id >= ? and id < ?",
"select id, name, durationInDays from member_events_type_mapping where id >= @p1 "
+ " and id < @p2",
0,
BigDecimal.ONE,
TableSpec.LONG_FIELD_TYPE,
"0",
String.valueOf(Long.MAX_VALUE)
);
tableSpecs.add(spec);
spec = new TableSpec(
"member_events",
"select id, memberEventId, numericId, eventTypeId, eventCode, detail from member_events where id >= ? and id < ?",
"select id, memberEventId, numericId, eventTypeId, eventCode, detail from member_events where id >= @p1 "
+ " and id < @p2",
0,
BigDecimal.ONE,
TableSpec.LONG_FIELD_TYPE,
"0",
String.valueOf(Long.MAX_VALUE)
);
tableSpecs.add(spec);
return tableSpecs;
}