from __future__ import absolute_import
from __future__ import division
from __future__ import print_function
import json
from pyspark.streaming.kafka import KafkaUtils
from pyspark import SparkContext
from pyspark.sql import SQLContext
from pyspark.streaming import StreamingContext
from pyspark import  SparkConf
import redis
import sys
import os
import json
import pymysql
import numpy as np
import pandas as pd
import time
import datetime

def Json(x):
    data = json.loads(x[1])
    if 'type' in data and 'device' in data and 'params' in data and 'card_content_type' in data['params']:
        if data['type'] == 'on_click_card'and data['params']['card_content_type'] =='diary' \
                and data["device"]["device_id"] == "E417C286-40A4-42F6-BDA9-AEEBD8FEC3B6":
            return True
        # elif data['type'] == 'on_click_button'and 'params' in data:
        #     if 'page_name' in data['params'] and 'button_name' in data['params'] and 'extra_params' in data['params']:
        #         if data['params']['page_name'] =='page_choose_interest' and data['params']['button_name']=='next':
        #             return True

            return True
        else:
            return False
    else:
        return False


def filter_na(x):
    if x[0] != "0" and x[1] is not None:
        return True
    else:
        return False


def model(rdd):
    try:
        rdd = rdd.filter(lambda x:Json(x)).repartition(10).map(lambda x:get_data(x))
            # .map(lambda x:write_redis(x[0],x[1]))
        return  rdd
    except:
        print("fail")
def get_data(x):
    try:
        data = json.loads(x[1])
        device_id = data['device']['device_id']
        diary_id = data['params']["card_id"]
        return device_id,diary_id
    except Exception as e:
        print("get_data fail")
        # send_email("get_data", "get_data", e)


def write_redis(device_id,cid_list):
    try:
        db = pymysql.connect(host='172.16.40.158', port=4000, user='root', passwd='3SYz54LS9#^9sBvC', db='eagle')
        sql = "select b.id from src_mimas_prod_api_diary_tags a left join src_zhengxing_api_tag b " \
              "on a.tag_id = b.id where b.tag_type = '3' and a.diary_id = {}".format(cid_list)
        cursor = db.cursor()
        cursor.execute(sql)
        result = cursor.fetchall()
        tags = result[0][0]
        if tags is not None:
            sql = "select a.id from src_mimas_prod_api_diary a left join src_mimas_prod_api_diary_tags b " \
                  "on a.id=b.diary_id left join src_zhengxing_api_tag c on b.tag_id=c.id " \
                  "where a.is_online = 1 and a.content_level >= '3' " \
                  "and c.id = {} and c.tag_type = '3'".format(tags)
            cursor.execute(sql)
            result = cursor.fetchall()
            db.close()
            cids = list(set([i[0] for i in result]))
            if len(cids) != 0:

                r = redis.StrictRedis.from_url('redis://:ReDis!GmTx*0aN6@172.16.40.133:6379')
                key = str(device_id) + "_dislike_diary"
                if r.exists(key):
                    value = eval(r.get(key))
                    value.extend(cids)
                    cids = json.dumps(list(set(value)))
                    r.set(key, json.dumps(cids))
                else:
                    r.set(key, json.dumps(cids))
                    r.expire(key, 7*24*60*60)
        return "good"

    except Exception as e:
        print("insert redis fail")
        print(e)

def group_redis(device_id,cid_list):
    db = pymysql.connect(host='172.16.40.158', port=4000, user='root', passwd='3SYz54LS9#^9sBvC', db='eagle')
    sql = "select b.id from src_mimas_prod_api_diary_tags a left join src_zhengxing_api_tag b " \
          "on a.tag_id = b.id where b.tag_type = '3' and a.diary_id in {}".format(tuple(cid_list))
    cursor = db.cursor()
    cursor.execute(sql)
    result = cursor.fetchall()
    tags = list(set([i[0] for i in result]))
    if len(tags) != 0:
        sql = "select a.id from src_mimas_prod_api_diary a left join src_mimas_prod_api_diary_tags b " \
              "on a.id=b.diary_id left join src_zhengxing_api_tag c on b.tag_id=c.id " \
              "where a.is_online = 1 and a.content_level >= '3' " \
              "and c.id in {} and c.tag_type = '3'".format(tuple(tags))
        cursor.execute(sql)
        result = cursor.fetchall()
        cids = list(set([i[0] for i in result]))
        if len(cids) >1 :
            r = redis.StrictRedis.from_url('redis://:ReDis!GmTx*0aN6@172.16.40.133:6379')
            key = str(device_id) + "_dislike_diary"
            if r.exists(key):
                value = eval(r.get(key))
                value.extend(cids)
                cids = json.dumps(list(set(value)))
                r.set(key, json.dumps(cids))
            else:
                r.set(key, json.dumps(cids))
                r.expire(key, 60*60)


def group_write(rdd):
    a = rdd.groupByKey().map(lambda x,y:x).collect()
    return a

# Spark-Streaming-Kafka
sc = SparkContext(conf=SparkConf().setMaster("spark://nvwa01:7077").setAppName("filter").set("spark.io.compression.codec", "lzf"))
ssc=SQLContext(sc)
ssc = StreamingContext(sc,4)
sc.setLogLevel("WARN")
kafkaParams = {"metadata.broker.list": "172.16.44.25:9092,172.16.44.31:9092,172.16.44.45:9092",
               "group.id": "filter",
               "socket.timeout.ms": "600000",
               "auto.offset.reset": "largest"}


stream = KafkaUtils.createDirectStream(ssc, ["gm-maidian-data"], kafkaParams)
transformstream = stream.transform(lambda x:model(x)).foreachRDD(group_write)
# transformstream.pprint()
print(transformstream)
ssc.start()
ssc.awaitTermination()