I'm sorry I didn't have time to look at the script...
I try to look at it in the near future.
Jonhy
2010/5/22 Alexandre Andrade <alexandrema...@gmail.com>
> I can adapt it on demand to any database for just $100.
> Obviously it will be returned to community too.
>
> I usualy use only mysql, postresql, sqlite and now mongo (nosql).
>
> This are the only one I will maybe do it sometime for free.
>
>
> --
> Atenciosamente
>
> --
> =========================
> Alexandre Andrade
> Hipercenter.com
>
>
>
> 2010/5/21 Nicol van der Merwe <aspersie...@gmail.com>
>
>> Nice! This is super excellent.
>>
>>
>> Just a simple question : will this work on SQL Server?
>>
>>
>> On Fri, May 21, 2010 at 1:37 AM, Alexandre Andrade <
>> alexandrema...@gmail.com> wrote:
>>
>>> Some time ago I talk about to do it.
>>>
>>> Finally I have to do it.
>>>
>>> It can be improved to a form in appadmin, use the model to another db
>>> (postgresql, etc), and generate the file in /models.
>>>
>>> You can see the code below:
>>>
>>> ----------------------------------------------------------
>>>
>>> #!/usr/bin/env python
>>> # -*- coding: utf-8 -*-
>>> #script to generate schemas from dbs
>>> #by Alexandre Andrade alexandrema...@gmail.com
>>> #www.hipercenter.com
>>>
>>> #config it here
>>> passwd="mypass"
>>> user="myuser"
>>> host="localhost"
>>> db = 'mydb'
>>> port='3306'
>>>
>>>
>>> def query(bd,sql):
>>> bd.query(sql)
>>> r = bd.store_result()
>>> rows = r.fetch_row(maxrows=0,how=1)
>>> return rows
>>>
>>> def get_tables():
>>> rows = query(bd,'show tables')
>>> tables=[]
>>> for row in rows:
>>> tables.append(row['Tables_in_'+db])
>>> return tables
>>>
>>> #tables()
>>>
>>> def get_fields(table):
>>> print table
>>> rows = query(bd,'show fields from '+ table)
>>> fields=[]
>>> for row in rows:
>>> #print row
>>> fields.append(row)
>>> return fields
>>>
>>> def field_type(field):
>>> if field['Type'][0:7]=='varchar':
>>> tipo = ",'string'"
>>> elif field['Type'][:8]=='longtext':
>>> tipo = ",'text'"
>>> elif field['Type'][:3]=='int':
>>> tipo = ",'integer'"
>>> elif field['Type'][:4]=='date':
>>> tipo = ",'date'"
>>> elif field['Type'][:7]=='tinyint':
>>> tipo = ",'int'"
>>> elif field['Type'][:11]=='mediumtext':
>>> tipo = ",'text'"
>>> elif field['Type'][:4]=='char':
>>> tipo = ",'text'"
>>> else:
>>> print field['Type'][0:10]
>>> return tipo
>>>
>>> def primarykey(field):
>>> if field['Extra']=='auto_increment':
>>> pk = True
>>> else:
>>> pk = False
>>> return pk
>>>
>>> def define_table(table):
>>> fields = get_fields(table)
>>> result = []
>>> head = 'db = DAL("mysql://'+ user+
>>> ':'+passwd+'@'+host+':'+port+'/'+db+'",
>>> pool_size=10)\r\r'
>>>
>>> line = "db.define_table('"+table+"'"
>>> result.append(line)
>>> for field in fields:
>>> if primarykey(field) == True:
>>> pk =field['Field']
>>> #print pk
>>> tipo = field_type(field)
>>> line = " Field('"+field['Field']+"'"+tipo+")"
>>> result.append(line)
>>> line
>>> try:
>>> line = " primarykey=['"+pk+"']"
>>> result.append(line)
>>> except:
>>> pass
>>> out = ',\r'.join(result)
>>> output = head + out + '\r)'
>>> print output
>>> return output
>>>
>>> def define_db():
>>> tables = get_tables()
>>> r = []
>>> for table in tables:
>>> r.append(define_table(table))
>>> result = '\r \r'.join(r)
>>> return result
>>>
>>> r = define_db()
>>> f = open('db_'+db+'.py', 'w')
>>> f.write(r)
>>> f.close()
>>>
>>> -----------------------------------------------------------
>>>
>>> --
>>> Atenciosamente
>>>
>>> --
>>> =========================
>>> Alexandre Andrade
>>> Hipercenter.com
>>>
>>
>>
>>
>> --
>> Old Gregg: Ever drink baileys from a shoe? Wanna go to a club where people
>> wee on each other? I'm gonna hurt you. I like you. What do ya think of me?
>> Howard:I think your a nice..modern gentleman
>>
>
>
>
>
>
