conda env create -f devenv.yaml

name: myname
channels:
  - conda-forge
  - bioconda
dependencies:
  # Package creation and environment management
  - conda-build
  # Automation control (command line interface, workflow and multi-process management)
  - python-dotenv
  - click
  - snakemake-minimal
  - joblib
  - numba
  # Workspace
  - notebook
  # Visualization
  - plotly
  - plotly-orca
  - matplotlib
  - seaborn
  - shap
  - openpyxl
  - ipywidgets
  - tensorboard
  # Data manipulation
  - numpy
  - pandas
  - pyarrow
  # Functional style tools
  - more-itertools
  - toolz
  # Machine learning
  - scikit-learn
  - imbalanced-learn
  - scikit-image
  - statsmodels
  - catboost
  - hyperopt
  - tsfresh
  # Deep learning
  - pytorch
  # code checking and formatting
  - pylint
  - black
  - flake8
  - mypy
  # Python base
  - python
  - pip
  - pip:

mysqldump -u root -ppass kodi_video119 | mysql -h192.168.178.73 -u kodi -ppass kodi_video119

mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
'RROR 1102 (42000): Incorrect database name 'kodi_video119
mysqldump: Got errno 11 on write

#!/bin/bash
for db in $(hive -e "show databases like 'the_same_databasename_*;") 
do
   tbl_count=$(hive -S -e "use $db; show tables;" | wc -l)
   echo "Database $db contains $tbl_count tables."
  
done    

Failed to compile
src/index.js
  Line 25:1:   'firebase' is not defined  no-undef
  Line 28:16:  'firebase' is not defined  no-undef

Search for the keywords to learn more about each error.
This error occurred during the build time and cannot be dismissed.

{
  "name": "my-app",
  "version": "0.1.0",
  "private": true,
  "dependencies": {
    "@material-ui/core": "^4.12.2",
    "@testing-library/jest-dom": "^5.14.1",
    "@testing-library/react": "^11.2.7",
    "@testing-library/user-event": "^12.8.3",
    "firebase": "^9.0.0",
    "react": "^17.0.2",
    "react-dom": "^17.0.2",
    "react-router-config": "^5.1.1",
    "react-router-dom": "^5.2.0",
    "react-scripts": "4.0.3",
    "web-vitals": "^1.1.2"
  },
  "scripts": {
    "start": "react-scripts start",
    "build": "react-scripts build",
    "test": "react-scripts test",
    "eject": "react-scripts eject"
  },
  "eslintConfig": {
    "extends": [
      "react-app",
      "react-app/jest"
    ]
  },
  "browserslist": {
    "production": [
      ">0.2%",
      "not dead",
      "not op_mini all"
    ],
    "development": [
      "last 1 chrome version",
      "last 1 firefox version",
      "last 1 safari version"
    ]
  }
}

import React from 'react';
import ReactDOM from 'react-dom';
//import './index.css';
//import App from './App';
//import reportWebVitals from './reportWebVitals';
// Import the functions you need from the SDKs you need
import { initializeApp } from "firebase/app";
import { getAnalytics } from "firebase/analytics";
// TODO: Add SDKs for Firebase products that you want to use
// https://firebase.google.com/docs/web/setup#available-libraries

// Your web app's Firebase configuration
// For Firebase JS SDK v7.20.0 and later, measurementId is optional
const config = {
  apiKey: "AIzaSyBk5lf0WtiZPs1ZQkA48OfXpzW7P_RCrZk",
  authDomain: "test-c2ec9.firebaseapp.com",
  projectId: "test-c2ec9",
  storageBucket: "test-c2ec9.appspot.com",
  messagingSenderId: "11138018851",
  appId: "1:11138018851:web:ecfb63337ca11f62028b96",
  measurementId: "G-3S1M3601YR"
};

// Initialize Firebase
firebase.initializeApp(config);

// Get a reference to the database service
var database = firebase.database();
const app = initializeApp(config);
const analytics = getAnalytics(app);

ReactDOM.render(
  
  ,
  document.getElementById('root')
);

// If you want to start measuring performance in your app, pass a function
// to log results (for example: reportWebVitals(console.log))
// or send to an analytics endpoint. 
//reportWebVitals();

  
    
    
    Welcome to Firebase Hosting

    
    
    
    
    
    
    
    
    
    
    
    
    
    

    
  
  
    
      Welcome
      Firebase Hosting Setup Complete
      
You're seeing this because you've successfully setup Firebase Hosting. Now it's time to go build something extraordinary!
      Open Hosting Documentation
    
    
Firebase SDK Loading…

    
    
    

    
    
    
    
  

  
    
    
    
    
    
    
    
    
    
    React App
  
  
    You need to enable JavaScript to run this app.
    
    
    
    

    
    
    
    
  

int parse_cmd(char* tokens[], process_t* commands) {
    assert(tokens!=NULL);
    assert(commands!=NULL);
    
    int position = 0;
    int commandNumber = 0;
        
    for(int i=0; tokens[i] != NULL; i++){
        if(is_reserved(tokens[i]) == 0 && tokens[i+1] != NULL) continue;
        int end = is_reserved(tokens[i]) == 0 ? i+1 : i;
        int argc = position;
        int count = 0;
        
        process_t newProcess;

        char* argv[MAX_CMD_SIZE] = {NULL};
        for(argc; argc < end; argc++) {
            argv[count] = tokens[argc];
            count = count + 1;
        }
        newProcess.path = tokens[position];
        newProcess.argv = argv;
        position = i + 1;
        commands[commandNumber] = newProcess;
        commandNumber = commandNumber + 1;
    }
}

