Puff

Scripts and other files related to storage and analysis of data from my vape.

Gist

I use an Orion DNA mod, which records detailed information about each puff.

The SSIS packages have been deprecated because SSIS is a nightmare.

Currently I'm using PowerShell to import data from the Orion REST service directly to the SQL server.

Name		Name	Last commit message	Last commit date
Latest commit History 27 Commits
SSIS (deprecated)		SSIS (deprecated)
.gitattributes		.gitattributes
.gitignore		.gitignore
Create Database Puff.sql		Create Database Puff.sql
Create Procedure ImportNewPuffData.sql		Create Procedure ImportNewPuffData.sql
Create Table Puff.sql		Create Table Puff.sql
Create Table Puff_Interval.sql		Create Table Puff_Interval.sql
Create Table Puff_Staging.sql		Create Table Puff_Staging.sql
Create Table Puff_Usage.sql		Create Table Puff_Usage.sql
Create Table Puff_Usage_Staging.sql		Create Table Puff_Usage_Staging.sql
Create View PuffJoin.sql		Create View PuffJoin.sql
Create View dbo.DailyAverage.sql		Create View dbo.DailyAverage.sql
Create View dbo.DailyTotals.sql		Create View dbo.DailyTotals.sql
Create View dbo.TimeOfDay.sql		Create View dbo.TimeOfDay.sql
Import Data from BIlls to Puff.sql		Import Data from BIlls to Puff.sql
Import Puff Data (REST).ps1		Import Puff Data (REST).ps1
Merge Puff Table.sql		Merge Puff Table.sql
Notebook-Puff.ipynb		Notebook-Puff.ipynb
Populate Table Puff_Intervals.sql		Populate Table Puff_Intervals.sql
Puffs Cursor.sql		Puffs Cursor.sql
README.md		README.md
Shrink Puff.sql		Shrink Puff.sql
puff_usage sample.csv		puff_usage sample.csv