learnings
REPO: basic interaction with db: run scripts, retrieve query results: SCRIPT, QUERY, CONNECTION Model: a WHOLE table breaks into...... ModelInstance: individual records: UPDATE, SAVE DirScan: scan a DIRECTORY: COLLECTION, SAMPLE, how to process FILES SasScanner: for sas database files Find one associated record by type and name row count, column count, date created variable: label, type, length Periodicity: data updated....two months go by.....SAME data updated....two months go by.....SAME data updated Seeding a database with data, seed.yml file etc. DETERMINE COLLECTION agency name: hhs collection name: tanf sample name: 2008 a fulltext index is faster than a like or full query cus it looks for a partial piece type thing SQLServerDataSource MICROSOFT SQL server SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG= 'cmr' ; Model: what data structure looks like in db, but mak...