marcometz

parent_article = Goldencobra::Article.create!(url_name: "cities", breadcrumb: "cities", title: "cities", article_type: "City Index")

inactive_cities = City.where(article_id: nil)

inactive_cities.each do |city|
  city_article = Goldencobra::Article.new(teaser: city.title, content: "", breadcrumb: city.title, title: city.title, article_type: "City Show", parent_id: parent_article.id)
  city_article.city = city
  city_article.save
end

marcometz

Increasing the amount of inotify watchers

If you are running Debian, RedHat, or another similar Linux distribution, run the following in a terminal:

$ echo fs.inotify.max_user_watches=524288 >> /etc/sysctl.conf
$ sysctl -p

marcometz

{
  // Verwendet IntelliSense zum Ermitteln möglicher Attribute.
  // Zeigen Sie auf vorhandene Attribute, um die zugehörigen Beschreibungen anzuzeigen.
  // Weitere Informationen finden Sie unter https://go.microsoft.com/fwlink/?linkid=830387
  //
  // https://github.com/microsoft/vscode-recipes/tree/master/debugging-Ruby-on-Rails
  "version": "0.2.0",
  "configurations": [
    {
      "name": "Rails server",

marcometz

DOMAIN=docker.localhost
PRODUCTION_DOMAIN=foo.bar.de
APP=appname-api
REGISTRY_URL=registry.foo.bar.de/tpwd/appname-api
NODE_ENV=development

marcometz

cap production deploy
cap production maintenance:enable
cap production unicorn:stop
cap production unicorn:stop
cap production unicorn:start
cap production maintenance:disable

cap staging deploy
cap staging maintenance:enable
cap staging unicorn:stop

marcometz

traefik.frontend.auth.basic.users:

echo $(htpasswd -nbB username "passwort") | sed -e s/\\$/\\$\\$/g

marcometz

# www.quirinprivatbank.de => localhost:3000
UPDATE goldencobra_article_urls SET url = REPLACE(url, "https://www.quirinprivatbank.de", "http://localhost:3000");

# www.quirinprivatbank.de => staging.quirincloud.dev-ikusei.de
UPDATE goldencobra_article_urls SET url = REPLACE(url, "https://www.quirinprivatbank.de", "https://staging.quirincloud.dev-ikusei.de");

marcometz

Goldencobra::Article.where("content LIKE '%http://%' OR teaser LIKE '%http://%' OR summary LIKE '%http://%' OR context_info LIKE '%http://%'").pluck(:id)
=> [3, 5, 7, 145, 146, 148, 149, 150, 152, 153, 155, 157, 158, 159, 160, 161, 162, 165, 172, 173, 232, 236]

Goldencobra::Widget.where("content LIKE '%http://%' OR mobile_content LIKE '%http://%' OR teaser LIKE '%http://%'").pluck(:id)
=> [5]

Goldencobra::Setting.where("value LIKE '%http://%'").pluck(:id)
=> [154, 158, 236]

GoldencobraEvents::EventPricegroup.where("description LIKE '%http://%' OR email_text LIKE '%http://%'").pluck(:id)

marcometz

CREATE TABLE `versions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` varchar(255) NOT NULL,
  `item_id` int(11) NOT NULL,
  `event` varchar(255) NOT NULL,
  `whodunnit` varchar(255) DEFAULT NULL,
  `object` text,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_versions_on_item_type_and_item_id` (`item_type`,`item_id`)

marcometz

#! /bin/bash

### BEGIN INIT INFO
# Provides:          unicorn
# Required-Start:    $local_fs $remote_fs $network $syslog
# Required-Stop:     $local_fs $remote_fs $network $syslog
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: starts the unicorn web server
# Description:       starts unicorn