package com.ivalentin.margolariak;

import android.graphics.Bitmap;
import android.graphics.BitmapFactory;
import android.util.Log;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.Locale;

/**
 * Final class that contains useful static values to be used across the app.
 *
 * @author Iñigo Valentin
 *
 */
final class GM {

	/**
	 * Contains info about the database.
	 */
	final class DB {

		/**
		 * Name of the database.
		 */
		static final String NAME = "gmv3";

		/**
		 * Initial version of the database.
		 */
		static final int INITIAL_VERSION = 0;

		/**
		 * Names of the tables of the database.
		 */
		final class TABLE {

			/**
			 * Name of the table "activity".
			 */
			static final String ACTIVITY = "activity";

			/**
			 * Name of the table "activity_comment".
			 */
			static final String ACTIVITY_COMMENT = "activity_comment";

			/**
			 * Name of the table "activity_image".
			 */
			static final String ACTIVITY_IMAGE = "activity_image";

			/**
			 * Name of the table "activity_itinerary".
			 */
			static final String ACTIVITY_ITINERARY = "activity_itinerary";

			/**
			 * Name of the table "activity_tag".
			 */
			static final String ACTIVITY_TAG = "activity_tag";

			/**
			 * Name of the table "album".
			 */
			static final String ALBUM = "album";

			/**
			 * Name of the table "festival".
			 */
			static final String FESTIVAL = "festival";

			/**
			 * Name of the table "festival_day".
			 */
			static final String FESTIVAL_DAY = "festival_day";

			/**
			 * Name of the table "festival_event_city".
			 */
			static final String FESTIVAL_EVENT_CITY = "festival_event_city";

			/**
			 * Name of the table "festival_event_gm".
			 */
			static final String FESTIVAL_EVENT_GM = "festival_event_gm";

			/**
			 * Name of the table "festival_event_image".
			 */
			static final String FESTIVAL_EVENT_IMAGE = "festival_event_image";

			/**
			 * Name of the table "festival_offer".
			 */
			static final String FESTIVAL_OFFER = "festival_offer";

			/**
			 * Name of the table "location".
			 */
			static final String LOCATION = "location";

			/**
			 * Name of the table "notification".
			 */
			static final String NOTIFICATION = "notification";

			/**
			 * Name of the table "people".
			 */
			static final String PEOPLE = "people";

			/**
			 * Name of the table "photo".
			 */
			static final String PHOTO = "photo";

			/**
			 * Name of the table "photo_album".
			 */
			static final String PHOTO_ALBUM = "photo_album";

			/**
			 * Name of the table "photo_comment".
			 */
			static final String PHOTO_COMMENT = "photo_comment";

			/**
			 * Name of the table "place".
			 */
			static final String PLACE = "place";

			/**
			 * Name of the table "post".
			 */
			static final String POST = "post";

			/**
			 * Name of the table "post_comment".
			 */
			static final String POST_COMMENT = "post_comment";

			/**
			 * Name of the table "post_image".
			 */
			static final String POST_IMAGE = "post_image";

			/**
			 * Name of the table "post_tag".
			 */
			static final String POST_TAG = "post_tag";

			/**
			 * Name of the table "route".
			 */
			static final String ROUTE = "route";

			/**
			 * Name of the table "route_point".
			 */
			static final String ROUTE_POINT = "route_point";

			/**
			 * Name of the table "settings".
			 */
			static final String SETTINGS = "settings";

			/**
			 * Name of the table "sponsor".
			 */
			static final String SPONSOR = "sponsor";

			/**
			 * Name of the table "version".
			 */
			static final String VERSION = "version";
		}

		/**
		 * Column types
		 */
		final class COLUMN {

			/**
			 * INT column.
			 */
			static final int INT = 0;

			/**
			 * VARCHAR column.
			 */
			static final int VARCHAR = 1;

			/**
			 * Datetime column.
			 */
			static final int DATETIME = 2;
		}

		/**
		 * Usefull queries
		 */
		final class QUERY {

			/**
			 * Queries to create tables.
			 */
			final class CREATE {

				/**
				 * Creates the table "activity" on the database.
				 */
				static final String ACTIVITY = "CREATE TABLE IF NOT EXISTS activity (id INT, permalink VARCHAR, date DATETIME, city VARCHAR, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, text_es VARCHAR, text_en VARCHAR, text_eu VARCHAR, after_es VARCHAR, after_en VARCHAR, after_eu VARCHAR, price INT, inscription INT, max_people INT, album INT, dtime DATETIME, comments INT);";

				/**
				 * Creates the table "activity_comment" on the database.
				 */
				static final String ACTIVITY_COMMENT = "CREATE TABLE IF NOT EXISTS activity_comment (id INT, activity INT, text VARCHAR, dtime DATETIME, username VARCHAR, lang VARCHAR);";

				/**
				 * Creates the table "activity_image" on the database.
				 */
				static final String ACTIVITY_IMAGE = "CREATE TABLE IF NOT EXISTS activity_image (id INT, activity INT, image VARCHAR, idx INT);";

				/**
				 * Creates the table "activity_itinerary" on the database.
				 */
				static final String ACTIVITY_ITINERARY = "CREATE TABLE IF NOT EXISTS activity_itinerary (id INT, activity INT, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, start DATETIME, end DATETIME, place INT, route INT);";

				/**
				 * Creates the table "activity_tag" on the database.
				 */
				static final String ACTIVITY_TAG = "CREATE TABLE IF NOT EXISTS activity_tag (activity INT, tag VARCHAR);";

				/**
				 * Creates the table "album" on the database.
				 */
				static final String ALBUM = "CREATE TABLE IF NOT EXISTS album (id INT, permalink VARCHAR, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, open INT, time DATETIME);";

				/**
				 * Creates the table "festival" on the database.
				 */
				static final String FESTIVAL = "CREATE TABLE IF NOT EXISTS festival (id INT, year INT, text_es VARCHAR, text_en VARCHAR, text_eu VARCHAR, summary_es VARCHAR, summary_en VARCHAR, summary_eu VARCHAR, img VARCHAR);";

				/**
				 * Creates the table "festival_day" on the database.
				 */
				static final String FESTIVAL_DAY = "CREATE TABLE IF NOT EXISTS festival_day (id INT, date DATETIME, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, price INT, people INT, max_people INT);";

				/**
				 * Creates the table "festival_event_city" on the database.
				 */
				static final String FESTIVAL_EVENT_CITY = "CREATE TABLE IF NOT EXISTS festival_event_city (id INT, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, host INT, sponsor INT, place INT, route INT, start DATETIME, end DATETIME, interest INT);";

				/**
				 * Creates the table "festival_event_gm" on the database.
				 */
				static final String FESTIVAL_EVENT_GM = "CREATE TABLE IF NOT EXISTS festival_event_gm (id INT, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, host INT, sponsor INT, place INT, route INT, start DATETIME, end DATETIME, interest INT);";

				/**
				 * Creates the table "festival_event_image" on the database.
				 */
				static final String FESTIVAL_EVENT_IMAGE = "CREATE TABLE IF NOT EXISTS festival_event_image (id INT, event INT, image VARCHAR, idx INT);";

				/**
				 * Creates the table "festival_offer" on the database.
				 */
				static final String FESTIVAL_OFFER = "CREATE TABLE IF NOT EXISTS festival_offer (id INT, year INT, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, days INT, price INT);";

				/**
				 * Creates the table "location" on the database.
				 */
				static final String LOCATION = "CREATE TABLE IF NOT EXISTS location (dtime DATETIME, lat DOUBLE, lon DOUBLE);";

				/**
				 * Creates the table "notification" on the database.
				 */
				static final String NOTIFICATION = "CREATE TABLE IF NOT EXISTS notification (id INT, dtime DATETIME, duration INT, action VARCHAR, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, text_es VARCHAR, text_en VARCHAR, text_eu VARCHAR, internal INT, seen INT DEFAULT 0);";

				/**
				 * Creates the table "people" on the database.
				 */
				static final String PEOPLE = "CREATE TABLE IF NOT EXISTS people (id INT, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, link VARCHAR);";

				/**
				 * Creates the table "photo" on the database.
				 */
				static final String PHOTO = "CREATE TABLE IF NOT EXISTS photo (id INT, file VARCHAR, permalink VARCHAR, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, description_es VARCHAR, description_en VARCHAR, description_eu VARCHAR, dtime DATETIME, uploaded DATETIME, place INT, width INT, height INT, size INT, username VARCHAR);";

				/**
				 * Creates the table "photo_album" on the database.
				 */
				static final String PHOTO_ALBUM = "CREATE TABLE IF NOT EXISTS photo_album (photo INT, album INT);";

				/**
				 * Creates the table "photo_comment" on the database.
				 */
				static final String PHOTO_COMMENT = "CREATE TABLE IF NOT EXISTS photo_comment (id INT, photo INT, text VARCHAR, dtime DATETIME, username VARCHAR, lang VARCHAR);";

				/**
				 * Creates the table "place" on the database.
				 */
				static final String PLACE = "CREATE TABLE IF NOT EXISTS place (id INT, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, address_es VARCHAR, address_en VARCHAR, address_eu VARCHAR, cp VARCHAR, lat FLOAT, lon FLOAT);";

				/**
				 * Creates the table "post" on the database.
				 */
				static final String POST = "CREATE TABLE IF NOT EXISTS post (id INT, permalink VARCHAR, title_es VARCHAR, title_en VARCHAR, title_eu VARCHAR, text_es VARCHAR, text_en VARCHAR, text_eu VARCHAR, comments INT, username VARCHAR, dtime DATETIME);";

				/**
				 * Creates the table "post_comment" on the database.
				 */
				static final String POST_COMMENT = "CREATE TABLE IF NOT EXISTS post_comment (id INT, post INT, text VARCHAR, dtime DATETIME, username VARCHAR, lang VARCHAR);";

				/**
				 * Creates the table "photo" on the database.
				 */
				static final String POST_IMAGE = "CREATE TABLE IF NOT EXISTS post_image (id INT, post INT, image VARCHAR, idx INT);";

				/**
				 * Creates the table "post_tag" on the database.
				 */
				static final String POST_TAG = "CREATE TABLE IF NOT EXISTS post_tag (post INT, tag VARCHAR);";

