public static void withMap(String companyId) {
Company company = Company.findById(companyId);
Project project = new Project();
project.companies = new HashMap();
project.companies.put(company.name, company);
project.create();
render("@show", project);
}
/**
* This uses a native query because you can't use the DATE() function in MySQL in a JPA query
*
* @param start startDate
* @param end endDate end date ( uses the whole day via DateUtil.getNextDay() )
* @param c Company
* @param campaign Campaign (optional)
* @param device Device (optional)
* @return
*/
@Override
public List<BluetoothFileSendSummary> getBluetoothFileSendSummaryFromBluetoothSend(
Date start, Date end, Company company, Campaign campaign, Device device) {
int count = 4;
HashMap<Integer, Object> parameters = new HashMap<Integer, Object>();
String query =
"SELECT DATE(event_date), file, count(*) "
+ "FROM bluetooth_send "
+ "WHERE send_status = 1 "
+ "AND company_id = ?1 "
+ "AND event_date BETWEEN ?2 AND ?3 ";
if (campaign != null) {
query += "AND campaign_id = ?" + count + " ";
parameters.put(count, campaign.getId());
count++;
}
if (device != null) {
query += "AND device_id = ?" + count + " ";
parameters.put(count, device.getId());
count++;
}
query += "GROUP BY file, DATE(event_date) ORDER BY DATE(event_date)";
Query q = em.createNativeQuery(query);
q.setParameter(1, company.getId());
q.setParameter(2, start);
q.setParameter(3, DateUtil.getNextDay(end));
for (Map.Entry<Integer, Object> entry : parameters.entrySet()) {
Integer position = entry.getKey();
Object param = entry.getValue();
q.setParameter(position, param);
}
List<BluetoothFileSendSummary> results = new ArrayList<BluetoothFileSendSummary>();
List<Object[]> result = q.getResultList();
for (Object[] object : result) {
Date eventDate = (Date) object[0];
String file = (String) object[1];
Long sendCount = (Long) object[2];
BluetoothFileSendSummary item = new BluetoothFileSendSummary();
item.setEventDate(eventDate);
item.setFile(file);
item.setSendCount(sendCount);
item.setCompany(company);
item.setCampaign(campaign);
item.setDevice(device);
results.add(item);
}
return results;
}
public void populate(DatabaseSession session) {
PopulationManager manager = PopulationManager.getDefaultManager();
Cat cat = Cat.example1();
session.writeObject(cat);
manager.registerObject(cat, "catExample1");
Dog dog = Dog.example1();
session.writeObject(dog);
manager.registerObject(dog, "dogExample1");
cat = Cat.example2();
session.writeObject(cat);
manager.registerObject(cat, "catExample2");
dog = Dog.example2();
session.writeObject(dog);
manager.registerObject(dog, "dogExample2");
cat = Cat.example3();
session.writeObject(cat);
manager.registerObject(cat, "catExample3");
dog = Dog.example3();
session.writeObject(dog);
manager.registerObject(dog, "dogExample3");
Company company = Company.example1();
session.writeObject(company);
manager.registerObject(company, "example1");
manager.registerObject(((Vector) company.getVehicles().getValue()).firstElement(), "example1");
company = Company.example2();
session.writeObject(company);
manager.registerObject(company, "example2");
company = Company.example3();
session.writeObject(company);
manager.registerObject(company, "example3");
Person person = Person.example1();
session.writeObject(person);
manager.registerObject(person, "example1");
// populate the data for duplicate field testing
session.writeObject(A_King2.exp1());
session.writeObject(A_King2.exp2());
session.writeObject(A_1_King2.exp3());
session.writeObject(A_2_King2.exp4());
session.writeObject(A_2_1_King2.exp5());
UnitOfWork unitOfWork = session.acquireUnitOfWork();
person = Person.example2();
unitOfWork.registerObject(person);
unitOfWork.commit();
manager.registerObject(person, "example2");
manager.registerObject(person.bestFriend, "example5");
manager.registerObject(person.representitive, "example4");
person = Person.example3();
session.writeObject(person);
manager.registerObject(person, "example3");
Computer computer = Computer.example1();
session.writeObject(computer);
manager.registerObject(computer, "example1");
computer = Computer.example2();
session.writeObject(computer);
manager.registerObject(computer, "example2");
computer = Computer.example3();
session.writeObject(computer);
manager.registerObject(computer, "example3");
computer = Computer.example4();
session.writeObject(computer);
manager.registerObject(computer, "example4");
computer = Computer.example5();
session.writeObject(computer);
manager.registerObject(computer, "example5");
JavaProgrammer JP = JavaProgrammer.example1();
session.writeObject(JP);
manager.registerObject(JP, "example1");
JP = JavaProgrammer.example2();
session.writeObject(JP);
manager.registerObject(JP, "example2");
// Added to test bug 3019934.
unitOfWork = session.acquireUnitOfWork();
Alligator alligator = new Alligator();
alligator.setFavoriteSwamp("Florida");
alligator.setLatestVictim(JavaProgrammer.steve());
unitOfWork.registerObject(alligator);
manager.registerObject(alligator, "example1");
unitOfWork.commit();
// Added to test bug 6111278
unitOfWork = session.acquireUnitOfWork();
Entomologist bugguy = new Entomologist();
bugguy.setId((int) System.currentTimeMillis());
bugguy.setName("Gary");
bugguy = (Entomologist) unitOfWork.registerObject(bugguy);
Insect insect = new GrassHopper();
insect.setIn_numberOfLegs(4);
insect.setEntomologist(bugguy);
bugguy.getInsectCollection().add(insect);
unitOfWork.commit();
}
public static void createCompany(Company company) {
company.create();
render(company);
}
