<commit_before>from gluino import DAL, Field
import config

#db = DAL(config.uri, auto_import=True, migrate=False, folder=config.dbdir)
#db = DAL(config.uri, migrate=True, migrate_enabled=True, fake_migrate=True, folder=config.dbdir)
db = DAL(config.uri, migrate=False, folder=config.dbdir)

users = db.define_table('users', Field('id','integer'),
                                 Field('user', 'string'),
                                 Field('passwd','<PASSWORD>'),
                                 Field('email','string'),
                                 Field('priority','integer'))

# this is also defined in scheduler.py
# need to fix in the future
apps = db.define_table('apps', Field('id','integer'),
                               Field('name','string'),
                               Field('description','string'),
                               Field('category','string'),
                               Field('language','string'),
                               Field('input_format','string'),
                               Field('command','string'),
                               Field('preprocess','string'),
                               Field('postprocess','string'))

app_user = db.define_table('app_user', Field('id', 'integer'), 
                                       Field('appid', 'integer'),
                                       Field('uid', 'integer'), migrate='app_user.table')

# this is also defined in scheduler.py
# need to fix in the future
jobs = db.define_table('jobs', Field('id','integer'),
                               Field('uid',db.users),
                               Field('app','string'),
                               Field('cid','string'),
                               Field('state','string'),
                               Field('time_submit','string'),
                               Field('description','string'),
                               Field('np','integer'),
                               Field('priority','integer'),<commit_msg>second try to fix DB migrations<commit_after>from gluino import DAL, Field
import config

#db = DAL(config.uri, auto_import=True, migrate=False, folder=config.dbdir)
#db = DAL(config.uri, migrate=True, migrate_enabled=True, fake_migrate=True, folder=config.dbdir)
db = DAL(config.uri, migrate=False, folder=config.dbdir)

users = db.define_table('users', Field('id','integer'),
                                 Field('user', 'string'),
                                 Field('passwd','<PASSWORD>'),
                                 Field('email','string'),
                                 Field('priority','integer'))

# this is also defined in scheduler.py
# need to fix in the future
apps = db.define_table('apps', Field('id','integer'),
                               Field('name','string'),
                               Field('description','string'),
                               Field('category','string'),
                               Field('language','string'),
                               Field('input_format','string'),
                               Field('command','string'),
                               Field('preprocess','string'),
                               Field('postprocess','string'))

app_user = db.define_table('app_user', Field('id', 'integer'), 
                                       Field('appid', 'integer'),
                                       Field('uid', 'integer'))

# this is also defined in scheduler.py
# need to fix in the future
jobs = db.define_table('jobs', Field('id','integer'),
                               Field('uid',db.users),
                               Field('app','string'),
                               Field('cid','string'),
                               Field('state','string'),
                               Field('time_submit','string'),
                               Field('description','string'),
                               Field('np','integer'),
                               Field('priority','integer'),
{'fraction_non_alphanumeric': 0.14053106212424848, 'fraction_numerical': 0.0, 'mean_word_length': 1.4258809234507899, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 12, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4572834', 'n_tokens_mistral': 901, 'n_tokens_neox': 884, 'n_words': 173}