import os

import sqlite3

from pathlib import Path

def dict_factory(cursor, row):

d = {}

for idx, col in enumerate(cursor.description):

d[col[0]] = row[idx]

return d

def load_table(table):

result = []

conn = sqlite3.connect(str(Path(os.getcwd()) / 'example' / 'remote.db'))

try:

conn.row_factory = dict_factory

cursor = conn.cursor()

cursor.execute('SELECT * FROM {table}'.format(table=table))

for row in cursor.fetchall():

result.append(row)

finally:

conn.close()

return result