public static void viewAd(String id) {
Ad ad = Ad.findById(Long.parseLong(id));
List<Category> cats = Category.find("categorytype_id=?1 order by id", "1").fetch();
EntityManager entityManager = play.db.jpa.JPA.em();
List<BigInteger> bCounts =
entityManager
.createNativeQuery(
"select count(*) as maxCount from Ad as a group by category_id order by maxCount")
.getResultList();
int min = bCounts.get(0).intValue();
int max = bCounts.get(bCounts.size() - 1).intValue();
bCounts =
entityManager
.createNativeQuery(
"select count(*) as maxCount from Ad as a group by category_id order by category_id ")
.getResultList();
List<String> fonts = new ArrayList<String>();
for (int i = 0; i < bCounts.size(); i++) {
BigInteger count = bCounts.get(i);
int x = Ads.getFontSize(count.intValue(), min, max);
fonts.add(String.valueOf(x));
}
render(ad, fonts, min, max, cats);
}
// -------------------------------------+
@Test
public void findRepostByUsers_Entity_単数_00() {
User usr1 = User.findBySerialCode("usr-goro").first();
List<RepostBase> lst = RepostBase.findRepostByUsers(usr1).fetch();
assertThat(lst.size(), is(4));
// DBからの取得リストの並び保証なし
}
private static void addProjectNotDupped(List<Project> target, List<Project> foundProjects) {
for (Project project : foundProjects) {
if (!target.contains(project)) {
target.add(project);
}
}
}
@Test
public void postComments() {
// Create a new user and save it
User bob = new User("*****@*****.**", "secret", "Bob").save();
// Create a new post
Post bobPost = new Post(bob, "My first post", "Hello world").save();
// Post a first comment
new Comment(bobPost, "Jeff", "Nice Post").save();
new Comment(bobPost, "Tom", "I knew that !").save();
// Retrieve all comments
List<Comment> bobPostComments = Comment.find("byPost", bobPost).fetch();
// Tests
assertEquals(2, bobPostComments.size());
Comment firstComment = bobPostComments.get(0);
assertNotNull(firstComment);
assertEquals("Jeff", firstComment.author);
assertEquals("Nice Post", firstComment.content);
assertNotNull(firstComment.postedAt);
Comment secondComment = bobPostComments.get(1);
assertNotNull(secondComment);
assertEquals("Tom", secondComment.author);
assertEquals("I knew that !", secondComment.content);
assertNotNull(secondComment.postedAt);
}
public static Result start() {
java.util.Map<String, String[]> map = request().body().asFormUrlEncoded();
List<String> terms = new ArrayList<>(map.size());
for (int i = 0; i < map.size(); i++) {
String key = "terms[" + i + "]";
if (map.containsKey(key)) {
String[] values = map.get(key);
if ((values != null) && (values.length >= 1)) {
terms.add(values[0]);
}
}
}
StreamConfig config = getConfig();
config.putTerms(terms);
config.update();
StringBuilder sb = new StringBuilder();
for (String t : terms) {
sb.append(t);
sb.append(", ");
}
sb.delete(sb.length() - 2, sb.length());
try {
startStream(terms);
flash("success", "Twitter stream started (" + sb.toString() + ")");
} catch (TwitterException e) {
Logger.info("Error starting twitter stream", e);
flash("error", "Error starting Twitter stream" + e.getMessage());
}
return redirect(routes.Streams.listAll());
}
public static void showPicasaGallery(Long id, String name) {
notFoundIfNull(id);
PicasaGallery gallery = PicasaGallery.findById(id);
notFoundIfNull(gallery);
PicasawebService service = new PicasawebService("portfolio");
List<PhotoEntry> photoEntries = Collections.emptyList();
try {
java.net.URL feedUrl = new java.net.URL(gallery.getFeedUrl());
AlbumFeed feed = service.getFeed(feedUrl, AlbumFeed.class);
photoEntries = feed.getPhotoEntries();
} catch (MalformedURLException e) {
Logger.error("Service URL for Picasa is not well formed");
e.printStackTrace();
} catch (IOException e) {
Logger.error("Error I/O while communicating with Picasa Service");
e.printStackTrace();
} catch (ServiceException e) {
Logger.error("Picasa service error");
e.printStackTrace();
}
List<ImageView> images = new ArrayList<ImageView>();
for (PhotoEntry entry : photoEntries) {
ImageView image = new ImageView();
// We take the largest
image.thumbnail =
entry.getMediaThumbnails().get(entry.getMediaThumbnails().size() - 1).getUrl();
image.url = entry.getMediaContents().get(0).getUrl();
images.add(image);
}
render("Application/gallery.html", images, gallery);
}
// -------------------------------------+
@Test
public void findRepostByCategories_Entity_単数_00() {
Category cat1 = Category.findBySerialCode("cat-biz").first();
List<RepostBase> lst = RepostBase.findRepostByCategories(cat1).fetch();
assertThat(lst.size(), is(2));
// DBからの取得リストの並び保証なし
}
// -------------------------------------+
@Test
public void findRepostByTags_Entity_単数_00() {
Tag tag1 = Tag.findBySerialCode("tag-goro-red").first();
List<RepostBase> lst = RepostBase.findRepostByTags(tag1).fetch();
assertThat(lst.size(), is(3));
// DBからの取得リストの並び保証なし
}
@Test
public void findRepostByTags_String_単数_投稿者_00() {
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst = RepostBase.findRepostByTags("tag-goro-red").contributor(acnt).fetch();
assertThat(lst.size(), is(3));
// DBからの取得リストの並び保証なし
}
// -------------------------------------+
@Test
public void findRepostByAccounts_Entity_単数_00() {
Account acnt1 = Account.findByLoginName("goro_san").first();
List<RepostBase> lst = RepostBase.findRepostByAccounts(acnt1).fetch();
assertThat(lst.size(), is(17));
// DBからの取得リストの並び保証なし
}
// -------------------------------------+
@Test
public void findRepostByTweets_Entity_単数_00() {
Tweet twt1 = Tweet.findBySerialCode("twt-goro2").first();
List<RepostBase> lst = RepostBase.findRepostByTweets(twt1).fetch();
assertThat(lst.size(), is(4));
// DBからの取得リストの並び保証なし
}
// -------------------------------------+
@Test
public void findRepostByUsers_Entity_単数_投稿者_00() {
User usr1 = User.findBySerialCode("usr-goro").first();
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst = RepostBase.findRepostByUsers(usr1).contributor(acnt).fetch();
assertThat(lst.size(), is(2));
// DBからの取得リストの並び保証なし
}
@Test
public void findRepostByTweets_String_複数_投稿者_00() {
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst =
RepostBase.findRepostByTweets("twt-goro2", "twt-jiro1").contributor(acnt).fetch();
assertThat(lst.size(), is(5));
// DBからの取得リストの並び保証なし
}
// -------------------------------------+
@Test
public void findRepostByTweets_Entity_単数_投稿者_00() {
Tweet twt1 = Tweet.findBySerialCode("twt-goro2").first();
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst = RepostBase.findRepostByTweets(twt1).contributor(acnt).fetch();
assertThat(lst.size(), is(2));
// DBからの取得リストの並び保証なし
}
public StockPrice[] getStocks() {
List<Stock> stocks = Stock.findAll();
StockPrice[] prices = new StockPrice[stocks.size()];
for (int i = 0; i < stocks.size(); i++) {
prices[i] = stocks.get(i).asStockPrice();
}
return prices;
}
// -------------------------------------+
@Test
public void findRepostByCategories_Entity_単数_投稿者_00() {
Category cat1 = Category.findBySerialCode("cat-biz").first();
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst = RepostBase.findRepostByCategories(cat1).contributor(acnt).fetch();
assertThat(lst.size(), is(2));
// DBからの取得リストの並び保証なし
}
@Test
public void findRepostByCategories_String_複数_投稿者_00() {
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst =
RepostBase.findRepostByCategories("cat-biz", "cat-enta").contributor(acnt).fetch();
assertThat(lst.size(), is(3));
// DBからの取得リストの並び保証なし
}
@Test
public void findRepostByAccounts_String_複数_降順_00() {
List<RepostBase> lst =
RepostBase.findRepostByAccounts("usr-goro", "usr-jiro")
.orderBy(RepostBase.OrderBy.DATE_OF_REPOST_DESC)
.fetch();
assertThat(lst.size(), is(24));
assertThat(lst.get(0).contributor.loginUser.screenName, is("goro_san"));
}
@Test
public void findRepostByTags_Entity_複数_投稿者_00() {
Tag tag1 = Tag.findBySerialCode("tag-goro-red").first();
Tag tag2 = Tag.findBySerialCode("tag-jiro-hello").first();
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst = RepostBase.findRepostByTags(tag1, tag2).contributor(acnt).fetch();
assertThat(lst.size(), is(3));
// DBからの取得リストの並び保証なし
}
public static void index() {
List<Verify> verifies = Verify.findAll();
if (verifies.size() > 0) {
render(verifies);
} else {
String message = "There is no upload need to be verified.";
render(verifies, message);
}
}
// -------------------------------------+
@Test
public void findRepostByAccounts_Entity_単数_降順_00() {
Account acnt1 = Account.findByLoginName("goro_san").first();
List<RepostBase> lst =
RepostBase.findRepostByAccounts(acnt1)
.orderBy(RepostBase.OrderBy.DATE_OF_REPOST_DESC)
.fetch();
assertThat(lst.size(), is(17));
assertThat(lst.get(0).contributor.loginUser.screenName, is("goro_san"));
}
private static void showPage(String custId, String errMsg) {
// Obviously this is inefficient -- the list of customer and products never changes,
// so we could cache it.
List<Customer> customers = Customer.find("order by name").fetch();
List<Product> products = Product.find("order by name").fetch();
Customer currentCustomer;
if (custId == null || custId.trim().length() == 0) currentCustomer = customers.get(0);
else currentCustomer = Customer.findById(new Long(custId));
renderTemplate("Application/index.html", customers, currentCustomer, products, errMsg);
}
@Test
public void findRepostByTags_String_複数_投稿者_降順_00() {
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst =
RepostBase.findRepostByTags("tag-goro-red", "tag-jiro-hello")
.contributor(acnt)
.orderBy(RepostBase.OrderBy.DATE_OF_REPOST_DESC)
.fetch();
assertThat(lst.size(), is(3));
assertThat(lst.get(0).getLabel().serialCode, is("tag-goro-red"));
}
public static void showGallery(Long id, String name) {
notFoundIfNull(id);
Gallery gallery = Gallery.findById(id);
notFoundIfNull(gallery);
List<Picture> pictures = gallery.getPictures();
List<ImageView> images = new ArrayList<ImageView>();
for (Picture picture : pictures) images.add(picture.toImageView());
render("Application/gallery.html", images, gallery);
}
@Test
public void findRepostByCategories_String_複数_投稿者_降順_00() {
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst =
RepostBase.findRepostByCategories("cat-biz", "cat-enta")
.contributor(acnt)
.orderBy(RepostBase.OrderBy.DATE_OF_REPOST_DESC)
.fetch();
assertThat(lst.size(), is(3));
assertThat(lst.get(0).getLabel().serialCode, is("cat-biz"));
}
@Test
public void findRepostByTweets_String_複数_投稿者_降順_00() {
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst =
RepostBase.findRepostByTweets("twt-goro2", "twt-jiro1")
.contributor(acnt)
.orderBy(RepostBase.OrderBy.DATE_OF_REPOST_DESC)
.fetch();
assertThat(lst.size(), is(5));
assertThat(lst.get(0).getItem().serialCode, is("twt-jiro1"));
}
// -------------------------------------+
@Test
public void findRepostByUsers_Entity_単数_投稿者_降順_00() {
User usr1 = User.findBySerialCode("usr-goro").first();
Account acnt = Account.findByLoginName("goro_san").first();
List<RepostBase> lst =
RepostBase.findRepostByUsers(usr1)
.contributor(acnt)
.orderBy(RepostBase.OrderBy.DATE_OF_REPOST_DESC)
.fetch();
assertThat(lst.size(), is(2));
assertThat(lst.get(0).getItem().serialCode, is("usr-goro"));
}
public TweetListener(List<String> terms, Client esClient, String esIndex, String esType) {
this.terms = terms;
this.esClient = esClient;
StringBuilder query = new StringBuilder();
for (int i = 0; i < terms.size(); i++) {
if (i > 0) query.append("|");
// query.append("(").append(Pattern.quote(terms.get(i))).append(")");
// query.append("(").append(terms.get(i)).append(")");
query.append(terms.get(i));
}
Logger.info("Query match pattern: " + query.toString());
this.matchPattern = Pattern.compile(query.toString(), Pattern.CASE_INSENSITIVE);
Logger.info("Query match pattern: " + matchPattern.toString());
}
public static void ajaxDeleteDocument(Long documentId) {
// If it is not the root document we are going to delete
if (documentId != 0L) {
Document document = Document.findById(documentId);
List<Document> children =
Document.find("select p from Document p where p.parentId=?", document.id).fetch();
// If target document contains children documents
// then remove all children, don't leave scala documents
int i = 0;
for (i = 0; i < children.size(); i++) {
children.get(i).delete();
}
document.delete();
}
}
/**
* 메일 발송 페이지로 이동한다.
*
* <p>when 관리자 메일 발송페이지
*
* <p>{@code application.conf}에서 SMTP 관련 설정을 가져온다. {@code requiredItems} 중 설정되지 않은 item을 {@code
* notConfiguredItems}에 저장하고 페이지에 전달한다. 메일 sender는 {@code smtp.user}@{@code smtp.domain} 값으로 구성된다.
*
* @param errorMessage 메일 발송 오류메세지
* @param sended 메일 발송여부
* @return the result
*/
public static Result writeMail(String errorMessage, boolean sended) {
Configuration config = play.Play.application().configuration();
List<String> notConfiguredItems = new ArrayList<>();
String[] requiredItems = {"smtp.host", "smtp.user", "smtp.password"};
for (String key : requiredItems) {
if (config.getString(key) == null) {
notConfiguredItems.add(key);
}
}
String sender = config.getString("smtp.user") + "@" + config.getString("smtp.domain");
return ok(mail.render("title.sendMail", notConfiguredItems, sender, errorMessage, sended));
}
