{
    "chat.tools.terminal.autoApprove": {
        "/^cd \"/mnt/sda1/CSU Fullerton Dropbox/David Adams/Research Projects/Data Centers/US Data Centers\" && python3 - <<'PY'\nimport os, psycopg2\nconn=psycopg2\\.connect\\(host=os\\.environ\\['PGWEB_HOST'\\],port=os\\.environ\\['PGWEB_PORT'\\],user=os\\.environ\\['PGWEB_USER'\\],password=os\\.environ\\['PGWEB_PASSWORD'\\],dbname='data_centers'\\)\nwith conn, conn\\.cursor\\(\\) as cur:\n    cur\\.execute\\(\"select count\\(\\*\\) from public\\.us_dc_sample_geocoded where geoid is not null\"\\)\n    geoid_nonnull=cur\\.fetchone\\(\\)\\[0\\]\n    cur\\.execute\\(\"select geocode_source, count\\(\\*\\) filter \\(where geoid is not null\\), count\\(\\*\\) from public\\.us_dc_sample_geocoded group by geocode_source order by count\\(\\*\\) desc\"\\)\n    rows=cur\\.fetchall\\(\\)\nprint\\('geoid_nonnull', geoid_nonnull\\)\nfor s,nn,total in rows:\n    print\\(s, nn, total\\)\nPY$/": {
            "approve": true,
            "matchCommandLine": true
        },
        "/^cd \"/mnt/sda1/CSU Fullerton Dropbox/David Adams/Research Projects/Data Centers/US Data Centers\" && python3 - <<'PY'\nimport os, psycopg2\nconn=psycopg2\\.connect\\(host=os\\.environ\\['PGWEB_HOST'\\],port=os\\.environ\\['PGWEB_PORT'\\],user=os\\.environ\\['PGWEB_USER'\\],password=os\\.environ\\['PGWEB_PASSWORD'\\],dbname='data_centers'\\)\nwith conn, conn\\.cursor\\(\\) as cur:\n    cur\\.execute\\(\"select to_regclass\\('public\\.data_center_census_tracts_2024'\\)\"\\)\n    print\\('final_exists', cur\\.fetchone\\(\\)\\[0\\]\\)\n    cur\\.execute\\(\"select count\\(\\*\\) from public\\.us_dc_sample_geocoded\"\\)\n    print\\('points', cur\\.fetchone\\(\\)\\[0\\]\\)\n    cur\\.execute\\(\"select count\\(\\*\\) from public\\.us_dc_sample_geocoded where geoid is not null\"\\)\n    print\\('points_geoid_nonnull', cur\\.fetchone\\(\\)\\[0\\]\\)\nPY$/": {
            "approve": true,
            "matchCommandLine": true
        },
        "/^cd \"/mnt/sda1/CSU Fullerton Dropbox/David Adams/Research Projects/Data Centers/US Data Centers\" && python3 -m py_compile create_data_center_census_tract_table\\.py && python3 create_data_center_census_tract_table\\.py --help \\| sed -n '1,80p'$/": {
            "approve": true,
            "matchCommandLine": true
        },
        "/^cd \"/mnt/sda1/CSU Fullerton Dropbox/David Adams/Research Projects/Data Centers/US Data Centers\" && python3 -m py_compile build_watershed_huc8_tables\\.py && python3 build_watershed_huc8_tables\\.py --replace-stage --max-files 5$/": {
            "approve": true,
            "matchCommandLine": true
        }
    }
}