###
Returns a Organization by it's ID
###
exports.get_by_id = (connection, org_id, fn) ->

	connection.query 'SELECT * FROM organizations WHERE organizations.id=? LIMIT 1;', [ 1 * org_id ], (err, results) ->

		if err
			fn err
		else
			fn err, results[0]

###
Returns a Organization by it's Name
###
exports.get_by_name = (connection, org_name, fn) ->

	connection.query 'SELECT * FROM organizations WHERE organizations.name=? LIMIT 1;', [ org_name ], (err, results) ->

		if err
			fn err
		else
			fn err, results[0]

###
Handles validation and create or update a Organization.

Only members are allowed depending on their groups
###
exports.save = (connection, org_params, fn) ->
	fn()

###
Removes the Organization with the specified ID
###
exports.delete = (connection, org_id, fn) ->
	fn()

###
Returns a list of organizations and their membership object for this user.

This will only return current memberships.
###
exports.get_memberships_by_user_id = (connection, user_id, fn) ->

	connection.query 'CALL list_memberships(?);', [ 1 * user_id ], (err, results) ->

		if err
			fn err
		else
			fn err, results