				/**
				 * Creates the table "route" on the database.
				 */
				static final String ROUTE = "CREATE TABLE IF NOT EXISTS route (id INT, name VARCHAR, mins INT, c_lat DOUBLE, c_lon DOUBLE, zoom INT);";

				/**
				 * Creates the table "route_point" on the database.
				 */
				static final String ROUTE_POINT = "CREATE TABLE IF NOT EXISTS route_point (id INT, route INT, part INT, lat_o DOUBLE, lon_o DOUBLE, lat_d DOUBLE, lon_d DOUBLE, mins INT, visible INT);";

				/**
				 * Creates the table "settings" on the database.
				 */
				static final String SETTINGS = "CREATE TABLE IF NOT EXISTS settings (name VARCHAR, value VARCHAR);";

				/**
				 * Creates the table "sponsor" on the database.
				 */
				static final String SPONSOR = "CREATE TABLE IF NOT EXISTS sponsor (id INT, name_es VARCHAR, name_en VARCHAR, name_eu VARCHAR, text_es VARCHAR, text_en VARCHAR, text_eu VARCHAR, image VARCHAR, address_es VARCHAR, address_en VARCHAR, address_eu VARCHAR, link VARCHAR, lat FLOAT, lon FLOAT);";

				/**
				 * Creates the table "version" on the database.
				 */
				static final String VERSION = "CREATE TABLE IF NOT EXISTS version (section VARCHAR, version INT);";
			}

			/**
			 * Queries to remove tables.
			 */
			final class DROP {

				/**
				 * Deletes the table "activity" from the database.
				 */
				static final String ACTIVITY = "DROP TABLE activity;";

				/**
				 * Deletes the table "activity_comment" from the database.
				 */
				static final String ACTIVITY_COMMENT = "DROP TABLE activity_comment;";

				/**
				 * Deletes the table "activity_comment" from the database.
				 */
				static final String ACTIVITY_IMAGE = "DROP TABLE activity_image;";

				/**
				 * Deletes the table "activity_comment" from the database.
				 */
				static final String ACTIVITY_ITINERARY = "DROP TABLE activity_itinerary;";

				/**
				 * Deletes the table "activity_comment" from the database.
				 */
				static final String ACTIVITY_TAG = "DROP TABLE activity_tag;";

				/**
				 * Deletes the table "album" from the database.
				 */
				static final String ALBUM = "DROP TABLE album;";

				/**
				 * Deletes the table "festival" from the database.
				 */
				static final String FESTIVAL = "DROP TABLE festival;";

				/**
				 * Deletes the table "festival_day" from the database.
				 */
				static final String FESTIVAL_DAY = "DROP TABLE festival_day;";

				/**
				 * Deletes the table "festival_event_city" from the database.
				 */
				static final String FESTIVAL_EVENT_CITY = "DROP TABLE festival_event_city;";

				/**
				 * Deletes the table "festival_event_gm" from the database.
				 */
				static final String FESTIVAL_EVENT_GM = "DROP TABLE festival_event_gm;";

				/**
				 * Deletes the table "festival_event_image" from the database.
				 */
				static final String FESTIVAL_EVENT_IMAGE = "DROP TABLE festival_event_image;";

				/**
				 * Deletes the table "festival_offer" from the database.
				 */
				static final String FESTIVAL_OFFER = "DROP TABLE festival_offer;";

				/**
				 * Deletes the table "location" from the database.
				 */
				static final String LOCATION = "DROP TABLE location;";

				/**
				 * Deletes the table "notification" from the database.
				 */
				static final String NOTIFICATION = "DROP TABLE notification;";

				/**
				 * Deletes the table "people" from the database.
				 */
				static final String PEOPLE = "DROP TABLE people;";

				/**
				 * Deletes the table "photo" from the database.
				 */
				static final String PHOTO = "DROP TABLE photo;";

				/**
				 * Deletes the table "photo_album" from the database.
				 */
				static final String PHOTO_ALBUM = "DROP TABLE photo_album;";

				/**
				 * Deletes the table "photo_comment" from the database.
				 */
				static final String PHOTO_COMMENT = "DROP TABLE photo_comment;";

				/**
				 * Deletes the table "place" from the database.
				 */
				static final String PLACE = "DROP TABLE place;";

				/**
				 * Deletes the table "post" from the database.
				 */
				static final String POST = "DROP TABLE post;";

				/**
				 * Deletes the table "post_comment" from the database.
				 */
				static final String POST_COMMENT = "DROP TABLE post_comment;";

				/**
				 * Deletes the table "post_image" from the database.
				 */
				static final String POST_IMAGE = "DROP TABLE post_image;";

				/**
				 * Deletes the table "post_tag" from the database.
				 */
				static final String POST_TAG = "DROP TABLE post_tag;";

				/**
				 * Deletes the table "route" from the database.
				 */
				static final String ROUTE = "DROP TABLE route;";

				/**
				 * Deletes the table "route_point" from the database.
				 */
				static final String ROUTE_POINT = "DROP TABLE route_point;";

				/**
				 * Deletes the table "settings" from the database.
				 */
				static final String SETTINGS = "DROP TABLE settings;";

				/**
				 * Deletes the table "sponsor" from the database.
				 */
				static final String SPONSOR = "DROP TABLE sponsor;";

