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,