Oracle database backend

[Jack28]

SQLAlchemy has support for Oracle but our current test for _meta table and schema is not compatible.

oracle+cx_oracle://

First the test to check if schema exists leads to a crash because cx_oracle doesn't have the function has_table

PeekabooAV/peekaboo/db.py

Line 422 in 18d0ac2

if not self.__engine.dialect.has_table(self.__engine, '_meta'):

Secondly the auto_increment of primary keys needs to be realised by additional Sequences:

from sqlalchemy.schema import Sequence
...
    id = Column(Integer, Sequence('id_sample'), primary_key=True)
...
    id = Column(Integer, Sequence('id_analysis'), primary_key=True)

https://docs.sqlalchemy.org/en/13/dialects/oracle.html#auto-increment-behavior

After that everything seems to working as expected.