				/**
				 * Deletes the table "version" from the database.
				 */
				static final String VERSION = "DROP TABLE version;";
			}

			/**
			 * Queries to empty tables.
			 */
			@SuppressWarnings("unused")
			final class EMPTY {

				/**
				 * Empties the table "activity".
				 */
				static final String ACTIVITY = "DELETE FROM activity;";

				/**
				 * Empties the table "activity_comment".
				 */
				static final String ACTIVITY_COMMENT = "DELETE FROM activity_comment;";

				/**
				 * Empties the table "activity_image".
				 */
				static final String ACTIVITY_IMAGE = "DELETE FROM activity_image;";

				/**
				 * Empties the table "activity_itinerary".
				 */
				static final String ACTIVITY_ITINERARY = "DELETE FROM activity_itinerary;";

				/**
				 * Empties the table "activity_tag".
				 */
				static final String ACTIVITY_TAG = "DELETE FROM activity_tag;";

				/**
				 * Empties the table "album".
				 */
				static final String ALBUM = "DELETE FROM album;";

				/**
				 * Empties the table "festival".
				 */
				static final String FESTIVAL = "DELETE FROM festival;";

				/**
				 * Empties the table "festival_day".
				 */
				static final String FESTIVAL_DAY = "DELETE FROM festival_day;";

				/**
				 * Empties the table "festival_event_city".
				 */
				static final String FESTIVAL_EVENT_CITY = "DELETE FROM festival_event_city;";

				/**
				 * Empties the table "festival_event_gm".
                 */
				static final String FESTIVAL_EVENT_GM = "DELETE FROM festival_event_gm;";

				/**
				 * Empties the table "festival_event_image".
				 */
				static final String FESTIVAL_EVENT_IMAGE = "DELETE FROM festival_event_image;";

				/**
				 * Empties the table "festival_offer".
				 */
				static final String FESTIVAL_OFFER = "DELETE FROM festival_offer;";

				/**
				 * Empties the table "location".
				 */
				static final String LOCATION = "DELETE FROM location;";

				/**
				 * Empties the table "notification".
				 */
				static final String NOTIFICATION = "DELETE FROM notification;";

				/**
				 * Empties the table "people".
				 */
				static final String PEOPLE = "DELETE FROM people;";

				/**
				 * Empties the table "photo".
				 */
				static final String PHOTO = "DELETE FROM photo;";

				/**
				 * Empties the table "photo_album".
				 */
				static final String PHOTO_ALBUM = "DELETE FROM photo_album;";

				/**
				 * Empties the table "photo_comment".
				 */
				static final String PHOTO_COMMENT = "DELETE FROM photo_comment;";

				/**
				 * Empties the table "place".
				 */
				static final String PLACE = "DELETE FROM place;";

				/**
				 * Empties the table "post".
				 */
				static final String POST = "DELETE FROM post;";

				/**
				 * Empties the table "post_comment".
				 */
				static final String POST_COMMENT = "DELETE FROM post_comment;";

				/**
				 * Empties the table "post_image".
				 */
				static final String POST_IMAGE = "DELETE FROM post_image;";

				/**
				 * Empties the table "post_tag".
				 */
				static final String POST_TAG = "DELETE FROM post_tag;";

				/**
				 * Empties the table "route".
				 */
				static final String ROUTE = "DELETE FROM route;";

				/**
				 * Empties the table "route_point".
				 */
				static final String ROUTE_POINT = "DELETE FROM route_point;";

				/**
				 * Empties the table "settings".
				 */
				static final String SETTINGS = "DELETE FROM settings;";

				/**
				 * Empties the table "sponsor".
				 */
				static final String SPONSOR = "DELETE FROM sponsor;";

				/**
				 * Empties the table "version".
				 */
				static final String VERSION = "DELETE FROM version;";
			}

			/**
			 * Queries to remove and the recreate tables.
			 */
			@SuppressWarnings("unused")
			final class RECREATE {

				/**
				 * Deletes and then recreates the table "activity".
				 */
				static final String ACTIVITY = GM.DB.QUERY.DROP.ACTIVITY + GM.DB.QUERY.CREATE.ACTIVITY;

				/**
				 * Deletes and then recreates the table "activity_comment".
				 */
				static final String ACTIVITY_COMMENT = GM.DB.QUERY.DROP.ACTIVITY_COMMENT + GM.DB.QUERY.CREATE.ACTIVITY_COMMENT;

				/**
				 * Deletes and then recreates the table "activity_image".
				 */
				static final String ACTIVITY_IMAGE = GM.DB.QUERY.DROP.ACTIVITY_IMAGE + GM.DB.QUERY.CREATE.ACTIVITY_IMAGE;

				/**
				 * Deletes and then recreates the table "itinerary".
				 */
				static final String ACTIVITY_ITINERARY = GM.DB.QUERY.DROP.ACTIVITY_ITINERARY + GM.DB.QUERY.CREATE.ACTIVITY_ITINERARY;

				/**
				 * Deletes and then recreates the table "activity_tag".
				 */
				static final String ACTIVITY_TAG = GM.DB.QUERY.DROP.ACTIVITY_TAG + GM.DB.QUERY.CREATE.ACTIVITY_TAG;

