We will be using following information throughout this article:
index_name : customersindex_type : personalcustomer will have name,age,gender,email,phone,address,city,state as fields in schema for now
| DBNAME=<database_name> | |
| TABLE=<table_name> | |
| FNAME=/path/to/output/dir/$(date +%Y.%m.%d)-$DBNAME.csv | |
| #(1)creates empty file and sets up column names using the information_schema | |
| mysql -u <username> -p<password> $DBNAME -B -e "SELECT COLUMN_NAME FROM information_schema.COLUMNS C WHERE table_name = '$TABLE';" | awk '{print $1}' | grep -iv ^COLUMN_NAME$ | sed 's/^/"/g;s/$/"/g' | tr '\n' ',' > $FNAME | |
| #(2)appends newline to mark beginning of data vs. column titles | |
| echo "" >> $FNAME |
| <?php | |
| function getAdminToken() | |
| { | |
| $url = 'https://example.com/rest/default/V1/integration/admin/token'; | |
| $data = [ | |
| "username" => "user", | |
| "password" => "user_password" | |
| ]; | |
| $data_string = json_encode($data); |
| static String timeAgoSinceDate(String dateString, {bool numericDates = true}) { | |
| DateTime date = DateTime.parse(dateString); | |
| final date2 = DateTime.now(); | |
| final difference = date2.difference(date); | |
| if ((difference.inDays / 365).floor() >= 2) { | |
| return '${(difference.inDays / 365).floor()} years ago'; | |
| } else if ((difference.inDays / 365).floor() >= 1) { | |
| return (numericDates) ? '1 year ago' : 'Last year'; | |
| } else if ((difference.inDays / 30).floor() >= 2) { |
| <template> | |
| <div> | |
| <!-- Using hide-overlay below allows for clicking while progress showing--> | |
| <v-dialog | |
| v-model="dialog" | |
| persistent | |
| :width="options.width" | |
| v-bind:style="{ zIndex: options.zIndex }" | |
| > | |
| <v-card |
| #!/bin/bash | |
| if [ -z "$1" ]; then | |
| echo "waiting for the following arguments: username + max-page-number" | |
| exit 1 | |
| else | |
| name=$1 | |
| fi | |
| if [ -z "$2" ]; then |
| #!/usr/bin/env bash | |
| # Reference: https://github.com/nagygergo/jetbrains-toolbox-install/blob/master/jetbrains-toolbox.sh | |
| # Note that we grep for linux here, if you are using this on mac/windows please see json output | |
| TOOLBOX_URL=$(curl --silent 'https://data.services.jetbrains.com//products/releases?code=TBA&latest=true&type=release' \ | |
| -H 'Origin: https://www.jetbrains.com' \ | |
| -H 'Accept-Encoding: gzip, deflate, br' \ | |
| -H 'Accept-Language: en-US,en;q=0.8' \ | |
| -H 'Accept: application/json, text/javascript, */*; q=0.01' \ | |
| -H 'Referer: https://www.jetbrains.com/toolbox/download/' \ |
| class HousePickerView extends StatelessWidget { | |
| @override | |
| Widget build(BuildContext context) { | |
| return new GradientAppBar('Houses', | |
| new ListView( | |
| children: <Widget>[ | |
| new HouseListTile(url: [ | |
| 'https://statusandphoto.weebly.com/uploads/6/0/1/5/60158603/8347592_orig.png', | |
| 'http://globalmedicalco.com/photos/globalmedicalco/20/98181.jpg', | |
| 'https://allinonetricks.com/wp-content/uploads/2017/08/5-7.png' |
| #!/bin/bash | |
| #--- Configurables ------------------------------------------ | |
| # replication delay threshold | |
| TH_SECONDS_BEHIND=5 | |
| # notifcation email (if blank, no email will be sent) | |
| EMAIL_ADDR="" | |
| #------------------------------------------------------------ |
| [Desktop Entry] | |
| Version=1.0 | |
| Type=Application | |
| Name=PhpStorm | |
| Icon=/home/themoroccan09/programs/phpstorm/bin/phpstorm.png | |
| Exec="/home/themoroccan09/programs/phpstorm/bin/phpstorm.sh" %f | |
| Comment=The Drive to Develop | |
| Categories=Development;IDE; | |
| Terminal=false | |
| StartupWMClass=jetbrains-phpstorm |