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

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

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

###
Returns Portfolio by it's user
###
exports.get_by_user_id = (connection, user_id, fn) ->

	connection.query 'SELECT * FROM portfolio WHERE portfolio.user=? LIMIT 1;', [ 1 * user_id ], (err, results) ->

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

###
Handles validation and create or update a portfolio item.
###
exports.save = (connection, portfolio_params, fn) ->
	fn()

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