tva77

Codebase Analysis Prompt

You are an expert code reviewer and software architect. Analyze the provided codebase thoroughly and identify potential issues, risks, and improvement opportunities, create a report with the findings in a markdown file.

Analysis Framework

1. Code Quality & Structure

Readability: Is the code easy to understand? Are naming conventions clear and consistent?
Modularity: Is the code properly separated into logical components/modules?
Complexity: Identify overly complex functions or classes that could be simplified

Comprehensive Codebase Analysis & Documentation Prompt

You are a senior software architect and technical writer tasked with analyzing a codebase and creating comprehensive documentation from high-level overview to detailed specifications.

Analysis Approach

Please analyze the provided codebase systematically through the following lenses:

	#!/bin/bash
	# shell script to clone a wordpress installation on the same server, to another subdomain
	# Source Settings
	SOURCE_DIR="/var/www/vhosts/yourdomain.com/subdomain1.yourdomain.com/httpdocs"
	SOURCE_DB_NAME="source_db_name"
	SOURCE_DB_USER="source_db_user"
	SOURCE_DB_PASS="source_db_pass"
	SOURCE_SUBDOMAIN="subdomain1.yourdomain.com"

	# Destination Settings

	UBUNTU 22

	sudo apt-get install apt-transport-https make gcc g++ unixodbc unixodbc-dev plesk-php82-dev

	sudo curl https://packages.microsoft.com/keys/microsoft.asc \| sudo tee /etc/apt/trusted.gpg.d/microsoft.asc

	sudo curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list \| sudo tee /etc/apt/sources.list.d/mssql-release.list

	sudo apt-get update

	SSAS: Using DMV Queries to get Cube Metadata

	SSAS Dynamic Management Views (DMV’s) are very useful to query metadata of a cube. For developers, this is quite handy to provide simple documentation for the cubes they build.

	There are some excellent posts on SSAS DMVs by Yaniv Mor and Vidas Matelis

	Given below are some of the queries which I found particularly useful. A complete reference to the DMV schema rowset is available in msdn – http://msdn.microsoft.com/en-us/library/ms126079.aspx. Execute these queries from SQL Server Management Studio (SSMS) using MDX or DMX query editor.

	--All Cubes in database
	SELECT [CATALOG_NAME] AS [DATABASE];CUBE_CAPTION AS [CUBE/PERSPECTIVE];BASE_CUBE_NAME

	# add this in your /etc/postfix/main.cf

	default_destination_rate_delay = 1s
	initial_destination_concurrency = 1
	default_destination_concurrency_limit = 1
	smtpd_helo_required = yes
	smtpd_helo_restrictions = permit_mynetworks,permit_sasl_authenticated,reject_invalid_helo_hostname,reject_non_fqdn_helo_hostname,reject_unknown_helo_hostname
	relayhost = [smtp.sendgrid.net]:587
	smtp_sasl_auth_enable = yes
	smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd