northwind-swift/northwindsqlite.swift

Views

The following views have been converted from the original Northwind Access database. Please refer to the src/create.sql file to view the code behind each of these views.

| View Name | |-----------| | [Alphabetical list of products] | | [Current Product List] | | [Customer and Suppliers by City] | | [Invoices] | | [Orders Qry] | | [Order Subtotals] | | [Order Subtotals] | | [Product Sales for 1997] | | [Products Above Average Price] | | [Products by Category] | | [Quarterly Orders] | | [Sales Totals by Amount] | | [Summary of Sales by Quarter] | | [Summary of Sales by Year] | | [Category Sales for 1997] | | [Order Details Extended] | | [Sales by Category] |

Build Instructions

Prerequisites

• You are running in a unix-like environment (Linux, MacOS)
• Python 3.6 or higher (python3 --version)
• SQLite3 installed sqlite3 -help

Build

make build  # Creates database at ./dist/northwind.db

Populate with more data

make populate

Print report of row counts

make report

Original ERD Picture

[Northwind ERD Picture]

Package Metadata

Repository: northwind-swift/northwindsqlite.swift

Default branch: main

README: README.md