I would download and start fresh... How did you get 2.14.5? git clone? If so did you clone --recursive?
On Thu, Jun 16, 2016 at 12:41 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Do they share the same Database, if not it make no sens that auth_user > already exists... Did you modify the welcome app.ini db config? I ask > because web2py use welcome as template for new app... > > On Thu, Jun 16, 2016 at 12:36 PM, Marty Jones <murtin.jo...@gmail.com> > wrote: > >> The reason I suspect a non-application-specific issue is that creating a >> new simple app from the web2py admin console results in a similar database >> issue. Visiting the default/index of the new app spits back: >> >> Traceback (most recent call last): >> File "/home/murtyjones/app/gluon/restricted.py", line 227, in restricted >> exec ccode in environment >> File "/home/murtyjones/app/applications/test_users/models/db.py" >> <https://nolabills.com/admin/default/edit/test_users/models/db.py>, line 93, >> in <module> >> auth.define_tables(username=False, signature=False) >> File "/home/murtyjones/app/gluon/tools.py", line 2376, in define_tables >> format='%(first_name)s %(last_name)s (%(id)s)')) >> File "/home/murtyjones/app/gluon/packages/dal/pydal/base.py", line 576, in >> define_table >> table = self.lazy_define_table(tablename,*fields,**args) >> File "/home/murtyjones/app/gluon/packages/dal/pydal/base.py", line 615, in >> lazy_define_table >> polymodel=polymodel) >> File "/home/murtyjones/app/gluon/packages/dal/pydal/adapters/base.py", >> line 768, in create_table >> return self.migrator.create_table(*args, **kwargs) >> File "/home/murtyjones/app/gluon/packages/dal/pydal/migrator.py", line >> 269, in create_table >> self.adapter.create_sequence_and_triggers(query, table) >> File "/home/murtyjones/app/gluon/packages/dal/pydal/adapters/base.py", >> line 820, in create_sequence_and_triggers >> self.execute(query) >> File "/home/murtyjones/app/gluon/packages/dal/pydal/adapters/__init__.py", >> line 68, in wrap >> return f(*args, **kwargs) >> File "/home/murtyjones/app/gluon/packages/dal/pydal/adapters/base.py", >> line 417, in execute >> rv = self.cursor.execute(command, *args[1:], **kwargs) >> OperationalError: table auth_user already exists >> >> >> >> >> On Thursday, June 16, 2016 at 12:28:35 PM UTC-4, Richard wrote: >>> >>> There shouldn't be issue specific to SQLite (I mean it should work >>> properly), though there is maybe a specific unnoticed issue with it as >>> there has been a big refactoring of pyDAL, I don't recall it the refactored >>> pyDAL was present in 2.14.5 >>> >>> >>> >>> On Thu, Jun 16, 2016 at 12:22 PM, Marty Jones <murtin...@gmail.com> >>> wrote: >>> >>>> Done - no change. >>>> >>>> Is it possible that the issue is SQLite specific and I need to migrate >>>> to MySQL or some other db? >>>> >>>> On Thursday, June 16, 2016 at 12:14:51 PM UTC-4, Richard wrote: >>>>> >>>>> Can you comment out the part of the scheduler, the db lock file may >>>>> come from there... >>>>> >>>>> On Thu, Jun 16, 2016 at 12:05 PM, Marty Jones <murtin...@gmail.com> >>>>> wrote: >>>>> >>>>>> Controller logic is below. Error 1 is occuring under the "dashboard" >>>>>> function. Errors 2/3 under the user function. >>>>>> >>>>>> # -*- coding: utf-8 -*- >>>>>> # this file is released under public domain and you can use without >>>>>> limitations >>>>>> >>>>>> >>>>>> ############################################################################### >>>>>> ## Launch with all settings via "sudo python run_server.py" >>>>>> >>>>>> ############################################################################### >>>>>> >>>>>> import operator # needed for manager_status variable >>>>>> >>>>>> response.title = 'nolabills' >>>>>> >>>>>> def jspage(): >>>>>> link = URL('static', 'main.js') >>>>>> return dict(link=link) >>>>>> >>>>>> def index(): >>>>>> """ >>>>>> For registered users, redirects to the requests page >>>>>> For unregistered users, displays intro message >>>>>> """ >>>>>> >>>>>> signup = URL(a=request.application, c='default', >>>>>> f='user/register') >>>>>> >>>>>> return dict(is_logged_in=auth.is_logged_in(), signup=signup) >>>>>> >>>>>> @auth.requires_membership('manager') >>>>>> def manage(): >>>>>> """ >>>>>> This page, accessible by only managers, shows the current >>>>>> employees >>>>>> of a company as well as any users who are registering themselves >>>>>> as >>>>>> employees of the company. >>>>>> From this page a manager can approve a pending user's membership, >>>>>> as well as revoke the membership of a user on the current >>>>>> employee list. >>>>>> """ >>>>>> pending_list = [] >>>>>> approved_list = [] >>>>>> if request.post_vars: >>>>>> for each in request.post_vars: >>>>>> key = request.post_vars.keys()[0] >>>>>> underscore = key.find('_') >>>>>> id = key[0:underscore] >>>>>> change = key[underscore+1:len(key)] >>>>>> change = None if change == "approve" else "unapproved" >>>>>> # modify db accordingly >>>>>> record = db(db.auth_user.id==id).select().first() >>>>>> record.registration_key=change >>>>>> record.update_record() >>>>>> >>>>>> for row in db().select(): >>>>>> #for row in db(db.auth_user.company==auth.user.company).select(): >>>>>> if row.registration_key: # if pending approval by manager >>>>>> pending_list.append({row.id: >>>>>> {"first":row.first_name,"last":row.last_name}}) >>>>>> else: >>>>>> manager_status = auth.has_membership('manager', row.id) >>>>>> approved_list.append({row.id: >>>>>> {"first":row.first_name,"last":row.last_name,"manager_status":manager_status}}) >>>>>> return dict(pending_list=pending_list, >>>>>> approved_list=approved_list) >>>>>> >>>>>> @auth.requires_login() >>>>>> def dashboard(): >>>>>> """ >>>>>> This page allows a user to send an email to >>>>>> a potential customer, requesting access to bill data >>>>>> """ >>>>>> i = 0 >>>>>> already_submitted = False # default is false; can only be changed >>>>>> if request.post_vars == True >>>>>> >>>>>> # SQLFORM version >>>>>> data_requests = >>>>>> SQLFORM.grid(db(db.data_requests.company==auth.user.company), >>>>>> fields=[db.data_requests.last_name, \ >>>>>> db.data_requests.first_name, >>>>>> \ >>>>>> db.data_requests.email, \ >>>>>> db.data_requests.status, \ >>>>>> db.data_requests.bill_1, >>>>>> ], >>>>>> >>>>>> headers={'data_requests.bill_1':'Most Recent Bill'}, >>>>>> sortable=False, >>>>>> create=False, >>>>>> editable=False, >>>>>> deletable=True, >>>>>> details=False, >>>>>> maxtextlength=30, >>>>>> csv=False, >>>>>> upload=URL('download'), >>>>>> ) >>>>>> >>>>>> pending_list = db().select(db.data_requests.email) >>>>>> # if a new request has been made, update the database >>>>>> if request.post_vars: >>>>>> >>>>>> while not already_submitted and i <= len(data_requests): >>>>>> already_submitted = [True for row in pending_list if >>>>>> row.email == request.post_vars.email] >>>>>> i += 1 >>>>>> >>>>>> from entergy_scraper import download >>>>>> from mailer import send_request >>>>>> >>>>>> if not already_submitted: >>>>>> # generate token >>>>>> import random, base64, sha >>>>>> token = >>>>>> base64.b64encode(sha.sha(str(random.random())).hexdigest())[:8] >>>>>> db.tokens.insert(token = token, >>>>>> first_name = >>>>>> request.post_vars.first_name, >>>>>> last_name = request.post_vars.last_name, >>>>>> email = request.post_vars.email, >>>>>> company = auth.user.company, >>>>>> ) >>>>>> >>>>>> # send request to user >>>>>> db.scheduler_task.insert(status = 'QUEUED', >>>>>> application_name = >>>>>> request.application+'/default', >>>>>> task_name = 'request', >>>>>> group_name = 'email', >>>>>> function_name = 'send_request', >>>>>> args = '["{0}", "{1}", "{2}", >>>>>> "{3}"]'.format( \ >>>>>> request.post_vars.first, >>>>>> request.post_vars.last, request.post_vars.email, token), >>>>>> vars = '{}', >>>>>> enabled = True, >>>>>> start_time = request.now, >>>>>> timeout = 500, # should take >>>>>> less than 500 secs >>>>>> ) >>>>>> # update data_requests to show that the task is >>>>>> AWAITING_CUSTOMER >>>>>> db.data_requests.insert(first_name = >>>>>> request.post_vars.first_name, >>>>>> last_name = >>>>>> request.post_vars.last_name, >>>>>> email = request.post_vars.email, >>>>>> company = auth.user.company, >>>>>> status = 'AWAITING_CUSTOMER', >>>>>> ) >>>>>> >>>>>> >>>>>> return dict(already_submitted=already_submitted, >>>>>> data_requests=data_requests, pending_list=pending_list) >>>>>> >>>>>> def approve_request(): >>>>>> """ >>>>>> Allows a customer to approve a data request >>>>>> """ >>>>>> submitted = 'submitted' >>>>>> valid_token = 'valid_token' >>>>>> invalid_token = 'invalid_token' >>>>>> >>>>>> >>>>>> # if the user has submitted their data and it's not already in >>>>>> the database, let them know we'll get their data >>>>>> if request.post_vars: >>>>>> status = submitted >>>>>> >>>>>> token_submitted = True if db(db.data_requests.email == >>>>>> request.post_vars.email).select(db.tokens.submitted).first() else False >>>>>> >>>>>> if token_submitted == False: >>>>>> # download data >>>>>> db.data_requests.insert(first_name = >>>>>> request.post_vars.first_name, >>>>>> last_name = >>>>>> request.post_vars.last_name, >>>>>> email = request.post_vars.email, >>>>>> company = auth.user.company, >>>>>> energy_username = >>>>>> request.post_vars.energy_username, >>>>>> energy_password = >>>>>> request.post_vars.energy_password, >>>>>> ) >>>>>> >>>>>> # if no submission of info, try to give them the option to do so >>>>>> else: >>>>>> try: >>>>>> status = valid_token >>>>>> token = request.get_vars.token >>>>>> token_row = db(db.tokens.token == token).select().first() >>>>>> first_name = token_row.first_name >>>>>> last_name = token_row.last_name >>>>>> email = token_row.email >>>>>> except: >>>>>> status = invalid_token >>>>>> >>>>>> if status == submitted or status == invalid_token: >>>>>> return dict(status=status, submitted=submitted, >>>>>> invalid_token=invalid_token, token_submitted=token_submitted) >>>>>> else: >>>>>> return dict(status=status, first_name=first_name, >>>>>> last_name=last_name, email=email, submitted=False, invalid_token=False, >>>>>> token_submitted=False) >>>>>> >>>>>> def user(): >>>>>> """ >>>>>> exposes: >>>>>> http://..../[app]/default/user/login >>>>>> http://..../[app]/default/user/logout >>>>>> http://..../[app]/default/user/register >>>>>> http://..../[app]/default/user/profile >>>>>> http://..../[app]/default/user/retrieve_password >>>>>> http://..../[app]/default/user/change_password >>>>>> http://..../[app]/default/user/bulk_register >>>>>> use @auth.requires_login() >>>>>> @auth.requires_membership('group name') >>>>>> @auth.requires_permission('read','table name',record_id) >>>>>> to decorate functions that need access control >>>>>> also notice there is http://..../[app]/appadmin/manage/auth to >>>>>> allow administrator to manage users >>>>>> """ >>>>>> return dict(form=auth()) >>>>>> >>>>>> @cache.action() >>>>>> def download(): >>>>>> """ >>>>>> allows downloading of uploaded files >>>>>> http://..../[app]/default/download/[filename] >>>>>> """ >>>>>> return response.download(request, db) >>>>>> >>>>>> def call(): >>>>>> """ >>>>>> exposes services. for example: >>>>>> http://..../[app]/default/call/jsonrpc >>>>>> decorate with @services.jsonrpc the functions to expose >>>>>> supports xml, json, xmlrpc, jsonrpc, amfrpc, rss, csv >>>>>> """ >>>>>> return service() >>>>>> >>>>>> >>>>>> >>>>>> On Thursday, June 16, 2016 at 9:36:18 AM UTC-4, Marty Jones wrote: >>>>>> >>>>>>> I uploaded a local application to my DigitalOcean droplet and have >>>>>>> been having a nightmare of a time with the databases. I get this >>>>>>> variety of >>>>>>> errors on various pages: >>>>>>> >>>>>>> *Error 1:* >>>>>>> >>>>>>> Traceback (most recent call last): >>>>>>> File "/home/murtyjones/app/gluon/restricted.py", line 227, in >>>>>>> restricted >>>>>>> exec ccode in environment >>>>>>> File >>>>>>> "/home/murtyjones/app/applications/nolabills/controllers/default.py" >>>>>>> <https://nolabills.com/admin/default/edit/nolabills/controllers/default.py>, >>>>>>> line 230, in <module> >>>>>>> File "/home/murtyjones/app/gluon/globals.py", line 417, in <lambda> >>>>>>> self._caller = lambda f: f() >>>>>>> File "/home/murtyjones/app/gluon/tools.py", line 4241, in f >>>>>>> return action(*a, **b) >>>>>>> File >>>>>>> "/home/murtyjones/app/applications/nolabills/controllers/default.py" >>>>>>> <https://nolabills.com/admin/default/edit/nolabills/controllers/default.py>, >>>>>>> line 73, in dashboard >>>>>>> data_requests = >>>>>>> SQLFORM.grid(db(db.data_requests.company==auth.user.company), >>>>>>> File "/home/murtyjones/app/gluon/packages/dal/pydal/objects.py", line >>>>>>> 91, in __getattr__ >>>>>>> raise AttributeError >>>>>>> AttributeError >>>>>>> >>>>>>> >>>>>>> *Error 2 (trying to apply changes as a user to own profile):* >>>>>>> >>>>>>> Traceback (most recent call last): >>>>>>> File "/home/murtyjones/app/gluon/restricted.py", line 227, in >>>>>>> restricted >>>>>>> exec ccode in environment >>>>>>> File >>>>>>> "/home/murtyjones/app/applications/nolabills/controllers/default.py" >>>>>>> <https://nolabills.com/admin/default/edit/nolabills/controllers/default.py>, >>>>>>> line 230, in <module> >>>>>>> File "/home/murtyjones/app/gluon/globals.py", line 417, in <lambda> >>>>>>> self._caller = lambda f: f() >>>>>>> File >>>>>>> "/home/murtyjones/app/applications/nolabills/controllers/default.py" >>>>>>> <https://nolabills.com/admin/default/edit/nolabills/controllers/default.py>, >>>>>>> line 211, in user >>>>>>> return dict(form=auth()) >>>>>>> File "/home/murtyjones/app/gluon/tools.py", line 1941, in __call__ >>>>>>> return getattr(self, args[0])() >>>>>>> File "/home/murtyjones/app/gluon/tools.py", line 4026, in profile >>>>>>> hideerror=self.settings.hideerror): >>>>>>> File "/home/murtyjones/app/gluon/sqlhtml.py", line 1744, in accepts >>>>>>> self.id_field_name]).update(**fields) >>>>>>> File "/home/murtyjones/app/gluon/packages/dal/pydal/objects.py", line >>>>>>> 2041, in update >>>>>>> ret = db._adapter.update("%s" % table._tablename, self.query, >>>>>>> fields) >>>>>>> File >>>>>>> "/home/murtyjones/app/gluon/packages/dal/pydal/adapters/base.py", line >>>>>>> 519, in update >>>>>>> raise e >>>>>>> OperationalError: attempt to write a readonly database >>>>>>> >>>>>>> >>>>>>> *Error 3 (trying to logout as a user):* >>>>>>> >>>>>>> Traceback (most recent call last): >>>>>>> File "/home/murtyjones/app/gluon/restricted.py", line 227, in >>>>>>> restricted >>>>>>> exec ccode in environment >>>>>>> File >>>>>>> "/home/murtyjones/app/applications/nolabills/controllers/default.py" >>>>>>> <https://nolabills.com/admin/default/edit/nolabills/controllers/default.py>, >>>>>>> line 230, in <module> >>>>>>> File "/home/murtyjones/app/gluon/globals.py", line 417, in <lambda> >>>>>>> self._caller = lambda f: f() >>>>>>> File >>>>>>> "/home/murtyjones/app/applications/nolabills/controllers/default.py" >>>>>>> <https://nolabills.com/admin/default/edit/nolabills/controllers/default.py>, >>>>>>> line 211, in user >>>>>>> return dict(form=auth()) >>>>>>> File "/home/murtyjones/app/gluon/tools.py", line 1941, in __call__ >>>>>>> return getattr(self, args[0])() >>>>>>> File "/home/murtyjones/app/gluon/tools.py", line 3235, in logout >>>>>>> self.log_event(log, self.user) >>>>>>> File "/home/murtyjones/app/gluon/tools.py", line 2530, in log_event >>>>>>> self.table_event().insert(description=str(description % vars), >>>>>>> origin=origin, user_id=user_id) >>>>>>> File "/home/murtyjones/app/gluon/packages/dal/pydal/objects.py", line >>>>>>> 740, in insert >>>>>>> ret = self._db._adapter.insert(self, self._listify(fields)) >>>>>>> File >>>>>>> "/home/murtyjones/app/gluon/packages/dal/pydal/adapters/base.py", line >>>>>>> 482, in insert >>>>>>> raise e >>>>>>> IntegrityError: FOREIGN KEY constraint failed >>>>>>> >>>>>>> >>>>>>> *db.py* >>>>>>> ## app configuration made easy. Look inside private/appconfig.ini >>>>>>> from gluon.contrib.appconfig import AppConfig >>>>>>> ## import current for current.db = db line >>>>>>> from gluon import current >>>>>>> >>>>>>> ## once in production, remove reload=True to gain full speed >>>>>>> myconf = AppConfig(reload=True) >>>>>>> >>>>>>> ## if NOT running on Google App Engine use SQLite or other DB >>>>>>> db = DAL(myconf.take('db.uri'), >>>>>>> pool_size=myconf.take('db.pool_size', cast=int), migrate_enabled = >>>>>>> myconf.get('db.migrate'), check_reserved=['all']) >>>>>>> >>>>>>> ## define current.db for module usage >>>>>>> current.db = db >>>>>>> >>>>>>> ## by default give a view/generic.extension to all actions from >>>>>>> localhost >>>>>>> ## none otherwise. a pattern can be 'controller/function.extension' >>>>>>> response.generic_patterns = ['*'] if request.is_local else [] >>>>>>> ## choose a style for forms >>>>>>> response.formstyle = myconf.take('forms.formstyle') # or >>>>>>> 'bootstrap3_stacked' or 'bootstrap2' or other >>>>>>> response.form_label_separator = myconf.take('forms.separator') >>>>>>> >>>>>>> from gluon.tools import Auth, Service, PluginManager >>>>>>> >>>>>>> auth = Auth(db) >>>>>>> service = Service() >>>>>>> plugins = PluginManager() >>>>>>> >>>>>>> auth.settings.extra_fields['auth_user']= [ >>>>>>> Field('company'), >>>>>>> ] >>>>>>> >>>>>>> ## create all tables needed by auth if not custom tables >>>>>>> auth.define_tables(username=False, signature=False, migrate=True, >>>>>>> fake_migrate=True) >>>>>>> >>>>>>> ## configure email >>>>>>> mail = auth.settings.mailer >>>>>>> mail.settings.server = 'smtp.gmail.com' >>>>>>> mail.settings.sender = 'em...@gmail.com' >>>>>>> mail.settings.login = 'em...@gmail.com:password' >>>>>>> >>>>>>> ## configure auth policy >>>>>>> auth.settings.registration_requires_verification = True >>>>>>> auth.settings.registration_requires_approval = True >>>>>>> auth.settings.reset_password_requires_verification = True >>>>>>> >>>>>>> ## after defining tables, uncomment below to enable auditing >>>>>>> # auth.enable_record_versioning(db) >>>>>>> >>>>>>> >>>>>>> ## create list of companies for which this is available >>>>>>> db.define_table('company_info', >>>>>>> Field('name'), >>>>>>> Field('street_address'), >>>>>>> ) >>>>>>> >>>>>>> ## create a table for the queue of not yet fulfilled data requests >>>>>>> db.define_table('data_requests', >>>>>>> Field('first_name'), >>>>>>> Field('last_name'), >>>>>>> Field('entergy_username'), >>>>>>> Field('entergy_password'), >>>>>>> Field('email'), >>>>>>> Field('company'), >>>>>>> Field('status', default='QUEUED'), >>>>>>> Field('runs', 'integer', default=0), >>>>>>> Field('bill_1', 'upload', uploadfield='bill_1_file'), >>>>>>> Field('bill_1_file', 'blob'), >>>>>>> ) >>>>>>> >>>>>>> >>>>>>> ## create a table for generating tokens >>>>>>> db.define_table('tokens', >>>>>>> Field('first_name'), >>>>>>> Field('last_name'), >>>>>>> Field('email'), >>>>>>> Field('company'), >>>>>>> Field('token'), >>>>>>> Field('submitted', default=False), >>>>>>> ) >>>>>>> >>>>>>> >>>>>>> >>>>>>> *sql.log* >>>>>>> timestamp: 2016-06-15T14:20:52.811948 >>>>>>> CREATE TABLE auth_user( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> first_name CHAR(128), >>>>>>> last_name CHAR(128), >>>>>>> email CHAR(512), >>>>>>> password CHAR(512), >>>>>>> registration_key CHAR(512), >>>>>>> reset_password_key CHAR(512), >>>>>>> registration_id CHAR(512) >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:20:52.856816 >>>>>>> CREATE TABLE auth_group( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> role CHAR(512), >>>>>>> description TEXT >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:20:52.899975 >>>>>>> CREATE TABLE auth_membership( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> user_id INTEGER REFERENCES auth_user (id) ON DELETE CASCADE , >>>>>>> group_id INTEGER REFERENCES auth_group (id) ON DELETE CASCADE >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:20:53.040386 >>>>>>> CREATE TABLE auth_permission( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> group_id INTEGER REFERENCES auth_group (id) ON DELETE CASCADE , >>>>>>> name CHAR(512), >>>>>>> table_name CHAR(512), >>>>>>> record_id INTEGER >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:20:53.092848 >>>>>>> CREATE TABLE auth_event( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> time_stamp TIMESTAMP, >>>>>>> client_ip CHAR(512), >>>>>>> user_id INTEGER REFERENCES auth_user (id) ON DELETE CASCADE , >>>>>>> origin CHAR(512), >>>>>>> description TEXT >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:20:53.223004 >>>>>>> CREATE TABLE auth_cas( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> user_id INTEGER REFERENCES auth_user (id) ON DELETE CASCADE , >>>>>>> created_on TIMESTAMP, >>>>>>> service CHAR(512), >>>>>>> ticket CHAR(512), >>>>>>> renew CHAR(1) >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:22:53.166163 >>>>>>> ALTER TABLE auth_user ADD company CHAR(512); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:22:53.554653 >>>>>>> CREATE TABLE company_info( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> name CHAR(512), >>>>>>> street_address CHAR(512) >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:22:53.604055 >>>>>>> CREATE TABLE data_requests( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> first_name CHAR(512), >>>>>>> last_name CHAR(512), >>>>>>> entergy_username CHAR(512), >>>>>>> entergy_password CHAR(512), >>>>>>> email CHAR(512), >>>>>>> company CHAR(512), >>>>>>> status CHAR(512), >>>>>>> runs INTEGER, >>>>>>> bill_1 CHAR(512), >>>>>>> bill_1_file BLOB >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:22:53.645905 >>>>>>> CREATE TABLE tokens( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> first_name CHAR(512), >>>>>>> last_name CHAR(512), >>>>>>> email CHAR(512), >>>>>>> company CHAR(512), >>>>>>> token CHAR(512), >>>>>>> submitted CHAR(512) >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:22:56.435830 >>>>>>> CREATE TABLE scheduler_task( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> application_name CHAR(512), >>>>>>> task_name CHAR(512), >>>>>>> group_name CHAR(512), >>>>>>> status CHAR(512), >>>>>>> function_name CHAR(512), >>>>>>> uuid CHAR(255) UNIQUE, >>>>>>> args TEXT, >>>>>>> vars TEXT, >>>>>>> enabled CHAR(1), >>>>>>> start_time TIMESTAMP, >>>>>>> next_run_time TIMESTAMP, >>>>>>> stop_time TIMESTAMP, >>>>>>> repeats INTEGER, >>>>>>> retry_failed INTEGER, >>>>>>> period INTEGER, >>>>>>> prevent_drift CHAR(1), >>>>>>> timeout INTEGER, >>>>>>> sync_output INTEGER, >>>>>>> times_run INTEGER, >>>>>>> times_failed INTEGER, >>>>>>> last_run_time TIMESTAMP, >>>>>>> assigned_worker_name CHAR(512) >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:22:56.501649 >>>>>>> CREATE TABLE scheduler_run( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> task_id INTEGER REFERENCES scheduler_task (id) ON DELETE CASCADE >>>>>>> , >>>>>>> status CHAR(512), >>>>>>> start_time TIMESTAMP, >>>>>>> stop_time TIMESTAMP, >>>>>>> run_output TEXT, >>>>>>> run_result TEXT, >>>>>>> traceback TEXT, >>>>>>> worker_name CHAR(512) >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:22:56.546304 >>>>>>> CREATE TABLE scheduler_worker( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> worker_name CHAR(255) UNIQUE, >>>>>>> first_heartbeat TIMESTAMP, >>>>>>> last_heartbeat TIMESTAMP, >>>>>>> status CHAR(512), >>>>>>> is_ticker CHAR(1), >>>>>>> group_names TEXT, >>>>>>> worker_stats TEXT >>>>>>> ); >>>>>>> success! >>>>>>> timestamp: 2016-06-15T14:22:56.589493 >>>>>>> CREATE TABLE scheduler_task_deps( >>>>>>> id INTEGER PRIMARY KEY AUTOINCREMENT, >>>>>>> job_name CHAR(512), >>>>>>> task_parent INTEGER, >>>>>>> task_child INTEGER REFERENCES scheduler_task (id) ON DELETE >>>>>>> CASCADE , >>>>>>> can_visit CHAR(1) >>>>>>> ); >>>>>>> success! >>>>>>> >>>>>>> No idea where to even start with this and would appreciate help. >>>>>>> >>>>>>> -- >>>>>> Resources: >>>>>> - http://web2py.com >>>>>> - http://web2py.com/book (Documentation) >>>>>> - http://github.com/web2py/web2py (Source code) >>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "web2py-users" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to web2py+un...@googlegroups.com. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to web2py+un...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web2py+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
