Skip to content

Instantly share code, notes, and snippets.

View ainsofs's full-sized avatar

Ainsof So'o ainsofs

View GitHub Profile
@ainsofs
ainsofs / table-size.sql
Created July 26, 2022 21:13
Get table sizes on Ms SQL
-- DROP TABLE #tmpTableSizes
CREATE TABLE #tmpTableSizes
(
tableName varchar(100),
numberofRows varchar(100),
reservedSize varchar(50),
dataSize varchar(50),
indexSize varchar(50),
unusedSize varchar(50)
)
@ainsofs
ainsofs / boilerplate.vue3
Last active June 23, 2022 05:49
Vue3 Component template and snippet for vscode
<template>
<div>
<!--start-here-->
</div>
</template>
<script setup>
import { ref, computed } from 'vue'
// props and emits
const props = defineProps(['someProp'])
@ainsofs
ainsofs / settings.local.php
Created June 19, 2022 20:59
Redirect script that can be used in wodby environment
# redirect from multiple domains to your primary domain
if (isset($_SERVER['WODBY_ENVIRONMENT_TYPE']) && $_SERVER['WODBY_ENVIRONMENT_TYPE'] == 'prod' && php_sapi_name() != "cli") {
$redirect_from = array(
'oldsite.com',
'alternative-spelling.com',
);
if (in_array($_SERVER['HTTP_HOST'], $redirect_from)) {
header('HTTP/1.0 301 Moved Permanently');
header('Location: https://primary-domain.com');
# show all pods
kubectl get pods --all-namespaces
# get pod info
kubectl -n {uuid} describe pods {container_name}
# delete pod
kubectl -n {uuid} delete pods -lname={container_name}
# view pod log
@ainsofs
ainsofs / mount.sh
Last active February 10, 2021 22:23
mount / unmount volumes in linux
# list volumes
sudo fdisk -l
# create a mount location
mkdir -p /mnt/some-vol
# mount
mount /dev/xvdf /mnt/some-vol
# unmount
@ainsofs
ainsofs / add_https.bat
Last active November 24, 2020 21:51
Use this snippet to add https to an IIS7 site
appcmd set site /site.name:"<IISSiteName>" /+bindings.[protocol='https',bindingInformation='*:443:<hostHeaderValue>']
# https://www.sslshopper.com/article-ssl-host-headers-in-iis-7.html
@ainsofs
ainsofs / template.yml
Created September 16, 2020 04:07
custom wodby stack - IPT
metadata:
type: drupal8
infrastructure: ^5.1
services:
ipt:
enabled: true
required: true
image: 'gbif/ipt:2.4.2'
ports:
- 'edge::80:8080/tcp'
@ainsofs
ainsofs / drupal console commands.txt
Created August 24, 2020 23:42
export content type using drupal console
# export content type using drupal console
drupal config:export:content:type page \
--module="demo" \
--optional-config \
--remove-uuid \
--remove-config-hash
more: https://drupalconsole.com/docs/en/commands/config-export-content-type
# rebuild permissions
drush php-eval "node_access_rebuild();"
# remove missing module
drush sql-query "DELETE FROM key_value WHERE collection='system.schema' AND name='module_name';"
# how to re-apply drupal update
drush ev "drupal_set_installed_schema_version('field_group', 8000)"
@ainsofs
ainsofs / web.config
Last active March 18, 2020 19:12
web.config redirect http to https
<!-- requires url rewrite module --->
<!-- https://docs.microsoft.com/en-us/archive/blogs/dawiese/redirect-from-http-to-https-using-the-iis-url-rewrite-module -->
<system.webServer>
<rewrite>
<rules>
<rule name="Redirect http to https" patternSyntax="Wildcard" stopProcessing="true">
<match url="*" />
<conditions>
<add input="{HTTPS}" pattern="off" />