# -*- coding: utf-8 -*-
# Copyright 2014, 2015 OpenMarket Ltd
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

from ._base import SQLBaseStore

from twisted.internet import defer

from synapse.util.stringutils import random_string

import logging

logger = logging.getLogger(__name__)


class StateStore(SQLBaseStore):
    """ Keeps track of the state at a given event.

    This is done by the concept of `state groups`. Every event is a assigned
    a state group (identified by an arbitrary string), which references a
    collection of state events. The current state of an event is then the
    collection of state events referenced by the event's state group.

    Hence, every change in the current state causes a new state group to be
    generated. However, if no change happens (e.g., if we get a message event
    with only one parent it inherits the state group from its parent.)

    There are three tables:
      * `state_groups`: Stores group name, first event with in the group and
        room id.
      * `event_to_state_groups`: Maps events to state groups.
      * `state_groups_state`: Maps state group to state events.
    """

    def get_state_groups(self, event_ids):
        """ Get the state groups for the given list of event_ids

        The return value is a dict mapping group names to lists of events.
        """

        def f(txn):
            groups = set()
            for event_id in event_ids:
                group = self._simple_select_one_onecol_txn(
                    txn,
                    table="event_to_state_groups",
                    keyvalues={"event_id": event_id},
                    retcol="state_group",
                    allow_none=True,
                )
                if group:
                    groups.add(group)

            res = {}
            for group in groups:
                state_ids = self._simple_select_onecol_txn(
                    txn,
                    table="state_groups_state",
                    keyvalues={"state_group": group},
                    retcol="event_id",
                )

                state = self._get_events_txn(txn, state_ids)

                res[group] = state

            return res

        return self.runInteraction(
            "get_state_groups",
            f,
        )

    def _store_state_groups_txn(self, txn, event, context):
        if context.current_state is None:
            return

        state_events = dict(context.current_state)

        if event.is_state():
            state_events[(event.type, event.state_key)] = event

        state_group = context.state_group
        if not state_group:
            state_group = self._state_groups_id_gen.get_next_txn(txn)
            self._simple_insert_txn(
                txn,
                table="state_groups",
                values={
                    "id": state_group,
                    "room_id": event.room_id,
                    "event_id": event.event_id,
                },
            )

            for state in state_events.values():
                self._simple_insert_txn(
                    txn,
                    table="state_groups_state",
                    values={
                        "state_group": state_group,
                        "room_id": state.room_id,
                        "type": state.type,
                        "state_key": state.state_key,
                        "event_id": state.event_id,
                    },
                )

        self._simple_insert_txn(
            txn,
            table="event_to_state_groups",
            values={
                "state_group": state_group,
                "event_id": event.event_id,
            },
        )

    @defer.inlineCallbacks
    def get_current_state(self, room_id, event_type=None, state_key=""):
        def f(txn):
            sql = (
                "SELECT e.event_id FROM events as e"
                " INNER JOIN current_state_events as c ON e.event_id = c.event_id"
                " WHERE c.room_id = ? "
            )

            if event_type and state_key is not None:
                sql += " AND c.type = ? AND c.state_key = ? "
                args = (room_id, event_type, state_key)
            elif event_type:
                sql += " AND c.type = ?"
                args = (room_id, event_type)
            else:
                args = (room_id, )

            txn.execute(sql, args)
            results = self.cursor_to_dict(txn)

            return self._parse_events_txn(txn, results)

        events = yield self.runInteraction("get_current_state", f)
        defer.returnValue(events)


def _make_group_id(clock):
    return str(int(clock.time_msec())) + random_string(5)

@@ -4364,18 +4364,16 @@
 %22SELECT 
-e.
 event_id
@@ -4382,102 +4382,28 @@
 ROM 
-events as e%22%0A                %22 INNER JOIN current_state_events as c ON e.event_id = c.event_id
+current_state_events
 %22%0A  
@@ -4424,18 +4424,16 @@
 %22 WHERE 
-c.
 room_id 
@@ -4527,34 +4527,32 @@
    sql += %22 AND 
-c.
 type = ? AND c.s
@@ -4548,18 +4548,16 @@
 = ? AND 
-c.
 state_ke
@@ -4649,16 +4649,16 @@
 t_type:%0A
+
         
@@ -4682,10 +4682,8 @@
 AND 
-c.
 type

Remove pointless join