Changed Timezone

3 files changed, 555 insertions, 346 deletions

diff --git a/src/main/Analyzor.java b/src/main/Analyzor.java
index 0c3ede3..58f7dfc 100644
--- a/src/main/Analyzor.java
+++ b/src/main/Analyzor.java
@@ -1,345 +1,368 @@
-package main;

-

-import analysis.BrandChecker;

-import database.NamedPreparedStatement;

-import database.QueryUtils;

-import java.io.File;

-import java.io.FileNotFoundException;

-import java.io.IOException;

-import java.io.PrintWriter;

-import java.io.UnsupportedEncodingException;

-import java.sql.Connection;

-import java.sql.PreparedStatement;

-import java.sql.ResultSet;

-import java.sql.SQLException;

-import java.util.List;

-import java.util.HashMap;

-import java.util.Map.Entry;

-import java.util.Scanner;

-

-/**

- * The sentiment analysis class that rates tweets based on a unigram and bigram

- * set of weights.

- */

-public class Analyzor {

-

-    /**

-     * The map that matches single words to their weights.

-     */

-    private final HashMap<String, Double> unimap = new HashMap();

-

-    /**

-     * The map that matches word pairs to their weights.

-     */

-    private final HashMap<String, Double> bimap = new HashMap();

-

-    /**

-     * The results of a query, maybe return from query().

-     */

-    private ResultSet data;

-

-    /**

-     * The persistent connection to the database.

-     */

-    private final Connection connection;

-

-    /**

-     * @param connection An open connection to the database.

-     */

-    public Analyzor(Connection connection) {

-        this.connection = connection;

-    }

-

-    /**

-     * Read the unigram and bigram lexica.

-     *

-     * @throws FileNotFoundException

-     */

-    public void readLexicon() throws FileNotFoundException {

-        if (!unimap.isEmpty()) {

-            // data is already read.

-            return;

-        }

-        System.err.println("Trying to read lexicons...");

-        // A unigram is in the format (WS = whitespace):

-        // word <WS> rating <WS> ??? <WS> ??

-        // A bigram has an two WS-separated words instead of one.

-        try (Scanner uniScanner = new Scanner(new File("unigrams-pmilexicon.txt"));

-                Scanner biScanner = new Scanner(new File("bigrams-pmilexicon.txt"));) {

-            //Fill the map of unigrams

-            int lineno = 1;

-            while (uniScanner.hasNext()) {

-

-                String words = uniScanner.next();

-                Double d = Double.valueOf(uniScanner.next());

-                unimap.put(words.toLowerCase(), d);

-                if (uniScanner.hasNextLine()) {

-                    uniScanner.nextLine();

-                }

-                lineno++;

-

-            }

-

-            //fill the map of bigrams

-            while (biScanner.hasNext()) {

-                String words = biScanner.next() + " " + biScanner.next();

-                bimap.put(words.toLowerCase(), Double.valueOf(biScanner.next()));

-                if (biScanner.hasNextLine()) {

-                    biScanner.nextLine();

-                }

-            }

-        }

-        System.err.println("Lexicons are read.");

-    }

-

-    /**

-     * Executes a query that the analyzer can analyze.

-     *

-     * @param query The query string to execute.

-     * @throws SQLException When database connection isn't available.

-     */

-    public void query(String query) throws SQLException {

-        PreparedStatement statement;

-        //make a connection to the database and execute the query

-        statement = connection.prepareStatement(query);

-        data = statement.executeQuery();

-    }

-

-    /**

-     * Run a sentiment analysis and fill the database with the output.

-     *

-     * @param query The sql text for the query.

-     * @throws SQLException

-     * @throws IOException

-     */

-    public void sentimentAnalysis(String query) throws SQLException, IOException {

-        query(query);

-

-        //read the lexicons

-        readLexicon();

-

-        //go to the start of te dataset

-        if (data == null) {

-            System.err.println("data is empty, try querying first");

-            return;

-        }

-

-        Double value;

-        String text;

-

-        //for all tuples

-        while (data.next()) {

-            //get the text

-            text = data.getString("text");

-            text = splitPunctToWords(text);

-            // test is the tweet text you are going to analyze

-            String[] words = text.split("\\s+"); // text splitted into separate words

-            double positiverate = 0; // positive rating

-

-            // Rate the text with unigrams

-            for (String word : words) {

-                value = unimap.get(word);

-                if (value != null) {

-                    positiverate += unimap.get(word);

-                }

-            }

-            // Rate the text with bigrams

-            for (int i = 0; i < words.length - 1; i++) {

-                String pair = words[i] + " " + words[i + 1];

-                value = bimap.get(pair);

-                if (value != null) {

-                    positiverate += bimap.get(pair);

-                }

-            }

-            //insert the rating into the database

-            NamedPreparedStatement m_insertRating;

-            m_insertRating = new NamedPreparedStatement(connection, QueryUtils.insertRating);

-            QueryUtils.setInsertParams(m_insertRating, data.getLong("tweetid"), data.getString("brand"), (int) (positiverate * 10));

-            m_insertRating.executeUpdate();

-            //don't print the rate

-            //System.out.println(text + ": " + (int) (positiverate * 10));

-        }

-    }

-

-    /**

-     * Make a wordcloud of the results of some query.

-     *

-     * @param query The sql text for a query.

-     * @throws SQLException

-     * @throws FileNotFoundException

-     * @throws UnsupportedEncodingException

-     */

-    public void makeWordCloud(String query) throws SQLException, FileNotFoundException, UnsupportedEncodingException {

-

-        query(query);

-        //go to the start of the ResultSet data

-        if (data == null) {

-            System.err.println("data is empty, try querying first");

-            return;

-        }

-

-        String text;

-        String brand;

-        String[] words;

-        HashMap<String,HashMap<String, Integer>> wordcloud = new HashMap<>();

-

-        while (data.next()) {

-            //get brand

-            brand=data.getString("brand");

-            //make hashmap for each brand

-            if(!wordcloud.containsKey(brand)){

-                wordcloud.put(brand, new HashMap<String,Integer>());

-            }

-            //get the text

-            text = data.getString("text");

-            //remove punctuation, convert to lowercase and split on words

-            text = removePunct(text);

-            text = text.toLowerCase();

-            words = text.split("\\s+");

-            //for all words

-            for (String word : words) {

-                //if it is empty, a space or a stripe, skip it

-                if(word.equals("") || word.equals(" ") || word.equals("-")){

-                    continue;

-                }

-                //if the word is already in the map, increment the amount

-                if(wordcloud.get(brand).containsKey(word)){

-                    wordcloud.get(brand).put(word, wordcloud.get(brand).get(word) + 1);

-                }

-                //if the word is not already in the map, make an entry with amount = 1

-                else{

-                    wordcloud.get(brand).put(word, 1);

-                }

-            }

-        }

-        //print the words and their frequency in a csv file

-        mapToCSV(wordcloud, "wordcloud.csv", "brand,word,count");

-    }

-

-    //generate csv for disco from the query

-    public void disco(String query) throws SQLException, FileNotFoundException, UnsupportedEncodingException {

-        //do the query

-        query(query);

-        PrintWriter writer = new PrintWriter("output.csv", "UTF-8");

-        //print the first row

-        for (int i = 1; i < data.getMetaData().getColumnCount(); i++) {

-            writer.print(data.getMetaData().getColumnLabel(i) + ", ");

-        }

-        writer.println(data.getMetaData().getColumnLabel(data.getMetaData().getColumnCount()));

-        //print the values

-        while (data.next()) {

-            for (int i = 1; i < data.getMetaData().getColumnCount(); i++) {

-                if (data.getObject(i) == null) {

-                    writer.print(", ");

-                } else {

-                    writer.print(data.getObject(i).toString().replaceAll("[,\n]", " ") + ", ");

-                }

-            }

-            if (data.getObject(data.getMetaData().getColumnCount()) == null) {

-                writer.println("0");

-            } else {

-                writer.println(data.getObject(data.getMetaData().getColumnCount()).toString().replace(",", " "));

-            }

-        }

-        writer.close();

-    }

-

-    public void getBrands() throws SQLException {

-        PreparedStatement statement;

-        //make a connection to the database and execute the query

-        statement = connection.prepareStatement("delete from mentionsbrand");

-        statement.executeUpdate();

-        BrandChecker checker = new BrandChecker("brandonlyrules.txt");

-        query("select * from tweet");

-        NamedPreparedStatement m_insertBrand = new NamedPreparedStatement(connection, QueryUtils.insertBrand);

-        while (data.next()) {

-            List<String> brands = checker.getBrands(data.getString("text"));

-            if (brands.isEmpty()) {

-                QueryUtils.setInsertBrandParams(m_insertBrand, data.getLong("tweetid"), "no");

-                m_insertBrand.executeUpdate();

-            } else {

-                for (String brand : brands) {

-                    QueryUtils.setInsertBrandParams(m_insertBrand, data.getLong("tweetid"), brand);

-                    m_insertBrand.executeUpdate();

-                }

-            }

-        }

-    }

-

-    //gets the amount of users that tweet about a brand in a timezone

-    //makes a csv file timezone, brand, amount

-    public void timezone(String query) throws SQLException, FileNotFoundException, UnsupportedEncodingException{

-        query(query);

-        //hashmap timezone, brand, amount

-        HashMap<String, HashMap<String, Integer>> timeMap = new HashMap<>();

-        String timezone;

-        String brand;

-        

-        while(data.next()){

-            timezone = data.getString("timezone");

-            brand = data.getString("brand");

-            //if the timezone is already in the map

-            if(timeMap.containsKey(timezone)){

-                //if the brand for that timezone is already in the map

-                if(timeMap.get(timezone).containsKey(brand)){

-                    //increment the amount

-                    timeMap.get(timezone).put(brand, timeMap.get(timezone).get(brand) + 1);

-                }

-                //if the brand for that timezone is not yet in the map

-                else{

-                    //make a new entry for that brand with amount = 1

-                    timeMap.get(timezone).put(brand, 1);

-                }

-            }

-            //if the timezone is not yet in the map

-            else{

-                //make a new hashmap for this map and fill it with the brand and the amount

-                timeMap.put(timezone, new HashMap<String, Integer>());

-                timeMap.get(timezone).put(brand, 1);

-            }

-        }

-        //make the CSV out of the map

-        mapToCSV(timeMap, "timezone.csv", "timezone,brand,count");

-    }

-    

-    //replaces punctuation so it will be splitted

-    //also removes urls

-    private String splitPunctToWords(String text) {

-        text = text.replaceAll("https?://\\S*", "");

-        text = text.replaceAll("[!?):;\"']", " $0");

-        text = text.replaceAll("[.,-](\\s|$)", " $0");

-        text = text.replaceAll("\\s[(\"']", "$0 ");

-        return text;

-    }

-

-    //removes punctuation

-    //also removes urls

-    private String removePunct(String text) {

-        text = text.replaceAll("https?://\\S*", " ");

-        text = text.replaceAll("@\\S*", " ");

-        text = text.replaceAll("[^a-zA-Z0-9#_-]", " ");

-        return text;

-    }

-    

-    //prints a hashmap into a csv for a html application

-    //Hashmap<key1, HashMap<key2, value>> becomes key1, key2, value

-    //only for String, String, Integer

-    void mapToCSV(HashMap<String, HashMap<String, Integer>> map, String fileName, String firstLine) 

-                throws FileNotFoundException, UnsupportedEncodingException{

-        

-        PrintWriter writer = new PrintWriter(fileName, "UTF-8");

-        

-        writer.println(firstLine);

-          

-        //loop over brands

-        for(Entry en : map.entrySet()){

-            //loop over words

-            for(Entry e : map.get(en.getKey()).entrySet()){

-                writer.println(en.getKey() + "," + e.getKey() + "," + e.getValue());

-            }

-        }

-        

-        writer.close();

-        System.out.println("csv file made, please put it next to html file and run this");

-    }

-}

