kjmph

-- Based off IETF draft, https://datatracker.ietf.org/doc/draft-peabody-dispatch-new-uuid-format/

create or replace function uuid_generate_v7()
returns uuid
as $$
begin
  -- use random v4 uuid as starting point (which has the same variant we need)
  -- then overlay timestamp
  -- then set version 7 by flipping the 2 and 1 bit in the version 4 string
  return encode(

stettix

Things I believe

This is a collection of the things I believe about software development. I have worked for years building backend and data processing systems, so read the below within that context.

Agree? Disagree? Feel free to let me know at @JanStette. See also my blog at www.janvsmachine.net.

Fundamentals

Keep it simple, stupid. You ain't gonna need it.

mattst

obskyr

# -*- coding: utf-8 -*-

import requests
from io import BytesIO, SEEK_SET, SEEK_END

class ResponseStream(object):
    def __init__(self, request_iterator):
        self._bytes = BytesIO()
        self._iterator = request_iterator

cairabbit

from sqlalchemy.orm import sessionmaker, relationship, aliased
from sqlalchemy import cast, Integer, Text, Column, ForeignKey, literal, null
from sqlalchemy.sql import column, label

class Catalog(Base):
    __tablename__ = 'catalog'
    id = Column(String, primary_key=True)
    parentid = Column(String, ForeignKey('catalog.id'))
    name = Column(String)
    parent = relationship("Catalog", remote_side=[id])

olgakogan

########## CASE IN UPDATE STATEMENT ############

from sqlalchemy import case

# single value modification (the 'else' is not mandatory)
session.query(User).update({User.status : case([(User.status == "pending", "approved")], else_=User.status)}, False)

# multiple values modification
session.query(User).update({User.status : case([(User.status == "pending", "approved"),
                                                (User.status == "waiting", "deprecated_status")])}, False)