Submitted. https://github.com/web2py/pydal/issues/322
On Tuesday, December 29, 2015 at 3:18:49 AM UTC-8, Niphlod wrote: > > if it fixes all issues, open a bug on pydal and it'll get merged. > > On Monday, December 28, 2015 at 9:57:52 PM UTC+1, Michael Messmer wrote: >> >> @Niphlod @Massimo >> >> Is what i did a correct fix and is this something that needs to be >> corrected here >> https://github.com/web2py/pydal/blob/master/pydal/adapters/oracle.py ? >> >> On Monday, December 28, 2015 at 12:38:13 PM UTC-8, Michael Messmer wrote: >>> >>> I looked at the other Adapter Modules for that "Reference()" >>> >>> "web2py/gluon/packages/dal/pydal/adapters/mongo.py" >>> >>> had it and it also had: >>> >>> from "..helpers.classes import SQLCustomType, SQLALL, Reference" >>> >>> So I added this to the following to >>> "web2py/gluon/packages/dal/pydal/adapters/oracle.py" >>> "..helpers.classes import Reference" >>> >>> It works >>> >>> On Monday, December 28, 2015 at 10:29:17 AM UTC-8, Michael Messmer wrote: >>>> >>>> ok, so. I tried adding a user record and now im getting this: >>>> >>>> Traceback (most recent call last): >>>> File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted >>>> exec ccode in environment >>>> File "/opt/www-data/web2py/applications/test/controllers/appadmin.py" >>>> <https://xnvbase00245.corp.costco.com/admin/default/edit/test/controllers/appadmin.py>, >>>> line 703, in <module> >>>> File "/opt/www-data/web2py/gluon/globals.py", line 412, in <lambda> >>>> self._caller = lambda f: f() >>>> File "/opt/www-data/web2py/applications/test/controllers/appadmin.py" >>>> <https://xnvbase00245.corp.costco.com/admin/default/edit/test/controllers/appadmin.py>, >>>> line 151, in insert >>>> if form.accepts(request.vars, session): >>>> File "/opt/www-data/web2py/gluon/sqlhtml.py", line 1725, in accepts >>>> self.vars.id = self.table.insert(**fields) >>>> File "/opt/www-data/web2py/gluon/packages/dal/pydal/objects.py", line >>>> 728, in insert >>>> ret = self._db._adapter.insert(self, self._listify(fields)) >>>> File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", >>>> line 233, in insert >>>> rid = Reference(id) >>>> NameError: global name 'Reference' is not defined >>>> >>>> >>>> Any Ideas? >>>> >>>> >>>> On Monday, December 28, 2015 at 10:17:46 AM UTC-8, Michael Messmer >>>> wrote: >>>>> >>>>> MAGIC: >>>>> >>>>> cursor.execute("DROP SEQUENCE AUTH_USER_SEQUENCE") >>>>> cursor.execute("DROP SEQUENCE AUTH_GROUP_SEQUENCE") >>>>> cursor.execute("DROP SEQUENCE AUTH_MEMBERSHIP_SEQUENCE") >>>>> cursor.execute("DROP SEQUENCE AUTH_PERMISSION_SEQUENCE") >>>>> cursor.execute("DROP SEQUENCE AUTH_EVENT_SEQUENCE") >>>>> cursor.execute("DROP SEQUENCE AUTH_CAS_SEQUENCE") >>>>> >>>>> and now I have: >>>>> >>>>> Welcome to web2py! >>>>> >>>>> How did you get here? >>>>> -My answer: >>>>> --Gray Hairs and not giving up and asking for help until I figured >>>>> this stuff out!!!!!! >>>>> >>>>> Thank-you Everyone!!!!! >>>>> >>>>> Next life lesson. Understanding Linux Permissions and global >>>>> variables. >>>>> >>>>> Ill post my install script after I test on a totally blank non-prod >>>>> provisioned server in my env. >>>>> >>>>> On Monday, December 28, 2015 at 10:11:53 AM UTC-8, Michael Messmer >>>>> wrote: >>>>>> >>>>>> Alright it worked for blah: >>>>>> >>>>>> cursor.execute("DROP SEQUENCE BLAH_SEQUENCE") >>>>>> >>>>>> Going for the rest now. >>>>>> >>>>>> On Monday, December 28, 2015 at 10:09:31 AM UTC-8, Michael Messmer >>>>>> wrote: >>>>>>> >>>>>>> Ahh, I am ULTRA-Newb to db's: >>>>>>> >>>>>>> here is what it returned: >>>>>>> >>>>>>> >>> for row in cursor: >>>>>>> ... print row >>>>>>> ... >>>>>>> ('SYS_C0012098', 'INDEX') >>>>>>> ('SYS_LOB0000092306C00003$$', 'LOB') >>>>>>> ('AUTH_CAS_SEQUENCE', 'SEQUENCE') >>>>>>> ('AUTH_EVENT_SEQUENCE', 'SEQUENCE') >>>>>>> ('AUTH_GROUP_SEQUENCE', 'SEQUENCE') >>>>>>> ('AUTH_MEMBERSHIP_SEQUENCE', 'SEQUENCE') >>>>>>> ('AUTH_PERMISSION_SEQUENCE', 'SEQUENCE') >>>>>>> ('AUTH_USER_SEQUENCE', 'SEQUENCE') >>>>>>> ('BLAH_SEQUENCE', 'SEQUENCE') >>>>>>> ('AUTH_USER', 'TABLE') >>>>>>> >>>>>>> >>>>>>> I just googled dropping Objects. Wish me luck. ill report back. >>>>>>> >>>>>>> >>>>>>> On Monday, December 28, 2015 at 9:59:18 AM UTC-8, Dan Feeney wrote: >>>>>>>> >>>>>>>> You can view tables owned by the current user with: >>>>>>>> >>>>>>>> SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME; >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> You can view all objects owned by the current user with: >>>>>>>> >>>>>>>> SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS ORDER BY 2, 1; >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> HTH, >>>>>>>> -Dan >>>>>>>> >>>>>>> -- 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.
