db.py

from sheet_utils import append_to_sheet, update_to_sheet, SHEET_NAME

def db_set(ts, event_type, username, latitude, longitude, horizontal_accuracy, source=None):
    values = [ts, event_type, username, latitude, longitude, horizontal_accuracy, source]
    result = append_to_sheet(values)
    return result


def db_update(column, row, data):
    range_to_update = f"{SHEET_NAME}!{column}{row}"
    result = update_to_sheet(range_to_update, [data])
    return result


def db_update_batch(column_start, row, column_end, ts, event_type, username, latitude, longitude, horizontal_accuracy, source=None):
    range_to_update = f"{SHEET_NAME}!{column_start}{row}:{column_end}{row}"
    values = [ts, event_type, username, latitude, longitude, horizontal_accuracy, source]
    result = update_to_sheet(range_to_update, values)
    return result