URL catcher - Githubissues

UltrosBot / Ultros

Connecting communities, one squid at a time! Ultros is a multi-protocol chat bot written in Python, designed with both the user and developer in mind

http://ultros.io

Artistic License 2.0

23 stars 7 forks source link

URL catcher #38

Closed gdude2002 closed 10 years ago

gdude2002 commented 10 years ago

Reported by phat on IRC

Catch all URLs and put them into a database.

Add an event to the URL catcher for when a URL is detected
Create a contrib module..
- Use SQLAlchemy to support all of the databases
- Allow configuration of specific channels to watch for URLs
- Store metadata - Protocol, channel, user, the URL itself
- Possibly store the title as well, provided there is one
- Add support to the web interface, and provide a sample PHP page

rakiru commented 10 years ago

I assume using a Data class that wraps SQLAlchemy? Also, can we do this in twisted properly (async)?

gdude2002 commented 10 years ago

I was going to use Twistar as an ORM but honestly it's not up to the job of being a proper ORM.

There are no other ORMs for Twisted, so I'll have to support different databases manually. We'll just use MySQL for now. I'm also going to need a database schema from Phat.

gdude2002 commented 10 years ago

The database schema Phat was using with the eggdrop is not suitable, so I've modified it a bit to work for our needs. I'll be supporting MySQL and PostgreSQL by default; adding dialects will be very easy as they're stored in .sql files, and users can use whatever adapters they like.