From 981ba5c5f30549dbd233fab1e52bb774fd3eebe1 Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Tue, 4 Aug 2015 23:24:46 +0200 Subject: o Adding Trireme setup to support migrating the Cassandra schema. --- trireme/config.py | 9 +++++++++ trireme/db/migrations/2015-08-04_0_sm_by_day.cql | 10 ++++++++++ trireme/db/migrations/2015-08-04_1_raw_record.cql | 9 +++++++++ trireme/tasks.py | 4 ++++ 4 files changed, 32 insertions(+) create mode 100644 trireme/config.py create mode 100644 trireme/db/migrations/2015-08-04_0_sm_by_day.cql create mode 100644 trireme/db/migrations/2015-08-04_1_raw_record.cql create mode 100644 trireme/tasks.py (limited to 'trireme') diff --git a/trireme/config.py b/trireme/config.py new file mode 100644 index 0000000..e198dbe --- /dev/null +++ b/trireme/config.py @@ -0,0 +1,9 @@ +contact_points = ['127.0.0.1'] +keyspace = 'soil_moisture' + +username = None +password = None + +migration_master = True + +solr_url = 'http://127.0.0.1:8983/solr' diff --git a/trireme/db/migrations/2015-08-04_0_sm_by_day.cql b/trireme/db/migrations/2015-08-04_0_sm_by_day.cql new file mode 100644 index 0000000..776cd23 --- /dev/null +++ b/trireme/db/migrations/2015-08-04_0_sm_by_day.cql @@ -0,0 +1,10 @@ +CREATE TABLE sm_by_day ( + device text, + day text, + timestamp timestamp, + sensors list>>, + PRIMARY KEY ( + (device, day), + timestamp + ) +); diff --git a/trireme/db/migrations/2015-08-04_1_raw_record.cql b/trireme/db/migrations/2015-08-04_1_raw_record.cql new file mode 100644 index 0000000..85c4ecb --- /dev/null +++ b/trireme/db/migrations/2015-08-04_1_raw_record.cql @@ -0,0 +1,9 @@ +CREATE TABLE raw_record ( + day text, + timestamp timestamp, + records list>>, + PRIMARY KEY ( + (day), + timestamp + ) +); diff --git a/trireme/tasks.py b/trireme/tasks.py new file mode 100644 index 0000000..de586ef --- /dev/null +++ b/trireme/tasks.py @@ -0,0 +1,4 @@ +from invoke import Collection +from trireme import trireme + +namespace = Collection(trireme) -- cgit v1.2.3