private void setUpUserToProducts() {
try {
UserToProduct UserToProduct = utptd.insertUserToProductTable1();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable2();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable3();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable4();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable5();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable6();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable7();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable8();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable9();
mySqlUserToProduct.create(UserToProduct);
} catch (Exception e) {
e.printStackTrace();
}
}
public void createTables() throws Exception {
System.out.println("SetUpTables createTables");
mySqlProduct = TableFactory.getTable(TableEnum.PRODUCT);
mySqlRegisteredUser = TableFactory.getTable(TableEnum.REGISTERED_USER);
mySqlUserToProduct = TableFactory.getTable(TableEnum.USER_TO_PRODUCT);
try {
mySqlProduct.dropTable();
mySqlRegisteredUser.dropTable();
mySqlUserToProduct.dropTable();
} catch (Exception e) {
// ignore if no table found
}
mySqlProduct.createTable();
mySqlRegisteredUser.createTable();
mySqlUserToProduct.createTable();
System.out.println("SetUpTables set up product");
Product product = ptd.setUpProduct1();
mySqlProduct.create(product);
product = ptd.setUpProduct2();
mySqlProduct.create(product);
product = ptd.setUpProduct3();
mySqlProduct.create(product);
product = ptd.setUpProduct4();
mySqlProduct.create(product);
product = ptd.setUpProduct5();
mySqlProduct.create(product);
product = ptd.setUpProduct6();
mySqlProduct.create(product);
System.out.println("SetUpTables set up registered user");
RegisteredUser registeredUser = rutd.setUpRegisteredUser1();
mySqlRegisteredUser.create(registeredUser);
registeredUser = rutd.setUpRegisteredUser2();
mySqlRegisteredUser.create(registeredUser);
registeredUser = rutd.setUpRegisteredUser3();
mySqlRegisteredUser.create(registeredUser);
registeredUser = rutd.setUpRegisteredUser4();
mySqlRegisteredUser.create(registeredUser);
registeredUser = rutd.setUpRegisteredUser5();
mySqlRegisteredUser.create(registeredUser);
registeredUser = rutd.setUpRegisteredUser6();
mySqlRegisteredUser.create(registeredUser);
registeredUser = rutd.setUpRegisteredUser7();
mySqlRegisteredUser.create(registeredUser);
registeredUser = rutd.setUpRegisteredUser8();
mySqlRegisteredUser.create(registeredUser);
registeredUser = rutd.setUpRegisteredUser9();
mySqlRegisteredUser.create(registeredUser);
System.out.println("SetUpTables set up user to product");
UserToProduct UserToProduct = utptd.insertUserToProductTable1();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable2();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable3();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable4();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable5();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable6();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable7();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable8();
mySqlUserToProduct.create(UserToProduct);
UserToProduct = utptd.insertUserToProductTable9();
mySqlUserToProduct.create(UserToProduct);
}