package Torello.Browser;

import java.util.*;
import javax.json.*;
import javax.json.stream.*;
import java.io.*;

import java.lang.reflect.Method;
import java.lang.reflect.Parameter;
import java.util.function.Function;

import Torello.Java.Additional.*;
import Torello.Java.JSON.*;

import static Torello.Java.JSON.JFlag.*;

import Torello.Java.StrCmpr;
import Torello.JavaDoc.StaticFunctional;
import Torello.JavaDoc.JDHeaderBackgroundImg;
import Torello.JavaDoc.Excuse;

/**
 * <SPAN CLASS=COPIEDJDK><B><CODE>[No Description Provided by Google]</CODE></B></SPAN>
 * 
 * <EMBED CLASS='external-html' DATA-FILE-ID=CODE_GEN_NOTE>
 */
@StaticFunctional(Excused={"counter"}, Excuses={Excuse.CONFIGURATION})
@JDHeaderBackgroundImg(EmbedTagFileID="WOOD_PLANK_NOTE")
public class Database
{
    // ********************************************************************************************
    // ********************************************************************************************
    // Class Header Stuff
    // ********************************************************************************************
    // ********************************************************************************************


    // No Pubic Constructors
    private Database () { }

    // These two Vector's are used by all the "Methods" exported by this class.  java.lang.reflect
    // is used to generate the JSON String's.  It saves thousands of lines of Auto-Generated Code.
    private static final Map<String, Vector<String>>    parameterNames = new HashMap<>();
    private static final Map<String, Vector<Class<?>>>  parameterTypes = new HashMap<>();

    // Some Methods do not take any parameters - for instance all the "enable()" and "disable()"
    // I simply could not get ride of RAW-TYPES and UNCHECKED warnings... so there are now,
    // offically, two empty-vectors.  One for String's, and the other for Classes.

    private static final Vector<String>     EMPTY_VEC_STR = new Vector<>();
    private static final Vector<Class<?>>   EMPTY_VEC_CLASS = new Vector<>();

    static
    {
        for (Method m : Database.class.getMethods())
        {
            // This doesn't work!  The parameter names are all "arg0" ... "argN"
            // It works for java.lang.reflect.Field, BUT NOT java.lang.reflect.Parameter!
            //
            // Vector<String> parameterNamesList = new Vector<>(); -- NOPE!

            Vector<Class<?>> parameterTypesList = new Vector<>();
        
            for (Parameter p : m.getParameters()) parameterTypesList.add(p.getType());

            parameterTypes.put(
                m.getName(),
                (parameterTypesList.size() > 0) ? parameterTypesList : EMPTY_VEC_CLASS
            );
        }
    }

    static
    {
        Vector<String> v = null;

        parameterNames.put("disable", EMPTY_VEC_STR);

        parameterNames.put("enable", EMPTY_VEC_STR);

        v = new Vector<String>(2);
        parameterNames.put("executeSQL", v);
        Collections.addAll(v, new String[]
        { "databaseId", "query", });

        v = new Vector<String>(1);
        parameterNames.put("getDatabaseTableNames", v);
        Collections.addAll(v, new String[]
        { "databaseId", });
    }


    // ********************************************************************************************
    // ********************************************************************************************
    // Types - Static Inner Classes
    // ********************************************************************************************
    // ********************************************************************************************

    // public static class DatabaseId => String
    
