juanonsoftware

Autotrading bot

juanonsoftware

To add other repos as submodules in an existing git repo

1. Create a public repo for submodule https://github.com/juanonsoftware/PocGitAsPublicSubmodule, with some content.

2. Checkout the main public repo https://github.com/juanonsoftware/PocGitWorkflows

3. Run a command to add the child-repo as a submodule

git submodule add -f https://github.com/juanonsoftware/PocGitAsPublicSubmodule.git PublicSubmodule

juanonsoftware

Trigger a build from Github Actions, then deploy an application running in Docker on our "Laptop".

Add a self-hosted runners and execute scripts to deploy docker containers

1. Go to repo settings to add new hosted runner

2. Config the runner (Windows)

3. Create a new workflow yml file & job to use the configured runner

juanonsoftware

1. Create a git repo https://github.com/juanonsoftware/PocGitWorkflows
2. In Windows, create a folder D:\Dev\PocGitWorkflows
3. Open the Terminal and do the following on that folder:
  - git init -> to init an empty git repo
  - create a txt file called Readme.txt
  - git add -A -> to add all changes from tracked / untracked files
  - git commit -m "First commit in the repo" -> commit for the first time
  - git remote add origin https://github.com/juanonsoftware/PocGitWorkflows.git -> to add a remote
  -> git push -u origin master -> to push the local branch to remote repo
3. Now refresh https://github.com/juanonsoftware/PocGitWorkflows to see the new file available on github

juanonsoftware

Details of the package manager -> https://learn.microsoft.com/en-us/windows/package-manager/winget/

1. Search for packages
  - winget search git -> to search for packages containing "git"
2. From the output, I can see TortoiseGit. Its id is TortoiseGit.TortoiseGit
3. Run install command to install this app
  - winget install TortoiseGit.TortoiseGit -> winget will download the app and display a confirmation to install
4. Now it's ready to use, right click on a folder / show more to see git menus

juanonsoftware

Deploy a product from Github Actions

1. Go to repository settings

2. Add Environments and set the variables

juanonsoftware

# 1. Setup IIS
Enable-WindowsOptionalFeature -Online -FeatureName IIS-WebServerRole, IIS-WebServer
Install-WindowsFeature -Name "Web-CertProvider"
Install-WindowsFeature -Name Web-Asp-Net45

# 2. Setup Chocolatey
Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))

# 3. Setup Net 6 & IIS extensions
# 3.1. NET6

juanonsoftware

System Design Cheatsheet

Picking the right architecture = Picking the right battles + Managing trade-offs

Basic Steps

1. Clarify and agree on the scope of the system

• User cases (description of sequences of events that, taken together, lead to a system doing something useful)
  • Who is going to use it?
  • How are they going to use it?

juanonsoftware

-- With SQL

select handle.text as sql, * from
(
	select DB_NAME(dbid) as dbname, *
	from master.dbo.sysprocesses
	where blocked <> 0

	union

juanonsoftware

--- Kill blocked processes on a database
DECLARE @databasename nvarchar(50)
SET @databasename = N'Datbase_Name'
-- SET @databasename = DB_NAME()

DECLARE @Sql varchar(max)
SET @Sql = ''

SELECT @Sql = @Sql + 'Kill ' + Convert(varchar, SPId) + ';'
FROM master.dbo.sysprocesses