@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.

Reply via email to