def get(self, id): db, cursor = self.db_init() sql = "Select * From api.users Where id = '{}' and deleted is not True".format(id) cursor.execute(sql) db.commit() user = cursor.fetchone() db.close() return jsonify({"data": user})
class Meta: database = db class Minute(Model): time = DateTimeField(index=True, unique=True) pips = IntegerField(default=1) class Meta: database = db class Hour(Model): time = DateTimeField(index=True, unique=True) pips = IntegerField(default=1) class Meta: database = db class Day(Model): time = DateTimeField(index=True, unique=True) pips = IntegerField(default=1) class Meta: database = db db.create_tables([Pip, Minute, Hour, Day]) db.close()
def _db_close(exc): if not db.is_closed(): db.close()
def reset_db(self): db.drop_tables([Pip, Minute, Hour, Day]) db.create_tables([Pip, Minute, Hour, Day]) db.close()