1. ssh-key gen to generate private/public key
2. check the public key gnerated
4. Connect remote host. confirm public key copied.
Monday 1 August 2022
ssh login without password
Tuesday 19 July 2022
Thursday 23 June 2022
Building a serverless web app
https://docs.microsoft.com/en-us/labs/build2018/serverlesswebapp/
https://www.google.com/search?q=serverless+web+app+tutorial+c%23&oq=serverless&aqs=chrome.4.69i57j69i60l3j35i39l2j0i131i433i512j0i512.6810j1j4&client=ms-android-samsung-gs-rev1&sourceid=chrome-mobile&ie=UTF-8#fpstate=ive&vld=cid:2293a4cb,vid:idR4S7BXYns,st:0
### What is blazor?
### What is blazor?
```
C:\Users\matthew.oh>dotnet --list-sdks
6.0.300 [C:\Program Files\dotnet\sdk]
```
q. what is blazor?
ans. using c# as javascript
q. web assembly?
ans. web compiler
q. SignalR connection?
ans. connection between client and server
when button clicks on client side, HTML Diff sent from server through SignalR connection
blazor application + server hosting model
C:\Users\matthew.oh>dotnet --list-sdks
## Blazor tutorial
separate .cs files or inline in your Razor components.
### todo blazorapp
@expression() to add a c# statement inline with HTML
@code
@functions
@Page
@bind
```
c:\Works\BlazorApp\BlazorApp>dotnet new razorcomponent -n Todo -o Pages
The template "Razor Component" was created successfully.
```
Thursday 2 June 2022
c# wpf keep ui response not working (c# thread )
https://docs.microsoft.com/en-us/windows/uwp/debug-test-perf/keep-the-ui-thread-responsive
Above url says that don't put UI things with main working function.
// Perform background work here. // Don't directly access UI elements from this method.
The key point is let sub function be called inside:
await Task.Run(() => 'your function working long');
If you mix up main thread and ui thread, below error happens.
the calling thread cannot access this object
https://stackoverflow.com/questions/9732709/the-calling-thread-cannot-access-this-object-because-a-different-thread-owns-it
UI part code should be seprated from 'async work thread'. Otherwise you have error.
Read related article thoroughly:
https://stackoverflow.com/questions/9732709/the-calling-thread-cannot-access-this-object-because-a-different-thread-owns-it
Below code will not work for showing spinner
uiBefore();
ConnectionChanged();
uiAfter();
Below code works
uiBefore();
await Task.Run(() =>
{
ConnectionChanged();
});
uiAfter();
private void uiBefore()
{
faSpinner.Visibility = Visibility.Visible;
}
private void uiAfter()
{
faSpinner.Visibility = Visibility.Collapsed;
}
It seems funciton inside await Task.Run() doesn't have to be async function. Only the parent function needs to be async. Below code works.
Wednesday 1 June 2022
Sunday 29 May 2022
WPF tutorial
https://docs.microsoft.com/en-us/visualstudio/get-started/csharp/tutorial-wpf?view=vs-2022
So easy to release:
- No IIS publish
- No admin permission to install the program
- UI can be easily updated through XAML file.
More tutorials:
I choose the first one.
This tutorial shows TreeView and two ListViews.
Code converted to c# by: https://converter.telerik.com/
<ListView Name="listView1"
ItemsSource="{Binding Path=SelectedItem.SubFolders, ElementName=treeView1, Mode=OneWay}"
Grid.Column="1"
Grid.RowSpan="1" />
<ListView Name="listView2"
ItemsSource="{Binding Path=SelectedItem.Files, ElementName=treeView1, Mode=OneWay}"
Grid.Column="1"
Grid.Row="1" />
Friday 27 May 2022
visual code + ssh
You can then open any folder or workspace on the remote machine using File > Open... or File > Open Workspace... just as you would locally!
git bash include my scripts folder
https://www.maketecheasier.com/make-scripts-executable-everywhere-linux/
Combination of above two links.
I googled:
bash make my script runnable everywhere
git bash include my scripts folder
Now it works ...
Thursday 26 May 2022
dense_rank()
Good url about dense_rank()
-- In addition to dense_rank(), apply row_number for each row
select *, row_number() over (partition by category_id order by category_id) row_num from (
select category_id, product_id, product_name, list_price, dense_rank() over (partition by category_id order by list_price desc) price_rank from production.products
) t where price_rank < 3;
-- Top 1 record for each category by price
select * from (
select *, row_number() over (partition by category_id order by category_id) row_num from (
select category_id, product_id, product_name, list_price, dense_rank() over (partition by category_id order by list_price desc) price_rank from production.products
) t where price_rank < 3
) t2 where row_num in (1);
Wednesday 25 May 2022
DevOPs pipeline
Very confusing ...
Hi winhost,
Do you support DevOPs pipeline?
I am trying to replicate my table structure and data into one of my database in winhost.
MS document seems saying that I need to run windows shell script on the server.
https://docs.microsoft.com/en-us/azure/devops/pipelines/release/deployment-groups/?view=azure-devops
 | In this article. Azure DevOps Services | Azure DevOps Server 2020 | Azure DevOps Server 2019 | TFS 2018. A deployment group is a logical set of deployment target machines that have agents installed on each one. docs.microsoft.com |
