#!/usr/bin/env python3

import os as _os
import sqlite3 as _sqlite3
import json as _json


def pattern(content):
	return ("%%%s%%" % content)
	

def transform(entries, names):
	# return entries
	return list(map(lambda entry: dict(zip(names, entry)), entries))
	

def query(name, arguments = {}):
	path = _os.path.join("queries", "%s.sql.tpl" % name)
	handle = open(path, "r")
	querytemplate = handle.read()
	handle.close()
	connection = _sqlite3.connect(_os.path.join("db", "words.sqlite"))
	result = connection.cursor().execute(querytemplate, arguments).fetchall()
	connection.close()
	return result
	

def macro(query_name, query_arguments, transform_names):
	print(_json.dumps(transform(query(query_name, query_arguments), transform_names), indent = "\t"))