ProcedureParamListR # DB StoreProc param list sqlFile <- "SQL/DB-Procedure_listParams.sql" storedProcParamDataFrame <- SqlResultToDataFrame(simmqODBC, GetSqlFromFile(sqlFile)) DataFrameToCsv(storedProcParamDataFrame, SqlFileToCsv(sqlFile, dbInstance)) storedProcParamDataFrameSlim <- DataFrameFromColumns(storedProcParamDataFrame, "ProcedureName", "ProcedureType", "ProcedureDesc") # DB StoreProc repeat count storedProcParamDataFrameFat <- aggregate(list(NbParameters = rep(1, nrow(storedProcParamDataFrameSlim))), storedProcParamDataFrameSlim, length) write(summary(rev(storedProcParamDataFrameFat)), stdout()) # DB StoreProc with params countStoreProcWith <- nrow(storedProcParamDataFrameFat) # DB StoreProc without params countStoreProcWithout <- countStoreProc - countStoreProcWith # DB StoreProc data frame params storeProcParamsDF <- DataFrameWithoutWithTotal(countStoreProcWithout, countStoreProcWith, countStoreProc, "StoreProc") # DB StoreProc param list export DataFrameToCsv(storeProcParamsDF, SqlFileToCsv(sqlFile, dbInstance, "-Procs_Specs")) # DB StoreProc barplot StoredProcWithoutWithTotalDFToBarplot(storeProcParamsDF, SqlFileToPng(sqlFile, dbInstance, "-Procs_Barplot"), "StoredProc") # DB StoreProc boxplot DBStoreProcDataFrameToBoxplot(storedProcParamDataFrameFat, SqlFileToPng(sqlFile, dbInstance, "-Procs_Boxplot")) # DB StoreProc density plot DBStoreProcDataFrameToDensityplot(storedProcParamDataFrameFat, SqlFileToPng(sqlFile, dbInstance, "-Procs_Densityplot")) ĭBRowCountR # DB Table Count # DB Table Count DROP sqlQuery(simmqODBC, "IF OBJECT_ID(N'#counts', N'U') IS NOT NULL DROP TABLE #counts ") # DB TABLE Count CREATE sqlQuery(simmqODBC, "CREATE TABLE #counts (TableName VARCHAR(255), TableRows INT) ") # DB Table Count EXEC sqlQuery(simmqODBC, "EXEC sp_MSForEachTable #counts (TableName, TableRows) SELECT ''?'', COUNT(*) FROM ?' ") # DB Table Count CSV sqlFile mean repeats aMean aMean) DBRowCountFrameToBarplot(tableRowCountDataFrame, SqlFileToPng(sqlFile, dbInstance, "_Barplot")) # DB Table Count DROP sqlQuery(simmqODBC, "DROP TABLE #counts ") Debian coming soon.Microsoft Open for Revolution R Enterprise a.k.a. LimitationsĬurrently, only supports RedHat/CentOS.
PERFORCE VISUAL CLIENT DOWNLOAD 2015.2 PASSWORD
Do not change the gitswarm user's password without consulting the GitSwarm documentation! Bad things may happen if you do. HINT: If you don't log in before the ticket expires (12h), then you can find the generated password in the /etc/gitswarm/gitswarm.rb file. p4 -p ssl::1666 -u gitswarm configure show
Note that security is configured to be level 3, so strong passwords are required.
So you should use that account to set the password for the root account in p4d: p4 -p ssl::1666 -u gitswarm passwd root User gitswarm ticket expires in 4 hours 8 minutes.Īnd that user is a superuser Protections: The gitswarm user has an existing ticket p4 -p ssl::1666 -u gitswarm login -s Unknown_git (Unknown Git Contributor) accessed 6 There are several Perforce user accounts that are created initially in the instance: $ p4 -p ssl::1666 -u gitswarm users Server root: /var/opt/gitswarm/perforce/data
Logged into the instance, you can run p4 info to get more information: $ p4 -p ssl::1666 info
The installation creates a P4D instance running on ssl::1666. Once logged in, you can create projects, new users, groups, etc. When you log in, you will be asked to change that password to something that isn't on a README page on GitHub. The installation will create an administrative account in GitSwarm called root with the password 5iveL!fe.