Please see attached screenshots.
Any reply will be appreciated.
Thank you,
Matthew
Monday 23 May 2022
Azure DevOPs repo
Create a new repo
I couldn't make git push work with DevOps. It just showed below stupid screen with wrong branch 'main' not 'master'.
The below could mismatch. That's fine. You just need to go to the DevOps site and select the correct repo.
- Visual studio >> Git menu >> git global setting
- Visual studio >> File menu >> account setting
Select correct one that you created from Visual Studio.
Now all files show.
Change repo
- Delete .git folder
- Close/reopen visual studio
- Git>> Create a repository
- Select Azure DevOps
- Make the repository name different from the project name, eg, TodoApiMainenance
Add more columns to Todo Web api project
I want to add 4 more columns to the table.
GET Category
View
index.html
<form action="javascript:void(0);" method="POST" onsubmit="changeCategory()">
<select id="select-category">
<option>Please select</option>
</select>
</form>
Model
TodoItem.cs, TodoItemDTO.cs
public string? Category { get; set; }
Controller
TodoItemsController.cs
private static TodoItemDTO ItemToDTO(TodoItem todoItem) => new TodoItemDTO
{
Id = todoItem.Id,
Name = todoItem.Name,
IsComplete = todoItem.IsComplete,
Priority = todoItem.Priority,
Category = todoItem.Category,
};
PUT Category
View
site.js
function updateItem() {
if (!validateCategory()) {
return;
}
const itemId = document.getElementById('edit-id').value;
const item = {
id: parseInt(itemId, 10),
isComplete: document.getElementById('edit-isComplete').checked,
name: document.getElementById('edit-name').value.trim(),
priority: document.getElementById('edit-priority').value.trim(),
category: selectCategory.value,
};
callUpdateAPI(item);
closeInput();
return false;
}
Controller
Model
Add Category
View
site.js
function addItem() {
const addCategory = document.getElementById('add-category');
const addCategoryCheckbox = document.getElementById('add-category-checkbox');
let categoryString = undefined;
if (addCategoryCheckbox.checked) {
categoryString = addCategory.value;
} else {
if (!validateCategory()) {
return;
}
categoryString = selectCategory.value;
}
// saving ...
const addNameTextbox = document.getElementById('add-name');
toggleInputValue("#add-name-button");
const item = {
isComplete: false,
name: addNameTextbox.value.trim(),
priority: 9,
category: categoryString
};
Controller
TodoItemsController.cs
[HttpPost]
public async Task<ActionResult<TodoItem>> PostTodoItem(TodoItemDTO todoItemDTO)
{
var todoItem = new TodoItem
{
IsComplete = todoItemDTO.IsComplete,
Name = todoItemDTO.Name,
Priority = todoItemDTO.Priority,
Category = todoItemDTO.Category,
};
_context.TodoItems.Add(todoItem);
await _context.SaveChangesAsync();
//return CreatedAtAction("GetTodoItem", new { id = todoItem.Id }, todoItem);
return CreatedAtAction(nameof(GetTodoItem), new { id = todoItem.Id }, ItemToDTO(todoItem));
}
Model
Thursday 19 May 2022
Create shell script reading csv file and inserting SQL Server
Create a shell script
Above link's bcp command options didn't work.
Correct bcp command options could be found in:
https://docs.microsoft.com/en-us/azure/azure-sql/load-from-csv-with-bcp?view=azuresql
https://datacadamia.com/db/sql_server/bcp#csv
Also, make sure you didn't open the csv file.
https://stackoverflow.com/questions/39465354/bcp-error-unable-to-open-bcp-host-data-file
After changing 'Year' as int type, import had error.
https://stackoverflow.com/questions/604864/print-a-file-skipping-the-first-x-lines-in-bash
Run script from Informatica
Subscribe to:
Posts (Atom)