IronPython Documentation
The information below is aimed at IronPython 2.7.3. This is the version used for scripting in SoftPro Select. The obvious question is why don’t we update? The obvious answer is – why?
Category Archives: Software
IronPython DLL Paths
IronPython code will automatically look in the following folders for DLLs and code modules for Custom Order Rules.
IronPython 2.7.x CLR Library Methods/Properties
I was curious about the methods exposed when you do an import clr command. The source code for ClrModule.cs is here. Methods marked as “Advanced” are highly specialized and will not be covered. Methods AddReference(string[] references) : void Add DLL to internal list of assemblies useable by code. Adds a reference to a .NET assembly. Parameters can be… Read More »
Azure Pipeline Conditions
Typical task condition statements look like this PowerShell task: Below are example condition statements. Note that you cannot use macro variable format such as $(Build.SourceBranch). Case is ignored on the variable names. Other useful conditions are available from Microsoft. Template Parameter Conditions (From Microsoft documents) Parameter expansion happens before conditions are considered. Therefore, when you declare a parameter… Read More »
Using PowerShell in Azure
Let’s start by saying the PowerShell is one of the most opaque and crappy languages that was ever created. I’m glad some people like it – but as far as me, it sucks. Adding PowerShell to Azure YAML Build Script Adding PowerShell scripts is easy. The example below shows how to create a script with embedded PowerShell code.… Read More »
Template SQL Script for Order ID Index Values
Use the template below to load the RootID and Guid values for an order if you have the order number. Add your custom code to the “Queries” section. The code shows an example that displays the Settlement Date for the specified order number.
Add Build Output Messages to Azure DevOps
Azure has a tool that is used in many DevOps YAML scripts. It has many capabilities – to the point of wondering why they crammed so many unrelated functions into one construct. All of this information is from a Microsoft Azure DevOps Services page: Logging commands. Check it out because I will not list these options: Show percentage… Read More »
Search SQL Database for Instances of Column Name
I needed to find where a certain column name was being used. Try this…
SQL Cheatsheet
Multiple “Order By” Clause Separate the order by clauses with commas. Use “CASE” to Convert Non-String to String Value In this example, we want do display the SettlementType value (an integer) as a human readable value in a column named “Settlement”. Resulting SQL view. Update Row Value The basic command is: For instance:
Python Quick Tips for SoftPro Select Custom Order Rules and Automation Snippets
I keep a bunch of handy code fragments here so I don’t lose them. They are in no particular order. IEnumManager – Get IState, IBillCode, and Many Others You must use IEnumManager to get literally dozens of values that are come from lists that are either maintained inside Select (like IState) or are user editable (such as Bill… Read More »