believe i did clone, but can't remember if i did recursive. should i? i will get a new start and report back
On Thursday, June 16, 2016 at 12:42:43 PM UTC-4, Richard wrote: > > 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 <[email protected] > <javascript:>> 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 <[email protected] >> <javascript:>> 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 <[email protected]> >>>> 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 <[email protected]> >>>>>> 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 = '[email protected]' >>>>>>>> mail.settings.login = '[email protected]: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 [email protected]. >>>>>>> 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 [email protected]. >>>>> 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 [email protected] <javascript:>. >>> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