    /** Database object. */
    public static class _Database
        extends BaseType
        implements java.io.Serializable
    {
        /** For Object Serialization.  java.io.Serializable */
        protected static final long serialVersionUID = 1;
        
        public boolean[] optionals()
        { return new boolean[] { false, false, false, false, }; }
        
        /** Database ID. */
        public final String id;
        
        /** Database domain. */
        public final String domain;
        
        /** Database name. */
        public final String name;
        
        /** Database version. */
        public final String version;
        
        /**
         * Constructor
         *
         * @param id Database ID.
         * 
         * @param domain Database domain.
         * 
         * @param name Database name.
         * 
         * @param version Database version.
         */
        public _Database(String id, String domain, String name, String version)
        {
            // Exception-Check(s) to ensure that if any parameters which are not declared as
            // 'Optional', but have a 'null' value anyway, that a NullPointerException shall throw.
            
            if (id == null)      BRDPC.throwNPE("id");
            if (domain == null)  BRDPC.throwNPE("domain");
            if (name == null)    BRDPC.throwNPE("name");
            if (version == null) BRDPC.throwNPE("version");
            
            this.id       = id;
            this.domain   = domain;
            this.name     = name;
            this.version  = version;
        }
        
        /**
         * JSON Object Constructor
         * @param jo A Json-Object having data about an instance of {@code 'Database'}.
         */
        public _Database (JsonObject jo)
        {
            this.id       = ReadJSON.getString(jo, "id", false, true);
            this.domain   = ReadJSON.getString(jo, "domain", false, true);
            this.name     = ReadJSON.getString(jo, "name", false, true);
            this.version  = ReadJSON.getString(jo, "version", false, true);
        }
        
        
        /** Checks whether {@code 'this'} equals an input Java-{@code Object} */
        public boolean equals(Object other)
        {
            if (other == null)                       return false;
            if (other.getClass() != this.getClass()) return false;
        
            _Database o = (_Database) other;
        
            return
                    Objects.equals(this.id, o.id)
                &&  Objects.equals(this.domain, o.domain)
                &&  Objects.equals(this.name, o.name)
                &&  Objects.equals(this.version, o.version);
        }
        
        /** Generates a Hash-Code for {@code 'this'} instance */
        public int hashCode()
        {
            return
                    Objects.hashCode(this.id)
                +   Objects.hashCode(this.domain)
                +   Objects.hashCode(this.name)
                +   Objects.hashCode(this.version);
        }
    }
    
    /** Database error. */
    public static class Error
        extends BaseType
        implements java.io.Serializable
    {
        /** For Object Serialization.  java.io.Serializable */
        protected static final long serialVersionUID = 1;
        
        public boolean[] optionals()
        { return new boolean[] { false, false, }; }
        
        /** Error message. */
        public final String message;
        
        /** Error code. */
        public final int code;
        
        /**
         * Constructor
         *
         * @param message Error message.
         * 
         * @param code Error code.
         */
        public Error(String message, int code)
        {
            // Exception-Check(s) to ensure that if any parameters which are not declared as
            // 'Optional', but have a 'null' value anyway, that a NullPointerException shall throw.
            
            if (message == null) BRDPC.throwNPE("message");
            
            this.message  = message;
            this.code     = code;
        }
        
        /**
         * JSON Object Constructor
         * @param jo A Json-Object having data about an instance of {@code 'Error'}.
         */
        public Error (JsonObject jo)
        {
            this.message  = ReadJSON.getString(jo, "message", false, true);
            this.code     = ReadPrimJSON.getInt(jo, "code");
        }
        
        
        /** Checks whether {@code 'this'} equals an input Java-{@code Object} */
        public boolean equals(Object other)
        {
            if (other == null)                       return false;
            if (other.getClass() != this.getClass()) return false;
        
            Error o = (Error) other;
        
            return
                    Objects.equals(this.message, o.message)
                &&  (this.code == o.code);
        }
        
        /** Generates a Hash-Code for {@code 'this'} instance */
        public int hashCode()
        {
            return
                    Objects.hashCode(this.message)
                +   this.code;
        }
    }
    
    /** <CODE>[No Description Provided by Google]</CODE> */
    public static class addDatabase
        extends BrowserEvent
        implements java.io.Serializable
    {
        /** For Object Serialization.  java.io.Serializable */
        protected static final long serialVersionUID = 1;
        
        public boolean[] optionals()
        { return new boolean[] { false, }; }
        
        /** <CODE>[No Description Provided by Google]</CODE> */
        public final Database._Database database;
        
        /**
         * Constructor
         *
         * @param database -
         */
        public addDatabase(Database._Database database)
        {
            super("Database", "addDatabase", 1);
            
            // Exception-Check(s) to ensure that if any parameters which are not declared as
            // 'Optional', but have a 'null' value anyway, that a NullPointerException shall throw.
            
            if (database == null) BRDPC.throwNPE("database");
            
            this.database  = database;
        }
        
        /**
         * JSON Object Constructor
         * @param jo A Json-Object having data about an instance of {@code 'addDatabase'}.
         */
        public addDatabase (JsonObject jo)
        {
            super("Database", "addDatabase", 1);
        
            this.database  = ReadJSON.getObject(jo, "database", Database._Database.class, false, true);
        }
        
        
        /** Checks whether {@code 'this'} equals an input Java-{@code Object} */
        public boolean equals(Object other)
        {
            if (other == null)                       return false;
            if (other.getClass() != this.getClass()) return false;
        
            addDatabase o = (addDatabase) other;
        
            return
                    Objects.equals(this.database, o.database);
        }
        
        /** Generates a Hash-Code for {@code 'this'} instance */
        public int hashCode()
        {
            return
                    this.database.hashCode();
        }
    }
    
    
    // Counter for keeping the WebSocket Request ID's distinct.
    private static int counter = 1;
    
