Android Open Source - StockTicker Query Creator

From Project

Back to project page StockTicker.

License

The source code is released under:

MIT License

If you think the Android project StockTicker listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package com.github.premnirmal.ticker.network;
//from   w w w . j av  a  2s .c  o m
import org.joda.time.DateTime;
import org.joda.time.format.DateTimeFormat;
import org.joda.time.format.DateTimeFormatter;

/**
 * Created by premnirmal on 12/30/14.
 */
public class QueryCreator {


    public final static DateTimeFormatter formatter = DateTimeFormat.forPattern("yyyy-MM-dd");

    public static String buildStocksQuery(Object[] objects) {
        final StringBuilder commaSeparator = new StringBuilder();
        for (Object object : objects) {
            final String ticker = object.toString().replace("^", "")
                    .replaceAll(" ", "").trim();
            if (ticker.length() < 10) {
                commaSeparator.append(ticker);
                commaSeparator.append(',');
            }
        }
        if (objects.length > 0) {
            commaSeparator.deleteCharAt(commaSeparator.length() - 1);
        }

        return "select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(\"" + commaSeparator.toString() + "\")";
    }

    public static String buildHistoricalDataQuery(String ticker, DateTime start, DateTime end) {
        final StringBuilder stringBuilder = new StringBuilder();
        stringBuilder.append("select%20*%20from%20yahoo.finance.historicaldata%20where%20symbol%20%3D%20%22");
        stringBuilder.append(ticker);
        stringBuilder.append("%22%20and%20startDate%20%3D%20%22");
        stringBuilder.append(formatter.print(start));
        stringBuilder.append("%22%20and%20endDate%20%3D%20%22");
        stringBuilder.append(formatter.print(end));
        stringBuilder.append("%22");
        return stringBuilder.toString();
    }
}

Java Source Code List