gabfl / dbschema Goto Github PK

PyMySQL v0.8 includes a breaking change related to running multi-statement queries.

More information is available at PyMySQL/PyMySQL@c0aa317

CREATE FUNCTION get_date_lock(date_start timestamp with time zone) RETURNS timestamp with time zone
LANGUAGE sql IMMUTABLE
AS $$
    SELECT date_trunc('hour', date_start);
$$;

CREATE TABLE abc(
    id bigserial primary key,
    name text,
    date timestamp with time zone
);

Function get_date_lock gets created but table abc is ignored

Setting a host parameter in the config file is ignored: it always attempts to connect to localhost.

This appears to be because of:

Presumably this should read .get('host', 'localhost') instead?

dbschema relies on python's glob.glob function, which explicitly states (emphasis mine):

The glob module finds all the pathnames matching a specified pattern according to the rules used by the Unix shell, although results are returned in arbitrary order.

I expect to file a PR with a quick-and-dirty solution for this today.

It's pretty much essential to use TLS/SSL for a remote connection, but there's no way to do that currently.

For PyMYSQL we'd need a way to set the CA cert at the very least.

I'm not sure what's needed to make this work for Postgres, I don't use it regularly.