Skip to content

Instantly share code, notes, and snippets.

@robertmryan
Created February 10, 2017 21:53
Show Gist options
  • Select an option

  • Save robertmryan/317d033bd1d132ecb17f59f53bc2d676 to your computer and use it in GitHub Desktop.

Select an option

Save robertmryan/317d033bd1d132ecb17f59f53bc2d676 to your computer and use it in GitHub Desktop.
[{
"DAY": "MONDAY",
"EVENTS": [{
"TITLE": "TEST DRIVEN DEVELOPMENT",
"SPEAKER": "JASON SHAPIRO",
"TIME": "9:00 AM",
"ROOM": "MATISSE",
"DETAILS": "EXPLORE THE TOPICS AND TOOLS RELATED TO TEST DRIVEN DEVELOPMENT."
}, {
"TITLE": "JAVA TOOLS",
"SPEAKER": "JIM WHITE",
"TIME": "9:00 AM",
"ROOM": "ROTHKO",
"DETAILS": "DISCUSS THE LATEST SET OF TOOLS USED TO HELP EASE SOFTWARE DEVELOPMENT."
}]
}, {
"DAY": "TUESDAY",
"EVENTS": [{
"TITLE": "MONGODB",
"SPEAKER": "DAVINMICKELSON",
"TIME": "1: 00PM",
"ROOM": "PICASSO",
"DETAILS": "LEARNABOUT\"NOSQL\"DATABASES."
}, {
"TITLE": "DEBUGGINGWITHXCODE",
"SPEAKER": "JASONSHAPIRO",
"TIME": "1: 00PM",
"ROOM": "VANGOGH",
"DETAILS": "EXPLOREDIFFERENTPATTERNSFORDEBUGGINGYOURIOSAPPS."
}]
}]
@robertmryan

Copy link
Copy Markdown
Author

Or, perhaps easier/better, do something like:

{
	"EVENTS": [{
		"DAY": "MONDAY",
		"TITLE": "TEST DRIVEN DEVELOPMENT",
		"SPEAKER": "JASON SHAPIRO",
		"TIME": "9:00 AM",
		"ROOM": "MATISSE",
		"DETAILS": "EXPLORE THE TOPICS AND TOOLS RELATED TO TEST DRIVEN DEVELOPMENT."
	}, {
		"DAY": "MONDAY",
		"TITLE": "JAVA TOOLS",
		"SPEAKER": "JIM WHITE",
		"TIME": "9:00 AM",
		"ROOM": "ROTHKO",
		"DETAILS": "DISCUSS THE LATEST SET OF TOOLS USED TO HELP EASE SOFTWARE DEVELOPMENT."
	}, {
		"DAY": "TUESDAY",
		"TITLE": "MONGODB",
		"SPEAKER": "DAVINMICKELSON",
		"TIME": "1: 00PM",
		"ROOM": "PICASSO",
		"DETAILS": "LEARNABOUT\"NOSQL\"DATABASES."
	}, {
		"DAY": "TUESDAY",
		"TITLE": "DEBUGGINGWITHXCODE",
		"SPEAKER": "JASONSHAPIRO",
		"TIME": "1: 00PM",
		"ROOM": "VANGOGH",
		"DETAILS": "EXPLOREDIFFERENTPATTERNSFORDEBUGGINGYOURIOSAPPS."
	}]
}

It's always good to make the top level item a dictionary (makes it easier to do error handling), and then you can have a simple array of dictionaries of the results of your SQL statement.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment