forked from sqlancer/sqlancer
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathSparkTableGenerator.java
More file actions
87 lines (74 loc) · 2.86 KB
/
Copy pathSparkTableGenerator.java
File metadata and controls
87 lines (74 loc) · 2.86 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
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
85
86
87
package sqlancer.spark.gen;
import java.util.ArrayList;
import java.util.List;
import sqlancer.Randomly;
import sqlancer.common.DBMSCommon;
import sqlancer.common.gen.AbstractTableGenerator;
import sqlancer.common.query.SQLQueryAdapter;
import sqlancer.spark.SparkErrors;
import sqlancer.spark.SparkGlobalState;
import sqlancer.spark.SparkSchema;
import sqlancer.spark.SparkSchema.SparkColumn;
import sqlancer.spark.SparkSchema.SparkDataType;
import sqlancer.spark.SparkSchema.SparkTable;
import sqlancer.spark.SparkToStringVisitor;
public class SparkTableGenerator extends AbstractTableGenerator<SparkColumn> {
private enum ColumnConstraints {
NOT_NULL, DEFAULT
}
private final SparkGlobalState globalState;
private final String tableName;
private final SparkExpressionGenerator gen;
private final SparkTable table;
private final List<SparkColumn> columnsToBeAdded = new ArrayList<>();
public SparkTableGenerator(SparkGlobalState globalState, String tableName) {
this.tableName = tableName;
this.globalState = globalState;
this.table = new SparkTable(tableName, columnsToBeAdded, false);
this.gen = new SparkExpressionGenerator(globalState).setColumns(columnsToBeAdded);
this.canAffectSchema = true;
this.canonicalizeString = false;
}
public static SQLQueryAdapter generate(SparkGlobalState globalState, String tableName) {
return new SparkTableGenerator(globalState, tableName).getStatement();
}
@Override
public void buildStatement() {
int columnCount = Randomly.smallNumber() + 1;
for (int i = 0; i < columnCount; i++) {
String columnName = DBMSCommon.createColumnName(i);
SparkDataType type = SparkSchema.SparkDataType.getRandomType();
columnsToBeAdded.add(new SparkColumn(columnName, table, type));
}
appendCreateTable(globalState.getDatabaseName() + "." + tableName);
sb.append(" ");
appendColumnDefinitions(columnsToBeAdded);
sb.append(" USING PARQUET");
SparkErrors.addExpressionErrors(errors);
}
@Override
protected void appendColumnDefinition(SparkColumn column) {
sb.append(column.getName());
sb.append(" ");
sb.append(column.getType());
appendColumnConstraint();
}
private void appendColumnConstraint() {
if (Randomly.getBoolean()) {
return;
}
ColumnConstraints constraint = Randomly.fromOptions(ColumnConstraints.values());
switch (constraint) {
case NOT_NULL:
sb.append(" NOT NULL");
break;
case DEFAULT:
sb.append(" DEFAULT ");
sb.append(SparkToStringVisitor.asString(gen.generateConstant()));
sb.append(" ");
break;
default:
throw new AssertionError(constraint);
}
}
}