import pymysql
import datetime

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'alpha',
        'USER': 'work',
        'PASSWORD': 'Gengmei123!',
        'HOST': '172.21.36.16',
        'PORT': '3306',
        'OPTIONS': {
            "init_command": "SET foreign_key_checks = 0;",
            "charset": "utf8mb4",
        },
    },
    'master': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'alpha',
        'USER': 'work',
        'PASSWORD': 'Gengmei123!',
        'HOST': '172.21.36.6',
        'PORT': '3306',
        'OPTIONS': {
            "init_command": "SET foreign_key_checks = 0;",
            "charset": "utf8mb4",
        },
    },
    'face': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'face',
        'USER': 'work',
        'PASSWORD': 'Gengmei123!',
        'HOST': '172.21.36.16',
        'PORT': '3306',
        # 'CONN_MAX_AGE': None,
        'OPTIONS': {
            "init_command": "SET foreign_key_checks = 0;",
            "charset": "utf8mb4",
        },
    },
    'commodity': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'commodity',
        'USER': 'work',
        'PASSWORD': 'Gengmei123!',
        'HOST': '172.21.36.16',
        'PORT': '3306',
        # 'CONN_MAX_AGE': None,
        'OPTIONS': {
            "init_command": "SET foreign_key_checks = 0;",
            "charset": "utf8mb4",
        },
    }

}


host = DATABASES['default']['HOST']

user = DATABASES['default']['USER']

port = DATABASES['default']['PORT']

db = DATABASES['default']['NAME']

passwd = DATABASES['default']['PASSWORD']

def time_convs(numtime, numtime2):
    '''
    params: 1, 2
    datetime.now(): 2019-10-09 10:35:50.231463
    return: 2019-10-08 23:59:59.000000 2019-10-07 00:00:00.000000
    '''
    try:
        now = datetime.datetime.now()
        yes_time = now - datetime.timedelta(days=numtime)
        yes_time_str = yes_time.strftime('%Y-%m-%d')
        yes_time_str = yes_time_str + ' 23:59:59.000000'

        yes_time2 = now - datetime.timedelta(days=numtime2)
        yes_time_str2 = yes_time2.strftime('%Y-%m-%d')
        yes_time_str2 = yes_time_str2 + ' 00:00:00.000000'
        return yes_time_str, yes_time_str2
    except:
        return None


def get_commnet_id(numtime, numtime2):
    pc = pymysql.connect(host=host, user=user, passwd=passwd, db=db, port=3306)
    cursor = pc.cursor()

    # 发贴后
    cursor.execute(

        "select  user_id from topic  WHERE  create_time > '%s' and create_time < '%s' " % (numtime, numtime2))

    data_new_user = cursor.fetchall()

    all_data = list(data_new_user)

    user_id_list = []
    for i in all_data and all_data:
        cursor.execute(
            "select user_id from user_extra where user_id =" + str(i[0]) + " and is_shadow =0 ")
        data = cursor.fetchall()
        user_id = list(data)
        if (user_id and user_id[0][1] == 0) or len(user_id) == 0:
            user_id_list.append(i)

    pc.close()
    return user_id_list


# numtime1, numtime2 = time_convs(1, 1)
# user_id = get_commnet_id(numtime2, numtime1)





# def time_conv_minute(minutest, minutest2):
#     try:
#         now = datetime.datetime.now()
#         minute = datetime.datetime.now().minute
#         yes_time = now - datetime.timedelta(minutes=minutest)
#         yes_time2 = now - datetime.timedelta(minutes=minutest2)
#         return yes_time, yes_time2, minute
#     except:
#         return None
#
# a, b, c = time_conv_minute(0, 5)
#
# print(a, b)


import requests
auto_follow_url = 'http://earth.gmapp.env/api/v1/follow'


def follow(cookies_get, id):
    post_dict = {
        'type': 1,
        'id': id
    }
    response = requests.post(url=auto_follow_url,
                             cookies=cookies_get,
                             data=post_dict)
    print(response.text)


def index_first():
    try:
        r1 = requests.get("http://earth.gmapp.env/api/account/login_pwd")
        return r1.cookies.get_dict()
    except:
        return None


def get_cook_by_email(email):
    cookies = index_first()
    post_dict = {
        'account_type': 2,
        'pwd': '123456',
        'email': email
    }
    response = requests.post(
        url="http://earth.gmapp.env/api/account/login_pwd",
        data=post_dict,
        cookies=cookies
    )
    headers = response.headers
    # print(response.text)
    cook = headers['Set-Cookie'].split(";")
    cook = cook[0].split('=')[1]
    return cook



res = get_cook_by_email("s_gXRMNW@shadow.com")
print(res)