				/**
				 * Deletes and then recreates the table "album".
				 */
				static final String ALBUM = GM.DB.QUERY.DROP.ALBUM + GM.DB.QUERY.CREATE.ALBUM;

				/**
				 * Deletes and then recreates the table "festival".
				 */
				static final String FESTIVAL = GM.DB.QUERY.DROP.FESTIVAL + GM.DB.QUERY.CREATE.FESTIVAL;

				/**
				 * Deletes and then recreates the table "festival_day".
				 */
				static final String FESTIVAL_DAY = GM.DB.QUERY.DROP.FESTIVAL_DAY + GM.DB.QUERY.CREATE.FESTIVAL_DAY;

				/**
				 * Deletes and then recreates the table "festival_event_city".
				 */
				static final String FESTIVAL_EVENT_CITY = GM.DB.QUERY.DROP.FESTIVAL_EVENT_CITY + GM.DB.QUERY.CREATE.FESTIVAL_EVENT_CITY;

				/**
				 * Deletes and then recreates the table "festival_event_gm".
				 */
				static final String FESTIVAL_EVENT_GM = GM.DB.QUERY.DROP.FESTIVAL_EVENT_GM + GM.DB.QUERY.CREATE.FESTIVAL_EVENT_GM;

				/**
				 * Deletes and then recreates the table "festival_event_image".
				 */
				static final String FESTIVAL_EVENT_IMAGE = GM.DB.QUERY.DROP.FESTIVAL_EVENT_IMAGE + GM.DB.QUERY.CREATE.FESTIVAL_EVENT_IMAGE;

				/**
				 * Deletes and then recreates the table "festival_offer".
				 */
				static final String FESTIVAL_OFFER = GM.DB.QUERY.DROP.FESTIVAL_OFFER + GM.DB.QUERY.CREATE.FESTIVAL_OFFER;

				/**
				 * Deletes and then recreates the table "location".
				 */
				static final String LOCATION = GM.DB.QUERY.DROP.LOCATION + GM.DB.QUERY.CREATE.LOCATION;

				/**
				 * Deletes and then recreates the table "notification".
				 */
				static final String NOTIFICATION = GM.DB.QUERY.DROP.NOTIFICATION + GM.DB.QUERY.CREATE.NOTIFICATION;

				/**
				 * Deletes and then recreates the table "people".
				 */
				static final String PEOPLE = GM.DB.QUERY.DROP.PEOPLE + GM.DB.QUERY.CREATE.PEOPLE;

				/**
				 * Deletes and then recreates the table "photo".
				 */
				static final String PHOTO = GM.DB.QUERY.DROP.PHOTO + GM.DB.QUERY.CREATE.PHOTO;

				/**
				 * Deletes and then recreates the table "photo_album".
				 */
				static final String PHOTO_ALBUM = GM.DB.QUERY.DROP.PHOTO_ALBUM + GM.DB.QUERY.CREATE.PHOTO_ALBUM;

				/**
				 * Deletes and then recreates the table "photo_comment".
				 */
				static final String PHOTO_COMMENT = GM.DB.QUERY.DROP.PHOTO_COMMENT + GM.DB.QUERY.CREATE.PHOTO_COMMENT;

				/**
				 * Deletes and then recreates the table "place".
				 */
				static final String PLACE = GM.DB.QUERY.DROP.PLACE + GM.DB.QUERY.CREATE.PLACE;

				/**
				 * Deletes and then recreates the table "post".
				 */
				static final String POST = GM.DB.QUERY.DROP.POST + GM.DB.QUERY.CREATE.POST;

				/**
				 * Deletes and then recreates the table "post_comment".
				 */
				static final String POST_COMMENT = GM.DB.QUERY.DROP.POST_COMMENT + GM.DB.QUERY.CREATE.POST_COMMENT;

				/**
				 * Deletes and then recreates the table "post_image".
				 */
				static final String POST_IMAGE = GM.DB.QUERY.DROP.POST_IMAGE + GM.DB.QUERY.CREATE.POST_IMAGE;

				/**
				 * Deletes and then recreates the table "post_tag".
				 */
				static final String POST_TAG = GM.DB.QUERY.DROP.POST_TAG + GM.DB.QUERY.CREATE.POST_TAG;

				/**
				 * Deletes and then recreates the table "route".
				 */
				static final String ROUTE = GM.DB.QUERY.DROP.ROUTE + GM.DB.QUERY.CREATE.ROUTE;

				/**
				 * Deletes and then recreates the table "route_point".
				 */
				static final String ROUTE_PONT = GM.DB.QUERY.DROP.ROUTE_POINT + GM.DB.QUERY.CREATE.ROUTE_POINT;

				/**
				 * Deletes and then recreates the table "settings".
				 */
				static final String SETTINGS = GM.DB.QUERY.DROP.SETTINGS + GM.DB.QUERY.CREATE.SETTINGS;

				/**
				 * Deletes and then recreates the table "sponsor".
				 */
				static final String SPONSOR = GM.DB.QUERY.DROP.SPONSOR + GM.DB.QUERY.CREATE.SPONSOR;

				/**
				 * Deletes and then recreates the table "version".
				 */
				static final String VERSION = GM.DB.QUERY.DROP.VERSION + GM.DB.QUERY.CREATE.VERSION;
			}
		}
	}

