From c01eb0e3220924c24aabc3ccd282f89f9ed9cb3e Mon Sep 17 00:00:00 2001 From: neodarz Date: Fri, 11 Jan 2019 23:41:00 +0100 Subject: Add first implementation of a database --- app.py | 8 ++++++++ config.py | 5 +++++ database/__init__.py | 0 database/models.py | 17 +++++++++++++++++ spider.db | Bin 0 -> 8192 bytes 5 files changed, 30 insertions(+) create mode 100644 app.py create mode 100644 config.py create mode 100644 database/__init__.py create mode 100644 database/models.py create mode 100644 spider.db diff --git a/app.py b/app.py new file mode 100644 index 0000000..2a80507 --- /dev/null +++ b/app.py @@ -0,0 +1,8 @@ +from database.models import Page, db +import config + +def main(): + db.create_tables([Page]) + +if __name__ == '__main__': + main() diff --git a/config.py b/config.py new file mode 100644 index 0000000..3717715 --- /dev/null +++ b/config.py @@ -0,0 +1,5 @@ +from os import path + +APP_DIR = path.dirname(__file__) + +DATABASE = '%s' % path.join(APP_DIR, 'spider.db') diff --git a/database/__init__.py b/database/__init__.py new file mode 100644 index 0000000..e69de29 diff --git a/database/models.py b/database/models.py new file mode 100644 index 0000000..4b27806 --- /dev/null +++ b/database/models.py @@ -0,0 +1,17 @@ +from peewee import Model, CharField, SqliteDatabase + +import config + +db = SqliteDatabase(config.DATABASE) +db.connect() + +class Page(Model): + """ + Page of a website + """ + url = CharField() + title = CharField() + content = CharField() + + class Meta: + database = db diff --git a/spider.db b/spider.db new file mode 100644 index 0000000..7e60fa8 Binary files /dev/null and b/spider.db differ -- cgit v1.2.1