Simple Data Toolkit - Tutorial - Mac OS - Scheduled Task

from sdtk import com_sdtk_api_ChatGPTAPI
import os
import fnmatch
import re

texData = ""
texBegin = "\n\\begin{document}\n"
texEnd = "\n\\end{document}"
header = ""
footer = ""
foundBody = False

# Get a list of all .png files in the current directory
png_files = [file for file in os.listdir('.') if fnmatch.fnmatch(file, '*.png')]

def result(text):
    global texData
    global header
    global footer
    global foundBody

    text = text.replace("```latex", "").replace("```", "")
    body_match = re.search(r'\\begin{document}(.*?)\\end{document}', text, re.DOTALL)

    if body_match:
        body_content = body_match.group(1).strip()
        if len(texData) > 0:
            texData = texData + "\n" + "\\newpage" + "\n"
        else:
            header_match = re.search(r'^(.*?)\\begin{document}', text, re.DOTALL)
            header = header_match.group(1).strip()
            footer_match = re.search(r'\\end{document}(.*)$', text, re.DOTALL)
            footer = footer_match.group(1).strip()
            
        texData = texData + body_content
        foundBody = True
    else:
        foundBody = False
        print(text)

# Loop over each .png file
for file_name in png_files:
    foundBody = False
    while foundBody == False:
        com_sdtk_api_ChatGPTAPI.instance().query(result, "Can you generate a LaTeX document to represent the text in this image and format it correctly and return only the LaTeX code?", file_name)
        with open("output.tex", "w+") as file:
            # Write the string to the file
            file.write(header + texBegin + texData + texEnd + footer)

	from sdtk import com_sdtk_api_GitAPI

	def printer(data, reader):
	    print(reader.toArrayOfNativeMaps(None))

	com_sdtk_api_GitAPI.reposAPI().retrieveData({"owner": "Vis-LLC"}, printer)

	from sdtk import com_sdtk_api_GitAPI

	def printer(data, reader):
	    print(reader.toArrayOfNativeMaps(None))

	com_sdtk_api_GitAPI.branchesAPI().retrieveData({"owner": "Vis-LLC", "repo": "Simple-Data-Toolkit"}, printer)

	from sdtk import com_sdtk_api_GitAPI

	def printer(data, reader):
	    print(reader.toArrayOfNativeMaps(None))

	com_sdtk_api_GitAPI.filesAPI().retrieveData({"owner": "Vis-LLC", "repo": "Simple-Data-Toolkit", "branch": "main"}, printer)

	from sdtk import com_sdtk_api_GitAPI

	def printerData(data, reader):
	    print(data)

	com_sdtk_api_GitAPI.retrieveAPI().retrieveData({"owner": "Vis-LLC", "repo": "Simple-Data-Toolkit-UI", "branch": "main", "path": "index.html"}, printerData)

	from sdtk import com_sdtk_api_GitAPI

	def printerData(data, reader):
	    print(data)

	com_sdtk_api_GitAPI.instance().setKey("Personal Access Token Here").retrieveAPI().retrieveData({"owner": "Vis-LLC", "repo": "Simple-Data-Toolkit-UI", "branch": "main", "path": "index.html"}, printerData)

from sdtk import com_sdtk_api_OrtingoAPI


def printer(data, reader):
    print(reader.toArrayOfNativeMaps(None))

com_sdtk_api_OrtingoAPI.postsAPI().retrieveData({"owner": "60CQ59FN46SVQFXJ"}, printer)

from sdtk import com_sdtk_api_OrtingoAPI


def printer(data, reader):
    print(reader.filterColumnsOnly(["title"]).toArrayOfNativeMaps(None))

com_sdtk_api_OrtingoAPI.postsAPI().retrieveData({"owner": "60CQ59FN46SVQFXJ"}, printer)

from sdtk import com_sdtk_api_OrtingoAPI

def printerUrls(data, reader):
    print(reader.filterColumnsOnly(["url"]).toArrayOfNativeMaps(None))

com_sdtk_api_OrtingoAPI.suggestionsAPI().retrieveData({"query": "data"}, printerUrls)

from sdtk import com_sdtk_api_OrtingoAPI

def printerComments(data, reader):
    print(reader.filterColumnsOnly(["commentDate", "post"]).toArrayOfNativeMaps(None))

com_sdtk_api_OrtingoAPI.commentsAPI().retrieveData({"owner": "60CQ59FN46SVQFXJ", "id": "test"}, printerComments)

from sdtk import com_sdtk_api_ChatGPTAPI, com_sdtk_table_ArrayOfMapsReader

#Set

def callbackData(reader):
    print(reader.toArrayOfNativeMaps(None))

def callbackText(data):
    print(data)

users = [
    {"user_id": 1, "first_name": "Sally", "last_name": "Franklin"},
    {"user_id": 2, "first_name": "Lucas", "last_name": "Franklin"},
    {"user_id": 3, "first_name": "Joe", "last_name": "Romeo"},
    {"user_id": 4, "first_name": "Julie", "last_name": "Romeo"},
    {"user_id": 5, "first_name": "Lucia", "last_name": "Templeton"},
]

orders = [
    {"order_id": 1, "user_id": 3, "item_desc": "Book 1", "item_quantity": 2, "date": "2024-01-01"},
    {"order_id": 2, "user_id": 3, "item_desc": "Book 2", "item_quantity": 1, "date": "2024-02-01"},
    {"order_id": 3, "user_id": 3, "item_desc": "Book 3", "item_quantity": 3, "date": "2024-03-01"},
    {"order_id": 4, "user_id": 3, "item_desc": "Book 4", "item_quantity": 0, "date": "2024-04-01"},
    {"order_id": 5, "user_id": 3, "item_desc": "Book 5", "item_quantity": 4, "date": "2024-05-01"}
]

com_sdtk_api_ChatGPTAPI.queryAsReaderWithDataAPI().execute("What can we determine about the buying habits of all of our users?", None, {"Users": com_sdtk_table_ArrayOfMapsReader.readWholeArray(users), "Orders": com_sdtk_table_ArrayOfMapsReader.readWholeArray(orders)}, callbackData)
com_sdtk_api_ChatGPTAPI.queryWithDataAPI().execute("What can we determine about the buying habits of all of our users?  As a narrative.", None, {"Users": com_sdtk_table_ArrayOfMapsReader.readWholeArray(users), "Orders": com_sdtk_table_ArrayOfMapsReader.readWholeArray(orders)}, callbackText)

content = ""
with open('sample.html', 'r') as content_file:
    content = content_file.read()

com_sdtk_api_ChatGPTAPI.queryWithDataAPI().execute("We also have this document in HTML format on recent trends.\n" + content + "\n\nWhat can we determine about the buying habits of all of our users?  As a narrative.", None, {"Users": com_sdtk_table_ArrayOfMapsReader.readWholeArray(users), "Orders": com_sdtk_table_ArrayOfMapsReader.readWholeArray(orders)}, callbackText)

from sdtk import com_sdtk_api_ChatGPTAPI

def callback(data, reader):
    print(reader.toArrayOfNativeMaps(None))

com_sdtk_api_ChatGPTAPI.queryAsReaderAPI().retrieveData({ "query": "List all cities in the USA with known population." }, callback)