Spaces:
Running
Running
File size: 1,689 Bytes
fec6d78 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 | import csv
import sys
import os
sys.path.insert(0, os.path.dirname(os.path.abspath(__file__)))
from config import supabase
def export_streets(output_path="export_streets.csv"):
all_data = []
page_size = 1000
offset = 0
while True:
result = (
supabase.table("Streets")
.select("id, name")
.order("id")
.range(offset, offset + page_size - 1)
.execute()
)
rows = result.data or []
all_data.extend(rows)
if len(rows) < page_size:
break
offset += page_size
with open(output_path, "w", encoding="utf-8", newline="") as f:
writer = csv.DictWriter(f, fieldnames=["id", "name"])
writer.writeheader()
writer.writerows(all_data)
print(f"Exported {len(all_data)} streets → {output_path}")
def export_positions(output_path="export_positions.csv"):
all_data = []
page_size = 1000
offset = 0
while True:
result = (
supabase.table("Positions")
.select("id, long, lat, streets")
.order("id")
.range(offset, offset + page_size - 1)
.execute()
)
rows = result.data or []
all_data.extend(rows)
if len(rows) < page_size:
break
offset += page_size
with open(output_path, "w", encoding="utf-8", newline="") as f:
writer = csv.DictWriter(f, fieldnames=["id", "long", "lat", "streets"])
writer.writeheader()
writer.writerows(all_data)
print(f"Exported {len(all_data)} positions → {output_path}")
if __name__ == "__main__":
export_streets()
export_positions()
|