home_old3

import wixData from 'wix-data';
import wixFetch from 'wix-fetch';

$w.onReady(function () {
    //load_hv_table()
    load_opt_price()
});


async function load_hv_table() {
    const res = await wixData.query('hv_data').find();
    //var json = JSON.parse(res.items[0]["jsondata"])
    console.log(res.items)
    var json = JSON.parse(res.items[0]["jsondata"])
    console.log(json)
    //console.log(Object.keys(json[0]))
    //await wixData.insert("temp", json[0])

    var cols = []
    Object.keys(json[0]).forEach(key => {
        if (key[0] != "_")
            cols.push({
                "id": key.toString(),
                "label": key.toString(),
                "dataPath": key.toString(),
                // "width": 100,
                // "visible": true,
                // "type": "string"
            })
    })


    console.log(cols)
    $w("#table1").columns = cols;
    //console.log($w("#table1").columns);
    $w('#table1').rows = json;
}

async function load_opt_price() {
    const res = await wixData.query('opt_data').ascending("title").find();
    var json = JSON.parse(res.items[0]["call1"])
    console.log(json)
    console.log(Object.keys(json[0]))
    //await wixData.insert("temp", json[0])

    let cols = []
    Object.keys(json[0]).forEach(key => {
        if (key[0] != "_")
            cols.push({
                "id": key.toString(),
                "label": key.toString(),
                "dataPath": key.toString(),
            })
    })
    $w("#table1").columns = cols;
    //console.log($w("#table1").columns);
    $w('#table1').rows = json;
}


async function loadData() {
    const res = await wixData.query('Data').limit(200).find();
    const data = res.items;
    //$w('#table2').rows = data;
}