door-delights-源码

上传者: 42098830 | 上传时间: 2021-08-03 14:04:01 | 文件大小: 1MB | 文件类型: ZIP
门的乐趣 一个在线食品订购应用程序。 该项目的目的是在生产环境中研究和实施 DBMS。 部分: 数据库架构设计 用于在数据库之间迁移数据的脚本 需要迁移脚本 问题 有多个环境具有自己的数据库版本。 一台在生产服务器中,一台在 QA 中,每个工作站上的开发服务器。 因此,当数据库中有任何更改时,例如向数据库添加新表或向现有表添加新列或向包含静态数据的现有表添加新行,则需要迁移这些更改并应用于所有其他数据库服务器,以便所有数据库以一致的方式,并且可以迁移到生产服务器。 解决方案和工作流程 解决方案 将更改迁移到其他数据库的 Python 脚本和用于维护生产中应用的迁移历史的 json 文件。 工作流程 本项目中实现的将更改从一个数据库迁移到另一个数据库的工作流程如下: 运行create_migration_file.py这将为包含以下内容的更改生成 JSON 文件: SQL 查询 对应

文件下载

资源详情

[{"title":"( 93 个子文件 1MB ) door-delights-源码","children":[{"title":"door-delights-master","children":[{"title":".gitignore <span style='color:#111;'> 2.26KB </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 4.59KB </span>","children":null,"spread":false},{"title":"FoodOrderingSchemaDesign.png <span style='color:#111;'> 92.52KB </span>","children":null,"spread":false},{"title":"sql-migration-scripts","children":[{"title":"create_migration_file.py <span style='color:#111;'> 4.44KB </span>","children":null,"spread":false},{"title":"migrate_to_db.py <span style='color:#111;'> 3.60KB </span>","children":null,"spread":false},{"title":"test_migration.py <span style='color:#111;'> 953B </span>","children":null,"spread":false},{"title":"releases.json <span style='color:#111;'> 633B </span>","children":null,"spread":false},{"title":"migrations","children":[{"title":"00003_create_order_tables.json <span style='color:#111;'> 1.27KB </span>","children":null,"spread":false},{"title":"00006_add_single_menu_items.json <span style='color:#111;'> 816B </span>","children":null,"spread":false},{"title":"00000_create_user_and_address_tables.json <span style='color:#111;'> 1.48KB </span>","children":null,"spread":false},{"title":"00004_alter_menu_table.json <span style='color:#111;'> 518B </span>","children":null,"spread":false},{"title":"00005_add_toppings.json <span style='color:#111;'> 1.21KB </span>","children":null,"spread":false},{"title":"00001_create_menu_item_tables.json <span style='color:#111;'> 1.71KB </span>","children":null,"spread":false},{"title":"00007_add_topping_item_pairs.json <span style='color:#111;'> 1.75KB </span>","children":null,"spread":false},{"title":"00002_create_combo_meals.json <span style='color:#111;'> 610B </span>","children":null,"spread":false},{"title":"00008_add_combo_menu_items.json <span style='color:#111;'> 1.54KB </span>","children":null,"spread":false}],"spread":true},{"title":"utils.py <span style='color:#111;'> 3.93KB </span>","children":null,"spread":false},{"title":"requirements.txt <span style='color:#111;'> 193B </span>","children":null,"spread":false},{"title":"sql_queries","children":[{"title":"migrations","children":[{"title":"00004_alter_menu_item_and_topping_tables.sql <span style='color:#111;'> 187B </span>","children":null,"spread":false},{"title":"00007_add_item_topping_pairs.sql <span style='color:#111;'> 762B </span>","children":null,"spread":false},{"title":"00006_add_single_menu_items.sql <span style='color:#111;'> 578B </span>","children":null,"spread":false},{"title":"00005_add_toppings.sql <span style='color:#111;'> 969B </span>","children":null,"spread":false},{"title":"00002_create_combo_meal_pair_table.sql <span style='color:#111;'> 386B </span>","children":null,"spread":false},{"title":"00000_create_user_and_address_tables.sql <span style='color:#111;'> 1.14KB </span>","children":null,"spread":false},{"title":"00008_add_menu_items.sql <span style='color:#111;'> 1.21KB </span>","children":null,"spread":false},{"title":"00001_create_menu_items_tables.sql <span style='color:#111;'> 1.35KB </span>","children":null,"spread":false},{"title":"00003_create_order_tables.sql <span style='color:#111;'> 1.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"rollback","children":[{"title":"00004_alter_menu_item_and_topping_tables.sql <span style='color:#111;'> 161B </span>","children":null,"spread":false},{"title":"00007_add_item_topping_pairs.sql <span style='color:#111;'> 825B </span>","children":null,"spread":false},{"title":"00006_add_single_menu_items.sql <span style='color:#111;'> 80B </span>","children":null,"spread":false},{"title":"00005_add_toppings.sql <span style='color:#111;'> 206B </span>","children":null,"spread":false},{"title":"00002_create_combo_meal_pair_table.sql <span style='color:#111;'> 57B </span>","children":null,"spread":false},{"title":"00000_create_user_and_address_tables.sql <span style='color:#111;'> 132B </span>","children":null,"spread":false},{"title":"00008_add_menu_items.sql <span style='color:#111;'> 134B </span>","children":null,"spread":false},{"title":"00001_create_menu_items_tables.sql <span style='color:#111;'> 145B </span>","children":null,"spread":false},{"title":"00003_create_order_tables.sql <span style='color:#111;'> 74B </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true},{"title":"spring-web-app","children":[{"title":".gitignore <span style='color:#111;'> 444B </span>","children":null,"spread":false},{"title":"gradle","children":[{"title":"wrapper","children":[{"title":"gradle-wrapper.jar <span style='color:#111;'> 57.82KB </span>","children":null,"spread":false},{"title":"gradle-wrapper.properties <span style='color:#111;'> 203B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"build.gradle <span style='color:#111;'> 678B </span>","children":null,"spread":false},{"title":"system.properties <span style='color:#111;'> 23B </span>","children":null,"spread":false},{"title":"gradlew.bat <span style='color:#111;'> 2.61KB </span>","children":null,"spread":false},{"title":"Procfile <span style='color:#111;'> 80B </span>","children":null,"spread":false},{"title":"gradlew <span style='color:#111;'> 5.63KB </span>","children":null,"spread":false},{"title":"src","children":[{"title":"test","children":[{"title":"java","children":[{"title":"com","children":[{"title":"example","children":[{"title":"doordelights","children":[{"title":"DoordelightsApplicationTests.java <span style='color:#111;'> 222B </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":false},{"title":"main","children":[{"title":"resources","children":[{"title":"static","children":[{"title":"css","children":[{"title":"baguetteBox.min.css <span style='color:#111;'> 3.52KB </span>","children":null,"spread":false},{"title":"bootstrap.min.css <span style='color:#111;'> 137.13KB </span>","children":null,"spread":false},{"title":"custom.css <span style='color:#111;'> 36B </span>","children":null,"spread":false},{"title":"superslides.css <span style='color:#111;'> 1.14KB </span>","children":null,"spread":false},{"title":"responsive.css <span style='color:#111;'> 1.46KB </span>","children":null,"spread":false},{"title":"greetings.css <span style='color:#111;'> 25B </span>","children":null,"spread":false},{"title":"font-awesome.min.css <span style='color:#111;'> 28.38KB </span>","children":null,"spread":false},{"title":"classic.css <span style='color:#111;'> 2.75KB </span>","children":null,"spread":false},{"title":"classic.time.css <span style='color:#111;'> 2.89KB </span>","children":null,"spread":false},{"title":"animate.css <span style='color:#111;'> 55.36KB </span>","children":null,"spread":false},{"title":"style.css <span style='color:#111;'> 23.94KB </span>","children":null,"spread":false},{"title":"classic.date.css <span style='color:#111;'> 5.90KB </span>","children":null,"spread":false}],"spread":false},{"title":"images","children":[{"title":"slider-01.jpg <span style='color:#111;'> 260.09KB </span>","children":null,"spread":false},{"title":"slider-02.jpg <span style='color:#111;'> 162.22KB </span>","children":null,"spread":false},{"title":"slider-03.jpg <span style='color:#111;'> 285.79KB </span>","children":null,"spread":false}],"spread":false},{"title":"js","children":[{"title":"jquery.superslides.min.js <span style='color:#111;'> 7.70KB </span>","children":null,"spread":false},{"title":"custom.js <span style='color:#111;'> 2.35KB </span>","children":null,"spread":false},{"title":"picker.time.js <span style='color:#111;'> 31.23KB </span>","children":null,"spread":false},{"title":"jquery.mapify.js <span style='color:#111;'> 6.31KB </span>","children":null,"spread":false},{"title":"images-loded.min.js <span style='color:#111;'> 5.43KB </span>","children":null,"spread":false},{"title":"form-validator.min.js <span style='color:#111;'> 5.91KB </span>","children":null,"spread":false},{"title":"picker.js <span style='color:#111;'> 37.02KB </span>","children":null,"spread":false},{"title":"legacy.js <span style='color:#111;'> 4.04KB </span>","children":null,"spread":false},{"title":"jquery-3.2.1.min.js <span style='color:#111;'> 84.63KB </span>","children":null,"spread":false},{"title":"picker.date.js <span style='color:#111;'> 47.11KB </span>","children":null,"spread":false},{"title":"contact-form-script.js <span style='color:#111;'> 1.51KB </span>","children":null,"spread":false},{"title":"bootstrap.min.js <span style='color:#111;'> 49.54KB </span>","children":null,"spread":false},{"title":"popper.min.js <span style='color:#111;'> 19.86KB </span>","children":null,"spread":false},{"title":"isotope.min.js <span style='color:#111;'> 34.49KB </span>","children":null,"spread":false},{"title":"baguetteBox.min.js <span style='color:#111;'> 9.00KB </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"templates","children":[{"title":"greetings.html <span style='color:#111;'> 492B </span>","children":null,"spread":false},{"title":"index.html <span style='color:#111;'> 6.30KB </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"java","children":[{"title":"com","children":[{"title":"example","children":[{"title":"doordelights","children":[{"title":"dao","children":[{"title":"UserAccountDaoImpl.java <span style='color:#111;'> 4.10KB </span>","children":null,"spread":false},{"title":"UserAccountDao.java <span style='color:#111;'> 408B </span>","children":null,"spread":false},{"title":"MenuItemDao.java <span style='color:#111;'> 355B </span>","children":null,"spread":false},{"title":"MenuItemDaoImpl.java <span style='color:#111;'> 3.59KB </span>","children":null,"spread":false}],"spread":false},{"title":"DoordelightsApplication.java <span style='color:#111;'> 329B </span>","children":null,"spread":false},{"title":"controller","children":[{"title":"ApplicationController.java <span style='color:#111;'> 1.13KB </span>","children":null,"spread":false},{"title":"APIController.java <span style='color:#111;'> 2.74KB </span>","children":null,"spread":false}],"spread":false},{"title":"mapper","children":[{"title":"MenuItemRowMapper.java <span style='color:#111;'> 683B </span>","children":null,"spread":false},{"title":"UserAccountRowMapper.java <span style='color:#111;'> 820B </span>","children":null,"spread":false}],"spread":false},{"title":"service","children":[{"title":"MenuItemServiceImpl.java <span style='color:#111;'> 881B </span>","children":null,"spread":false},{"title":"MenuItemService.java <span style='color:#111;'> 357B </span>","children":null,"spread":false},{"title":"UserAccountService.java <span style='color:#111;'> 402B </span>","children":null,"spread":false},{"title":"UserAccountServiceImpl.java <span style='color:#111;'> 985B </span>","children":null,"spread":false}],"spread":false},{"title":"entity","children":[{"title":"MenuItem.java <span style='color:#111;'> 987B </span>","children":null,"spread":false},{"title":"UserAccount.java <span style='color:#111;'> 1.34KB </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":true},{"title":"settings.gradle <span style='color:#111;'> 34B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]

评论信息

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明