Author Archives: Andreas

JavaScript CSV Download – Excel + Umlaute

var downloadCsv = function(content, fileName) { var a = document.createElement(‘a’); mimeType = mimeType || ‘application/octet-stream’; var mimeType = ‘text/csv;encoding:utf-8’; var BOM = “\uFEFF”; content = BOM + content; if (navigator.msSaveBlob) { // IE10 navigator.msSaveBlob(new Blob([content], { type: mimeType }), fileName); } else if (URL && ‘download’ in a) { //html5 A[download] a.href = URL.createObjectURL(new Blob([content], […]

Posted on 12. November 2020 by Andreas in JavaScript

VueCli installieren

Begriffe Definition Babel Ein JavaScript Kompiler. Übersetzt Code in EcmaScript, welcher auch mit alten JavaScript Browsern kompatibel ist und vieles mehr PostCss Beim kompilieren werden Prefixe an Css Klassen / Ids hinzugefügt, damit in einer SinglePage Applikation nicht plötzlich ein und dieselbe Id für unterschiedliche Komponente genutzt werden Lint Ein Prozess wo der Source Code […]

Posted on 22. Oktober 2020 by Andreas in Allgemein

ASP Core 3.1 inkl VueCLI mit mehreren VueApps verwenden

using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Builder; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.SpaServices; using Microsoft.Extensions.DependencyInjection; using Microsoft.Extensions.FileProviders; using Microsoft.Extensions.Hosting; using VueCliMiddleware; namespace ASPMultipleVueSPA { public class Startup { // This method gets called by the runtime. Use this method to add services to the container. // For more information on […]

Posted on 6. Oktober 2020 by Andreas in C#

Backup alle Nicht System Datenbanken

--Script 3: Backup all non-system databases

--1. Variable declaration

DECLARE @path VARCHAR(500)
DECLARE @name VARCHAR(500)
DECLARE @filename VARCHAR(256)
DECLARE @time DATETIME
DECLARE @year VARCHAR(4)
DECLARE @month VARCHAR(2)
DECLARE @day VARCHAR(2)
DECLARE @hour VARCHAR(2)
DECLARE @minute VARCHAR(2)
DECLARE @second VARCHAR(2)
 
-- 2. Setting the backup path

SET @path = 'C:\Temp\OneDrive\DevAndy\Backups Kingside\Database Backup\'  

 -- 3. Getting the time values

SELECT @time = GETDATE()
SELECT @year   = (SELECT CONVERT(VARCHAR(4), DATEPART(yy, @time)))
SELECT @month  = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(mm,@time),'00')))
SELECT @day    = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(dd,@time),'00')))
SELECT @hour   = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(hh,@time),'00')))
SELECT @minute = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(mi,@time),'00')))
SELECT @second = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(ss,@time),'00')))

-- 4. Defining cursor operations
 
DECLARE db_cursor CURSOR FOR  
SELECT name 
FROM master.dbo.sysdatabases 
WHERE name NOT IN ('master','model','msdb','tempdb')  -- system databases are excluded

--5. Initializing cursor operations

OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @name   

WHILE @@FETCH_STATUS = 0   
BEGIN

-- 6. Defining the filename format   
       SET @fileName = CONCAT(@path, @name, '_backup_', @year, '_', @month, '_', @day, '_', @hour, '_', @minute, '_', @second, '.bak')  
       BACKUP DATABASE @name TO DISK = @fileName  

 
       FETCH NEXT FROM db_cursor INTO @name   
END   
CLOSE db_cursor   
DEALLOCATE db_cursor

--Script 3: Backup all non-system databases

--1. Variable declaration

DECLARE @path VARCHAR(500)

DECLARE @name VARCHAR(500)

DECLARE @filename VARCHAR(256)

DECLARE @time DATETIME

DECLARE @year VARCHAR(4)

DECLARE @month VARCHAR(2)

DECLARE @day VARCHAR(2)

DECLARE @hour VARCHAR(2)

DECLARE @minute VARCHAR(2)

DECLARE @second VARCHAR(2)

-- 2. Setting the backup path

SET @path = 'C:\Temp\OneDrive\DevAndy\Backups Kingside\Database Backup\'

