Create environment group and create variable
Now in Login post API call, write below lines in scripts tab
Use Bareartoken automatically in all other authorized API call,
Generate AI Video
1)
-- input - Provide - Write topic name
Need fast paced more engaging script that starts with a shocking hook that engaged the audience in the first 3 seconds of the video, script contains only true and real facts because we don't want to misguide our audience, Need only script part, so don't write anything extra, need script in gujarati
-- output - ChatGPT will provide story script
--------
2)
-- input - below text
Mujhe iss script ke har possible scene ka 9:16 ratio me image prompt chahiye but dhyan rahe mujhe ye details:
"Ultra-realistic 3D cinematic render, hyper detailed skin texture, dramatic lighting, depth of field, mythological Indian art style, epic storytelling, high resolution, 8K, photorealistic, Unreal Engine, cinematic composition." Sabhi image me
Output - ChatGPT will provide some scenes scrip list
-------------
3)
-- input -
- Select Scene 1 by 1 and open chatgpt 5.2
- Select create image option from plus button
- Provide scene detail
-- output - ChatGPT will create image, download it
------------
4)
-- input
Mujhe es image ko animate bhi karna hai to kya tum story scene ke hisab se es scene ka most suitable video Prompt taiyar kr sakte ho, video must be 8k in quality, short and customized for grok ai, add different camera angle like - drone shot, zoom in, zoom out, specific character highlight, fast camera movement, etc.
output - ChatGPT will provide Video Prompt
---------
5) Open Grok Application
-- input
- Select imagine
- Select create video option
- select image
- paste video prompt
-- output - Video will be ready, download it.
---------------------
6) Repeate step 3, 4 and 5 for all scenes
-----------
7) Google AI Studio - Voice Generator
Instruction - Read aloud in a very fast paced, mysterious and shocking tone:
Mai tumhe jo bhi sentences dunga mujhe uska 9:16 ratio me detailed image prompt chahiye but dhyan rahe mujhe image details me:
"Ultra-realistic 3D cinematic render, hyper detailed skin texture, dramatic lighting, depth of field, mythological Indian art style, epic storytelling, high resolution, 8K, photorealistic, Unreal Engine, cinematic composition."
--------
az resource list --subscription [subscription id - GUID]
az servicebus queue list --namespace-name <ServiceBusName> --resource-group <ResourceGruopName> --output table
$vault_name = "keyvault-name"
# Get all secret names
$secret_names=$(az keyvault secret list --vault-name $vault_name --query [].name -o tsv)
# Loop through each secret name and get its value
foreach ($secret in $secret_names)
{
$secret_value=$(az keyvault secret show --vault-name $vault_name --name $secret --query "value")
Write-Output $secret
Write-Output $secret_value
Write-Output "-------------------------"
}
Here is a code to write data into Excel file and save it in a particular path.
$excel = New-Object -ComObject excel.application
#$excel.visible = $True
$workbook = $excel.Workbooks.Add()
$SheetName = "MySheet"
$uregwksht= $workbook.Worksheets.Item(1)
$uregwksht.Name = $SheetName
$row = 1
$Column = 1
$uregwksht.Cells.Item($row,$column)= "Column Title"
for ($i = 2; $i -le 5; $i++)
{
Write-Output $i
$row = $row + 1
$uregwksht.Cells.Item($row,$column)= "Abcd" + $i
}
$outputpath = "D:\test.xlsx"
$excel.displayalerts = $false
$workbook.Saveas($outputpath)
$excel.displayalerts = $true
Write-Output $("File saved on " + $outputpath )
$excel.Quit()
#ref - https://community.spiceworks.com/t/create-an-excel-file-from-within-powershell/1011485
#ref - https://chanmingman.wordpress.com/2022/10/02/powershell-write-to-excel-file/
docker build sh: react-scripts: not found
Deleting package-lock.json and re-installing packages with npm install before building the container solved the issue for me.
Data is Null. This method or property cannot be called on Null values
public string Memo { get; set; }
public string? Memo { get; set; }
New-AzResourceGroup : The term 'New-AzResourceGroup' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and
try again.
At line:1 char:1
+ New-AzResourceGroup
+ ~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (New-AzResourceGroup:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
You need to install the Azure Powershell module:
You can look for just the one for this command:
Install-Module -Name Az.Resources -AllowClobber -Scope CurrentUser
Or all of them:
Install-Module -Name Az -AllowClobber -Scope CurrentUser
CREATE PROC SearchAllTables ( @SearchStr nvarchar(100) ) AS
BEGIN
CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))
SET NOCOUNT ON
DECLARE @TableName nvarchar(256),
@ColumnName nvarchar(128),
@SearchStr2 nvarchar(110)
SET @TableName = ''
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')
WHILE @TableName IS NOT NULL
BEGIN
SET @ColumnName = ''
SET @TableName = ( SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
AND OBJECTPROPERTY( OBJECT_ID( QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) ), 'IsMSShipped' ) = 0
)
WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
BEGIN
SET @ColumnName = ( SELECT MIN(QUOTENAME(COLUMN_NAME))
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)
AND TABLE_NAME = PARSENAME(@TableName, 1)
AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')
AND QUOTENAME(COLUMN_NAME) > @ColumnName )
IF @ColumnName IS NOT NULL
BEGIN
INSERT INTO #Results
EXEC ( 'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630) FROM ' + @TableName + ' (NOLOCK) ' + ' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2 )
END
END
END
SELECT ColumnName, ColumnValue FROM #Results
END
[error]C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\MSBuild\
Microsoft\VisualStudio\v16.0\Web\Microsoft.Web.Publishing.targets(2601,5):
Error : Copying file bin\roslyn\csc.exe to
obj\Release\Package\PackageTmp\bin\roslyn\csc.exe failed.
Could not find a part of the path 'bin\roslyn\csc.exe'.
run this in the Package Manager Console:
Update-Package Microsoft.CodeDom.Providers.DotNetCompilerPlatform -r
import { Injectable } from '@angular/core';
import { environment } from 'src/environments/environment';
import { ProductSearch } from '../Model/CountrySearch';
import { TokenParams } from '../Model/TokenParams';
import { Http, Headers } from '@angular/http';
import { Observable } from 'rxjs';
@Injectable()
export class CountrySearchService {
user = new TokenParams();
constructor(private http: Http) {
this.user = JSON.parse(localStorage.getItem('loggedInUser'));
}
getCountryDetail() : Observable<CountrySearch[]>
{
var headersAPI = new Headers();
headersAPI.append('Authorization' , 'Bearer ' + this.user.access_token);
return this.http.get(environment.apiUrl + environment.countrysearch,
{headers : headersAPI}).map(res => res.json());
}
}
import { Injectable } from '@angular/core';
import { environment } from 'src/environments/environment';
import { ProductSearch } from '../Model/CountrySearch';
import { TokenParams } from '../Model/TokenParams';
import { Http, Headers } from '@angular/http';
import { Observable } from 'rxjs';
@Injectable()
export class CountrySearchService {
user = new TokenParams();
constructor(private http: Http) {
this.user = JSON.parse(localStorage.getItem('loggedInUser'));
}
getCountryDetail22(searchText: string, pageNumber : number ) {
var httpOptions = {
headers: new HttpHeaders({
'Content-Type': 'application/json; charset=utf-8',
'Authorization' : 'Bearer ' + this.user.access_token
}),
};
return this.http.post(environment.apiUrl + environment.countrysearch,
{
PageSize:10,
PageNumber:pageNumber,
Search: searchText
},
this.httpOptions);
}
}
export class LocalStorageComponent implements OnInit {
constructor() { }
ngOnInit() {
//remove value if exists
//localStorage.removeItem('loggedInUser');
}
setlocalstorage() : void{
let userObj = { name: 'Rohit', lname: 'Rathod' };
localStorage.setItem('loggedInUser', JSON.stringify(userObj));
}
getlocalstorage() : void{
if (localStorage.length > 0)
{
// We have items
let item = JSON.parse(localStorage.getItem('loggedInUser'));
if(item != null)
{
console.log(item)
console.log(item.name)
console.log(item.lname)
}
}
else
{
// No items
alert('no local data')
}
}
}
<button (click) = "setlocalstorage()">Set Storage</button>
<button (click) = "getlocalstorage()">Get Storage</button>
import { FormsModule } from "@angular/forms";
imports: [
...
FormsModule ,
...
]
export class Employee {
EmployeeID : number;
FullName : string;
EmpCode : string;
Mobile : string;
Position : string;
}
export class EmployeeComponent implements OnInit {
formData : Employee;
constructor() {
this.formData = {
EmployeeID : null,
FullName : '',
EmpCode: '',
Position: '',
Mobile: ''
}
}
ngOnInit() {
}
submitform() : void{
console.log("FullName = " + this.formData.FullName)
console.log("EmpCode = " + this.formData.EmpCode)
console.log("Position = " + this.formData.Position)
console.log("Mobile = " + this.formData.Mobile)
//TODO
//Call service to insert data
}
}
<form #form="ngForm" (submit)="onSubmit(form)" autocomplete="off">
<div class="form-group">
<label>Fullname</label>
<input name="FullName" #FullName="ngModel" [(ngModel)] = "formData.FullName" class="form-control" required>
<div class="validation-error" *ngIf="FullName.invalid && FullName.touched">Fullname is required</div>
</div>
<div class="form-group">
<label>Position</label>
<input name="Position" #Position="ngModel" [(ngModel)] = "formData.Position" class="form-control">
</div>
<div class="form-row">
<div class="form-group col-md-6">
<label>EmpCode</label>
<input name="EmpCode" #EmpCode="ngModel" [(ngModel)] = "formData.EmpCode" class="form-control">
</div>
<div class="form-group col-md-6">
<label>Mobile</label>
<input name="Mobile" #Mobile="ngModel" [(ngModel)] = "formData.Mobile" class="form-control">
</div>
</div>
<div class="form-group">
<button type="button" [disabled]="form.invalid" (click) = "submitform()" class="btn btn-lg btn-block">
Submit Button
</button>
</div>
</form>
ng g c componentName --module app
or
ng g c componentName --module=app.module
or
ng g c componentName --skip-import
npm install ngx-infinite-scroll --save
import { InfiniteScrollModule } from 'ngx-infinite-scroll';
imports: [
...,
InfiniteScrollModule,
...
],
export class country{
ID : number;
Name : string;
}
export class countries{
ID : number;
Name : string;
constructor(item?: country) {
if (item != undefined) {
for (let key in item) {
try { this[key] = item[key]; }
catch (e) { }
}
}
}
}
export class DemoScrollDataComponent implements OnInit {
page: number = 1;
records: country[] = [];
constructor(private countryService : CountryService) { }
ngOnInit() {
this.getData(0);
}
getData(page : Number) {
console.log(this.page);
this.countryService.getCountry(this.page).subscribe((res) => this.onSuccess(res));
}
// When we got data on a success
onSuccess(res) {
console.log(res);
if (res != undefined) {
res.forEach(item => {
this.records.push(new countries(item));
});
}
}
onScrollDown (ev) {
console.log('scrolled down!!', ev);
this.page = this.page + 1;
this.getData(this.page);
}
onUp(ev) {
console.log('scrolled up!', ev);
}
}
<div class="search-results"
infinite-scroll
[infiniteScrollDistance]="0"
[infiniteScrollUpDistance]="10"
(scrolled)="onScrollDown()"
(scrolledUp)="onUp()">
<div *ngFor="let item of records" style="padding:20px">
{{ item.ID }} - {{ item.Name }}
</div>
</div>
export class CountryService {
constructor(private http:HttpClient) { }
getCountry(pageNumber : Number): Observable<country[]> {
return this.http.get<country[]>('http://localhost/DemoApp.API/api/CountryListPage?pageNumber='+ pageNumber)
}
}
export class country{
ID : number;
Name : string;
}
export class CountryService {
constructor(private http:HttpClient) { }
getCountry(pageNumber : Number): Observable<country[]> {
return this.http.get<country[]>('http://localhost/DemoApp.API/api/CountryListPage?pageNumber='+ pageNumber)
}
}
export class DemoComponent implements OnInit {
pagenumber : Number;
records = { count: 227, data: [] };
config = {
itemsPerPage: 5,
currentPage: 1,
totalItems: this.records.count
};
constructor(private countryService : CountryService, private route: ActivatedRoute, private router: Router) {
this.router.routeReuseStrategy.shouldReuseRoute = function(){
return false;
}
route.queryParams.subscribe(
params => this.config.currentPage= params['page']?params['page']:1 );
this.pagenumber = +this.route.snapshot.queryParamMap.get('page');
this.countryService.getCountry(this.pagenumber).subscribe(data=>{
this.records.data = data;
this.records.count = 227;
});
}
ngOnInit() {
}
pageChanged(newPage: number) {
this.router.navigate(['demo'], { queryParams: { page: newPage } });
}
}
<table class="table">
<thead>
<tr>
<th scope="col">#</th>
<th scope="col">Item</th>
</tr>
</thead>
<tbody>
<tr *ngFor="let item of records.data | paginate: config">
<th scope="row">{{item.ID}}</th>
<td>{{item.Name}}</td>
</tr>
</tbody>
</table>
<div>
<pagination-controls (pageChange)="pageChanged($event)"></pagination-controls>
</div>
CREATE TABLE [dbo].[employee](
[EmpName] [varchar](50) NULL,
[EmpID] [int] NULL,
[ManagerID] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[employee] ([EmpName], [EmpID], [ManagerID]) VALUES (N'Saurav', 1, 0)
INSERT [dbo].[employee] ([EmpName], [EmpID], [ManagerID]) VALUES (N'Dravid', 2, 1)
INSERT [dbo].[employee] ([EmpName], [EmpID], [ManagerID]) VALUES (N'Kapila', 3, 2)
INSERT [dbo].[employee] ([EmpName], [EmpID], [ManagerID]) VALUES (N'Pranil', 4, 2)
INSERT [dbo].[employee] ([EmpName], [EmpID], [ManagerID]) VALUES (N'Rohini', 5, 4)
INSERT [dbo].[employee] ([EmpName], [EmpID], [ManagerID]) VALUES (N'Peeter', 6, 0)
INSERT [dbo].[employee] ([EmpName], [EmpID], [ManagerID]) VALUES (N'Keveen', 7, 6)
GO
;with CTE(EmpID, empName, ManagerID)
AS
(
SELECT EmpID, empName, ManagerID
FROM Employee F
WHERE EmpID = 5
UNION ALL
SELECT F.EmpID, F.empName, F.ManagerID
FROM Employee F
INNER JOIN CTE FH ON FH.ManagerID = F.EmpID
)
SELECT * FROM CTE
WITH empCTE
AS ( SELECT EmpID, empName, ManagerID
FROM Employee
WHERE empid = 1 -- and ManagerID = 0
UNION ALL
SELECT e.EmpID, e.empName, e.ManagerID
FROM Employee e
INNER JOIN empCTE ON e.ManagerID = empCTE.EmpID
WHERE e.ManagerID != 0)
SELECT *
FROM empCTE
export class country{
ID : number;
Name : string;
}
import { Component, OnInit } from '@angular/core';
import { country } from 'src/app/Model/Country';
@Component({
selector: 'app-parent',
templateUrl: './parent.component.html',
styleUrls: ['./parent.component.css']
})
export class ParentComponent implements OnInit {
name: string = "DemoName";
vmCountry: country;
receivedChildMessage: string;
receivedChildAnotherMessage: country;
constructor() { }
ngOnInit() {
this.vmCountry = new country();
this.receivedChildAnotherMessage = new country();
this.vmCountry.Name = "India";
}
getMessage(message: string) {
this.receivedChildMessage = message;
}
getAnotherMessage(varCountry : country) {
this.receivedChildAnotherMessage = varCountry;
}
}
<h1>
parent works! test
</h1>
<app-child [name]="name" [varCountry]="vmCountry"
(messageToEmit)="getMessage($event)"
(anotherMessageToEmit)="getAnotherMessage($event)"></app-child>
<div class="row">
<div class="col-md-2">
{{receivedChildMessage}}
</div>
<div class="col-md-2">
{{receivedChildAnotherMessage.Name}}
</div>
</div>
import { Component, OnInit, Input, EventEmitter, Output } from '@angular/core';
import { country } from 'src/app/Model/Country';
@Component({
selector: 'app-child',
templateUrl: './child.component.html',
styleUrls: ['./child.component.css']
})
export class ChildComponent implements OnInit {
@Input() name: string;
@Input() varCountry: country;
@Output() messageToEmit = new EventEmitter<string>();
@Output() anotherMessageToEmit = new EventEmitter<country>();
constructor() { }
ngOnInit() {
}
sendMessageToParent(message: string) {
this.messageToEmit.emit(message)
}
sendAnotherMessageToParent() {
this.varCountry = new country;
this.varCountry.ID = 10;
this.varCountry.Name = "Japan";
this.anotherMessageToEmit.emit(this.varCountry)
}
}
<p>
child works {{name}}!
</p>
<h1>{{varCountry.Name}}</h1>
<div class="row">
<div class="col-md-2">
<button (click)="sendMessageToParent('message from child')">Send to Parent</button>
</div>
<div class="col-md-2">
<button (click)="sendAnotherMessageToParent()">Another Send to Parent </button>
</div>
</div>
@NgModule({
declarations: [
ParentComponent,
ChildComponent,
.....
],
.....
})