utils

const API_KEY_apikey = "apikey"

const API_KEY_appname = "appname"

const API_KEY_clientid = "clientid"

const API_KEY_email = "email"

const API_KEY_file = "file"

const API_KEY_filename = "filename"

const API_KEY_image = "image"

const API_KEY_inviteid = "inviteid"

const API_KEY_message = "message"

const API_KEY_name = "name"

const API_KEY_pagenum = "pagenum"

const API_KEY_pagesize = "pagesize"

const API_KEY_password = "password"

const API_KEY_sequence = "sequence"

const API_KEY_startnum = "startnum"

const API_KEY_time = "time"

const API_KEY_token = "token"

const API_KEY_username = "username"

const API_URL = "http://localhost"

const API_URL_domain = "localhost"

const DB_NAME = "stunt.sqlite"

const DB_TYPE = "sqlite3"

const INVITE_VALIDITY_MS = 60 * 15 * 1000

const PATH_AddApiKey = "/apikeyadd"

const PATH_ApiKeyDelete = "/apikeydelete"

const PATH_ApiKeyDeleteConfirm = "/apikeydeleteconfirm"

const PATH_ApiKeys = "/apikeys"

const PATH_CLIENTINFO = "/sendclientinfo"

const PATH_ClientIds = "/clientids"

const PATH_ClientInfoUpdate = "/updateclientinfo"

const PATH_Login = "/login"

const PATH_MESSAGE = "/message"

const PATH_ROOT = "/"

const PATH_Register = "/register"

const PATH_Reports = "/reports"

const PATH_STATIC_TEMPLATES = "./templates"

const PATH_UPLOADFILE = "/uploadfile"

const PATH_UPLOADIMAGE = "/uploadimage"

const PATH_download = "/exports"

const PATH_filelog_delete = "/filelogdelete"

const PATH_invite = "/invite"

const PATH_logout = "/logout"

const PATH_reports_delete = "/reportsdelete"

const PATH_reports_delete_confirm = "/reportsdeleteconfirm"

const PORT_8080 = "8080"

const REPORTS_PAGE_SIZE = 100

const SALT_LENGTH = 32

const STMT_CREATE_TABLE_APIKEYS = "create table if not exists apikeys('id' integer primary key, 'userid' integer, 'apikey' text, 'appname' text)"

const STMT_CREATE_TABLE_CLIENTINFO = "" /* 128-byte string literal not displayed */

const STMT_CREATE_TABLE_INVITES = "" /* 131-byte string literal not displayed */

const STMT_CREATE_TABLE_REPORTS = "" /* 148-byte string literal not displayed */

const STMT_CREATE_TABLE_TOKENS = "" /* 128-byte string literal not displayed */

const STMT_CREATE_TABLE_USERS = "create table if not exists users('id' integer primary key, 'email' text unique, 'password' text, 'salt' text)"

const STMT_INSERT_INTO_APIKEYS = "insert or ignore into apikeys(userid, apikey, appname) values(?, ?, ?)"

const STMT_INSERT_INTO_CLIENTINFO = "insert or ignore into clientinfo%s(clientid, name, manufacturer, model, deviceid) values(?, ?, ?, ?, ?)"

const STMT_INSERT_INTO_INVITES = "insert or ignore into invites%s(inviteid, apikey, issued, expires) values(?, ?, ?, ?)"

const STMT_INSERT_INTO_REPORTS = "insert or ignore into reports%s(clientid, time, sequence, message, filepath) values(?, ?, ?, ?, ?)"

const STMT_INSERT_INTO_TOKENS = "insert or ignore into tokens(userid, token, issued, expires) values(?, ?, ?, ?)"

const STMT_INSERT_INTO_USERS = "insert or ignore into users(email, password, salt) values(?, ?, ?)"

const STR_All_clients = "All clients"

const STR_Authorization = "Authorization"

const STR_BLANK = " "

const STR_EMPTY = ""

const STR_GET = "GET"

const STR_MSG_404 = "404, Page not found"

