yucer-elbt

import logging

from sqlalchemy.sql import text


_logger = logging.getLogger(__name__)


class ArchivableMixin:
    """Model which can be duplicated via one special materialized view"""

yucer-elbt

WITH CTE AS (
    SELECT
      concat(
        substr('20220416T070044.243Z', 1, 4), '-',
        substr('20220416T070044.243Z', 5, 2), '-',
        substr('20220416T070044.243Z', 7, 2), 'T',
        substr('20220416T070044.243Z', 10, 2), ':',
        substr('20220416T070044.243Z', 12, 2), ':',
        substr('20220416T070044.243Z', 14)
      ) as ts

yucer-elbt

---
AWSTemplateFormatVersion: 2010-09-09
Description: A basic CloudFormation template for an RDS Aurora cluster.
Parameters:
    DatabaseInstanceType:
        Default: db.r3.large
        AllowedValues:
            - db.r3.large
            - db.r3.xlarge
            - db.r3.2xlarge

yucer-elbt

WITH
  HEADER_ROWS AS (
   SELECT
     col0 key
   , col1 value
   , "$path" file
   FROM
     "database"."orders"
   WHERE (NOT (col0 LIKE 'PID_%'))
) 

yucer-elbt

select format_datetime(current_timestamp, 'YYYY-MM-dd''T''HH:mm''Z''')