Thanks, Massimo. That worked.
On Sunday, September 30, 2012 5:33:00 PM UTC-4, Massimo Di Pierro wrote:
>
> Make sure you have the -M and -N options and the tables should be visible.
>
> On Sunday, 30 September 2012 14:26:43 UTC-5, curiouslearn wrote:
>>
>> Hi Massimo,
>>
>> Thanks for replying.
>>
>> I am trying to access tables that were already created from definitions
>> either in the db.py file in the models directory, or the definitions in a
>> controller function. Please see the code below. Do I have to define all the
>> tables from the shell prompt to access them, even when they already exist?
>> If so, do I have to write the whole table definition?
>>
>> I should also mention that I started with welcome app that web2py comes
>> with, changed the folder name and then commented out all the code in db.py
>> in welcome/models before adding the code below.
>>
>> Thanks once again for your help.
>>
>> **** The CODE ****
>> *
>> *
>> *db.py*
>> *
>> *
>> db = DAL('mysql://root:passwd@localhost/ultimatumG')
>>
>>
>> # Table containing teamnames
>> db.define_table('teams',
>> Field('teamname', 'string', length=40, required=True,
>> unique=True, notnull=True),
>> Field('passwd', 'password'),
>> Field('role', 'string', length=20, required=True,
>> default='NA'),
>> format = '%(teamname)s')
>>
>>
>> # Table showing the ask amount of the first mover
>> db.define_table('offerdecisions',
>> Field('round', 'integer'),
>> Field('askamount', 'integer'),
>> Field('payoff', 'integer'),
>> Field('teamname_id', 'reference teams'))
>>
>>
>> # Table accept-reject decisions
>> db.define_table('ardecisions',
>> Field('round', 'integer'),
>> Field('acceptorreject', 'string', length=2),
>> Field('payoff', 'integer'),
>> Field('teamname_id', 'reference teams'),
>> Field('offerer_id', 'reference teams'))
>>
>>
>>
>>
>> # Table containing a list of ultimatum game experiments
>> db.define_table('experimentlist',
>> Field('experimentname', 'string', length=40))
>>
>> In addition to the above tables, the following is created from a
>> controller function.
>>
>> *default.py*
>> *
>> *
>> def createteams():
>> if request.post_vars:
>> experimentname = request.post_vars.experimentname
>> numteams = int(float(request.post_vars.numteams))
>> tablename = "{0}_teams".format(experimentname)
>> migratetablename = "{0}.table".format(tablename)
>> db.define_table(tablename,
>> Field('teamname', 'string', length=40, required=True,
>> unique=True, notnull=True),
>> Field('passwd', 'password'),
>> Field('role', 'string', length=20, required=True,
>> default='NA'),
>> format = '%(teamname)s')
>> teamnames = maketeamnames(numteams)
>> for tname in teamnames:
>> db[tablename].update_or_insert(teamname=tname)
>> return dict()
>>
>>
>>
>> *
>> *
>>
>>
>>
>> On Sunday, September 30, 2012 1:42:48 PM UTC-4, Massimo Di Pierro wrote:
>>>
>>> This works for me:
>>>
>>> $ python web2py.py -S welcome -N
>>> >>> db = DAL()
>>> >>> db.define_table('tablename',Field('name'))
>>> <Table tablename (id,name)>
>>> >>> db.tablename.drop()
>>>
>>> Are you try to drop a table "tablename" that was not defined?
>>>
>>> On Sunday, 30 September 2012 11:55:09 UTC-5, curiouslearn wrote:
>>>>
>>>> Recently I created a simple game in web2py for educational purposes. It
>>>> worked out well, however, for this game I did not make use of a lot of
>>>> functionality available in web2py; especially the DAL. I used MySQLdb and
>>>> raw sql queries to do the job. Based on the recommendations here, I have
>>>> decided to use web2py DAL and other tools provided by web2py to rewrite
>>>> the game and to create other apps using web2py. I have a few questions as
>>>> I
>>>> tried a few things. Before I state those, a million thanks to Massimo for
>>>> creating web2py; and to Anthony and others who have helped me here to get
>>>> out of it when I am stuck.
>>>>
>>>> Questions about DAL
>>>> ------------------------------
>>>>
>>>> (1) If I am using DAL to create tables, is it true that I should not go
>>>> and make changes to the database from mysql prompt?
>>>>
>>>> For example, I created a table using DAL, then went to mysql prompt
>>>> and deleted the table. When I tried to run the code again, I kept getting
>>>> an error saying that "table already exists". I looked up on these forums
>>>> and there were some suggestions about deleting the .table file related to
>>>> that table in the databases folder of the application. I did that and
>>>> still
>>>> kept getting the same error.
>>>>
>>>> (2) In the documentation, there is a suggestion for using
>>>> db.tablename.truncate() for dropping the table.
>>>>
>>>> I tried the following:
>>>>
>>>> (a) Enter "python web2py.py -S applicationname". This gives the
>>>> iPython prompt.
>>>> (b) Enter db = DAL(DAL('mysql://root:mypasswd@localhost/ultimatumG')
>>>>
>>>> At this point, when I enter db.tablename.drop() (where tablename is the
>>>> name of a table in ultimatumG database) I get an error saying :
>>>>
>>>> 'DAL' object has no attribute tablename.
>>>>
>>>> How do I make small changes to database? It appears I cannot do them
>>>> from mysql prompt because that confuses the application and for some
>>>> reason
>>>> I am unable to connect from iPython prompt.
>>>>
>>>> I am using version 2.0.9 (2012-09-13) of web2py.
>>>>
>>>> Thanks for your help.
>>>>
>>>>
--