-- 3. Getting the time values

SELECT @time = GETDATE()

SELECT @year = (SELECT CONVERT(VARCHAR(4), DATEPART(yy, @time)))

SELECT @month = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(mm,@time),'00')))

SELECT @day = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(dd,@time),'00')))

SELECT @hour = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(hh,@time),'00')))

SELECT @minute = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(mi,@time),'00')))

SELECT @second = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(ss,@time),'00')))

-- 4. Defining cursor operations

DECLARE db_cursor CURSOR FOR

SELECT name

FROM master.dbo.sysdatabases

WHERE name NOT IN ('master','model','msdb','tempdb') -- system databases are excluded

--5. Initializing cursor operations

OPEN db_cursor

FETCH NEXT FROM db_cursor INTO @name

WHILE @@FETCH_STATUS = 0

BEGIN

-- 6. Defining the filename format

SET @fileName = CONCAT(@path, @name, '_backup_', @year, '_', @month, '_', @day, '_', @hour, '_', @minute, '_', @second, '.bak')

BACKUP DATABASE @name TO DISK = @fileName

FETCH NEXT FROM db_cursor INTO @name

END

CLOSE db_cursor

DEALLOCATE db_cursor

Quelle: https://www.sqlshack.com/multiple-methods-for-scheduling-a-sql-server-backup-automatically/

Posted on 8. August 2020 by Andreas in SQL

Openmediavault + Nextcloud auf Raspberry Pi installieren

Installation erfolgt von einem Windows Rechner. Benötigt werden folgende Programme: SD Card Formatter: https://www.sdcard.org/downloads/formatter/ Win32 Disk Imager: https://sourceforge.net/projects/win32diskimager/ Raspberry Pi OS (32-bit) Lite Image: https://www.raspberrypi.org/downloads/raspberry-pi-os/ KiTTY oder PuTTY (SSH Client) [Im folgenden Konsole genannt]: https://www.fosshub.com/KiTTY.html Vorbereitung: Mit SD Card Formatter SD Karte formatieren Mit Win32 Disk Imager “Raspberry Pi OS (32-bit) Lite Image” auf SD […]

Posted on 3. August 2020 by Andreas in Allgemein

ASP Core Configuration vererben

public IConfiguration Configuration { get; } in ServiceCollection services.Configure<BaseConfiguration>(this.Configuration); services.Configure<ChildConfiguration>(this.Configuration); Die ChildConfiguration erbt von BaseConfiguration Hat die ChildConfiguration Unterknoten, erben auch die Unterknoten. So wird die Konfiguration “erweitert”

Posted on 17. Juli 2020 by Andreas in Allgemein, C#

Integrations Test mit Dependency Injection MsTest v2 .Net Core 3.1

Möchte man einen Integrationstest schreiben und dabei dependency injection nutzen, muss man folgendermaßen vorgehen: Im Besten Fall teilt ma die Ausführende Applikation z.B. Web Applikation, Console etc und eine Bibliothek. In die Bibliothek kommt die Auslagerung der StartUp:

    public static class ServiceCollectionExtensions
    {
        public static void UseMyModule(this IServiceCollection services)
        {
            services.AddTransient<IMyClass, MyClass>();
        }
    }

public static class ServiceCollectionExtensions

