- Execute as script to save roundtrips

- Dont depend on get_jid_id(), this saves roundtrips

- This is added because even an ignored INSERT raises the
autoincrement value of the table.
This means the jid id gets high really fast.

- It should be where all other message received handlers are
- Port to new DB API

As we always load plugins from the user path first, we should not
reload them later from Gajims plugin base dir

Remove plugin path from sys.path after importing.

If we scan multiple plugin dirs and never remove the path from
sys.path, it is hard to predict from which path python will import
a package.

The chance that the same plugin package is in multiple plugin paths
is high.

This is a MUST see https://xmpp.org/extensions/xep-0234.html

Fixes #8662

- XEP-0234 demands UTC
- we missed the 'Z' at the end
- simplified the code

Simplify whats left

- also save stanza id to the DB

Fixes #8690

New logging methods and more MAM refactoring

See merge request !112

- Use new parse_datetime() method
- Drop message with error if MAM doesnt supply a timestamp.
- If the user supplys an own timestamp, save it so we can decide in the
future how to display it.

This is a regression from the refactoring

- also push a new MamDecryptedMessageReceived
event after disco instead of writing directly to the DB

Goal is to make the logger module easier to maintain in the future

- extract deduplication out into a own method, so we can use it
on its own in some other places.

- add new insert_into_logs() method
the DB fields we want to write to are passed as arguments, this makes
it so we dont have to change the method when we add or remove DB fields
in the future.

- instead of using get_jid_id() all around gajim to get the jid_id
before we write to the DB, we only have to pass the jid to
insert_into_logs(), it makes sure to get the correct jid_id or add
one in case it doesnt exist.

Add a new XEP-0082 parsing method

See merge request !111

This handles every possible XEP-0082 timestamp

It has some additional options:

- Check if a timestring is a valid UTC timestamp, as required by some
XEPs (for example: XEP-0203)
- Return timestamp as datetime in UTC
- Return timestamp as datetime in localtime
- Return timestamp as epoch

Xep 0319

See merge request !110

Set source IDs to None after removing the source
except when shutting down, because the Control ist destroyed anyway

Only try to remove if we have a source ID

- On single messages use the bare JID for DB querys
- Add more debug logging
- Some light refactoring

- The 'configure-event' does not trigger anymore when connected to
the MessageTextView. The reason is unknown.

- Use our own ScrolledWindow Widget instead so we can better control
the dimension of the MessageTextView