lewiswalsh

knex(TABLE_NAME)
  .insert({ data : data })
  .onConflict(PRIMARY_KEY)
  .merge()
  .then((res) => {
    ...
  })
  .catch((err) => {
    ...
  });

lewiswalsh

<template>
  <div id="app">
    <input v-on:focus="$event.target.select()" ref="myelement" readonly v-model="mytext" />
    <button v-on:click="copyElement">Copy</button>
  </div>
</template>

<script>
export default {
  data() {

lewiswalsh

<input type="file" @change="previewFiles" ref="imagefile">

methods: {
   previewFiles(event) {
      const fileToUpload = this.$refs.imagefile.files[0];
      const formData     = new FormData();
      formData.append('fileToUpload', fileToUpload);
      this.$http.post(`url/to/upload/script`, formData)
        .then((res) => {
          ...

lewiswalsh

#!/bin/bash

BUCKETS=$(aws s3 ls)

while IFS= read -r line
do
  BUCKET=$(echo $line | cut -d " " -f3)
  SIZE=$(aws s3 ls --summarize --human-readable --request-payer --recursive s3://$BUCKET/ | grep "Total Size" | cut -d ":" -f2)
  echo "$BUCKET $SIZE"
done <<< "$BUCKETS"

lewiswalsh

SELECT CONCAT(
    'ALTER TABLE ', fks.quotedSourceTableName, ' ',
    'ADD CONSTRAINT ', fks.quotedConstraintName, ' ',
    'FOREIGN KEY (', GROUP_CONCAT(fks.quotedSourceColumnName), ') ',
    'REFERENCES ', fks.quotedTargetTableName, ' (',
        GROUP_CONCAT(fks.quotedTargetColumnName),
    ') ',
    'ON DELETE ', fks.deleteRule, ' ',
    'ON UPDATE ', fks.updateRule, ';'
)

lewiswalsh

SELECT Concat('ALTER TABLE ', table_name, ' ', 'ADD ',
              IF(non_unique = 1, CASE Upper(index_type)
                            WHEN 'FULLTEXT' THEN 'FULLTEXT INDEX'
                            WHEN 'SPATIAL' THEN 'SPATIAL INDEX'
                            ELSE Concat('INDEX ', index_name, ' USING ',
                                 index_type)
                          end, IF(Upper(index_name) = 'PRIMARY', Concat(
                               'PRIMARY KEY USING ', index_type),
                                                       Concat('UNIQUE INDEX ',
                                                       index_name, ' USING ',

lewiswalsh

backdrop-filter: blur(10px);

lewiswalsh

display: grid;
place-items: center;

lewiswalsh

cat -n <filename>

lewiswalsh

http://source.unsplash.com/random/1200x600