Yes you have to when cloning with git, if you don't pyDAL module don't get clone/fresh... You can confirm that, which version of pyDAL you run on, by looking in gluon/packages/dal/pydal/init.py
You should have 16.03 Richard On Thu, Jun 16, 2016 at 12:46 PM, Marty Jones <murtin.jo...@gmail.com> wrote: > 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 <ml.richa...@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...@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+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.
