Example #1
0
    def add_items(self, items):
        if not items:
            return
        logger.info("batch %s: adding %d items", self.name, len(items))
        already_present = [row.ia_id for row in db.query("SELECT ia_id FROM import_item WHERE ia_id IN $items", vars=locals())]
        # ignore already present
        items = list(set(items) - set(already_present))

        logger.info("batch %s: %d items are already present, ignoring...", self.name, len(already_present))
        if items:
            values = [dict(batch_id=self.id, ia_id=item) for item in items]
            db.get_db().multiple_insert("import_item", values)        
            logger.info("batch %s: added %d items", self.name, len(items))
Example #2
0
 def setup_method(self):
     self.db = get_db()
     self.db.multiple_insert("bookshelves_books",
                             self.READING_LOG_SETUP_ROWS)
     self.db.multiple_insert("booknotes", self.BOOKNOTES_SETUP_ROWS)
     self.db.multiple_insert("ratings", self.RATINGS_SETUP_ROWS)
     self.db.multiple_insert("observations", self.OBSERVATIONS_SETUP_ROWS)
Example #3
0
 def setup_method(self, method):
     self.db = get_db()
     self.source_book = {
         "username": "******",
         "work_id": "1",
         "edition_id": "1",
         "bookshelf_id": "1",
     }
     assert not len(list(self.db.select("bookshelves_books")))
     self.db.insert("bookshelves_books", **self.source_book)
Example #4
0
    def setup_class(cls):
        web.config.db_parameters = dict(dbn="sqlite", db=":memory:")
        db = get_db()
        db.query("""
        CREATE TABLE bookshelves_books (
        username text NOT NULL,
        work_id integer NOT NULL,
        bookshelf_id INTEGER references bookshelves(id) ON DELETE CASCADE ON UPDATE CASCADE,
        edition_id integer default null,
        primary key (username, work_id, bookshelf_id)
        );""")

        db.query(
            """
            CREATE TABLE booknotes (
                username text NOT NULL,
                work_id integer NOT NULL,
                edition_id integer NOT NULL default -1,
                notes text NOT NULL,
                primary key (username, work_id, edition_id)
            );
            """
        )
Example #5
0
 def teardown_class(cls):
     db = get_db()
     db.query("delete from bookshelves_books;")
     db.query("delete from booknotes;")
Example #6
0
 def setup_class(cls):
     web.config.db_parameters = dict(dbn="sqlite", db=":memory:")
     db = get_db()
     db.query(READING_LOG_DDL)
     db.query(BOOKNOTES_DDL)
Example #7
0
 def setup_class(cls):
     web.config.db_parameters = dict(dbn="sqlite", db=":memory:")
     db = get_db()
     db.query(RATINGS_DDL)
     db.query(OBSERVATIONS_DDL)