taylonr

var _ = require('lodash'),
    ActivityController = require('../../../controllers/activity.controller'),
    FakeDatabase = [
      {userId: '123', Name: 'First Activity', Records: [{Date: new Date(2014, 1, 1)}]},
      {userId: '123', Name: 'Second Activity', Records: [{Date: new Date(2014, 2, 1)}]}];

    require('underscore-query')(_);

    ActivityController.Activity.find = function(findObject, callback){
      var activities = _.query(FakeDatabase, findObject);

taylonr

describe('User Service...', function(){

   var userService,
      customerService,
      scope;
   
   beforeEach(inject(function(testHelper){
      userService = testHelper.setUpMocksWithSpies('UserService');
      customerService = testHelper.setUpMocksWithSpies('CustomerService');
      

taylonr

$scope.isBalancePositive = function(){
  if($scope.balance > 0){
    return true;
  }
}

taylonr

public class DataProfiler : IProfiler
{
    public DataProfiler()
    {
	Enabled = true;
    }

    public bool Enabled { get; set; }

    public void Update(PetaPocoSqlInfo info)

taylonr

public class DataProfiler : ISqlProfiler
{
    public DataProfiler()
    {
	Enabled = true;
    }

    public bool Enabled { get; set; }

    public void Update(PetaPocoSqlInfo info)

taylonr

[GlimpsePlugin]
public class PetaPocoGlimpsePlugin : IGlimpsePlugin
{
    public object GetData(HttpContextBase context)
    {
    	if (context.Items[DataProfiler.PetaKey] == null)
		return new List<object[]> { new[] { "Log" }, new[] { "No database requests   or database logging not switched on (Compilation debug='true' or ForceLogging='true' on
PetaPoco.DatabaseWithLogging)", "warn" } };

	var sqls = new List<object[]> {new[] {"#", "Time(ms)", "Sql", "Parameters"}};

taylonr

public class SqlInfo
{
	public double Time { get; set; }
	public string FormattedSql { get; set; }
	public string Sql { get; set; }
	public IDataParameterCollection Parameters { get; set; }
}

taylonr

public interface ISqlProfiler
{
	bool Enabled { get;}

	void Update(PetaPocoSqlInfo info);
}

taylonr

CREATE TYPE [dbo].[MyRecords] AS TABLE(
	[Id] [int] NOT NULL,
	[ModuleId] [int] NOT NULL,
	[Code] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
	PRIMARY KEY CLUSTERED 
(
	[Id] ASC,
	[ModuleId] ASC,
	[Code] ASC
)WITH (IGNORE_DUP_KEY = OFF)

taylonr

var returnCode = Database.ExecuteScalar<int>(
    "exec GetData @userId, @date", 
     new {userId = userId, @date = DateTime.Now});