marksteward

certwatch=> select id, no_of_certs_issued, name from ca where id in (select distinct ca_id from ca_trust_purpose ctp, trust_purpose tp where tp.purpose = 'EV Server Authentication' and ctp.trust_purpose_id = tp.id) order by 2 desc;
   id   | no_of_certs_issued |                                                                                                                                    name                                                                                                                                    
--------+--------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   1582 |           43052791 | C=GB, ST=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO ECC Domain Validation Secure Server CA 2
...
    797 |             970183 | C=US, ST=Arizona

marksteward

https://www.trismegistos.org/text/619
http://www.bl.uk/manuscripts/Viewer.aspx?ref=papyrus_402_f001v


writing case
2 mattresses
4 pillows
3 mats
another mat, red, for putting on a horse
sack in which corslet,

marksteward

from sqlalchemy import create_engine, Column, ForeignKey, Integer, String
from sqlalchemy.orm import relationship, Session
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()
metadata = Base.metadata

class Parent(Base):
    __tablename__ = 'parent'
    id = Column(Integer, primary_key=True)

marksteward

//  Created by NHSX on 12.03.20.
//  Created by NHSX on 12.03.20.
//  Created by NHSX on 17.03.20.
//  Created by NHSX on 17.03.20.
//  Created by NHSX on 18.03.20.
//  Created by NHSX on 18.03.20.
//  Created by NHSX on 19.03.20.
//  Created by NHSX on 19.03.20.
//  Created by NHSX on 19.03.20.
//  Created by NHSX on 19.03.20.

marksteward

class StateWaiter extends Promise {
  constructor(resolveStates, rejectStates) {
    let handlers;
    super((resolve, reject) => handlers = {resolve, reject});
    this._handlers = handlers;
    this._resolveStates = resolveStates;
    this._rejectStates = rejectStates;
  }
  check(state) {
    if (this._resolveStates.includes(state)) this._handlers.resolve(state);

marksteward

#!/usr/bin/env python3

from sqlalchemy import create_engine
from sqlalchemy import Column, Integer, String
from sqlalchemy.dialects.postgresql import insert as pg_insert
from sqlalchemy.ext.declarative import declarative_base

from os import environ

# In docker-compose, DATABASE_URL will point to postgres