def load_entries(self, entry_id, page=1, limit=10):
page -= 1
if page < 0:
page = 0
offset = page * limit
print page, offset, limit
s = master_session()
self._entries = s.query(self._klass).filter_by(entry_id=entry_id).limit(limit).offset(offset)
self._entry_id = entry_id
self._total_num = s.query(self._klass).filter_by(entry_id=entry_id).count()
self._page = page
self._limit = limit
self._book_entry = s.query(BookEntryTable).filter_by(id=entry_id).one()
def updated(self):
rankno = self.get_update_rankno()
s = master_session()
num_rows = s.query(UpdateSysTable).filter_by(id=1, available=0).update({'rankno':rankno, 'available':1})
s.commit()
return num_rows > 0
def run_update(self):
s = master_session()
num_rows = s.query(UpdateSysTable).filter_by(id=1, available=1).update({'available':0})
s.commit()
return num_rows > 0
def __init__(self):
s = master_session()
o = s.query(UpdateSysTable).one()
self.rankno = o.rankno
self.available = o.available
def truncate():
s = master_session()
s.execute("TRUNCATE %s" % BookEntryTable.__tablename__)
def get_one(id):
s = master_session()
return s.query(BookEntryTable).filter_by(id=id).one()
def get_all():
s = master_session()
return s.query(BookEntryTable).order_by(BookEntryTable.id).all()
def update(id, img):
b = BookEntryUpdater.get_one(id)
b.img = img
s = master_session()
s.add(b)
s.commit()
def add(title, img, term, searchindex, node):
b = BookEntryTable(title, img, term, searchindex, node)
s = master_session()
s.add(b)
s.commit()
return b.id
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#---------------------------------------------------------------------------
from db.bookentry import BookEntryTable
from db.bookranking import BookRankingTable0, BookRankingTable1
from db import master_engine, master_session
from db.updatesys import UpdateSysTable
def create_master_tables(t):
try:
t.drop(bind=master_engine)
except:
pass
t.create(bind=master_engine)
# Create table
create_master_tables(UpdateSysTable.__table__)
create_master_tables(BookEntryTable.__table__)
create_master_tables(BookRankingTable0.__table__)
create_master_tables(BookRankingTable1.__table__)
# Insert default row
t = UpdateSysTable()
s = master_session()
s.add(t)
s.commit()
def truncate(self):
s = master_session()
s.execute("TRUNCATE %s" % self._klass.__tablename__)
def add(self, entry_id, rank, **kwargs):
s = master_session()
s.add(self._klass(entry_id, rank, **kwargs))
s.commit()
