import random

# Configuration
num_points = 200
x_range = (0, 100)
y_range = (0, 100)
z_range = (0, 10)
table_name = "demo_graph_data"
output_file = "demo_graph_data.sql"

# Generate SQL values
values = []
for _ in range(num_points):
    x = round(random.uniform(*x_range), 2)
    y = round(random.uniform(*y_range), 2)
    z = round(random.uniform(*z_range), 2)
    values.append(f"  ({x}, {y}, {z})")

# Build SQL string
sql = f"INSERT INTO {table_name} (x_value, y_value, z_value) VALUES\n" + ",\n".join(values) + ";"

# Save to file
with open(output_file, "w") as f:
    f.write(sql)

print(f"SQL INSERT statement saved to '{output_file}'")