	/**
	 * Keys and values of data that the app needs to store.
	 */
	static final class DATA {

		/**
		 * Name of the file where data will be stored.
		 */
		static final String DATA = "data";

		/**
		 * Keys of data that the app needs to store.
		 */
		static final class KEY {

			/**
			 * Key of the data string to store the user id with.
			 */
			static final String USER = "user_id";

			/**
			 * Key of the data to store the previous app version with.
			 */
			static final String PREVIOUS_APP_VERSION = "previous_app_version";

			/**
			 * Key of the data to store if ther is a festival season.
			 */
			static final String LABLANCA = "lablanca";

			/**
			 * Key that indicates if comments can be posted.
			 */
			static final String COMMENTS = "comments";

			/**
			 * Key that indicates if photos can be uploaded.
			 */
			static final String PHOTOS = "photos";
		}

		/**
		 * Default values of data that the app needs to store.
		 */
		static final class DEFAULT {


			/**
			 * Default string for the user.
			 */
			static final String USER = "";

			/**
			 * Default value for the previous app version data.
			 */
			static final int PREVIOUS_APP_VERSION = 0;

			/**
			 * Default value for the data that indicates if it's festival season.
			 */
			static final boolean LABLANCA = false;

			/**
			 * Default value for the key that indicates if comments can be posted.
			 */
			static final boolean COMMENTS = false;

			/**
			 * Default value for the key that indicates if photos can be uploaded.
			 */
			static final boolean PHOTOS = false;
		}
	}

	/**
	 * Keys and values of the app settings.
	 */
	static final class PREFERENCES {

		/**
		 * Name of the file where preferences will be stored.
		 */
		static final String PREFERNCES = "preferences";

		/**
		 * Keys of the app settings.
		 */
		static final class KEY {

			/**
			 * Key to store the sync status.
			 */
			static final String SYNC = "performBackgroundSyncs";

			/**
			 * Key to store the notification preference status.
			 */
			static final String NOTIFICATIONS = "recieveNotificacions";
		}

		/**
		 * Default values of the app settings.
		 */
		static final class DEFAULT {

			/**
			 * Default value for the sync preference.
			 */
			static final boolean SYNC = true;

			/**
			 * Default value for the notification preference.
			 */
			static final boolean NOTIFICATIONS = true;
		}
	}

	/**
	 * Used URLs.
	 */
	static class URL {

		/**
		 * URL of the project on GitHub.
		 */
		static final String GITHUB = "https://github.com/GasteizkoMargolariak/GasteizkoMargolariakApp";

		/**
		 * URL of the Open Street Maps copyright.
		 */
		static final String OSM_COPYRIGHT = "https://www.openstreetmap.org/copyright";

		/**
		 * URL of the server.
		 */
		//static final String SERVER = "https://margolariak.com";
		static final String SERVER = "http://192.168.1.101";
	}

	/**
	 * Info about the API.
	 */
	static final class API {

		/**
		 * Name of the client.
		 */
		static final String CLIENT = "com.ivalentin.margolariak";

		/**
		 * URL of the server.
		 */
		static final String SERVER = URL.SERVER;

		/**
		 * Utilities for the Sync V3 API.
		 */
		static final class SYNC {

			/**
			 * Path to the API.
			 */
			static final class PATH {

				/**
				 * Path to the fast sync API.
				 */
				static final String FAST= "/API/v3/fastsync.php";

				/**
				 * Path to the regular sync API.
				 */
				static final String COMPLETE= "/API/v3/sync.php";
			}

			/**
			 * Keys fotr the API parameters.
			 */
			static final class KEY {

				/**
				 * Key for the client identifier.
				 */
				static final String CLIENT = "client";

				/**
				 * Key for the user identifier.
				 */
				static final String USER = "user";

				/**
				 * Key to indicate to the API if the sync is being performed on the foreground.
				 */
				static final String FOREGROUND = "foreground";

			}
		}

		/**
		 * Utilities for the Location V3 API.
		 */
		static final class LOCATION {

			/**
			 * Path to the API.
			 */
			static final String PATH = "/API/v3/location.php";
		}

		/**
		 * Utilities for the Notifications V3 API.
		 */
		static final class NOTIFICATION {

			/**
			 * Path to the API.
			 */
			static final String PATH = "/API/v3/notifications.php";

			/**
			 * Keys fotr the API parameters.
			 */
			static final class KEY {

				/**
				 * Key for the client identifier.
				 */
				static final String CLIENT = "client";

				/**
				 * Key for the user identifier.
				 */
				static final String USER = "user";

				/**
				 * Key for the action to perform with the API ("sync" or "version").
				 */
				static final String TARGET = "target";
			}
		}

		/**
		 * Utilities for the COMMENT V3 API.
		 */
		static final class COMMENT {

			/**
			 * Path to the API.
			 */
			static final String PATH = "/API/v3/comment.php";

			/**
			 * Keys fotr the API parameters.
			 */
			static final class KEY {

				/**
				 * Key for the client identifier.
				 */
				static final String CLIENT = "client";

				/**
				 * Key for the user identifier.
				 */
				static final String USER = "user";

				/**
				 * Key for the action to perform with the API ("sync" or "version").
				 */
				static final String TARGET = "target";

