erhanzeyrek

## cmd.sql

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
begin tran

while(exists(select 1 from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where TABLE_CATALOG = ''
AND TABLE_SCHEMA != 'sys' and
CONSTRAINT_TYPE='FOREIGN KEY'))
begin
 declare @sql nvarchar(2000)
 SELECT TOP 1 @sql=('ALTER TABLE [' + TABLE_SCHEMA + '].[' + TABLE_NAME

## run.sh
// Bilgisayarı Ubuntu Live CD ya da bootable USB üzerinden boot ettikten sonra terminal açılır ve aşağıdaki komutlar girilir.
// Note: sdX = disk | sdXX = efi partition | sdXY = system partition

sudo mount /dev/sdXY /mnt
sudo mount /dev/sdXX /mnt/boot/efi
for i in /dev /dev/pts /proc /sys /run; do sudo mount -B $i /mnt$i; done
sudo chroot /mnt
grub-install /dev/sdX
update-grub

## run.cmd
sqlcmd -S SERVER\INSTANCE -U 'userId' -P 'password' -d 'databaseName' -i "C:/Backup/backup.sql"

## change.cmd
git remote -v
git remote set-url origin http://my-git-server.com/my-repository.git

## apply.cmd
git rm -r --cached .
git add .
git commit -m ".gitignore is now working"

## sil.ps1
Get-ChildItem -Path "." -Include "node_modules" -Recurse -Directory | Remove-Item -Recurse -Force

## metabase_docker_migration_guide
1-) Firstly, stop running container.

docker stop metabase_container_name_or_id

2-) Copy existing H2 database files to outside container.

docker cp metabase_container_id:/metabase.db ./metabase_db_backup

3-) Copy existing jar file outside from container for migration

## sqltocsharp.sql
declare @TableName sysname = 'TABLOADI'
declare @result varchar(max) = 'public class ' + @TableName + '
{'

select @result = @result + '
    public ' + ColumnType + ' ' + ColumnName + ' { get; set; }
'
from
(
    select

## commands.txt
--Ubuntu üzerinde TeamCity agent'ı başlat

 ./home/<username>/BuildAgent/bin/agent.sh start

## jsonParser.sql
USE [DATABASE]
GO

/****** Object:  UserDefinedFunction [dbo].[parseJSON]    Script Date: 5.10.2020 14:53:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

	SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
	begin tran

	while(exists(select 1 from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where TABLE_CATALOG = ''
	AND TABLE_SCHEMA != 'sys' and
	CONSTRAINT_TYPE='FOREIGN KEY'))
	begin
	declare @sql nvarchar(2000)
	SELECT TOP 1 @sql=('ALTER TABLE [' + TABLE_SCHEMA + '].[' + TABLE_NAME
	// Bilgisayarı Ubuntu Live CD ya da bootable USB üzerinden boot ettikten sonra terminal açılır ve aşağıdaki komutlar girilir.
	// Note: sdX = disk \| sdXX = efi partition \| sdXY = system partition

	sudo mount /dev/sdXY /mnt
	sudo mount /dev/sdXX /mnt/boot/efi
	for i in /dev /dev/pts /proc /sys /run; do sudo mount -B $i /mnt$i; done
	sudo chroot /mnt
	grub-install /dev/sdX
	update-grub
	git remote -v
	git remote set-url origin http://my-git-server.com/my-repository.git
	git rm -r --cached .
	git add .
	git commit -m ".gitignore is now working"
	1-) Firstly, stop running container.

	docker stop metabase_container_name_or_id

	2-) Copy existing H2 database files to outside container.

	docker cp metabase_container_id:/metabase.db ./metabase_db_backup

	3-) Copy existing jar file outside from container for migration
	declare @TableName sysname = 'TABLOADI'
	declare @result varchar(max) = 'public class ' + @TableName + '
	{'

	select @result = @result + '
	public ' + ColumnType + ' ' + ColumnName + ' { get; set; }
	'
	from
	(
	select
	--Ubuntu üzerinde TeamCity agent'ı başlat

	./home/<username>/BuildAgent/bin/agent.sh start
	USE [DATABASE]
	GO

	/**** Object: UserDefinedFunction [dbo].[parseJSON] Script Date: 5.10.2020 14:53:06 ****/
	SET ANSI_NULLS ON
	GO

	SET QUOTED_IDENTIFIER ON
	GO