vinijmoura

Param
(
    [string]$PAT,
    [string]$Organization,
    [string]$Connstr
)

$SQLQuery = "DELETE FROM DeploymentGroupsMachinesCapabilities"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr

vinijmoura

CREATE TABLE [dbo].[RepositoriesStargazers](
	RepositoryName			    [varchar](100) NOT NULL,
	StargazerLogin			    [varchar](100) NOT NULL,
	StargazerAvatarUrl		  [nvarchar](MAX) NOT NULL,
	StargazerCreatedDate		[datetime] NOT NULL
)

vinijmoura

Param
(
    [string]$PAT,
    [string]$UserGitHub,
    [string]$Connstr
)

Get-Date

$SQLQuery="TRUNCATE TABLE RepositoriesStargazers"

vinijmoura

CREATE TABLE [dbo].[RepositoriesForks](
	RepositoryName						[varchar](100) NOT NULL,
	ForkBy						        [varchar](100) NOT NULL,
	ForkCreatedDate						[datetime] NOT NULL
)

vinijmoura

Param
(
    [string]$PAT,
    [string]$UserGitHub,
    [string]$Connstr
)

Get-Date

$SQLQuery="TRUNCATE TABLE RepositoriesForks"

vinijmoura

CREATE TABLE [dbo].[RepositoriesBranchesAheadBehind](
	RepositoryId					[varchar](20) NOT NULL,
	RepositoryName					[varchar](100) NOT NULL,
	RepositoryBranchName				[varchar](50) NOT NULL,
	RepositoryBranchAheadCount			[int] NULL,
	RepositoryBranchBehindCount			[int] NULL,
)

vinijmoura

Param
(
    [string]$PAT,
    [string]$Organization,
    [string]$Connstr
)

$SQLQuery = "TRUNCATE TABLE RepositoriesBranchesAheadBehind"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr

vinijmoura

CREATE TABLE [dbo].[RepositoriesBranchProtectionRules](
	RepositoryId	                  [varchar](20) NOT NULL,
	RepositoryName                  [varchar](100) NOT NULL,
	RepositoryURL	                  [varchar](300) NOT NULL,
	DefaultBranch	                  [varchar](50) NOT NULL,
	RequiredSignatures              [bit] NOT NULL,
  EnforceAdmins                   [bit] NOT NULL,
  RequiredLinearHistory           [bit] NOT NULL,
  AllowForcePushes                [bit] NOT NULL,
  AllowDeletions                  [bit] NOT NULL,

vinijmoura

Param
(
    [string]$PAT,
    [string]$Organization,
    [string]$Connstr
)

$SQLQuery = "TRUNCATE TABLE RepositoriesBranchProtectionRules"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr

vinijmoura

CREATE TABLE [dbo].[Organization](
	[OrganizationId] [varchar](20) NOT NULL,
	[OrganizationName] [varchar](100) NOT NULL,
	CONSTRAINT [PK_Organization] PRIMARY KEY CLUSTERED
(
	[OrganizationId] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
)
GO