def _connect(state):
# Open DB connection
state.db_conn = db_iface.db_open(state.model.filepath)
if state.db_conn:
pass
'''
_D.DEBUG(
__name__,
"File Versioned Tracking DB found on disk",
'filepath', state.model.filepath,
'db_conn', state.db_conn
)
'''
else:
state.db_conn = db_iface.db_create(state.model.filepath)
'''
_D.DEBUG(
__name__,
"File Versioned Tracking DB not found on disk, creating new",
'filepath', state.model.filepath,
'db_conn', state.db_conn
)
'''
c = state.db_conn.cursor()
sql = "CREATE TABLE versions \
( \
id INTEGER PRIMARY KEY, \
date INTEGER UNIQUE, \
file TEXT, \
size INTEGER \
)"
c.execute(sql)
state.db_conn.commit()
def _connect(state):
# Open DB connection
state.db_conn = db_iface.db_open(state.model.filepath)
if state.db_conn:
pass
'''
_D.DEBUG(
__name__,
"DB Stats found on disk",
'filepath', state.model.filepath,
'db_conn', state.db_conn
)
'''
else:
state.db_conn = db_iface.db_create(state.model.filepath)
'''
_D.WARNING(
__name__,
"DB Stats not found on disk, creating new",
'filepath', state.model.filepath,
'db_conn', state.db_conn
)
'''
c = state.db_conn.cursor()
sql = "CREATE TABLE sessions_store \
( \
id INTEGER PRIMARY KEY, \
date INTEGER, \
backup_type TEXT, \
size INTEGER \
)"
c.execute(sql)
state.db_conn.commit()
def _connect(state):
# Open DB connection
state.db_conn = db_iface.db_open(state.model.filepath)
if state.db_conn:
pass
'''
_D.DEBUG(
__name__,
"File Incremental Tracking DB found on disk",
'filepath', state.model.filepath,
'db_conn', state.db_conn
)
'''
else:
state.db_conn = db_iface.db_create(state.model.filepath)
'''
_D.DEBUG(
__name__,
"File Incremental Tracking DB not found on disk, creating new",
'filepath', state.model.filepath,
'db_conn', state.db_conn
)
'''
c = state.db_conn.cursor()
# Table files: list of files in storage
sql = "CREATE TABLE files_storage \
( \
name TEXT UNIQUE, \
modified INTEGER, \
size INTEGER \
)"
c.execute(sql)
# Table files_local: list of files found on local disk
sql = "CREATE TABLE files_local \
( \
name TEXT UNIQUE, \
modified INTEGER, \
size INTEGER \
)"
c.execute(sql)
# Table files_upload: list of files to be stored
sql = "CREATE TABLE files_upload \
( \
name TEXT UNIQUE, \
modified INTEGER, \
size INTEGER \
)"
c.execute(sql)
# Table stats: stored amount of data by date
sql = "CREATE TABLE stats \
( \
date TEXT, \
size INTEGER \
)"
c.execute(sql)
# Table params: about this backup
sql = "CREATE TABLE params \
( \
id INTEGER PRIMARY KEY, \
dir_local TEXT, \
url_storage TEXT \
)"
c.execute(sql)
state.db_conn.commit()
