erhanzeyrek

// JS array equivalents to C# LINQ methods - by Dan B.

// Here's a simple array of "person" objects
var people = [ 
	{ name: "John", age: 20 }, 
	{ name: "Mary", age: 35 }, 
	{ name: "Arthur", age: 78 }, 
	{ name: "Mike", age: 27 }, 
	{ name: "Judy", age: 42 }, 
	{ name: "Tim", age: 8 } 

erhanzeyrek

USE [TIGER_DB]
GO

/****** Object:  StoredProcedure [dbo].[CARI_HESAP_EKSTRE]    Script Date: 1.10.2020 16:21:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

erhanzeyrek

DECLARE @VAR1 NVARCHAR(255)
DECLARE @VAR2 NVARCHAR(255)

DECLARE MYCURSOR CURSOR FOR
SELECT COL1, COL2 FROM MYTABLE

OPEN MYCURSOR

FETCH NEXT FROM MYCURSOR INTO @VAR1, @VAR2

erhanzeyrek

USE EBA

DELETE FROM OSPROPERTYVALUES WHERE ID LIKE '%johndoe%'

DELETE FROM OSUSERS WHERE ID LIKE '%johndoe%'

DELETE FROM COMPANYOBJECTS WHERE ID LIKE '%johndoe%' 

DELETE FROM GRIDLAYOUTSETTINGS WHERE USERID LIKE '%johndoe%' 

erhanzeyrek

USE DBNAME

/* Reto Egeter, fullparam.wordpress.com */

DECLARE @SearchStrTableName nvarchar(255), @SearchStrColumnName nvarchar(255), @SearchStrColumnValue nvarchar(255), @SearchStrInXML bit, @FullRowResult bit, @FullRowResultRows int
SET @SearchStrColumnValue = '%searchValue%' /* use LIKE syntax */
SET @FullRowResult = 1
SET @FullRowResultRows = 3
SET @SearchStrTableName = NULL /* NULL for all tables, uses LIKE syntax */
SET @SearchStrColumnName = NULL /* NULL for all columns, uses LIKE syntax */

erhanzeyrek

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

erhanzeyrek

--Ubuntu üzerinde TeamCity agent'ı başlat

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

erhanzeyrek

declare @TableName sysname = 'TABLOADI'
declare @result varchar(max) = 'public class ' + @TableName + '
{'
 
select @result = @result + '
    public ' + ColumnType + ' ' + ColumnName + ' { get; set; }
'
from
(
    select

erhanzeyrek

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

erhanzeyrek

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