gabfl / dbschema Goto Github PK
View Code? Open in Web Editor NEWMySQL/PostgreSQL schema migrations made easy
License: MIT License
MySQL/PostgreSQL schema migrations made easy
License: MIT License
PyMySQL v0.8 includes a breaking change related to running multi-statement queries.
More information is available at PyMySQL/PyMySQL@c0aa317
/usr/local/lib/python3.5/dist-packages/psycopg2/__init__.py:144: UserWarning:
The psycopg2 wheel package will be renamed from release 2.8;
in order to keep installing from binary please use "pip install psycopg2-binary" instead.
For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.
""")
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:
Line 280 in c57865d
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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.