gistfile1.js

	/**
	 * @private
	 * Query a Schema for a row or rows by example
	 *
	 * @param {object} name name of Schema OR a Schema object
	 * @param {object} example example to query
	 * @param {boolean} single true to return a single row, otherwise all matching rows
	 * @returns {object} A single row matching example, or all matching rows
	 */
	function find(name, example, single, _) {
		var schema = getSchema(name);
		name = schema.name;
		example = example || {};
		var where = Schema.where(name, example);
		var query = [
			'SELECT',
			'       *',
			'FROM',
			'       ' + name
		];
		if (where.length) {
			query.push('WHERE');
			query.push(where.join(' AND '));
		}
		if (single) {
			var ret = SQL.getDataRow(query, _);
			return empty(ret) ? false : Schema.onLoad(schema, ret);
		}
		else {
			return Schema.onLoad(schema, SQL.getDataRows(query, _));
		}
	}