Isolating Dependencies

Hi, is there any plan to introduce some procedure which apply all the constraints, keys and so on to faketable to have exact copy of original object (I know that I can add it through tSQLt.ApplyConstraint, but I am curious if there is plan to apply all constraints at once)?

A stackoverflow article mentions something that may work for faking functions

hi, I couldn't find anything about faking or appling an index after faking the table ? I am creating a test for a table and I need the presence of a filtered unique non clustered index , after faking the table,,, how can I do that ? appreciate your help. Thank you, Lisha

Hello, I writed SP that helps to fake scalar functions.It's not fully compled but it workin for me. create procedure tSQLt.FakeScalarFunction @FunctionName nvarchar(max) , @ReturnValue sql_variant = null as begin declare @Cmd nvarchar(max); declare @ProcParmTypeList nvarchar(max) declare @Seperator char(1) , @ProcParmTypeListSeparater char(1) , @ParamName sysname , @TypeName sysname; declare @fn_ObjectId bigint = object_id(@FunctionName) if not exists ( select * from sys.objects where type = 'fn' and object_id = @fn_objectId ) begin raiserror ('Scalar fucntion %s does not exists', 16, 1, @FunctionName) return; end select @ProcParmTypeListSeparater = '' , @ProcParmTypeList = '' declare Parameters cursor for select p.name , t.TypeName from sys.parameters p cross apply tSQLt.Private_GetFullTypeName(p.user_type_id, p.max_length, p.precision, p.scale) t where object_id = @fn_ObjectId and p.parameter_id > 0; open Parameters; fetch next from Parameters into @ParamName, @TypeName; while ( @@FETCH_STATUS = 0 ) begin select @ProcParmTypeList = @ProcParmTypeList + @ProcParmTypeListSeparater + @ParamName + ' ' + @TypeName + ' = NULL '--, select @ProcParmTypeListSeparater = ','; fetch next from Parameters into @ParamName, @TypeName; end; close Parameters; deallocate Parameters; declare @ReturnTypeName sysname = ( select t.name from sys.objects as o join sys.parameters as p on o.object_id = p.object_ID join sys.types as t on t.system_type_id = p.system_type_id where type in ( 'IF', 'TF', 'FN', 'FS', 'FT' ) and p.parameter_id = 0 and o.object_id = @fn_ObjectId ) select @Cmd = 'DROP function ' + @FunctionName + ';'; exec(@Cmd); declare @retValueStr varchar(max) = case when @ReturnValue is null then 'NULL' else convert(varchar(max), @ReturnValue) end select @Cmd = ' CREATE function ' + @FunctionName + ' ( ' + @ProcParmTypeList + ' ) ' + ' returns ' + @ReturnTypeName + ' AS BEGIN return ( ' + @retValueStr + ' ) ; END;'; exec(@Cmd); return 0; end; go

Hi @Lisha,

Did you get this right? I have exactlty the same requirement, and I'm working on a solution using a Generate Index Script at http://gallery.technet.microsoft.com/scriptcenter/SQL-Server-Generate-Index-fa790441

However, if you managed, you could save me some work :)

Thanks,

Dave

@DaveBoltman, tSQLt currently does not offer a built in way to apply an existing index to a faked table. For tSQLt.ApplyConstraint to handle Unique Constraints is one of the next items on the backlog, but currently it is not implemented either. 

Your best bet right now is to script out the index before faking the table and then re-applying it after the fake. But that is certainly not as simple as calling tSQLt.ApplyConstraint.