Stephen Hardy stephenhardy

I wrote this in early January 2012, but never finished it. The research and thinking in this area led to a lot of the design of Yeoman and talks like "Javascript Development Workflow of 2013", "Web Application Development Workflow" and "App development stack for JS developers" (surpisingly little overlap in those talks, btw).

Now it's June 2013 and the state of web app tooling has matured quite a bit. But here's a snapshot of the story from 18 months ago, even if a little ugly and incomplete. :p

In the beginning…

Intro to tooling

	select
	t.name table_name
	from
	sys.tables t
	join sys.schemas s on (t.schema_id = s.schema_id)
	join sys.partitions p on (t.object_id = p.object_id)
	where p.index_id in (0,1)
	group by t.name,s.name
	having sum(p.rows) = 0;

	To remote
	-----------
	rsync -azP file username@remote_host:/home/dir/file


	From remote
	-------------
	rsync -azP username@remote_host:/home/dir/file file

	SELECT DISTINCT TABLE_NAME
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE COLUMN_NAME IN ('columnA','ColumnB')
	AND TABLE_SCHEMA='YourDatabase';

	@Grab(group = 'com.fasterxml.jackson.dataformat', module= 'jackson-dataformat-csv', version = '2.3.0')
	import com.fasterxml.jackson.annotation.JsonProperty
	import com.fasterxml.jackson.annotation.JsonCreator
	import com.fasterxml.jackson.annotation.JsonPropertyOrder
	import com.fasterxml.jackson.core.JsonFactory
	import com.fasterxml.jackson.dataformat.csv.CsvMapper
	import com.fasterxml.jackson.dataformat.csv.CsvSchema
	import com.fasterxml.jackson.databind.MappingIterator
	import com.fasterxml.jackson.databind.ObjectMapper
	import com.fasterxml.jackson.databind.ObjectWriter

	-- Remove the history from
	rm -rf .git

	-- recreate the repos from the current content only
	git init
	git add .
	git commit -m "Initial commit"

	-- push to the github remote repos ensuring you overwrite history
	git remote add origin [email protected]:<YOUR ACCOUNT>/<YOUR REPOS>.git

	{
	"cmd": ["open", "-a", "Google Chrome", "$file"]
	}