1"""LICENSE 

2Copyright 2019 Hermann Krumrey <hermann@krumreyh.com> 

3 

4This file is part of xkcd-bot. 

5 

6xkcd-bot is free software: you can redistribute it and/or modify 

7it under the terms of the GNU General Public License as published by 

8the Free Software Foundation, either version 3 of the License, or 

9(at your option) any later version. 

10 

11xkcd-bot is distributed in the hope that it will be useful, 

12but WITHOUT ANY WARRANTY; without even the implied warranty of 

13MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 

14GNU General Public License for more details. 

15 

16You should have received a copy of the GNU General Public License 

17along with xkcd-bot. If not, see <http://www.gnu.org/licenses/>. 

18LICENSE""" 

19 

20from kudubot.db import Base 

21from sqlalchemy import Column, Integer, String, Binary 

22 

23 

24class Comic(Base): 

25 """ 

26 Models an XKCD comic 

27 """ 

28 

29 __tablename__ = "comics" 

30 """ 

31 The name of the database table 

32 """ 

33 

34 id = Column(Integer, primary_key=True) 

35 """ 

36 The ID of the comic (same as on the website itself) 

37 """ 

38 

39 image_url = Column(String(255), nullable=False) 

40 """ 

41 The URL of the image for this comic 

42 """ 

43 

44 title = Column(String(255), nullable=False) 

45 """ 

46 The comic's title 

47 """ 

48 

49 alt_text = Column(String(255), nullable=False) 

50 """ 

51 The comic's alt text 

52 """ 

53 

54 image_data = Column(Binary, nullable=False) 

55 """ 

56 The image's data 

57 """