1390890 - Deploy Splice 2.1.34 to stage

Status: RESOLVED FIXED

(Firefox :: New Tab Page, enhancement)

Description

[Nan Jiang [:nanj]]

This is a database schema change, which adds a new table called "assa_impression_stats_daily". In includes:

* A new alembic migration "migrations/versions/49387f326d6a_.py"
* A Redshift schema "ddl/migrations/redshift/1502811414.sql"

Please grant write permission to "infernyx", and read permission to "read_only" and "redash".


Thanks!

Comment 1

[Jon Buckley [:jbuck]]

$ cd /opt/splice/
$ cat version.json 
{
	"source": "https://github.com/mozilla/splice",
	"version": "2.1.34",
	"commit": "4734159e531a87efd2934eb7ef6710b998df7ef8"
}
$ SPLICE_IGNORE_REDSHIFT=true SPLICE_SETTINGS=splice_config.SpliceConfig /opt/splice/bin/python /opt/splice/bin/manage.py db upgrade
INFO  [alembic.env] Migrating database <default>
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 2809b3efc07e -> 49387f326d6a, empty message
INFO  [alembic.env] Migrating database stats
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 2809b3efc07e -> 49387f326d6a, empty message
$ psql < ddl/migrations/redshift/1502811414.sql
BEGIN
CREATE TABLE
COMMIT
$ psql
tiles=> GRANT INSERT ON ALL TABLES IN SCHEMA public to infernyx;
GRANT
tiles=> GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only;
GRANT
tiles=> GRANT SELECT ON ALL TABLES IN SCHEMA public TO pocketro;
GRANT