-
sql语句大全之记开发个人图书收藏清单小程序开
主要是参考豆瓣的图书查询接口:
https://api.douban.com/v2/book/isbn/:9780132350884
返回内容如下:
1 { 2 "rating": { 3 "max": 10, 4 "numRaters": 361, 5 "average": "8.8", 6 "min": 0 7 }, 8 "subtitle": "A Handbook of Agile Software Craftsmanship", 9 "author": [ 10 "Robert C. Martin" 11 ], 12 "pubdate": "2008-8-11", 13 "tags": [ 14 { 15 "count": 295, 16 "name": "编程", 17 "title": "编程" 18 }, 19 { 20 "count": 257, 21 "name": "programming", 22 "title": "programming" 23 }, 24 { 25 "count": 150, 26 "name": "软件开发", 27 "title": "软件开发" 28 }, 29 { 30 "count": 109, 31 "name": "程序设计", 32 "title": "程序设计" 33 }, 34 { 35 "count": 100, 36 "name": "计算机", 37 "title": "计算机" 38 }, 39 { 40 "count": 87, 41 "name": "软件工程", 42 "title": "软件工程" 43 }, 44 { 45 "count": 66, 46 "name": "敏捷开发", 47 "title": "敏捷开发" 48 }, 49 { 50 "count": 55, 51 "name": "agile", 52 "title": "agile" 53 } 54 ], 55 "origin_title": "", 56 "image": "https://img3.doubanio.com/view/subject/m/public/s29624974.jpg", 57 "binding": "Paperback", 58 "translator": [ ], 59 "catalog": "", 60 "pages": "464", 61 "images": { 62 "small": "https://img3.doubanio.com/view/subject/s/public/s29624974.jpg", 63 "large": "https://img3.doubanio.com/view/subject/l/public/s29624974.jpg", 64 "medium": "https://img3.doubanio.com/view/subject/m/public/s29624974.jpg" 65 }, 66 "alt": "https://book.douban.com/subject/3032825/", 67 "id": "3032825", 68 "publisher": "Prentice Hall", 69 "isbn10": "0132350882", 70 "isbn13": "9780132350884", 71 "title": "Clean Code", 72 "url": "https://api.douban.com/v2/book/3032825", 73 "alt_title": "", 74 "author_intro": "Robert C. “Uncle Bob” Martin has been a software professional since 1970 and an international software consultant since 1990. He is founder and president of Object Mentor, Inc., a team of experienced consultants who mentor their clients worldwide in the fields of C++, Java, C#, Ruby, OO, Design Patterns, UML, Agile Methodologies, and eXtreme programming.", 75 "summary": "Even bad code can function. But if code isn’t clean, it can bring a development organization to its knees. Every year, countless hours and significant resources are lost because of poorly written code. But it doesn’t have to be that way. 76 Noted software expert Robert C. Martin presents a revolutionary paradigm with Clean Code: A Handbook of Agile Software Craftsmanship. Martin has teamed up with his colleagues from Object Mentor to distill their best agile practice of cleaning code “on the fly” into a book that will instill within you the values of a software craftsman and make you a better programmer—but only if you work at it. 77 What kind of work will you be doing? You’ll be reading code—lots of code. And you will be challenged to think about what’s right about that code, and what’s wrong with it. More importantly, you will be challenged to reassess your professional values and your commitment to your craft. 78 Clean Code is divided into three parts. The first describes the principles, patterns, and practices of writing clean code. The second part consists of several case studies of increasing complexity. Each case study is an exercise in cleaning up code—of transforming a code base that has some problems into one that is sound and efficient. The third part is the payoff: a single chapter containing a list of heuristics and “smells” gathered while creating the case studies. The result is a knowledge base that describes the way we think when we write, read, and clean code. 79 Readers will come away from this book understanding 80 How to tell the difference between good and bad code 81 How to write good code and how to transform bad code into good code 82 How to create good names, good functions, good objects, and good classes 83 How to format code for maximum readability 84 How to implement complete error handling without obscuring code logic 85 How to unit test and practice test-driven development 86 This book is a must for any developer, software engineer, project manager, team lead, or systems analyst with an interest in producing better code.", 87 "price": "USD 49.99" 88 }
刚才出去拿纱窗了,等晚上设计DB的时候继续更新。
基于豆瓣API获取的Response信息,所以抽取如下信息:
字段名称 | 豆瓣字段 | 字段描述 |
Title | title | |
SubTitle | subtitle | |
Authors | author | |
Translator | translator | |
ISBN13 | isbn13 | |
ISBN10 | isbn10 | |
AuthorIntro | author_intro | |
Summary | summary | |
Publisher | publisher | |
Binding | binding | |
OriginTitle | origin_title | |
Pages | pages | |
ImageUrl | image | |
Pubdate | pubdate | |
Catalog | catalog | |
Tags | tags |
拆分如上字段出来。
......
因为在看世界杯,所以设计有点断断续续的,放出DB的Diagram:
当前的逻辑应该是没有问题了,现在需要丰富的是DB的内容,以及每条线的发展设计。
顺便放出几个Type的Script:
1 CREATE FUNCTION [core].[Matter#Type] () 2 RETURNS TABLE 3 WITH SCHEMABINDING, ENCRYPTION 4 AS RETURN 5 ( 6 select 1 as _Book 7 , 2 as _ShelfBook 8 , 4 as _BookList 9 )
1 CREATE FUNCTION [core].[Party#Type] () 2 RETURNS TABLE 3 WITH SCHEMABINDING, ENCRYPTION 4 AS RETURN 5 ( 6 select 1 as _Administrator 7 , 4 as _User 8 --------------------------------------- 9 , 16 as _Shelf 10 )
1 CREATE FUNCTION [base].[BookInfo#Type] () 2 RETURNS TABLE 3 WITH SCHEMABINDING, ENCRYPTION 4 AS RETURN 5 ( 6 select 1 as _Summary 7 , 2 as _Catalog 8 , 4 as _AuthorIntro 9 )
好的,今天就先到这吧。
最新更新
nodejs爬虫
Python正则表达式完全指南
爬取豆瓣Top250图书数据
shp 地图文件批量添加字段
爬虫小试牛刀(爬取学校通知公告)
【python基础】函数-初识函数
【python基础】函数-返回值
HTTP请求:requests模块基础使用必知必会
Python初学者友好丨详解参数传递类型
如何有效管理爬虫流量?
SQL SERVER中递归
2个场景实例讲解GaussDB(DWS)基表统计信息估
常用的 SQL Server 关键字及其含义
动手分析SQL Server中的事务中使用的锁
openGauss内核分析:SQL by pass & 经典执行
一招教你如何高效批量导入与更新数据
天天写SQL,这些神奇的特性你知道吗?
openGauss内核分析:执行计划生成
[IM002]Navicat ODBC驱动器管理器 未发现数据
初入Sql Server 之 存储过程的简单使用
这是目前我见过最好的跨域解决方案!
减少回流与重绘
减少回流与重绘
如何使用KrpanoToolJS在浏览器切图
performance.now() 与 Date.now() 对比
一款纯 JS 实现的轻量化图片编辑器
关于开发 VS Code 插件遇到的 workbench.scm.
前端设计模式——观察者模式
前端设计模式——中介者模式
创建型-原型模式