    /**
     * Disables database tracking, prevents database events from being sent to the client.
     * 
     * @return An instance of <CODE>{@link Script}&lt;String, {@link JsonObject},
     * {@link Ret0}&gt;</CODE>
     *
     * <BR /><BR />This {@code Script} instance must be <B STYLE='color:red'>executed</B> before the
     * browser receives the invocation-request.
     *
     * <BR /><BR />This Browser-Function <I>does not have</I> a return-value.  You may choose to
     * <B STYLE='color: red'>await</B> the {@link Promise}{@code <JsonObject,} {@link Ret0}
     * {@code >} to ensure the Browser Function has run to completion.
     */
    public static Script<String, JsonObject, Ret0> disable()
    {
        final int          webSocketID = 19000000 + counter++;
        final boolean[]    optionals   = new boolean[0];
        
        // Convert Method Parameters into JSON.  Build the JSON Request-Object (as a String)
        String requestJSON = WriteJSON.get(
            parameterTypes.get("disable"),
            parameterNames.get("disable"),
            optionals, webSocketID,
            "Database.disable"
        );
        
        // This Remote Command does not have a Return-Value.
        return new Script<>
            (BRDPC.defaultSender, webSocketID, requestJSON, BRDPC.NoReturnValues);
    }
    
    /**
     * Enables database tracking, database events will now be delivered to the client.
     * 
     * @return An instance of <CODE>{@link Script}&lt;String, {@link JsonObject},
     * {@link Ret0}&gt;</CODE>
     *
     * <BR /><BR />This {@code Script} instance must be <B STYLE='color:red'>executed</B> before the
     * browser receives the invocation-request.
     *
     * <BR /><BR />This Browser-Function <I>does not have</I> a return-value.  You may choose to
     * <B STYLE='color: red'>await</B> the {@link Promise}{@code <JsonObject,} {@link Ret0}
     * {@code >} to ensure the Browser Function has run to completion.
     */
    public static Script<String, JsonObject, Ret0> enable()
    {
        final int          webSocketID = 19001000 + counter++;
        final boolean[]    optionals   = new boolean[0];
        
        // Convert Method Parameters into JSON.  Build the JSON Request-Object (as a String)
        String requestJSON = WriteJSON.get(
            parameterTypes.get("enable"),
            parameterNames.get("enable"),
            optionals, webSocketID,
            "Database.enable"
        );
        
        // This Remote Command does not have a Return-Value.
        return new Script<>
            (BRDPC.defaultSender, webSocketID, requestJSON, BRDPC.NoReturnValues);
    }
    
