Development

Samples to support the development, lifecycle management, and CI/CD processes when working with the Thinkwise Platform.

  • 6 Topics
  • 3 Replies

6 Topics

L
Thinkwiser
luukschoutenThinkwiser
posted in Development

SVG icon validation

GoalThe following validation can be used to check whether the icons in the model comply with the desired file type. Solution;with cte as ( select 'col/form_next_grp_icon' as tab_col, form_next_grp_icon as icon from col t1 where t1.project_id = @project_id and t1.project_vrs_id = @project_vrs_id and t1.form_next_grp_icon not like '%.svg' union all select 'col/next_tab_icon', next_tab_icon from col t1 where t1.project_id = @project_id and t1.project_vrs_id = @project_vrs_id and t1.next_tab_icon not like '%.svg' union all select 'tile_grp/icon', icon from tile_grp t1 where t1.project_id = @project_id and t1.project_vrs_id = @project_vrs_id and t1.icon not like '%.svg' union all select 'task_variant_form/form_next_grp_icon', form_next_grp_icon from task_variant_form t1 where t1.project_id = @project_id and t1.project_vrs_id = @project_vrs_id and t1.form_next_grp_icon not like '%.svg' union all select 'task_variant_form/next_tab_icon',

2
Ester
Moderator
1 year ago
R
Thinkwiser
RemcoThinkwiser
posted in Development

Getting domain elements in SSMS with a shortcut

​GoalSometimes it's cumbersome to find out what a certain domain element means. For example with statuses where status = 1. So to find out what 1 is you need to leave SQL Server Management Studio (SSMS) and go to the software factory (SF) and search for the domain and check the domain elements. It would be faster if you can see it in SSMS.SolutionYou can make a procedure that will select the domain elements from the selected domain name and put it under a shortcut in SSMS. In that way you don’t have to leave SSMS.Here is how:First you create the procedure in the customer project in the SF: get_dom_elements. The code for the procedure is below. It only needs one parameter named: dom_id which is a varchar.After you created the procedure in the SF you need to add it as a shortcut in SSMS. You can get to the shortcuts options as followTools --> Options --> Environment --> keyboard --> Query shortcutsThen you type behind an available shortcut: exec get_dom_elementsIn the screens

1
E
Moderator
1 year ago
L
Thinkwiser
luukschoutenThinkwiser
posted in Development

Project specific validations

GoalIn projects you can make agreements with the customer and the development team about, for example, naming conventions for the data model, design of the GUI model or design of screen types. Examples of this are:Columns ending on "_nr" or "_number" should always have a numeric domain. Form fields have a standard width, which may only be deviated from in exceptional cases. When a column is determined to be an email address, then the column name should contain the text "email_address". A toolbar, report bar, prefilter bar and global filter are always on all screen types, also in the same position.These types of agreements ensure a consistent data model, GUI model which offers advantages for developers, administrators and users.SolutionYou can add your own validations to check for deviations from the agreements. If an exception has to be made, this can be done by approving the validation message. Validation examples:/* A column ending on "_nr" should always be numeric.*/insert validati

0
L
Thinkwiser
1 year ago
E
Moderator
Erwin EkkelModerator
posted in Development

Stored procedure execution plan and impact analysis

Goal:As applications become bigger there are also the risks of having no overview of what a stored procedure technically does. One stored procedure could have 6 sub-stored procedures and impact 12 tables with 7 triggers.There are two situations where this can become a problem:During troubleshooting: finding where a certain stored procedure modifies a specific table can become cumbersome. Impact analysis of a change: scanning all the sub processes and triggers involved can take a lot of time. The goal of this script is to give a visual representation of the execution plan of a stored procedure. And to make a better impact analysis also give you some info on the processes and triggers involved and the amount of rows and characters involved. The script scans every involved stored procedure/trigger and removes any comment lines. For now it ignores drop table statements (since these should be temp tables only), temp tables and it also ignores tsf_sendmessage since this stored procedure is o

0
E
Moderator
1 year ago
Tom van Druten
Thinkwiser
Tom van DrutenThinkwiser
posted in Development

Table variable for sp_who2

Goal You can easily check connections to the database (server), though you cannot filter it. Here's an easy example of a table variable where you insert into your sp_who2 data, so you can filter on whatever you want. I mostly use it to find all users connected to a certain database, so i can kill their connection when I want to upgrade and people didn't log out. Solution declare @sp_who table( spid int ,status varchar(max) ,login varchar(max) ,hostname varchar(max) ,blkby varchar(max) ,dbname varchar(max) ,command varchar(max) ,cputime int ,diskio int ,lastbatch varchar(max) ,programname varchar(max) ,spid2 int ,requestid int)insert into @sp_whoEXEC sp_who2SELECT * FROM @sp_whoWHERE dbname in('db1','db2')  

0
Tom van Druten
Thinkwiser
1 year ago
F
Thinkwiser
Frank Wijnhout
posted in Development

Attributes in a cursor have great impact on performance

Goal It is possible that in a stored procedure you need a cursor, for example to call another stored procedure. Think of a task Copy Sales Order, which calls the task Copy Sales Order Line for every line in the original order. Cursors can have several attributes . Microsoft gives the following syntax for a cursor in T-SQL: DECLARE cursor_name CURSOR [ LOCAL | GLOBAL ] [ FORWARD_ONLY | SCROLL ] [ STATIC | KEYSET | DYNAMIC | FAST_FORWARD ] [ READ_ONLY | SCROLL_LOCKS | OPTIMISTIC ] [ TYPE_WARNING ] FOR select_statement [ FOR UPDATE [ OF column_name [ ,...n ] ] ] [;] Cursors can scroll forward and backward, and can even be editable. However, in most cases these features are not needed (or not wanted). Important here is that the cursor attributes can have great impact on performance. With certain attributes used, performance can decrease op to 15 times! In the the solution you will find the best option for attributes in your cursors. Solutio

0
F
Thinkwiser
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings