One thing that makes me very scary every time i hear about it is, that COVID-19 looks like a JIRA ticket. To demonstrate what i mean i just made a new project with COVID project prefix.
A change request (field „pcr“) only can have one unique assigned user that shall be informed about the assignment every night.
The assigned user (field „created_by“) of a change requests (field „pcr“) is changing several times a day. Every time the user (field „created_by“) changes to another user, a table entry with the actual time stamp (field „created_on“) is inserted to a SQL table.
At the end of the day, the system shall report via email the users that have been assigned to a PCR (only one user per change request).
The following table contains entries with people wo shall be informed every evening.
| id | pcr | created_on | created_by |
|---|---|---|---|
| 1 | PCR-1 | 2020-02-26 09:20:52.977 | user1 |
| 2 | PCR-1 | 2020-02-26 09:20:54.667 | user1 |
| 3 | PCR-2 | 2020-02-26 09:20:57.137 | user1 |
| 4 | PCR-2 | 2020-02-26 09:20:59.003 | user1 |
| 5 | PCR-2 | 2020-02-26 09:21:07.540 | user3 |
| 6 | PCR-3 | 2020-02-26 09:21:09.850 | user3 |
| 7 | PCR-4 | 2020-02-26 09:21:12.850 | user3 |
| 8 | PCR-4 | 2020-02-26 09:21:15.100 | user3 |
| 9 | PCR-5 | 2020-02-26 09:21:55.323 | user3 |
| 10 | PCR-2 | 2020-02-26 09:22:06.037 | user2 |
| 11 | PCR-5 | 2020-02-26 09:22:07.037 | user2 |
| 12 | PCR-7 | 2020-02-26 09:22:08.760 | user2 |
| 13 | PCR-7 | 2020-02-26 10:20:07.233 | user2 |
| 14 | PCR-8 | 2020-02-26 10:20:08.967 | user2 |
| 15 | PCR-8 | 2020-02-26 10:20:13.393 | user1 |
| 16 | PCR-9 | 2020-02-26 10:20:15.020 | user1 |
| 17 | PCR-7 | 2020-02-26 10:20:19.497 | user3 |
| 18 | PCR-9 | 2020-02-26 10:20:20.163 | user3 |
A nightly executed batch job (at 23:59h every evening) shall provide the possibility to inform user1, user2 or user3 about their assigned PCR’s. Only the latest entry per PCR, that can be recognized by the timestamp (field „created_on“) represent the user assigned user at the end of the day
The SQL Statement shall output the latest entry per assigned user of each PCR. With a standard aggregate function this is not possible because the whole row entry has to be retrieved.
The Microsoft SQL Server has a proprietary function RANK(), that prints out the ranking of the PCR entry in connection with PARTITION BY and ORDER BY. The ORDER BY has to be used DESC, so that the latest entry always is on rank 1.
Because this methods only can be used within the SELECT statements fields and not withing WHERE, we need a second parent query to select everything with rank 1.
SELECT *
FROM (
SELECT id,
pcr,
created_on,
created_by,
RANK () OVER (
PARTITION BY pcr
ORDER BY created_on DESC
) as biggestHasRangOne
FROM nightly_email
)tab
WHERE biggestHasRangOne=1
AND CONVERT(date, GETDATE())=CONVERT (date, created_on)
To get the smallest one (minimum) in for that day you have to use
ORDER BY created_on ASC
In the RANK() – Partition by -Syntax.
Since JAVA has been overtaken by Oracle, it can’t be mistaken to get skilled with the basic concepts of Python. So this is my short Getting Started tutorial with my personal conclusion.
Instead of getting annoyed about the glorification of Python, it would be better to spend some time to have a short look at this programming framework.
In the most cases a language itself is not the crucial point, but it’s what it’s framework is providing for the developer.
So the most popular thing we hear about is the capabiliy that Python is good for…
To install Python, you have to go to https://www.python.org/downloads/ and download and install Python. The website is clearly arranged and you don’t have to spend much time to search for the correct runtime according to your needs.
After you have downloaded Python, a installation wizard guides you through the installation process in two steps. It catches to my eye that there are not so much options to choose except for the folder where you want to install it.
So what do we need now… a development environment? Hmm… well because I have installed a Visual Studio 2013, i want to test the free „Python support for Visual Studio 2013), which can be found for different Visual Studio versions here:
https://github.com/Microsoft/PTVS/releases/v2.2.2
After the installation, there is a new Project Type available, when choosing
Visual Studio 2013 menu: File –> New Project
After that you can immediatly start to code Python and press the Start-Button. Here is the „Hello World!“-Program:
What is a little bit weird is, that it doesn’t seems to matter if you use the following Syntax instead of the function-based print:
# This Python comment is like a UNIX Shellscript comment
print "Hello world!" # Is it possible to append a comment to the end?
# Is this really clean code if it doesn't matter how you write it?
print ("Hello world!")
# How do you write multi line?
print ("Hello "
"world!") # this works without line break
print "Hello "
"world!" #this not
print """Hello
world!""" #this works but shows the line break
# without declarion of a variable
print "Number 1:";
x = input(); # My first Input
print "Number 2:";
y = input("Here you can enter the input prompt:"); # My next Input
print """
The result is:
==============
"""
print "The result is " + str(x + y) # working
# Python is not converting
#automatically like C# when concatenating an Int to a String
print x #works
print y #works
print "A string for x: " + str(x) +"" #working
print "A string for y: " + y +"" #not working
#because he thinks that y is an Integer
In console applications it is possible to work simply with input and print. By experimenting a while you can find out what is working and what is not…
An input like „2“ will be automatically converted as an integer type (when it only contains an integer). It is possible to print the integers using the function (or command) „print“, but it is not possible to print an integer concatenated to a string.
„Wenn Sie Python sehen wollen, dann gehen sie doch ins Dschungelcamp!“
Nico Gerbig in WhatsApp
For non programmers it seems to be really easy to write small console programs, but the language itself allows much syntax variants that i don’t would expect as clear readable code (especially in Python 2.7 what i have been used ).
But as shown in the following Screenshot newer python versions are a little bit more strict concerning procedure-based-programming.
As you can see above, there is a small onboard IDE shipping with python that has a console in which it is possible to execute python code directly. Additionally it allows you to write programs in whole Python files by selecting the „File->New File“ in the menu.
One thing that makes me muse about the language concept is the missing option for variable declaration. Learing tutorials and guides are always promoting the omission of type-safe variable declaration as innovative concept and benefit in comparison to other common programming languages. I think it would be eligable to ask the question: „Why do non type-safe languages like JavaScript need a type-safe extension like TypeScript?“. Languages like Visual Basic (for applications) have introducted the „option explicit“ command to force the developer to do this … why? 🙂
In further steps i want to find out how to point my Visual Studio to the newer Python framework. Python 3.8 is already installed but i do not have the choice to change it in Visual Studio. So i guess there must be a seperate configuration for this.
I am looking forward to evaluate the Tensorflow AI library and what benefit i can get from it.
Testing makes me happy 🙂 …
There are 4 common Unit Test Frameworks available as NuGet-Packages:
This short instruction shows how to set up the integrated standard Unit Test Framework without installing packages.
Please Note: If you want to test another project with the test project, you have to Add a reference to it by right-clicking references -> Add…
Testing makes you happy 🙂
C# code shall be executed in the wordpress.
https://dotnetfiddle.net can be used to run C# Code.
Von Doors aus sollen REST Services aufgerufen werden.
REST Services shall be called within a DXL Script in IBM Doors
Usage of OLE Automization
pragma runLim,0
OleAutoArgs args = create
OleAutoArgs args2 = create
OleAutoObj http = oleCreateAutoObject("WinHttp.WinHttpRequest.5.1")
void sendResult(string commandId, string result) {
clear(args)
clear(args2)
put(args, "POST")
put(args, "https://my.url.de/commands/" commandId "/result")
OleAutoArgs args2 = create
put(args2, result)
oleMethod(http, "open", args)
string res = oleMethod(http, "send", args2)
if(!null(res)){
print "\n" stringOf(dateAndTime(today)) ": Sending data data Failed"
print "\n" res
}
}
Regexp lines = regexp ".*"
bool connected = true
while(connected) {
clear(args)
put(args, "GET")
put(args, "https://my.url.de/nextCommand")
oleMethod(http, "open", args)
oleMethod(http, "send")
int status
oleGet(http, "status", status)
connected = status == 200
string response
oleGet(http, "responseText", response)
print "RESPONSE:" response "\n"
lines response
string commandId = response[0:end 0]
string resultUrl = "https://my.urld.de/rest/connections/107030b3-0a046c8d-7c2b9836-edaa752e/commands/" commandId "/result"
string command = "pragma runLim,0\nstring resultUrl = \"" resultUrl "\"\n" response[end 0+2:]
sendResult(commandId, eval_(command))
}
Das akkustische Feebback bei VariAudio scheint nicht mehr zu funktionieren. Trotz mehrfachem Ein- und Ausschaltens der Monitor/Abhörfunktion oder der Aufnahmefunktion kann kein Feedback wahrgenommen werden.
Während des normale Workflow zum Bearbeiten von Projektinhalten wurde versehentlich der Control-Room eingeschaltet. Wenn der Control-Room eingeschaltet wurde kann er auch nicht über den Reiter „Control Room“ in der rechten Leiste deaktiviert werden.
Die VST-Verbindungen müssen mit F4 aufgerufen werden und der Reiter „Control Room“ ausgewählt werden. Anschließend wir der Button „Control Room“ deaktiviert. Danach funktioniert das akkustische Feedback von VariAudio wieder.
Sometimes it is eligible to have a way to easily create a browser prompt / confirm dialog / Textinput without defining a Popup DIV and catch those inputs.
The code thread will be interrupted and a modal browser window dialog will be shown
Emails should be send via DXL script.
The Doors Client should have access to a SMTP Server on it’s configured port (normally 25)
Right-click the doors database icon in the database explorer and make the following setttings:
string smtpServer = getDatabaseMailServer();
string smtpFrom = "Superman";
string smtpFrom2 = getDatabaseMailServerAccount();
string smtpTo = "bjoern.karpenstein@test.com";
string smtpSubject = "test";
string smtpMessage = "this is a test";
print "Mail Server Name: " smtpServer "\n";
print "Mail from account: " smtpFrom2 "\n\n";
bool b = sendEMailNotification(smtpFrom, smtpTo, smtpSubject, smtpMessage);
if (b) {
print "Message sent\n";
} else {
print "Could not send message.\n";
}
The SMB Mount / File Share for the web folders directory should be accessible for the admins but not for unauthorized people
After setting the File Sharing permissions to that, the web applications shows HTTP error code 500 what means that the Microsoft IIS worker process does not have enough privileges.
To ensure, that the Microsoft IIS Server worker process has enough privileges to execute ASP.NET in the Directory and to prevent unauthorized access to the SMB Mount of the web application,the following settings should be applied