const STR_MSG_NOTFOUND = "404 Not found"

const STR_MSG_invalidapikey = "Invalid api key"

const STR_MSG_invalidclientid = "Invalid client id"

const STR_MSG_login = "Please login"

const STR_MSG_register = "Please enter email and password"

const STR_MSG_server_error = "500 Server error"

const STR_PORT = "PORT"

const STR_POST = "POST"

const STR_error = "error"

const STR_export = "export"

const STR_filepath_download_template = "resources/exports/%s"

const STR_filepath_filelog = "resources/logs/logfile.txt"

const STR_filepath_upload_template = "resources/reportfiles/%s"

const STR_id = "id"

const STR_symbol_colon = ":"

const STR_symbol_dash = "-"

const STR_symbol_dot = "."

const STR_template_add_apikey_html = "templates/add_apikey.html"

const STR_template_apikey_deleteconfirm_html = "templates/apikey_deleteconfirm.html"

const STR_template_export_html = "templates/export.html"

const STR_template_invite_html = "templates/invite.html"

const STR_template_list_apikeys_html = "templates/list_apikeys.html"

const STR_template_list_clientids_for_apikey_html = "templates/list_clientids_for_apikey.html"

const STR_template_list_reports_for_apikey_html = "templates/list_reports_for_apikey.html"

const STR_template_page_error_html = "templates/page_error.html"

const STR_template_reports_deleteconfirm_html = "templates/reports_deleteconfirm.html"

const STR_template_result = "templates/result.json"

const STR_templates_Content_html = "templates/Page1.html"

const STR_templates_login_html = "templates/login.html"

const STR_templates_register_html = "templates/register.html"

const STR_txt = "txt"

const TABLE_APIKEYS_COLUMN_apikey = "apikey"

const TABLE_APIKEYS_COLUMN_appname = "appname"

const TABLE_APIKEYS_COLUMN_userid = "userid"

const TABLE_CLIENTINFO_clientid = "clientid"

const TABLE_CLIENTINFO_deviceid = "deviceid"

const TABLE_CLIENTINFO_manufacturer = "manufacturer"

const TABLE_CLIENTINFO_model = "model"

const TABLE_CLIENTINFO_name = "name"

const TABLE_INVITES_COLUMN_apikey = TABLE_APIKEYS_COLUMN_apikey

const TABLE_INVITES_COLUMN_expires = TABLE_TOKENS_COLUMN_expires

const TABLE_INVITES_COLUMN_inviteid = "inviteid"

const TABLE_INVITES_COLUMN_issued = TABLE_TOKENS_COLUMN_issued

const TABLE_REPORTS_COLUMN_clientid = "clientid"

const TABLE_REPORTS_COLUMN_filepath = "filepath"

const TABLE_REPORTS_COLUMN_id = STR_id

const TABLE_REPORTS_COLUMN_message = "message"

const TABLE_REPORTS_COLUMN_sequence = "sequence"

const TABLE_REPORTS_COLUMN_time = "time"

const TABLE_TOKENS_COLUMN_expires = "expires"

const TABLE_TOKENS_COLUMN_id = STR_id

const TABLE_TOKENS_COLUMN_issued = "issued"

const TABLE_TOKENS_COLUMN_token = "token"

const TABLE_TOKENS_COLUMN_userid = "userid"

const TABLE_USERS_COLUMN_email = "email"

const TABLE_USERS_COLUMN_id = STR_id

const TABLE_USERS_COLUMN_password = "password"

const TABLE_USERS_COLUMN_salt = "salt"

const TABLE_apikeys = "apikeys"

const TABLE_clientinfo = "clientinfo"

const TABLE_invites = "invites"

const TABLE_reports = "reports"

const TABLE_tokens = "tokens"

const TABLE_users = "users"

const TOKEN_VALIDITY_MS = TOKEN_VALIDITY_SECONDS * 1000

const TOKEN_VALIDITY_SECONDS = 60 * 60 * 24