walter
/
camera-database
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
camera-database/camera-db-venv/lib/python3.10/site-packages/openpyxl/chart
History
Walter Jekat d6f483349c COMPLETE: Imported all 74,020 Goergens cameras 
FINAL STATISTICS:
- 74,020 cameras successfully imported (100%)
- 45 duplicates skipped (as expected)
- 2,516 manufacturers
- 28,667 camera models
- 36,080 housing variants
- 6,606 unique lenses
- 1,135 unique shutters

30+ years of Harald Goergens' camera classification work
now preserved in PostgreSQL database.

Import challenges overcome:
- VARCHAR sizes adjusted (viewfinder_type, body_type, combo_number)
- NULL constraints relaxed (body_type, format_code)
- Transaction management per-row to prevent cascade failures
- ID verification to prevent cache poisoning
- 12 malformed IDs handled gracefully
- 46 duplicate IDs documented for later review
 		2025-11-17 23:54:23 +01:00
..
_3d.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
__init__.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
_chart.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
area_chart.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
axis.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
bar_chart.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
bubble_chart.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
chartspace.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
data_source.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
descriptors.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
error_bar.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
label.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
layout.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
legend.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
line_chart.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
marker.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
picture.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
pie_chart.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
pivot.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
plotarea.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
print_settings.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
radar_chart.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
reader.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
reference.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
scatter_chart.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
series.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
series_factory.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
shapes.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
stock_chart.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
surface_chart.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
text.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
title.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
trendline.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
updown_bars.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00