revskill10

from openpyxl import load_workbook

wb = load_workbook('template.xlsx')

# grab the active worksheet
ws = wb.active

# Data can be assigned directly to cells
ws['A2'] = 'Tom'
ws['B2'] = 30

revskill10

Docker 23 + Traefik v2.9.10 and v1.7 + Let's Encrypt + Github Registry V2 ghcr.io + Updated on 12 April 2023

Content:
- Ubuntu 22.04
- Docker Engine 23.0.3
- Docker Compose 2.17.2
- Traefik v1.7.18 with dnsChallenge
- Traefik v2.9.9 with httpChallenge
--
- Github Registry V2 ghcr.io

revskill10

import * as React from 'react'

const originalSetItem = localStorage.setItem
localStorage.setItem = function() {
  const event = new Event('storageChange')
  document.dispatchEvent(event)
  originalSetItem.apply(this, arguments)
}
const originalRemoveItem = localStorage.removeItem
localStorage.removeItem = function() {

revskill10

These are the rough steps for getting a surrealdb instance running on fly.io and connecting to it. This is heavily based off of steps posted in the surrealdb discord by rvdende. View Origional Post.

These steps work just fine for the hobby (pay as you go) plan.

HEADS UP By default this will create an instance on a single shared cpu with 256m memory. This is pretty darn small to do anything but experiment, but its free. You can scale your instance to something more useable by visiting the https://fly.io/apps/<appname>/scale. Obviously scaling to larger instances will incur higher costs, please refer to fly.io pricing

Installing fly.io client

source: fly.io docs

revskill10

class StoredProcedureService

  def self.instance
    @instance ||= StoredProcedureService.new
  end

  def execute(name, *args)
    results = []
    begin
      connection.execute("CALL #{name}(#{args.join(',')})").each(as: :hash, symbolize_keys: true) do |row|

revskill10

module ArelHelpers
  extend self

  def self.included(base)
    base.extend self
  end

  def asterisk(arel_table_or_model)
    arel_table, columns = case arel_table_or_model
                          when Arel::Table

revskill10

Ok, so I'm trying to replace a ' character with \' in a ruby string. I have working code, but it was 
*way* too painful getting there for my taste.

Take a look:

ree-1.8.7-2010.02 :001 > single_quote = "\'"
 => "'" 
ree-1.8.7-2010.02 :003 > single_quote.gsub(/'/, "\\\'")
 => "" 
ree-1.8.7-2010.02 :004 > single_quote.gsub(/'/) {|c| "\\'"}

revskill10

=begin

ref: https://gist.github.com/ahoward/5752290

web apps nearly always end up needing a plethora of little javascript helper methods: you know, auto-complete forms, populating defaults, validations, etc.  these aren't API calls properly, just little tidbits of functionality needed to make the views work.

there is always a question of which controller to hang these methods off of.  do you make a global helper controller for all this stuff?  do you hang them off the controller in question?  how to do share the backend of javascript helper methods across controllers?


step one

revskill10

module Decorator
  @@decorators = []
  def decorate(method_name,*args)
    @@decorators << [method_name.to_sym,args]
  end
  def method_added(method_name)
    super
    return if @@decorators.empty?
    decorators = @@decorators.reverse.map{|name,args| [method(name),args]}
    @@decorators = []

revskill10

require 'pdf_generator'
class TasksController < ApplicationController
  include PdfGenerator
  def some_action
    pdf_generator( download = true )
  end
end