{

public static void UseMyModule(this IServiceCollection services)

{

services.AddTransient<IMyClass, MyClass>();

}

Im Testprojekt wird eine Basis Klasse definiert, die dieses Modul einliest. Nun kann in CofigureServices services.UseMyModule() […]

Posted on 10. Juli 2020 by Andreas in Allgemein, C#

SQL CPU Last und Gesamtdauer von Query testen

set statistics time on
 
select 1


set statistics time off

set statistics time on

select 1

set statistics time off

Posted on 26. Mai 2020 by Andreas in SQL

.gitignore SSIS dtsx Dateien hinzufügen

in der VisualStudio .gitignore: https://www.gitignore.io/api/visualstudio wird das komplette Verzeichnis “obj” exkludiert. Die packages (.dtsx) aus SSIS befindet sich aber gerade dort. Daher muss man folgende Zeile auskommentieren:

#[Oo]bj/

#[Oo]bj/

und unter diesen Block einen neuen Block hinzufügen:

#SSIS
!**/[Oo]bj/**/*.*
**/[Oo]bj/**/*.*
!**/[Oo]bj/**/*.dtsx
!**/[Oo]bj/**/*.conmgr

#SSIS

!**/[Oo]bj/**/*.*

**/[Oo]bj/**/*.*

!**/[Oo]bj/**/*.dtsx

!**/[Oo]bj/**/*.conmgr

meine komplette .gitignore sieht demnach so aus:

## Ignore Visual Studio temporary files, build results, and
## files generated by popular Visual Studio add-ons.
##
## Get latest from https://github.com/github/gitignore/blob/master/VisualStudio.gitignore

# User-specific files
*.rsuser
*.suo
*.user
*.userosscache
*.sln.docstates

# User-specific files (MonoDevelop/Xamarin Studio)
*.userprefs

# Mono auto generated files
mono_crash.*

# Build results
[Dd]ebug/
[Dd]ebugPublic/
[Rr]elease/
[Rr]eleases/
x64/
x86/
[Ww][Ii][Nn]32/
[Aa][Rr][Mm]/
[Aa][Rr][Mm]64/
bld/
[Bb]in/
#[Oo]bj/
[Ll]og/
[Ll]ogs/

#SSIS
!**/[Oo]bj/**/*.*
**/[Oo]bj/**/*.*
!**/[Oo]bj/**/*.dtsx
!**/[Oo]bj/**/*.conmgr

# Visual Studio 2015/2017 cache/options directory
.vs/
# Uncomment if you have tasks that create the project's static files in wwwroot
#wwwroot/

# Visual Studio 2017 auto generated files
Generated\ Files/

# MSTest test Results
[Tt]est[Rr]esult*/
[Bb]uild[Ll]og.*

# NUnit
*.VisualState.xml
TestResult.xml
nunit-*.xml

# Build Results of an ATL Project
[Dd]ebugPS/
[Rr]eleasePS/
dlldata.c

# Benchmark Results
BenchmarkDotNet.Artifacts/

# .NET Core
project.lock.json
project.fragment.lock.json
artifacts/

# ASP.NET Scaffolding
ScaffoldingReadMe.txt

# StyleCop
StyleCopReport.xml

# Files built by Visual Studio
*_i.c
*_p.c
*_h.h
*.ilk
*.meta
*.obj
*.iobj
*.pch
*.pdb
*.ipdb
*.pgc
*.pgd
*.rsp
*.sbr
*.tlb
*.tli
*.tlh
*.tmp
*.tmp_proj
*_wpftmp.csproj
*.log
*.vspscc
*.vssscc
.builds
*.pidb
*.svclog
*.scc

# Chutzpah Test files
_Chutzpah*

# Visual C++ cache files
ipch/
*.aps
*.ncb
*.opendb
*.opensdf
*.sdf
*.cachefile
*.VC.db
*.VC.VC.opendb

# Visual Studio profiler
*.psess
*.vsp
*.vspx
*.sap

# Visual Studio Trace Files
*.e2e

# TFS 2012 Local Workspace
$tf/

# Guidance Automation Toolkit
*.gpState

# ReSharper is a .NET coding add-in
_ReSharper*/
*.[Rr]e[Ss]harper
*.DotSettings.user

# TeamCity is a build add-in
_TeamCity*

# DotCover is a Code Coverage Tool
*.dotCover

# AxoCover is a Code Coverage Tool
.axoCover/*
!.axoCover/settings.json

# Coverlet is a free, cross platform Code Coverage Tool
coverage*[.json, .xml, .info]

# Visual Studio code coverage results
*.coverage
*.coveragexml

# NCrunch
_NCrunch_*
.*crunch*.local.xml
nCrunchTemp_*

# MightyMoose
*.mm.*
AutoTest.Net/

# Web workbench (sass)
.sass-cache/

# Installshield output folder
[Ee]xpress/

# DocProject is a documentation generator add-in
DocProject/buildhelp/
DocProject/Help/*.HxT
DocProject/Help/*.HxC
DocProject/Help/*.hhc
DocProject/Help/*.hhk
DocProject/Help/*.hhp
DocProject/Help/Html2
DocProject/Help/html

# Click-Once directory
publish/

# Publish Web Output
*.[Pp]ublish.xml
*.azurePubxml
# Note: Comment the next line if you want to checkin your web deploy settings,
# but database connection strings (with potential passwords) will be unencrypted
*.pubxml
*.publishproj

# Microsoft Azure Web App publish settings. Comment the next line if you want to
# checkin your Azure Web App publish settings, but sensitive information contained
# in these scripts will be unencrypted
PublishScripts/

# NuGet Packages
*.nupkg
# NuGet Symbol Packages
*.snupkg
# The packages folder can be ignored because of Package Restore
**/[Pp]ackages/*
# except build/, which is used as an MSBuild target.
!**/[Pp]ackages/build/
# Uncomment if necessary however generally it will be regenerated when needed
#!**/[Pp]ackages/repositories.config
# NuGet v3's project.json files produces more ignorable files
*.nuget.props
*.nuget.targets

# Microsoft Azure Build Output
csx/
*.build.csdef

# Microsoft Azure Emulator
ecf/
rcf/

# Windows Store app package directories and files
AppPackages/
BundleArtifacts/
Package.StoreAssociation.xml
_pkginfo.txt
*.appx
*.appxbundle
*.appxupload

# Visual Studio cache files
# files ending in .cache can be ignored
*.[Cc]ache
# but keep track of directories ending in .cache
!?*.[Cc]ache/

# Others
ClientBin/
~$*
*~
*.dbmdl
*.dbproj.schemaview
*.jfm
*.pfx
*.publishsettings
orleans.codegen.cs

# Including strong name files can present a security risk
# (https://github.com/github/gitignore/pull/2483#issue-259490424)
#*.snk

# Since there are multiple workflows, uncomment next line to ignore bower_components
# (https://github.com/github/gitignore/pull/1529#issuecomment-104372622)
#bower_components/

# RIA/Silverlight projects
Generated_Code/

# Backup & report files from converting an old project file
# to a newer Visual Studio version. Backup files are not needed,
# because we have git ;-)
_UpgradeReport_Files/
Backup*/
UpgradeLog*.XML
UpgradeLog*.htm
ServiceFabricBackup/
*.rptproj.bak

# SQL Server files
*.mdf
*.ldf
*.ndf

# Business Intelligence projects
*.rdl.data
*.bim.layout
*.bim_*.settings
*.rptproj.rsuser
*- [Bb]ackup.rdl
*- [Bb]ackup ([0-9]).rdl
*- [Bb]ackup ([0-9][0-9]).rdl

# Microsoft Fakes
FakesAssemblies/

# GhostDoc plugin setting file
*.GhostDoc.xml

# Node.js Tools for Visual Studio
.ntvs_analysis.dat
node_modules/

# Visual Studio 6 build log
*.plg

# Visual Studio 6 workspace options file
*.opt

# Visual Studio 6 auto-generated workspace file (contains which files were open etc.)
*.vbw

# Visual Studio LightSwitch build output
**/*.HTMLClient/GeneratedArtifacts
**/*.DesktopClient/GeneratedArtifacts
**/*.DesktopClient/ModelManifest.xml
**/*.Server/GeneratedArtifacts
**/*.Server/ModelManifest.xml
_Pvt_Extensions

# Paket dependency manager
.paket/paket.exe
paket-files/

# FAKE - F# Make
.fake/

# CodeRush personal settings
.cr/personal

# Python Tools for Visual Studio (PTVS)
__pycache__/
*.pyc

# Cake - Uncomment if you are using it
# tools/**
# !tools/packages.config

# Tabs Studio
*.tss

# Telerik's JustMock configuration file
*.jmconfig

# BizTalk build output
*.btp.cs
*.btm.cs
*.odx.cs
*.xsd.cs

# OpenCover UI analysis results
OpenCover/

# Azure Stream Analytics local run output
ASALocalRun/

# MSBuild Binary and Structured Log
*.binlog

# NVidia Nsight GPU debugger configuration file
*.nvuser

# MFractors (Xamarin productivity tool) working folder
.mfractor/

# Local History for Visual Studio
.localhistory/

# BeatPulse healthcheck temp database
healthchecksdb

# Backup folder for Package Reference Convert tool in Visual Studio 2017
MigrationBackup/

# Ionide (cross platform F# VS Code tools) working folder
.ionide/

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

## Ignore Visual Studio temporary files, build results, and

## files generated by popular Visual Studio add-ons.

## Get latest from https://github.com/github/gitignore/blob/master/VisualStudio.gitignore

# User-specific files

*.rsuser

*.suo

*.user

*.userosscache

*.sln.docstates

# User-specific files (MonoDevelop/Xamarin Studio)

*.userprefs

# Mono auto generated files

mono_crash.*

# Build results

[Dd]ebug/

[Dd]ebugPublic/

[Rr]elease/

[Rr]eleases/

x64/

x86/

[Ww][Ii][Nn]32/

[Aa][Rr][Mm]/

[Aa][Rr][Mm]64/

bld/

[Bb]in/

#[Oo]bj/

[Ll]og/

[Ll]ogs/

#SSIS

!**/[Oo]bj/**/*.*

**/[Oo]bj/**/*.*

!**/[Oo]bj/**/*.dtsx

!**/[Oo]bj/**/*.conmgr

# Visual Studio 2015/2017 cache/options directory

.vs/

# Uncomment if you have tasks that create the project's static files in wwwroot

#wwwroot/

# Visual Studio 2017 auto generated files

Generated\ Files/

# MSTest test Results

[Tt]est[Rr]esult*/

[Bb]uild[Ll]og.*

# NUnit

*.VisualState.xml

TestResult.xml

nunit-*.xml

# Build Results of an ATL Project

[Dd]ebugPS/

[Rr]eleasePS/

dlldata.c

# Benchmark Results

BenchmarkDotNet.Artifacts/

# .NET Core

project.lock.json

project.fragment.lock.json

artifacts/

# ASP.NET Scaffolding

ScaffoldingReadMe.txt

# StyleCop

StyleCopReport.xml

# Files built by Visual Studio

*_i.c

*_p.c

*_h.h

*.ilk

*.meta

*.obj

*.iobj

*.pch

*.pdb

*.ipdb

*.pgc

*.pgd

*.rsp

*.sbr

*.tlb

*.tli

*.tlh

*.tmp

*.tmp_proj

*_wpftmp.csproj

*.log

*.vspscc

*.vssscc

.builds

*.pidb

*.svclog

*.scc

# Chutzpah Test files

_Chutzpah*

# Visual C++ cache files

ipch/

*.aps

*.ncb

*.opendb

*.opensdf

*.sdf

*.cachefile

*.VC.db

*.VC.VC.opendb

# Visual Studio profiler

*.psess

*.vsp

*.vspx

*.sap

# Visual Studio Trace Files

*.e2e

# TFS 2012 Local Workspace

$tf/

# Guidance Automation Toolkit

*.gpState

# ReSharper is a .NET coding add-in

_ReSharper*/

*.[Rr]e[Ss]harper

*.DotSettings.user

# TeamCity is a build add-in

_TeamCity*

# DotCover is a Code Coverage Tool

*.dotCover

# AxoCover is a Code Coverage Tool

.axoCover/*

!.axoCover/settings.json

# Coverlet is a free, cross platform Code Coverage Tool

coverage*[.json, .xml, .info]

# Visual Studio code coverage results

*.coverage

*.coveragexml

# NCrunch

_NCrunch_*

.*crunch*.local.xml

nCrunchTemp_*

# MightyMoose

*.mm.*

AutoTest.Net/

# Web workbench (sass)

.sass-cache/

# Installshield output folder

[Ee]xpress/

# DocProject is a documentation generator add-in

DocProject/buildhelp/

DocProject/Help/*.HxT

DocProject/Help/*.HxC

DocProject/Help/*.hhc

DocProject/Help/*.hhk

DocProject/Help/*.hhp

DocProject/Help/Html2

DocProject/Help/html

# Click-Once directory

publish/

# Publish Web Output

*.[Pp]ublish.xml

*.azurePubxml

# Note: Comment the next line if you want to checkin your web deploy settings,

# but database connection strings (with potential passwords) will be unencrypted

*.pubxml

*.publishproj

# Microsoft Azure Web App publish settings. Comment the next line if you want to

# checkin your Azure Web App publish settings, but sensitive information contained

# in these scripts will be unencrypted

PublishScripts/

# NuGet Packages

*.nupkg

# NuGet Symbol Packages

*.snupkg

# The packages folder can be ignored because of Package Restore

**/[Pp]ackages/*

# except build/, which is used as an MSBuild target.

!**/[Pp]ackages/build/

# Uncomment if necessary however generally it will be regenerated when needed

#!**/[Pp]ackages/repositories.config

# NuGet v3's project.json files produces more ignorable files

*.nuget.props

*.nuget.targets

# Microsoft Azure Build Output

csx/

*.build.csdef

# Microsoft Azure Emulator

ecf/

rcf/

# Windows Store app package directories and files

AppPackages/

BundleArtifacts/

Package.StoreAssociation.xml

_pkginfo.txt

*.appx

*.appxbundle

*.appxupload

# Visual Studio cache files

# files ending in .cache can be ignored

*.[Cc]ache

# but keep track of directories ending in .cache

!?*.[Cc]ache/

# Others

ClientBin/

~$*

*.dbmdl

*.dbproj.schemaview

*.jfm

*.pfx

*.publishsettings

orleans.codegen.cs

# Including strong name files can present a security risk

# (https://github.com/github/gitignore/pull/2483#issue-259490424)

#*.snk

# Since there are multiple workflows, uncomment next line to ignore bower_components

# (https://github.com/github/gitignore/pull/1529#issuecomment-104372622)

#bower_components/

# RIA/Silverlight projects

Generated_Code/

# Backup & report files from converting an old project file

# to a newer Visual Studio version. Backup files are not needed,

# because we have git ;-)

_UpgradeReport_Files/

Backup*/

UpgradeLog*.XML

UpgradeLog*.htm

ServiceFabricBackup/

*.rptproj.bak

# SQL Server files

*.mdf

*.ldf

*.ndf

# Business Intelligence projects

*.rdl.data

*.bim.layout

*.bim_*.settings

*.rptproj.rsuser

*- [Bb]ackup.rdl

*- [Bb]ackup ([0-9]).rdl

*- [Bb]ackup ([0-9][0-9]).rdl

# Microsoft Fakes

FakesAssemblies/

# GhostDoc plugin setting file

*.GhostDoc.xml

# Node.js Tools for Visual Studio

.ntvs_analysis.dat

node_modules/

# Visual Studio 6 build log

*.plg

# Visual Studio 6 workspace options file

*.opt

# Visual Studio 6 auto-generated workspace file (contains which files were open etc.)

*.vbw

# Visual Studio LightSwitch build output

**/*.HTMLClient/GeneratedArtifacts

**/*.DesktopClient/GeneratedArtifacts

**/*.DesktopClient/ModelManifest.xml

**/*.Server/GeneratedArtifacts

**/*.Server/ModelManifest.xml

_Pvt_Extensions

# Paket dependency manager

.paket/paket.exe

paket-files/

# FAKE - F# Make

.fake/

# CodeRush personal settings

.cr/personal

# Python Tools for Visual Studio (PTVS)

__pycache__/

*.pyc

# Cake - Uncomment if you are using it

# tools/**

# !tools/packages.config

# Tabs Studio

*.tss

# Telerik's JustMock configuration file

*.jmconfig

# BizTalk build output

*.btp.cs

*.btm.cs

*.odx.cs

*.xsd.cs

# OpenCover UI analysis results

OpenCover/

# Azure Stream Analytics local run output

ASALocalRun/

# MSBuild Binary and Structured Log

*.binlog

# NVidia Nsight GPU debugger configuration file

*.nvuser

# MFractors (Xamarin productivity tool) working folder

.mfractor/

# Local History for Visual Studio

.localhistory/

# BeatPulse healthcheck temp database

healthchecksdb

# Backup folder for Package Reference Convert tool in Visual Studio 2017

MigrationBackup/

# Ionide (cross platform F# VS Code tools) working folder

.ionide/

Posted on 30. März 2020 by Andreas in Allgemein

Step 1: Gitea installieren

Chocolaty ist eine Windows Umgebung um Anwendungen über Kommandozeile zu installieren: https://chocolatey.org/install GO installieren https://golang.org/dl/ cmd öffnen und echo %GOPATH% eingeben. Wenn als Ergebnis wieder %GOPATH% steht, Windows neustarten und nochmal prüfen. Andernfalls unter Systemsteurung -> System -> Erweitert -> Umgebungsvariablen die GOPATH Variable setzen cmd als Admin starten und folgende Befehle eingeben:

#Git installieren bei Abfrage mit A und Enter bestätigen
choco install git

#NodeJs installieren 
choco install nodejs 

#Make installieren 
choco install make

#Cmd Neustarten um Umgebungsvariablen zu laden
refreshenv

#Neuste Version updaten
git clone https://github.com/git/git

#Go Verzeichnis erstellen
mkdir %GOPATH%

#Zu Go Verzeichnis navigieren
cd %GOPATH%

#Gitea herunterladen
go get -d -u code.gitea.io/gitea

#Gitea Verzeichnis navigieren
cd "%GOPATH%/src/code.gitea.io/gitea"

#Gitea builden
go build

#Gitea Verzeichnis zu c:\gitea kopieren
xcopy "%GOPATH%/src/code.gitea.io/gitea" "C:\gitea\" /s/h/e/k/f/c

#app.ini kopieren mit F und Enter File bestätigen
xcopy "C:\gitea\custom\conf\app.ini.sample" "C:\gitea\custom\conf\app.ini"

#Computernamen ausgeben
echo %COMPUTERNAME%

#Zeile 11 in der app.ini bearbeiten ($ am Ende nicht vergessen): RUN_USER = MEIN_COMPUTERNAME$

#Git installieren bei Abfrage mit A und Enter bestätigen

choco install git

#NodeJs installieren

choco install nodejs

#Make installieren

choco install make

#Cmd Neustarten um Umgebungsvariablen zu laden

refreshenv

#Neuste Version updaten

git clone https://github.com/git/git

#Go Verzeichnis erstellen

mkdir %GOPATH%

#Zu Go Verzeichnis navigieren

cd %GOPATH%

#Gitea herunterladen

go get -d -u code.gitea.io/gitea

#Gitea Verzeichnis navigieren

cd "%GOPATH%/src/code.gitea.io/gitea"

#Gitea builden

go build

#Gitea Verzeichnis zu c:\gitea kopieren

xcopy "%GOPATH%/src/code.gitea.io/gitea" "C:\gitea\" /s/h/e/k/f/c

#app.ini kopieren mit F und Enter File bestätigen

xcopy "C:\gitea\custom\conf\app.ini.sample" "C:\gitea\custom\conf\app.ini"

#Computernamen ausgeben

echo %COMPUTERNAME%

#Zeile 11 in der app.ini bearbeiten ($ am Ende nicht vergessen): RUN_USER = MEIN_COMPUTERNAME$

[…]

Posted on 12. Februar 2020 by Andreas in Allgemein

Denn ich habe kein Gefallen am Tod dessen, der sterben muss, spricht Gott, der Herr. So kehrt denn um, und ihr sollt leben!

Author Archives: Andreas

JavaScript CSV Download – Excel + Umlaute

VueCli installieren

ASP Core 3.1 inkl VueCLI mit mehreren VueApps verwenden

Backup alle Nicht System Datenbanken

Openmediavault + Nextcloud auf Raspberry Pi installieren

ASP Core Configuration vererben

Integrations Test mit Dependency Injection MsTest v2 .Net Core 3.1

SQL CPU Last und Gesamtdauer von Query testen

.gitignore SSIS dtsx Dateien hinzufügen

Step 1: Gitea installieren

Seiten

Neueste Beiträge

Neueste Kommentare

Archive

Denn ich habe kein Gefallen am Tod dessen, der sterben muss, spricht Gott, der Herr. So kehrt denn um, und ihr sollt leben!

Author Archives: Andreas

Search this site

Seiten

Neueste Beiträge

Neueste Kommentare

Archive