    /**
     * <CODE>[No Description Provided by Google]</CODE>
     * 
     * @param databaseId -
     * 
     * @param query -
     * 
     * @return An instance of <CODE>{@link Script}&lt;String, {@link JsonObject},
     * {@link Ret3}&gt;</CODE>
     *
     * <BR /><BR />This {@link Script} may be <B STYLE='color:red'>executed</B> (using 
     * {@link Script#exec()}), and a {@link Promise} returned.
     *
     * <BR /><BR />When the {@code Promise} is <B STYLE='color: red'>awaited</B>
     * (using {@link Promise#await()}), the {@code Ret3} will subsequently
     * be returned from that call.
     * 
     * <BR /><BR />The <B STYLE='color: red'>returned</B> values are encapsulated
     * in an instance of <B>{@link Ret3}</B>
     *
     * <BR /><BR /><UL CLASS=JDUL>
     * <LI><CODE><B>Ret3.a:</B> String[] (<B>columnNames</B>)</CODE>
     *     <BR />-
     *     <BR /><BR /></LI>
     * <LI><CODE><B>Ret3.b:</B> JsonArray (<B>values</B>)</CODE>
     *     <BR />-
     *     <BR /><BR /></LI>
     * <LI><CODE><B>Ret3.c:</B> {@link Database.Error} (<B>sqlError</B>)</CODE>
     *     <BR />-
     *     </LI>
     * </UL>
     */
    public static Script<String, JsonObject, Ret3<String[], JsonArray, Database.Error>> executeSQL
        (String databaseId, String query)
    {
        // Exception-Check(s) to ensure that if any parameters which are not declared as
        // 'Optional', but have a 'null' value anyway, that a NullPointerException shall throw.
        
        if (databaseId == null) BRDPC.throwNPE("databaseId");
        if (query == null)      BRDPC.throwNPE("query");
        
        final int       webSocketID = 19002000 + counter++;
        final boolean[] optionals   = { false, false, };
        
        // Convert Method Parameters into JSON.  Build the JSON Request-Object (as a String)
        String requestJSON = WriteJSON.get(
            parameterTypes.get("executeSQL"),
            parameterNames.get("executeSQL"),
            optionals, webSocketID,
            "Database.executeSQL",
            databaseId, query
        );
        
        // 'JSON Binding' ... Converts Browser Response-JSON into Java-Type 'Ret3'
        Function<JsonObject, Ret3<String[], JsonArray, Database.Error>> 
            responseProcessor = (JsonObject jo) -> new Ret3<>(
                (jo.getJsonArray("columnNames") == null)
                    ? null
                    : ReadArrJSON.DimN.strArr(jo.getJsonArray("columnNames"), null, 0, String[].class),
                jo.getJsonArray("values"),
                ReadJSON.getObject(jo, "sqlError", Database.Error.class, true, false)
            );
        
        // Pass the 'defaultSender' to Script-Constructor
        // The sender that is used can be changed before executing script.
        return new Script<>(BRDPC.defaultSender, webSocketID, requestJSON, responseProcessor);
    }
    
    /**
     * <CODE>[No Description Provided by Google]</CODE>
     * 
     * @param databaseId -
     * 
     * @return An instance of <CODE>{@link Script}&lt;String, {@link JsonObject},
     * String[]&gt;</CODE>
     * 
     * <BR /><BR />This <B>script</B> may be <B STYLE='color: red'>executed</B>, using
     * {@link Script#exec()}, and afterwards, a {@link Promise}<CODE>&lt;JsonObject,
     * String[]&gt;</CODE> will be returned.
     *
     * <BR /><BR />Finally, the <B>{@code Promise}</B> may be <B STYLE='color: red'>awaited</B>,
     * using {@link Promise#await()}, <I>and the returned result of this Browser Function may
      * may be retrieved.</I>
     *
     * <BR /><BR />This Browser Function <B STYLE='color: red'>returns</B>
     * <BR /><BR /><UL CLASS=JDUL>
     * <LI><CODE>String[] (<B>tableNames</B></CODE>)
     *     <BR />-
     * </LI>
     * </UL> */
    public static Script<String, JsonObject, String[]> getDatabaseTableNames(String databaseId)
    {
        // Exception-Check(s) to ensure that if any parameters which are not declared as
        // 'Optional', but have a 'null' value anyway, that a NullPointerException shall throw.
        
        if (databaseId == null) BRDPC.throwNPE("databaseId");
        
        final int       webSocketID = 19003000 + counter++;
        final boolean[] optionals   = { false, };
        
        // Convert Method Parameters into JSON.  Build the JSON Request-Object (as a String)
        String requestJSON = WriteJSON.get(
            parameterTypes.get("getDatabaseTableNames"),
            parameterNames.get("getDatabaseTableNames"),
            optionals, webSocketID,
            "Database.getDatabaseTableNames",
            databaseId
        );
        
        // 'JSON Binding' ... Converts Browser Response-JSON to 'String[]'
        Function<JsonObject, String[]> responseProcessor = (JsonObject jo) ->
            (jo.getJsonArray("tableNames") == null)
                ? null
                : ReadArrJSON.DimN.strArr(jo.getJsonArray("tableNames"), null, 0, String[].class);
        
        // Pass the 'defaultSender' to Script-Constructor
        // The sender that is used can be changed before executing script.
        return new Script<>(BRDPC.defaultSender, webSocketID, requestJSON, responseProcessor);
    }
    
}