int main(int argc, char* argv[]) {

    char path[MAX_LINE_SIZE];
    char line[MAX_LINE_SIZE];
    char* cmdline[MAX_CMD_SIZE];
    process_t cmds[MAX_CMD_SIZE];

    getcwd(path, MAX_LINE_SIZE);
    while (1) {
  
        printf("mini@shell:%s$ ", path);
        scanf("%[^\n]%*c", line);
        
        trim(line);
        clean(line);
        tokenize(line, cmdline);
        
        parse_cmd(cmdline, cmds);
        toString(cmds);
        
        break;.
    }
    return -1;
}

mysql --socket=/mysql/socket -u root -p"$pass"

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '//mysql/socket' (2)

$ mysql --socket=socket -u root -p'random-init-pass'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.18

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

source //bash
module load 

SQLDIR="/"
cd $SQLDIR

# Kill the existing MySQL server (for testing purposes as I'm re-running this script multiple times)
# Do so by locating its process ID and terminating that ID, waiting until it's killed before proceeding.
ps -aux | grep mysql | grep -v grep
mysqlps=`ps -aux | grep mysql | grep -v grep | sed -e 's/ \{2,\}/ /g' | cut -f2 -d' '`

if [[ -n $mysqlps ]]; then
    kill $mysqlps
    while kill -0 $mysqlps; do
        sleep 0.5
    done
    echo "MySQL process successfully killed. Status $?"
else
    echo "No MySQL process to kill. Status $?"
fi
rm -rf $SQLDIR/mysql

# Set up MySQL server directory
mkdir -p $SQLDIR/mysql
pushd $SQLDIR/mysql

# Copy setup files stored in $SQLDIR in order to install MySQL
# The my.cnf config file contains the string "$USER" which should be replaced with a Unix username.
cat $SQLDIR/setup_files/my.cnf | awk -v user=`whoami` '{ sub(/\$USER/, user); print }' > my.cnf
cp -t . $SQLDIR/setup_files/loadmodules.bash $SQLDIR/setup_files/mysql_*
chmod +x mysql_*

# Load modules necessary to run the server
source loadmodules.bash

# Initialise MySQL server, kill the script if this step fails.
# NB thanks to Raman Sailopal for helping me with this bit: https://stackoverflow.com/questions/69406526/start-a-mysql-server-pipe-the-output-to-a-file
./mysql_init.sh 2>&1 | tee mysql_init.log
init_status=${PIPESTATUS[0]} 
if [[ $init_status -ne 0 ]]; then
    echo "Init script failed - kill script"
    return 1
fi

# Grab the setup password from the log produced by mysql_init.sh. Copy into variable.
line=`tail -n1 mysql_init.log`
pass="${line##* }"

# Launch MySQL server now that it's been initialised
./mysql_start.sh

# Create a .my.cnf config file in the user's home area, set to user-access only
user=`whoami`
cat << EOT > ~/.my.cnf
[mysqld]

user=$user
password=$pass
socket=$SQLDIR/mysql/socket
EOT

chmod 700 ~/.my.cnf

# Fire up the MySQL server command line
# THIS IS THE BIT THAT DOESN'T WORK
mysql --socket=$SQLDIR/mysql/socket -u root -p"$pass"

[mysqld]
 
user=lou-unix-username
socket=socket

#! /bin/sh
  
export MYSQL_HOME=$PWD
  
# Change lc-messages-dir if running on RHE6 host

mysqld \
--defaults-file=$MYSQL_HOME/my.cnf \
--lc-messages-dir="//mysql/5.7.18/rhe7-x86_64/share/english/" \
--datadir=$MYSQL_HOME/data \
--basedir=$MYSQL_HOME \
--pid-file=$MYSQL_HOME/mysql.pid \
--socket=$MYSQL_HOME/socket \
--port=3307 \
--initialize

#! /bin/sh
echo $DATADIR
export MYSQL_HOME=$PWD
  
mysqld \
--defaults-file=$MYSQL_HOME/my.cnf \
--log-error \
--lc-messages-dir="//mysql/5.7.18/rhe7-x86_64/share/english/" \
--datadir=$MYSQL_HOME/data \
--basedir=$MYSQL_HOME \
--pid-file=$MYSQL_HOME/mysql.pid \
--socket=$MYSQL_HOME/socket \
--port=3307 &

[mysqld]

user=lou-unix-username
password=random-init-password
socket=//mysql/socket

import click

@click.group()
def cli():
    pass

@click.command()
@click.argument('id')
def outer(id):
    print('outer id',id,type(id))
    inner(id)  # run inner() from within outer(), pass argument unchanged

@click.command()       # *
@click.argument('id')  # *
def inner(id):
    print('inner id',id,type(id))

cli.add_command(outer)
cli.add_command(inner)  # *

if __name__ == '__main__':
    cli()

% python3 test.py inner 123
inner id 123 
% python3 test.py outer 123
outer id 123 
Usage: test.py [OPTIONS] ID
Try 'test.py --help' for help.

Error: Got unexpected extra arguments (2 3)
%

% python3 test.py outer 1
outer id 1 
inner id 1 
%

% python3 test.py outer 123
outer id 123 
inner id 123 
%