				/**
				 * Key to indicate the format of the data for the API to send.
				 */
				static final String ID = "id";

				/**
				 * Key to indicate the comment's username.
				 */
				static final String USERNAME = "username";

				/**
				 * Key to indicate the text.
				 */
				static final String TEXT = "text";

			}
		}

	}

	/**
	 * App permissions.
	 */
	static final class PERMISSION {

		/**
		 * Code for the location permission request
		 */
		static final int LOCATION = 1;
	}


	/**
	 * Periods to perform syncs.
	 */
	static final class PERIOD_SYNC {

		/**
		 * Period of time (in seconds) at the end of witch the app will perform a sync during the festivals.
		 */
		static final int FESTIVALS = 20 * 60 * 1000;

		/**
		 * Period of time (in seconds) at the end of witch the app will perform a sync if no festivals.
		 */
		static final int NORMAL = 60 * 60 * 1000;
	}

	/**
	 * Identifiers to differenciate schedules.
	 */
	static final class SCHEDULE {

		/**
		 * Key to pass as bundle.
		 */
		static final String KEY = "schedule";

		/**
		 * City schedule.
		 */
		static final int CITY = 0;

		/**
		 * Margolari schedule.
		 */
		static final int MARGOLARIAK = 1;
	}

	/**
	 * Extras to pass to the main activity to open notifications.
	 */
	static final class EXTRA {

		/**
		 * Title of the notification.
		 */
		static final String TITLE = "title";

		/**
		 * Text of the notification.
		 */
		static final String TEXT = "text";

		/**
		 * Action for the button in the notification.
		 */
		static final String ACTION = "action";

		/**
		 * Sections to open with the notification.
		 */
		static final class SECTION {

			/**
			 * Value for {@see GM.EXTRA.ACTION} that opens the lablanca section.
			 */
			static final String LABLANCA = "lablanca";

			/**
			 * Value for {@see GM.EXTRA.ACTION} that opens the official schedule.
			 */
			static final String SCHEDULE = "cityschedule";

			/**
			 * Value for {@see GM.EXTRA.ACTION} that opens the GM schedule.
			 */
			static final String GMSCHEDULE = "gmschedule";

			/**
			 * Value for {@see GM.EXTRA.ACTION} that opens the location secton.
			 */
			static final String LOCATION = "location";

			/**
			 * Value for {@see GM.EXTRA.ACTION} that opens the blog.
			 */
			static final String BLOG = "blog";

			/**
			 * Value for {@see GM.EXTRA.ACTION} that opens the activities section.
			 */
			static final String ACTIVITIES = "activities";

			/**
			 * Value for {@see GM.EXTRA.ACTION} that opens the gallery section.
			 */
			static final String GALLERY = "gallery";
		}
	}

	/**
	 * Identifiers for app sections.
	 */
	static final class SECTION {

		/**
		 * Constant for section "Home".
		 */
		static final byte HOME = 0;

		/**
		 * Constant for La Blanca section "Location".
		 */
		static final byte LOCATION = 1;

		/**
		 * Constant for section "La Blanca".
		 */
		static final byte LABLANCA = 2;

		/**
		 * Constant for La Blanca section "Festival schedule".
		 */
		static final byte SCHEDULE = 20;

		/**
		 * Constant for La Blanca section "Gasteizko Margolariak Schedule".
		 */
		static final byte GM_SCHEDULE = 21;

		/**
		 * Constant for section "Activities".
		 */
		static final byte ACTIVITIES = 3;

		/**
		 * Constant for section "Blog".
		 */
		static final byte BLOG = 4;

		/**
		 * Constant for section "Gallery".
		 */
		static final byte GALLERY = 5;
	}

	/**
	 * Keys for the location manager.
	 */
	static class LOCATION {

		/**
		 * Required accuracy for the location manager.
		 */
		static class ACCURACY {

			/**
			 * The desired accuracy of the GPS coordinates, used to provide location updates, in meters.
			 */
			static final int SPACE = 10;

			/**
			 * The desired accuracy of the GPS coordinates, used to provide location updates, in milliseconds.
			 */
			static final int TIME = 10000;
		}

		/**
		 * Time interval to retrieve notifications.
		 */
		static final int INTERVAL = 10000;
	}

	/**
	 * Data for the images.
	 */
	static final class IMG {

		/**
		 * Dimensions of the images in the database.
		 */
		static final class SIZE {

			/**
			 * Max width and height for miniature images.
			 */
			static final int MINIATURE = 340;

			/**
			 * Max width and height for preview images.
			 */
			static final int PREVIEW = 600;

			/**
			 * Max width and height for thumbnail images.
			 */
			@SuppressWarnings("unused")
			static final int THUMB = 180;

			/**
			 * Max width and height for view images.
			 */
			static final int VIEW = 800;
		}
	}


	/**
	 * Programmatically loaded rows needs their margin to also be set programmatically.
	 */
	static final class UI {

		/**
		 * Margin for entries.
		 */
		static final int ENTRY_MARGIN = 8;
	}

	/**
	 * URLs to be shared.
	 */
	static final class SHARE {
		static final String HOME = "https://www.margolariak.com";
		static final String LABLANCA = HOME + "/lablanca/";
		static final String ACTIVITIES = HOME + "/actividades/";
		static final String BLOG = HOME + "/blog/";
		static final String GALLERY = HOME + "/galeria/";
	}