+package main;
+
+import analysis.BrandChecker;
+import database.NamedPreparedStatement;
+import database.QueryUtils;
+import java.io.File;
+import java.io.FileInputStream;
+import java.io.FileNotFoundException;
+import java.io.IOException;
+import java.io.InputStream;
+import java.io.PrintWriter;
+import java.io.UnsupportedEncodingException;
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.List;
+import java.util.HashMap;
+import java.util.Locale;
+import java.util.Map.Entry;
+import java.util.Scanner;
+
+/**
+ * The sentiment analysis class that rates tweets based on a unigram and bigram
+ * set of weights.
+ */
+public class Analyzor {
+
+    /**
+     * The map that matches single words to their weights.
+     */
+    private final HashMap<String, Double> unimap = new HashMap();
+
+    /**
+     * The map that matches word pairs to their weights.
+     */
+    private final HashMap<String, Double> bimap = new HashMap();
+
+    /**
+     * The results of a query, maybe return from query().
+     */
+    private ResultSet data;
+
+    /**
+     * The persistent connection to the database.
+     */
+    private final Connection connection;
+
+    /**
+     * @param connection An open connection to the database.
+     */
+    public Analyzor(Connection connection) {
+        this.connection = connection;
+    }
+
+    /**
+     * Read the unigram and bigram lexica.
+     *
+     * @throws FileNotFoundException
+     */
+    public void readLexicon() throws FileNotFoundException {
+        if (!unimap.isEmpty()) {
+            // data is already read.
+            return;
+        }
+        System.err.println("Trying to read lexicons...");
+        // A unigram is in the format (WS = whitespace):
+        // word <WS> rating <WS> ??? <WS> ??
+        // A bigram has an two WS-separated words instead of one.
+        try (Scanner uniScanner = new Scanner(new File("unigrams-pmilexicon.txt"));
+                Scanner biScanner = new Scanner(new File("bigrams-pmilexicon.txt"));) {
+            //Fill the map of unigrams
+            int lineno = 1;
+            while (uniScanner.hasNext()) {
+
+                String words = uniScanner.next();
+                Double d = Double.valueOf(uniScanner.next());
+                unimap.put(words.toLowerCase(), d);
+                if (uniScanner.hasNextLine()) {
+                    uniScanner.nextLine();
+                }
+                lineno++;
+
+            }
+
+            //fill the map of bigrams
+            while (biScanner.hasNext()) {
+                String words = biScanner.next() + " " + biScanner.next();
+                bimap.put(words.toLowerCase(), Double.valueOf(biScanner.next()));
+                if (biScanner.hasNextLine()) {
+                    biScanner.nextLine();
+                }
+            }
+        }
+        System.err.println("Lexicons are read.");
+    }
+
+    /**
+     * Executes a query that the analyzer can analyze.
+     *
+     * @param query The query string to execute.
+     * @throws SQLException When database connection isn't available.
+     */
+    public void query(String query) throws SQLException {
+        PreparedStatement statement;
+        //make a connection to the database and execute the query
+        statement = connection.prepareStatement(query);
+        data = statement.executeQuery();
+    }
+
+    /**
+     * Run a sentiment analysis and fill the database with the output.
+     *
+     * @param query The sql text for the query.
+     * @throws SQLException
+     * @throws IOException
+     */
+    public void sentimentAnalysis(String query) throws SQLException, IOException {
+        query(query);
+
+        //read the lexicons
+        readLexicon();
+
+        //go to the start of te dataset
+        if (data == null) {
+            System.err.println("data is empty, try querying first");
+            return;
+        }
+
+        Double value;
+        String text;
+
+        //for all tuples
+        while (data.next()) {
+            //get the text
+            text = data.getString("text");
+            text = splitPunctToWords(text);
+            // test is the tweet text you are going to analyze
+            String[] words = text.split("\\s+"); // text splitted into separate words
+            double positiverate = 0; // positive rating
+
+            // Rate the text with unigrams
+            for (String word : words) {
+                value = unimap.get(word);
+                if (value != null) {
+                    positiverate += unimap.get(word);
+                }
+            }
+            // Rate the text with bigrams
+            for (int i = 0; i < words.length - 1; i++) {
+                String pair = words[i] + " " + words[i + 1];
+                value = bimap.get(pair);
+                if (value != null) {
+                    positiverate += bimap.get(pair);
+                }
+            }
+            //insert the rating into the database
+            NamedPreparedStatement m_insertRating;
+            m_insertRating = new NamedPreparedStatement(connection, QueryUtils.insertRating);
+            QueryUtils.setInsertParams(m_insertRating, data.getLong("tweetid"), data.getString("brand"), (int) (positiverate * 10));
+            m_insertRating.executeUpdate();
+            //don't print the rate
+            //System.out.println(text + ": " + (int) (positiverate * 10));
+        }
+    }
+
+    /**
+     * Make a wordcloud of the results of some query.
+     *
+     * @param query The sql text for a query.
+     * @throws SQLException
+     * @throws FileNotFoundException
+     * @throws UnsupportedEncodingException
+     */
+    public void makeWordCloud(String query) throws SQLException, FileNotFoundException, UnsupportedEncodingException {
+
+        query(query);
+        //go to the start of the ResultSet data
+        if (data == null) {
+            System.err.println("data is empty, try querying first");
+            return;
+        }
+
+        String text;
+        String brand;
+        String[] words;
+        HashMap<String,HashMap<String, Integer>> wordcloud = new HashMap<>();
+
+        while (data.next()) {
+            //get brand
+            brand=data.getString("brand");
+            //make hashmap for each brand
+            if(!wordcloud.containsKey(brand)){
+                wordcloud.put(brand, new HashMap<String,Integer>());
+            }
+            //get the text
+            text = data.getString("text");
+            //remove punctuation, convert to lowercase and split on words
+            text = removePunct(text);
+            text = text.toLowerCase();
+            words = text.split("\\s+");
+            //for all words
+            for (String word : words) {
+                //if it is empty, a space or a stripe, skip it
+                if(word.equals("") || word.equals(" ") || word.equals("-")){
+                    continue;
+                }
+                //if the word is already in the map, increment the amount
+                if(wordcloud.get(brand).containsKey(word)){
+                    wordcloud.get(brand).put(word, wordcloud.get(brand).get(word) + 1);
+                }
+                //if the word is not already in the map, make an entry with amount = 1
+                else{
+                    wordcloud.get(brand).put(word, 1);
+                }
+            }
+        }
+        //print the words and their frequency in a csv file
+        mapToCSV(wordcloud, "wordcloud.csv", "brand,word,count");
+    }
+
+    //generate csv for disco from the query
+    public void disco(String query) throws SQLException, FileNotFoundException, UnsupportedEncodingException {
+        //do the query
+        query(query);
+        PrintWriter writer = new PrintWriter("output.csv", "UTF-8");
+        //print the first row
+        for (int i = 1; i < data.getMetaData().getColumnCount(); i++) {
+            writer.print(data.getMetaData().getColumnLabel(i) + ", ");
+        }
+        writer.println(data.getMetaData().getColumnLabel(data.getMetaData().getColumnCount()));
+        //print the values
+        while (data.next()) {
+            for (int i = 1; i < data.getMetaData().getColumnCount(); i++) {
+                if (data.getObject(i) == null) {
+                    writer.print(", ");
+                } else {
+                    writer.print(data.getObject(i).toString().replaceAll("[,\n]", " ") + ", ");
+                }
+            }
+            if (data.getObject(data.getMetaData().getColumnCount()) == null) {
+                writer.println("0");
+            } else {
+                writer.println(data.getObject(data.getMetaData().getColumnCount()).toString().replace(",", " "));
+            }
+        }
+        writer.close();
+    }
+
+    public void getBrands() throws SQLException {
+        PreparedStatement statement;
+        //make a connection to the database and execute the query
+        statement = connection.prepareStatement("delete from mentionsbrand");
+        statement.executeUpdate();
+        BrandChecker checker = new BrandChecker("brandonlyrules.txt");
+        query("select * from tweet");
+        NamedPreparedStatement m_insertBrand = new NamedPreparedStatement(connection, QueryUtils.insertBrand);
+        while (data.next()) {
+            List<String> brands = checker.getBrands(data.getString("text"));
+            if (brands.isEmpty()) {
+                QueryUtils.setInsertBrandParams(m_insertBrand, data.getLong("tweetid"), "no");
+                m_insertBrand.executeUpdate();
+            } else {
+                for (String brand : brands) {
+                    QueryUtils.setInsertBrandParams(m_insertBrand, data.getLong("tweetid"), brand);
+                    m_insertBrand.executeUpdate();
+                }
+            }
+        }
+    }
+
+    //gets the amount of users that tweet about a brand in a timezone
+    //makes a csv file timezone, brand, amount
+    public void timezone(String query) throws SQLException, FileNotFoundException, UnsupportedEncodingException{
+        query(query);
+        
+        InputStream inFile = new FileInputStream("timezone.txt");
+        Scanner readFile = new Scanner(inFile);
+        HashMap<String,String> toTimezone = new HashMap<>();
+        while (readFile.hasNextLine()) {
+            String line = readFile.nextLine();
+            if(line.split(",").length>1){
+                toTimezone.put(line.split(",")[0], line.split(",")[1]);
+            }
+        }
+        
+        
+        
+        //hashmap timezone, brand, amount
+        HashMap<String, HashMap<String, Integer>> timeMap = new HashMap<>();
+        String timezone;
+        String brand;
+        
+        while(data.next()){
+            timezone = data.getString("timezone");
+            if (toTimezone.containsKey(timezone)){
+                timezone=toTimezone.get(timezone);
+            } else {
+                timezone="other";
+            }
+            brand = data.getString("brand");
+            //if the timezone is already in the map
+            if(timeMap.containsKey(timezone)){
+                //if the brand for that timezone is already in the map
+                if(timeMap.get(timezone).containsKey(brand)){
+                    //increment the amount
+                    timeMap.get(timezone).put(brand, timeMap.get(timezone).get(brand) + 1);
+                }
+                //if the brand for that timezone is not yet in the map
+                else{
+                    //make a new entry for that brand with amount = 1
+                    timeMap.get(timezone).put(brand, 1);
+                }
+            }
+            //if the timezone is not yet in the map
+            else{
+                //make a new hashmap for this map and fill it with the brand and the amount
+                timeMap.put(timezone, new HashMap<String, Integer>());
+                timeMap.get(timezone).put(brand, 1);
+            }
+        }
+        
+        
+        //make the CSV out of the map
+        mapToCSV(timeMap, "timezone.csv", "timezone,brand,count");
+    }
+    
+    //replaces punctuation so it will be splitted
+    //also removes urls
+    private String splitPunctToWords(String text) {
+        text = text.replaceAll("https?://\\S*", "");
+        text = text.replaceAll("[!?):;\"']", " $0");
+        text = text.replaceAll("[.,-](\\s|$)", " $0");
+        text = text.replaceAll("\\s[(\"']", "$0 ");
+        return text;
+    }
+
+    //removes punctuation
+    //also removes urls
+    private String removePunct(String text) {
+        text = text.replaceAll("https?://\\S*", " ");
+        text = text.replaceAll("@\\S*", " ");
+        text = text.replaceAll("[^a-zA-Z0-9#_-]", " ");
+        return text;
+    }
+    
+    //prints a hashmap into a csv for a html application
+    //Hashmap<key1, HashMap<key2, value>> becomes key1, key2, value
+    //only for String, String, Integer
+    void mapToCSV(HashMap<String, HashMap<String, Integer>> map, String fileName, String firstLine) 
+                throws FileNotFoundException, UnsupportedEncodingException{
+        
+        PrintWriter writer = new PrintWriter(fileName, "UTF-8");
+        
+        writer.println(firstLine);
+          
+        //loop over brands
+        for(Entry en : map.entrySet()){
+            //loop over words
+            for(Entry e : map.get(en.getKey()).entrySet()){
+                writer.println(en.getKey() + "," + e.getKey() + "," + e.getValue());
+            }
+        }
+        
+        writer.close();
+        System.out.println("csv file made, please put it next to html file and run this");
+    }
+}
diff --git a/src/main/FarmShell.java b/src/main/FarmShell.java
index 1266fd3..8fc515a 100644
--- a/src/main/FarmShell.java
+++ b/src/main/FarmShell.java
@@ -130,6 +130,8 @@ public class FarmShell {
             case wordcloud:
                 getAnalyzor().makeWordCloud(params[0]);
                 break;
+            case timezone:
+                getAnalyzor().timezone(params[0]);
             case disco:
                 getAnalyzor().disco(params[0]);
                 break;
@@ -166,7 +168,8 @@ public class FarmShell {
         sentiment("analyzes all tweets on positivity (about a brand)", 1),
         wordcloud("makes a wordcloud of the text of the tweets", 1),
         getBrands("fills the database with the brands of a tweet"),
-        disco("makes a outputfile for disco",1),
+        timezone("makes a map per brand for the users", 1),
+        disco("makes a outputfile for disco", 1),
         exit("Returns to shell"),
         help("Get help");
 
diff --git a/timezone.txt b/timezone.txt
new file mode 100644
index 0000000..6d06302
--- /dev/null
+++ b/timezone.txt
@@ -0,0 +1,183 @@
+Warsaw,North Europe

+Hong Kong,Hong Kong

+Stockholm,North Europe

+Canada/Pacific,Pacific Time

+Bucharest,South Europe

+Mountain Time (US & Canada),Mountain Time

+Harare,South Africa

+Dhaka,New Delhi

+Sofia,South Europe

+Melbourne,Sydney

+Buenos Aires,South South America

+Bogota,North South America

+Belgrade,South Europe

+Krasnoyarsk,Russia

+BST,West Europe

+America/New_York,

+Fiji,Sydney

+Asia/Shanghai,Hong Kong

+Dublin,West Europe

+Karachi,New Delhi

+Muscat,Abu Dhabi

+Kolkata,New Delhi

+Urumqi,Hong Kong

+Islamabad,New Delhi

+Samoa,Sydney

+Tokyo,Hong Kong

+Berlin,West Europe

+America/Phoenix,Mountain Time

+Europe/Zurich,West Europe

+Madrid,West Europe

+Kathmandu,New Delhi

+Perth,Sydney

+Eastern Time (US & Canada),Eastern Time

+Zagreb,South Europe

+Europe/Dublin,West Europe

+Taipei,Hong Kong

+Helsinki,North Europe

+Europe/Belfast,West Europe

+America/Cancun,Central America

+Bangkok,Bangkok

+Guam,Bangkok

+Wellington,Sydney

+Minsk,Russia

+Atlantic Time (Canada),Atlantic Time

+Jerusalem,Abu Dhabi

+West Central Africa,North Africa

+Irkutsk,Russia

+Asia/Calcutta,New Delhi

+Sapporo,Hong Kong

+La Paz,South South America

+Mazatlan,Central America

+Europe/Copenhagen,North Europe

+Moscow,Russia

+Kabul,Abu Dhabi

+Quito,North South America

+Kyiv,South Europe

+Yerevan,South Europe

+Darwin,Sydney

+Marshall Is.,Sydney

+Caracas,North South America

+America/Puerto_Rico,Central America

+America/Denver,Mountain Time

+Kuala Lumpur,Bangkok

+London,West Europe

+Ulaan Bataar,Russia

+Nuku'alofa,Sydney

+Newfoundland,Eastern Time

+Adelaide,Sydney

+Riga,North Europe

+Astana,Russia

+Brisbane,Sydney

+Copenhagen,North Europe

+Port Moresby,Sydney

+America/Detroit,Eastern Time

+Rome,South Europe

+Pacific Time (US & Canada),Pacific Time

+Georgetown,North South America

+America/Boise,Mountain Time

+Azores,South Europe

+Sydney,Sydney

+Osaka,Hong Kong

+Almaty,Russia

+Jakarta,Bangkok

+Midway Island,

+Casablanca,North Africa

+America/Toronto,Eastern Time

+America/Chicago,Central Time

+America/Sao_Paulo,North South America

+Arizona,Mountain Time

+JST,Hong Kong

+Alaska,Alaska

+New Delhi,New Delhi

+Auckland,Sydney

+Mid-Atlantic,Atlantic Time

+Central Time (US & Canada),Central Time

+Central America,Central America

+Seoul,Hong Kong

+Solomon Is.,Sydney

+Mumbai,New Delhi

+IST,New Delhi

+America/Mexico_City,Central America

+Kamchatka,Russia

+Vilnius,North Europe

+Amsterdam,West Europe

+Baghdad,Abu Dhabi

+Novosibirsk,Russia

+Sri Jayawardenepura,New Delhi

+Sarajevo,South Europe

+Abu Dhabi,Abu Dhabi

+Greenland,Greenland

+Brussels,West Europe

+Hobart,Sydney

+Chennai,New Delhi

+Istanbul,South Europe

+Canberra,Sydney

+Asia/Karachi,New Delhi

+America/Managua,Central America

+Tashkent,Russia

+Kuwait,Abu Dhabi

+Vienna,West Europe

+Pretoria,South Africa

+CST,Central Time

+Australia/Perth,Sydney

+Nairobi,South Africa

+Monterrey,Central America

+PST,Pacific Time

+Ekaterinburg,Russia

+America/Vancouver,Pacific Time

+Asia/Manila,Bangkok

+Asia/Bahrain,Abu Dhabi

+Asia/Jakarta,Bangkok

+America/Edmonton,Mountain Time

+Cairo,North Africa

+Monrovia,North Africa

+Bern,West Europe

+America/Los_Angeles,Pacific Time

+Tbilisi,South Europe

+Paris,West Europe

+Cape Verde Is.,North Africa

+Beijing,Hong Kong

+EST,Eastern Time

+America/Guatemala,Central America

+Bratislava,South Europe

+America/Montreal,Eastern Time

+Saskatchewan,Mountain Time

+Edinburgh,West Europe

+Brasilia,North South America

+Skopje,South Europe

+Chongqing,Hong Kong

+Ljubljana,South Europe

+Athens,South Europe

+Indiana (East),Central Time

+Guadalajara,Central America

+Tijuana,Central America

+Santiago,South South America

+Pacific/Auckland,Sydney

+America/Atikokan,Central Time

+Chihuahua,Central America

+Budapest,South Europe

+Canada/Eastern,Eastern Time

+Africa/Nairobi,South Africa

+International Date Line West,Sydney

+New Caledonia,Sydney

+Rangoon,Bangkok

+Europe/Paris,West Europe

+Hanoi,Hong Kong

+Tehran,Abu Dhabi

+Asia/Kuwait,Abu Dhabi

+Africa/Lagos,North Africa

+America/Caracas,North South America

+Mexico City,Central America

+Asia/Kuala_Lumpur,Bangkok

+Hawaii,Pacific Time

+Lima,North South America

+St. Petersburg,Russia

+Riyadh,Abu Dhabi

+Lisbon,West Europe

+Magadan,Russia

+Asia/Kolkata,New Delhi

+Singapore,Bangkok

+Tallinn,North Europe

+Prague,North Europe

+Europe/London,West Europe