Open terminal.
Connect to psql:
psql -p 5433
I find it easier to delete and recreate the DB to which you want to import. So ensure the databse you want to delete is listed:
\l
SELECT todo_lists.id AS id, | |
todo_lists.name, | |
jsonb_agg(to_jsonb(todo_items) - 'todo_list_id') AS items | |
FROM todo_lists | |
LEFT JOIN todo_items ON todo_items.todo_list_id = todo_lists.id | |
GROUP BY todo_lists.id; |
<?php | |
/** | |
* Plugin Name: WooCommerce Settings Tab Demo | |
* Plugin URI: https://gist.github.com/BFTrick/b5e3afa6f4f83ba2e54a | |
* Description: A plugin demonstrating how to add a WooCommerce settings tab. | |
* Author: Patrick Rauland | |
* Author URI: http://speakinginbytes.com/ | |
* Version: 1.0 | |
* | |
* This program is free software: you can redistribute it and/or modify |
// Place this with the other middleware inclusion in routes/index.js | |
keystone.pre('admin', middleware.enforcePermissions); |
Open terminal.
Connect to psql:
psql -p 5433
I find it easier to delete and recreate the DB to which you want to import. So ensure the databse you want to delete is listed:
\l
<?php | |
// android store | |
if (preg_match('#android#i', $_SERVER ['HTTP_USER_AGENT'])) { | |
header('Location: market://details?id=com.google.android.apps.maps'); | |
exit; | |
} | |
// ios | |
if (preg_match('#(iPad|iPhone|iPod)#i', $_SERVER ['HTTP_USER_AGENT'])) { |
#! /bin/bash | |
# Replace "/path/to/gsutil/" with the path of your gsutil installation. | |
PATH="$PATH":/path/to/gsutil/ | |
# Replace "/home/username/" with the path of your home directory in Linux/Mac. | |
# The ".boto" file contains the settings that helps you connect to Google Cloud Storage. | |
export BOTO_CONFIG="/home/username/.boto" | |
# A simple gsutil command that returns a list of files/folders in your bucket. |
function atz_split_content_at_more(){ | |
// Split the content | |
$content_parts = preg_split('/<span id="more-\d+"><\/span>/i', get_the_content()); | |
// Grab first part of content and apply filters | |
$result['intro'] = apply_filters('the_content', array_shift($content_parts));; | |
// Content has a more part? | |
if(!empty($content_parts)): | |
$result['more'] = apply_filters('the_content', implode($content_parts)); |
<?xml version="1.0" encoding="UTF-8"?> | |
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> | |
<plist version="1.0"> | |
<dict> | |
<key>name</key> | |
<string>Xcode-ish</string> | |
<key>settings</key> | |
<array> | |
<dict> | |
<key>settings</key> |