	/**
	 * Gets the language code for sql queries.
	 * Only three values can be returned: es, eu, en.
	 * Defaults to es.
	 *
	 * @return Language two-letter code
	 */
	public static String getLang(){
		String currLang = Locale.getDefault().getISO3Language();
		switch (currLang){
			case "eng":
				currLang = "en";
				break;
			case "eus":
				currLang = "eu";
				break;
			default:
				currLang = "es";
		}
		return currLang;
	}

	/**
	 * Formats a datetime format strings and returns a human readable date, depending on the language
	 *
	 * @param dateString String in a datetime format.
	 * @param lang Language (es, en, eu).
	 * @param includeDay Also returns the weekday.
	 * @param includeYear Also returns the year.
	 * @param includeTime Also returns the hour and minute.
	 *
	 * @return The fragment view
	 *
	 * @see android.support.v4.app.Fragment#onCreateView(android.view.LayoutInflater, android.view.ViewGroup, android.os.Bundle)
	 */
	static String formatDate(String dateString, String lang, boolean includeDay, boolean includeYear, boolean includeTime){

		String output = "";

		String dayNameEs[] = {"dummy", "Domingo",  "Lunes", "Martes", "Miércoles", "Jueves", "Viernes", "Sábado"};
		String dayNameEn[] = {"dummy", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"};
		String dayNameEu[] = {"dummy", "igandea", "astelehena", "asteartea", "asteazkena", "osteguna", "ostirala", "larumbata"};
		String monthNameEs[] = {"enero", " febrero", "marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre"};
		String monthNameEn[] = {"January", "February", "March", "April", "May", "June", "July", "Augost", "September", "Octuber", "November", "December"};
		String monthNameEu[] = {"urtarrilaren", "otsailaren", "martxoaren", "apirilaren", "maiatzaren", "ekainaren", "uztailaren", "abuztuaren", "irailaren", "urriaren", "azaroaren", "abenduaren"};

		if (!lang.equals("es") && !lang.equals("eu")){
			lang = "en";
		}
		DateFormat format = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss", Locale.ENGLISH);
		SimpleDateFormat df;
		Date date;
		try{
			date = format.parse(dateString);
			df = new SimpleDateFormat("yyyy", Locale.US);
			String year = df.format(date);
			df = new SimpleDateFormat("hh:mm", Locale.US);
			String time = df.format(date);
			String dayName, monthName;

			Calendar calendar = Calendar.getInstance();
			calendar.setTime(date);
			int dayNumber = calendar.get(Calendar.DAY_OF_WEEK);
			int day = calendar.get(Calendar.DAY_OF_MONTH);
			int monthNumber = calendar.get(Calendar.MONTH);

			switch (lang){
				case "es":
					dayName = dayNameEs[dayNumber];
					monthName = monthNameEs[monthNumber];
					output = "";
					if (includeDay){
						output = dayName + ", ";
					}
					output = output + day + " de " + monthName;
					if (includeYear){
						output = output + " de " + year;
					}
					if (includeTime){
						output = output + " a las " + time;
					}
					break;
				case "eu":
					dayName = dayNameEu[dayNumber];
					monthName = monthNameEu[monthNumber];
					output = "";
					if (includeYear){
						output = year + "ko";
					}
					output = output + monthName + " " + day + "an";
					if (includeDay){
						output = output + ", " + dayName;
					}
					if (includeTime){
						output = output + " " + time + "etan";
					}
					break;
				default:
					dayName = dayNameEn[dayNumber];
					monthName = monthNameEn[monthNumber];
					output = "";
					if (includeDay){
						output = dayName + ", ";
					}
					output = output + monthName + " " + day;
					if (includeYear){
						output = output + ", " + year;
					}
					if (includeTime){
						output = output + " " + time;
					}
					break;
			}
		}
		catch(Exception ex){
			Log.e("Date format error", ex.toString());
		}

		return output;
	}

	/**
	 * Creates a bitmap from a image.
	 *
	 * @param path Path of the image.
	 * @param size Max width and height.
	 * @return A bitmap with the image.
	 */
	static Bitmap decodeSampledBitmapFromFile(String path, int size) { // BEST QUALITY MATCH

		// First decode with inJustDecodeBounds=true to check dimensions
		final BitmapFactory.Options options = new BitmapFactory.Options();
		options.inJustDecodeBounds = true;
		BitmapFactory.decodeFile(path, options);

		// Calculate inSampleSize
		// Raw height and width of image
		final int height = options.outHeight;
		final int width = options.outWidth;
		options.inPreferredConfig = Bitmap.Config.RGB_565;
		int inSampleSize = 1;

		if (height > size) {
			inSampleSize = Math.round((float)height / (float)size);
		}

		int expectedWidth = width / inSampleSize;

		if (expectedWidth > size) {
			//if(Math.round((float)width / (float)reqWidth) > inSampleSize) // If bigger SampSize..
			inSampleSize = Math.round((float)width / (float)size);
		}


		options.inSampleSize = inSampleSize;

		// Decode bitmap with inSampleSize set
		options.inJustDecodeBounds = false;

		return BitmapFactory.decodeFile(path, options);
	}
}