import os, rootpath
rootpath.append(pattern='main.py') # add the directory of main.py to PATH
import pysnooper
from kivy.uix.treeview import TreeView, TreeViewLabel
from kivy.uix.scrollview import ScrollView
from kivy.app import App
from kivy.properties import ObjectProperty, DictProperty, ListProperty
from kivy.core.window import Window
from kivy.clock import Clock
class TreeWidget(TreeView):
data = DictProperty()
select_idx = ListProperty()
def __init__(self, data):
super(TreeWidget, self).__init__()
self.data = data
self.size_hint_y = None
self.hide_root = True
self.bind(minimum_height=self.setter('height'))
self.bind(selected_node=self.on_selected_node)
self.populate_tree_view(None, self.data)
def populate_tree_view(self, parent, node):
if parent is None:
tree_node = self.add_node(
TreeViewLabel(text=node['node_id'], is_open=True))
else:
import datetime
import logging
import traceback
from typing import List, Dict, Tuple, Union, Iterable
import rootpath
from psycopg2 import extras
rootpath.append()
from utilities.connection import Connection
from dumper.dumperbase import DumperBase
logger = logging.getLogger()
class TweetDumper(DumperBase):
INSERT_WITH_LOCATION_QUERY = f"""
INSERT INTO records (id, create_at, text, hash_tag, profile_pic, created_date_time, screen_name, user_name,
followers_count, favourites_count, friends_count, user_id, user_location, statuses_count, location)
VALUES %s
ON CONFLICT(id) DO UPDATE
SET create_at = excluded.create_at, text = excluded.text, hash_tag = excluded.hash_tag,
profile_pic = excluded.profile_pic, created_date_time = excluded.created_date_time,
screen_name = excluded.screen_name, user_name = excluded.user_name, followers_count = excluded.followers_count,
favourites_count = excluded.favourites_count, friends_count= excluded.friends_count, user_id= excluded.user_id,
user_location= excluded.user_location, statuses_count= excluded.statuses_count, location = excluded.location;"""
INSERT_WITHOUT_LOCATION_QUERY = f"""
INSERT INTO records (id, create_at, text, hash_tag, profile_pic, created_date_time, screen_name, user_name,
