jjmontesl / cubetl Goto Github PK

# Apply https://github.com/jjmontesl/cubetl/pull/8 to open port 5005
docker-compose run --service-ports cubetls /bin/bash
pip install cubes click flask
cd examples/sql
sh sql2olap.sh
# Edit chinook.cubes-config.ini to use host 0.0.0.0 to listen for connections outside docker
slicer serve chinook.cubes-config.ini >& slicer.log &

2019-11-22 20:28:26,018 DEBUG Exception stack trace:
Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/cubes/sql/query.py", line 575, in column
    column = table.columns[mapping.column]
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/_collections.py", line 194, in __getitem__
    return self._data[key]
KeyError: 'Title'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python3.7/site-packages/cubes/server/decorators.py", line 118, in wrapper
    return f(*args, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/cubes/server/decorators.py", line 167, in wrapper
    retval = f(*args, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/cubes/server/blueprint.py", line 414, in cube_facts
    page_size=g.page_size)
  File "/usr/local/lib/python3.7/site-packages/cubes/sql/browser.py", line 249, in facts
    include_fact_key=True)
  File "/usr/local/lib/python3.7/site-packages/cubes/sql/browser.py", line 486, in denormalized_statement
    context = self._create_context(context_attributes)
  File "/usr/local/lib/python3.7/site-packages/cubes/sql/browser.py", line 472, in _create_context
    safe_labels=self.safe_labels)
  File "/usr/local/lib/python3.7/site-packages/cubes/sql/query.py", line 883, in __init__
    bases = {attr:self.star_schema.column(attr) for attr in base_names}
  File "/usr/local/lib/python3.7/site-packages/cubes/sql/query.py", line 883, in <dictcomp>
    bases = {attr:self.star_schema.column(attr) for attr in base_names}
  File "/usr/local/lib/python3.7/site-packages/cubes/sql/query.py", line 579, in column
    % (mapping.column, mapping.table, avail))
cubes.sql.query.SchemaError: Unknown column 'Title' in table 'Invoice' possible: Invoice.InvoiceId, Invoice.CustomerId, Invoice.InvoiceDate, Invoice.BillingAddress, Invoice.BillingCity, Invoice.BillingState, Invoice.BillingCountry, Invoice.BillingPostalCode, Invoice.Total

$ docker-compose run cubetls python -c "import cubetl.geoip"
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "/app/cubetl/geoip/__init__.py", line 26, in <module>
    from incf.countryutils import transformations
  File "/usr/local/lib/python3.7/site-packages/incf/countryutils/transformations.py", line 151
    raise KeyError, code
                  ^
SyntaxError: invalid syntax

$ git clone https://github.com/wyldebeast-wunderliebe/incf.countryutils.git
$ cd incf.countryutils.git
$ virtualenv .venv
$ source .venv/bin/activate
$ python setup.py install
$ python -c "from incf.countryutils import transformations"
$ 

Traceback (most recent call last):
  File "/root/cubetl/env/bin/cubetl", line 11, in <module>
    load_entry_point('cubetl', 'console_scripts', 'cubetl')()
  File "/root/cubetl/env/local/lib/python2.7/site-packages/pkg_resources/__init__.py", line 542, in load_entry_point
    return get_distribution(dist).load_entry_point(group, name)
  File "/root/cubetl/env/local/lib/python2.7/site-packages/pkg_resources/__init__.py", line 2569, in load_entry_point
    return ep.load()
  File "/root/cubetl/env/local/lib/python2.7/site-packages/pkg_resources/__init__.py", line 2229, in load
    return self.resolve()
  File "/root/cubetl/env/local/lib/python2.7/site-packages/pkg_resources/__init__.py", line 2235, in resolve
    module = __import__(self.module_name, fromlist=['__name__'], level=0)
  File "/root/cubetl/cubetl/core/bootstrap.py", line 23, in <module>
    import importlib.util
ImportError: No module named util

  /app/cubetl/core/context.py:177: DeprecationWarning: inspect.getargspec() is deprecated since Python 3.0, use inspect.signature() or inspect.getfullargspec()
    spec = getargspec(value)

  /app/cubetl/sql/sql.py:372: DeprecationWarning: The 'warn' method is deprecated, use 'warning' instead

$ git grep 'logger.warn('
cubetl/core/components.py:            logger.warn("Finalized a non initialized component: %s" % comp)
cubetl/core/components.py:                logger.warn("Unfinalized component %s" % comp_desc.comp)
cubetl/fs/__init__.py:            logger.warn("Could not stat file: %s", path)
cubetl/http/__init__.py:                logger.warn("Could not retrieve HTTP document (attempt %d/%d): %s " % (attempt_count, self.attempts, e))
cubetl/olap/sql.py:            logger.warn("%s has multiple primary keys mapped: %s (ignoring)" % (self, pk_mappings))
cubetl/olap/sql.py:                            logger.warn("%s looked up an entity which exists with different attributes (field=%s, existing_value=%r, tried_value=%r) (reported only once per field)" % (self, mapping.sqlcolumn, v1, v2))
cubetl/olap/sqlschema.py:                        logger.warn("Ignoring foreign key reference to self: %s", dbcol.name)
cubetl/olap/sqlschema.py:                        logger.warn("Ignoring foreign key reference from %s.%s to not available entity: %s", dbcol.sqltable.name, dbcol.name, related_fact_name)
cubetl/olap/sqlschema.py:                logger.warn("Multiple primary key found in table %s (not supported, ignoring table)", sqltable.name)
cubetl/olap/sqlschema.py:                logger.warn("No primary key found in table %s (not supported, ignoring table)", sqltable.name)
cubetl/pcaxis/__init__.py:                logger.warn("PCAxisIterator could not parse value: %r (cell: %s)", value, container)
cubetl/sql/schemaimport.py:                        logger.warn("Skipped foreign key %s in table %s, as foreign key column (%s.%s) was not found.", dbcol.name, dbtable.name, list(dbcol.foreign_keys)[0].column.table.name, list(dbcol.foreign_keys)[0].column.name)
cubetl/sql/sql.py:                                logger.warn("%s updating an entity that exists with different attributes, overwriting (field=%s, existing_value=%s, tried_value=%s)" % (self, c.name, v1, v2))
cubetl/sql/sql.py:                        logger.warn("Unicode column %r received non-unicode string: %r " % (column.name, row[column.name]))
cubetl/text/__init__.py:                    logger.warn("Failed to match regular expresion %s on value: %s", self.regexp, data)