Snippets vscode

##Gochan contains some/a snippet(s) for vscode to make development slightly easier

queryscan / scan-rows

This snippet can be used for querying the database for scanning the resulting rows to a slice of some object. The name of the array is the name of a single object + s.
Triggers: 'queryscan', 'scan-rows'
Snippet:

rows, err := QuerySQL('sql')  
if err != nil {  
	return nil, err  
}
var itemnames []elementType  
for rows.Next() {
	var itemname elementType  
	err = rows.Scan()  
	if err != nil {  
		return nil, err  
	}  
	itemnames = append(itemnames, itemname)  
}  
return itemnames, nil

Example:

rows, err := QuerySQL("Select * from balls")  
if err != nil {  
	return nil, err  
}  
var balls []Ball  
for rows.Next() {  
	var ball Ball  
	err = rows.Scan(&ball.size, &ball.color)  
	if err != nil {  
		return nil, err  
	}  
	balls = append(balls, ball)  
}  
return balls, nil