import { db } from "./database/db";

export async function loadGeoJSONData(region) {
  const selectQuery = `SELECT data FROM regions WHERE region_id = ${region};`;

  return new Promise((resolve, reject) => {
    db.transaction(tx => {
      tx.executeSql(
        selectQuery,
        [],
        (_, { rows }) => {
          if (rows.length > 0) {
            resolve(JSON.parse(rows._array[0].data));
          } else {
            resolve(null);
          }
        },
        (_, error) => {
          reject(error);
        }
      );
    });
  });
}

export async function loadMarkersData() {
  const selectQuery = `SELECT marker_id, l, g, i, n, d FROM markers;`;

  return new Promise((resolve, reject) => {
    db.transaction(tx => {
      tx.executeSql(
        selectQuery,
        [],
        (_, { rows }) => {
          if (rows.length > 0) {
            resolve(rows._array.slice(0, 20));
          } else {
            resolve(null);
          }
        },
        (_, error) => {
          reject(error);
        }
      );
    });
  });
}