"Exception: No suitable database adapter found!" for package examples

[juso]

While running flask-excel examples (database_example.py and database_example_formatted.py) in python3 on Windows face with the above exception. Will try on linux and report here as well

[juso]

checked on Linux (Ubuntu on Win10) - same behavior

[chfw]

any further information? I have just tried the database_example.py and it works as expected.

[juso]

I'm running on python 3.5.2. Which version you run it on?

[chfw]

I used python 2.7

[juso]

Here is the log
(env) yyy@FThi:~/projects/test.flask-excel$ python database_example.py

• Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)
• Restarting with stat
• Debugger is active!
• Debugger PIN: 340-127-841
  127.0.0.1 - - [12/Apr/2018 16:32:25] "GET /import HTTP/1.1" 200 -
  127.0.0.1 - - [12/Apr/2018 16:32:30] "POST /import HTTP/1.1" 500 -
  Traceback (most recent call last):
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/flask/app.py", line 1997, in call
  return self.wsgi_app(environ, start_response)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/flask/app.py", line 1985, in wsgi_app
  response = self.handle_exception(e)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/flask/app.py", line 1540, in handle_exception
  reraise(exc_type, exc_value, tb)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
  raise value
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/flask/app.py", line 1982, in wsgi_app
  response = self.full_dispatch_request()
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/flask/app.py", line 1614, in full_dispatch_request
  rv = self.handle_user_exception(e)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/flask/app.py", line 1517, in handle_user_exception
  reraise(exc_type, exc_value, tb)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
  raise value
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/flask/app.py", line 1612, in full_dispatch_request
  rv = self.dispatch_request()
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/flask/app.py", line 1598, in dispatch_request
  return self.view_functionsrule.endpoint
  File "/home/yuryf/projects/test.flask-excel/database_example.py", line 101, in doimport
  initializers=[category_init_func, post_init_func])
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/pyexcel_webio/init.py", line 237, in save_book_to_database
  pe.save_book_as(**params)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/pyexcel/core.py", line 99, in save_book_as
  return sources.save_book(book, **dest_keywords)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/pyexcel/internal/core.py", line 51, in save_book
  return _save_any(a_source, book)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/pyexcel/internal/core.py", line 55, in _save_any
  a_source.write_data(instance)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/pyexcel/plugins/sources/db_sources.py", line 103, in write_data
  **self._keywords)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/pyexcel/plugins/renderers/sqlalchemy.py", line 56, in render_book_to_stream
  save_data(importer, to_store, file_type=self._file_type, **keywords)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/pyexcel_io/io.py", line 119, in save_data
  **keywords)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/pyexcel_io/io.py", line 141, in store_data
  writer.write(data)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/pyexcel_io/book.py", line 210, in write
  sheet_writer = self.create_sheet(sheet_name)
  File "/home/yuryf/projects/test.flask-excel/env/lib/python3.5/site-packages/pyexcel_io/database/importers/sqlalchemy.py", line 92, in create_sheet
  raise Exception("No suitable database adapter found!")
  Exception: No suitable database adapter found!

[chfw]

I tried again with 3.6.3 on import use case. Worked for me.

[chfw]

Let me try it on py 3.5.2

[juso]

It's strange, it doesn't work on 2.7.12 either, not sure what is the catch. Cannot imagine what can be wrong similar way on both Win and Linux.

Here is the log:

(env2) yuryf@FThi:~/projects/test.flask-excel$ python ./database_example.py

• Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)
• Restarting with stat
• Debugger is active!
• Debugger PIN: 122-577-823
  127.0.0.1 - - [12/Apr/2018 18:36:42] "GET /import HTTP/1.1" 200 -
  127.0.0.1 - - [12/Apr/2018 18:36:47] "POST /import HTTP/1.1" 500 -
  Traceback (most recent call last):
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/flask/app.py", line 1997, in call
  return self.wsgi_app(environ, start_response)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/flask/app.py", line 1985, in wsgi_app
  response = self.handle_exception(e)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/flask/app.py", line 1540, in handle_exception
  reraise(exc_type, exc_value, tb)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/flask/app.py", line 1982, in wsgi_app
  response = self.full_dispatch_request()
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/flask/app.py", line 1614, in full_dispatch_request
  rv = self.handle_user_exception(e)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/flask/app.py", line 1517, in handle_user_exception
  reraise(exc_type, exc_value, tb)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/flask/app.py", line 1612, in full_dispatch_request
  rv = self.dispatch_request()
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/flask/app.py", line 1598, in dispatch_request
  return self.view_functionsrule.endpoint
  File "/home/yuryf/projects/test.flask-excel/database_example.py", line 101, in doimport
  initializers=[category_init_func, post_init_func])
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/pyexcel_webio/init.py", line 237, in save_book_to_database
  pe.save_book_as(**params)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/pyexcel/core.py", line 99, in save_book_as
  return sources.save_book(book, **dest_keywords)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/pyexcel/internal/core.py", line 51, in save_book
  return _save_any(a_source, book)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/pyexcel/internal/core.py", line 55, in _save_any
  a_source.write_data(instance)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/pyexcel/plugins/sources/db_sources.py", line 103, in write_data
  **self._keywords)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/pyexcel/plugins/renderers/sqlalchemy.py", line 56, in render_book_to_stream
  save_data(importer, to_store, file_type=self._file_type, **keywords)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/pyexcel_io/io.py", line 119, in save_data
  **keywords)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/pyexcel_io/io.py", line 141, in store_data
  writer.write(data)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/pyexcel_io/book.py", line 210, in write
  sheet_writer = self.create_sheet(sheet_name)
  File "/home/yuryf/projects/test.flask-excel/env2/lib/python2.7/site-packages/pyexcel_io/database/importers/sqlalchemy.py", line 92, in create_sheet
  raise Exception("No suitable database adapter found!")
  Exception: No suitable database adapter found!

[juso]

have integrated the code from 'database_example_formatted.py' into the existing project on 3.5.2 working with MySQL, and still get the same exception. The rest of the project works fine with the db, so very curious on what it could be.

[chfw]

The nature of the exception is your book got more sheets than the number of tables to be imported.

[juso]

I'm running the example 'database_example_formatted.py' with (what I assume it is) test data file 'example_for_upload.csv' from the same git directory. Shall I use something else?

[chfw]

You should use sample.xls

[juso]

Where can I take it or shall I create my own? If I need to create own then is there any logic of the content I need to follow? Number of sheets, number of columns on each sheet, headers etc.?

[juso]

created my own version https://www.dropbox.com/s/zbzpr368l88re8n/sample.xlsx?dl=0 but no luck so far, still same exception. Also tried this version without column headers, but still same result.