python如何利用sqlalchemy操作數(shù)據(jù)庫(kù)

本篇內(nèi)容介紹了“python如何利用sqlalchemy操作數(shù)據(jù)庫(kù)”的有關(guān)知識(shí)，在實(shí)際案例的操作過(guò)程中，不少人都會(huì)遇到這樣的困境，接下來(lái)就讓小編帶領(lǐng)大家學(xué)習(xí)一下如何處理這些情況吧！希望大家仔細(xì)閱讀，能夠?qū)W有所成！

1.安裝
pip install sqlalchemy

2.代碼如下

1. #!/usr/bin/python
   

2. # coding=utf-8
   

3. 
   

4. from sqlalchemy import create_engine
   

5. from sqlalchemy.ext.declarative import declarative_base
   

6. from sqlalchemy.orm import sessionmaker
   

7. from sqlalchemy import Column, Integer, String, DateTime, Boolean
   

8. 
   

9. engine = create_engine("mysql://root:root@127.0.0.1:3306/test?charset=utf8")
   

10. 
    

11. Session = sessionmaker(bind=engine)
    

12. 
    

13. Base = declarative_base()
    

14. 
    

15. 
    

16. class News(Base):
    

17.     ''' 新聞?lì)愋?'''
    

18.     __tablename__ = 'news'
    

19.     id = Column(Integer, primary_key=True)
    

20.     title = Column(String(200), nullable=False)
    

21.     content = Column(String(2000), nullable=False)
    

22.     types = Column(String(10), nullable=False)
    

23.     image = Column(String(300))
    

24.     author = Column(String(20))
    

25.     view_count = Column(Integer)
    

26.     created_at = Column(DateTime)
    

27.     is_valid = Column(Boolean)
    

28. 
    

29. 
    

30. class MysqlOrmTest(object):
    

31. 
    

32.     def __init__(self):
    

33.         self.session = Session()
    

34. 
    

35.     def add_one(self):
    

36.         new_obj = News(
    

37.             title='orm title',
    

38.             content='content',
    

39.             types='百家'
    

40.         )
    

41.         self.session.add(new_obj)
    

42.         self.session.commit()
    

43.         return new_obj
    

44. 
    

45.     def get_one(self):
    

46.         ''' 獲取一條數(shù)據(jù) '''
    

47.         return self.session.query(News).get(1)
    

48. 
    

49.     def get_more(self):
    

50.         ''' 獲取多條數(shù)據(jù) '''
    

51.         return self.session.query(News).filter_by(is_valid=1)
    

52. 
    

53.     def update_data(self):
    

54.         ''' 修改數(shù)據(jù) '''
    

55.         obj = self.session.query(News).get(38)
    

56.         obj.is_valid = 0
    

57.         self.session.add(obj)
    

58.         self.session.commit()
    

59.         return obj
    

60. 
    

61.     def delete_data(self):
    

62.         ''' 刪除數(shù)據(jù) '''
    

63.         # 獲取要?jiǎng)h除的數(shù)據(jù)
    

64.         data = self.session.query(News).get(39)
    

65.         self.session.delete(data)
    

66.         self.session.commit()
    

67. 
    

68. def main():
    

69.     obj = MysqlOrmTest()
    

70.     # rest = obj.add_one()
    

71.     # print(dir(rest))
    

72.     # print(obj.get_one().title)
    

73. 
    

74.     # print(obj.get_more().count())
    

75.     # for row in obj.get_more():
    

76.     # print(row.title)
    

77. 
    

78.     # print(obj.update_data())
    

79. 
    

80.     obj.delete_data()
    

81. 
    

82. 
    

83. 
    

84. if __name__ == '__main__':
    

85.     main()

“python如何利用sqlalchemy操作數(shù)據(jù)庫(kù)”的內(nèi)容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業(yè)相關(guān)的知識(shí)可以關(guān)注億速云網(wǎng)站，小編將為大家輸出更多高質(zhì)量的實(shí)用文章！