vim_name = unicode('gvim') vim_url = "http://www.vim.org" vim_dl_url = "http://www.vim.org/download.php" vim_version = "1.2.3" vim_regex = '".*vim.*\.exe"' vim_version_regex = '\d+.*\d' appLogFileName = "appLog" validQuery, applications = db_wrapper.get_applications(mydb) print 'All Applicaitons:', applications if validQuery and not vim_name in applications: print 'adding vim to the db.' db_wrapper.add_app(mydb, vim_name, vim_version, vim_dl_url, vim_url) db_wrapper.add_exe_regex(mydb, vim_name, [vim_regex]) db_wrapper.add_version_regex(mydb, vim_name, [vim_version_regex]) vim = app(vim_name, mydb, appLogFileName) updatesAvail = vim.checkUpdates() print 'gvim update available?', updatesAvail if updatesAvail: vim.dlUpdates() putty_name = 'putty' putty_url = 'http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html' putt_dl_url = 'http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html' putty_version = '1.0' putty_regex = '".*putty.*\.exe"'
#!/usr/bin/env python import wpm_db import db_wrapper import time mydb = wpm_db.db("dbFile", "dbLog") # Test Operations on Application Table print("\nTest Operations on Application Table") print("Unique App Insert Test", db_wrapper.add_app(mydb, "App", "1.0", "http://test_app.com", "http://test_app.com/dl", True)) print("Unique App Insert Test", db_wrapper.add_app(mydb, "latestApp", "1.2.3", "http://test.com", "http://test.com/dl")) print(db_wrapper.get_applications(mydb)) print("Non-Unique App Insert Test", db_wrapper.add_app(mydb, "latestApp", "1.2.3", "http://test.com", "http://test.com/dl")) print("Get Version Test", db_wrapper.get_app_version(mydb, "latestApp")) print("Get URLs Test", db_wrapper.get_app_urls(mydb, "latestApp")) print("Get UninstallFirst Flag - True", db_wrapper.get_app_uninstallFirst(mydb, "App")) print("Get UninstallFirst Flag - False", db_wrapper.get_app_uninstallFirst(mydb, "latestApp")) print("Get URLs Original", db_wrapper.get_app_urls(mydb, "latestApp")) db_wrapper.update_main_url(mydb, "latestApp", "http://newTest.com/index.php") print("After Change main URL", db_wrapper.get_app_urls(mydb, "latestApp")) db_wrapper.update_download_url(mydb, "latestApp", "http://newTest.com/dl") print("After Change dl URL", db_wrapper.get_app_urls(mydb, "latestApp")) print("Update Version", db_wrapper.add_update_file(mydb, "latestApp", "1.5")) print("Get Version", db_wrapper.get_app_version(mydb, "latestApp")) # Test Operations on Dependency Table print("\nTest Operations on Dependency Table") print("Add Dependencies", db_wrapper.add_dependencies(mydb, "App", ["latestApp", "latestApp"])) print("Get Dependency Name", db_wrapper.get_app_dependencies(mydb, "App")) print("Add Dependencies - Error", db_wrapper.add_dependencies(mydb, "App", ["DNE"]))