Sqlite - Autocad

-- Export query to CSV .headers on .mode csv .output drawing_data.csv SELECT * FROM your_table; .output stdout

SELECT block_name as "Component", COUNT(*) as "Quantity", SUM(CAST(value AS REAL)) as "Total Area" FROM attributes WHERE tag = 'AREA' GROUP BY block_name HAVING Total_Area > 0 ORDER BY block_name; sqlite autocad

# Get weekly changes cursor.execute(""" SELECT date, COUNT(*) FROM changes WHERE date >= date('now', '-7 days') GROUP BY date """) -- Export query to CSV