import settings
import mysql.connector
import requests
from settings import access_token

domain = 'wtlonline'
group_id = 79148977

database = mysql.connector.connect(user=settings.db_login, password=settings.db_password,
                                               host=settings.dp_ip, database=settings.db_name, use_unicode=True,
                                               charset='utf8', collation='utf8_general_ci', autocommit=True)

cursor = database.cursor()

cursor.execute("SET NAMES utf8;")
cursor.execute("SET CHARACTER SET utf8;")
cursor.execute("SET character_set_connection=utf8;")

member_request_params = (
            ('access_token', access_token),
            ('domain', domain),
            ('count', 1),
            ('date_from', '2013-08-08'),
            ('date_to', '2018-09-08'),
            ('version', 5.74))

r = requests.get('https://api.vk.com/method/wall.get', params=member_request_params).json()

text = r['response'][1]['text']
cursor.execute("""INSERT INTO VK_posts (text) VALUES (%s)""", (text,))

???? ??????! <br><br>??????!<br>??????? ????,