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"]))
