2 db.start <- function() {
3 drv <- dbDriver('SQLite')
4 con <- dbConnect(drv, dbname=file.path(root,'data/cran2deb.db'))
5 tables <- dbListTables(con)
6 if (!dbExistsTable(con,'sysreq_override')) {
7 dbGetQuery(con,paste('CREATE TABLE sysreq_override ('
8 ,' debian_name TEXT NOT NULL'
9 ,',r_pattern TEXT PRIMARY KEY NOT NULL'
12 if (!dbExistsTable(con,'license_override')) {
13 dbGetQuery(con,paste('CREATE TABLE license_override ('
14 ,' name TEXT PRIMARY KEY NOT NULL'
15 ,',accept INT NOT NULL'
18 if (!dbExistsTable(con,'license_files')) {
19 dbGetQuery(con,paste('CREATE TABLE license_files ('
20 ,' name TEXT NOT NULL'
21 ,',file_sha1 TEXT PRIMARY KEY NOT NULL'
27 db.stop <- function(con) {
31 db.quote <- function(text) {
32 return(paste('"',gsub('([^][[:alnum:]*?. ()<>:/=+-])','\\\\\\1',text),'"',sep=''))
35 db.sysreq.override <- function(sysreq_text) {
36 sysreq_text <- tolower(sysreq_text)
38 results <- dbGetQuery(con,paste(
39 'SELECT debian_name FROM sysreq_override WHERE'
40 ,db.quote(sysreq_text),'GLOB r_pattern'))
42 if (length(results) == 0) {
45 return(results$debian_name)
48 db.add.sysreq.override <- function(pattern,debian_name) {
49 pattern <- tolower(pattern)
50 debian_name <- tolower(debian_name)
52 results <- dbGetQuery(con,paste(
53 'INSERT OR REPLACE INTO sysreq_override'
54 ,'(debian_name, r_pattern) VALUES ('
55 ,' ',db.quote(debian_name)
56 ,',',db.quote(pattern)
61 db.sysreq.overrides <- function() {
63 overrides <- dbGetQuery(con,paste('SELECT * FROM sysreq_override'))
69 db.license.override.name <- function(name) {
72 results <- dbGetQuery(con,paste(
73 'SELECT accept FROM license_override WHERE'
74 ,db.quote(name),'= name'))
76 if (length(results) == 0) {
79 return(as.logical(results$accept))
82 db.add.license.override <- function(name,accept) {
84 message(paste('adding',name,'accept?',accept))
85 if (accept != TRUE && accept != FALSE) {
86 stop('accept must be TRUE or FALSE')
89 results <- dbGetQuery(con,paste(
90 'INSERT OR REPLACE INTO license_override'
91 ,'(name, accept) VALUES ('
93 ,',',as.integer(accept)
98 db.license.override.file <- function(file_sha1) {
99 file_sha1 <- tolower(file_sha1)
101 results <- dbGetQuery(con,paste(
102 'SELECT name,accept FROM license_override'
103 ,'INNER JOIN license_files'
104 ,'ON license_files.name = license_override.name WHERE'
105 ,db.quote(file_sha1),'= license_files.file_sha1'))
107 # TODO: change accept from 0,1 into FALSE,TRUE
112 db.license.overrides <- function() {
114 overrides <- dbGetQuery(con,paste('SELECT * FROM license_override'))
115 files <- dbGetQuery(con,paste('SELECT * FROM license_files'))
117 # TODO: change accept from 0,1 into FALSE,TRUE
118 return(list(overrides=overrides,files=files))
121 db.add.license.file <- function(name,file_sha1) {
122 name <- tolower(name)
123 file_sha1 <- tolower(file_sha1)
124 message(paste('adding file',file_sha1,'for',name))
126 dbGetQuery(con,paste(
127 'INSERT OR REPLACE INTO license_files'
128 ,'(name, file_sha1) VALUES ('
130 ,',',db.quote(file_sha1)