Isto nao faça conexões python dentro do gluon ela ja existe. voce tem que
fazer no models de cada aplicação.
ex: web2py\aplications\minhaapp1\model\db.py
import psycopg2
db = DAL('sqlite://storage.db')
db = DAL(' postgres://username:password@localhost/test')
Para cada aplicação uma conexao ou varias conexões se voce mexer na conexao
com o Gluon vc vai estar alterando a conexao global e nao a conexão para
cada aplicação em particular.
Ovidio Marinho Falcao Neto
ITJP.NET.BR
[email protected]
Brasil
Em 28 de outubro de 2013 10:22, Carlynhos77 <[email protected]>escreveu:
> ola, parece q houve alteracoes aqui... estava usando a versao FOR WINDOWS
> e nao SOURCE CODE do web2py, ja troquei
>
> minha tela de administrador ta diferente da imagem q vc me mandou, agora
> apareceu igual a sua...
>
> quando vc diz nao mexer no GLUON, seria nao declarar isso aqui dentro d
> APPSETINGS.PY
>
> from gluon.storage import Storage
> config = Storage(
> db=Storage(),
> mail=Storage(),
> auth=Storage()
> )
>
> log abaixo desse codigo mostrado acima, ainda dentro d APPSENTINGS.PY, eu
> coloquei o codigo q vc me passou...
>
> import psycopg2
> db = DAL('postgres://postgres:123@localhost:5432/saude')
>
>
> apaguei todos os arquivos da pasta DATABASES
>
>
> no arquivo DATABASE.PY tem essa linha
>
> db = DAL(**config.db) mantenho ela?
>
>
> acho q fiz o q me me orientou... segue imagem do meu terminal administrador
>
>
> apos essas atualizacoes, apareceu esse TRACE BACK
>
>
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Traceback (most recent call last
> ):
> File "C:\web2py\gluon\restricted.py", line 217, in restricted
>
> exec ccode in environment
> File "C:/web2py/applications/info_saude/models/datamodel_application.py"
> <http://localhost:8000/admin/default/edit/info_saude/models/datamodel_application.py>,
> line 42, in <module>
>
> auth.define_tables()
> File "C:\web2py\gluon\tools.py", line 1736, in define_tables
>
> format='%(first_name)s %(last_name)s (%(id)s)'))
> File "C:\web2py\gluon\dal.py", line 7935, in define_table
>
> table = self.lazy_define_table(tablename,*fields,**args)
>
> File "C:\web2py\gluon\dal.py", line 7972, in lazy_define_table
>
> polymodel=polymodel)
> File "C:\web2py\gluon\dal.py", line 1002, in create_table
>
> self.create_sequence_and_triggers(query,table)
>
> File "C:\web2py\gluon\dal.py", line 2660, in create_sequence_and_triggers
>
> self.execute(query)
> File "C:\web2py\gluon\dal.py", line 1836, in execute
>
> return self.log_execute(*a, **b)
>
> File "C:\web2py\gluon\dal.py", line 1830, in log_execute
>
> ret = self.cursor.execute(command, *a[1:], **b)
> ProgrammingError: ERRO: nenhum esquema foi selecionado para criá-lo(a)
>
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
>
>
>
> Em segunda-feira, 28 de outubro de 2013 08h44min52s UTC-2, Ovidio Marinho
> escreveu:
>
>> Porque voce nao usa a ORM do web2py, e esta tentando criar o que existe
>> em models, nao mexa na configuração do gluon
>>
>> no seu db.py use no local do sqlite:
>>
>> import psycopg2
>>
>> db = DAL('postgres://usuario:senha@**localhost:5432/meubanco')
>>
>> OBS.: Usuario do Postgresql e senha do postgres.
>>
>>
>>
>>
>>
>>
>> Ovidio Marinho Falcao Neto
>> ITJP.NET.BR
>> [email protected]
>> Brasil
>>
>>
>>
>> Em 27 de outubro de 2013 11:06, Jose Carlos Vicente Pereira <
>> [email protected]> escreveu:
>>
>>> Ola, bom dia... estou tentando conectar meu banco postgresql ao meu
>>> projeto, so q nao consigo.. veja meu codigo detalhado abaixo...
>>>
>>> ------------------------------**------------------------------**
>>> ------------------------------**------------------------------**
>>> --------------------
>>> *no MODELS - "appsettings.py" ta assim*
>>>
>>> from gluon.storage import Storage
>>> config = Storage(
>>> db=Storage(),
>>> mail=Storage(),
>>> auth=Storage()
>>> )
>>>
>>> import psycopg2
>>> #conn = psycopg2.connect(host='**localho**st', user='postgres',
>>> password='123',dbname='saude')
>>> conn = psycopg2.connect("dbname=saude user=postgres")
>>> db = conn.cursor()
>>>
>>> config.mail.sender = "[email protected]"
>>> config.mail.server = "smtp.gmail.com:587" # "smtp.dddd:25"
>>> config.mail.login = "[email protected]:"
>>>
>>> response.title = "INFO-SAÚDE"
>>> response.description = "SAÚDE"
>>>
>>> # glob
>>> response.generic_patterns = ['*']
>>>
>>> *no MODELS "database.py" tem isso, no sqllite isso era usado, acho
>>> q pro postgresql nao sera usado*
>>>
>>> #coding: utf-8
>>>
>>> # conectar ao banco de dados
>>> # setar opcoes da DAL
>>>
>>> db = DAL(**config.db)
>>>
>>>
>>> *no MODELS "datamodel_objects.py" isso foi usado para criar as
>>> tabelas no sqllite, no postgresql ja criei as tabelas*
>>>
>>> db.define_table("cadcidade",
>>> Field("nome", "text", length=128, notnull=True, unique=True),
>>> Field("uf", "text", length=2, notnull=True),
>>> Field("cep", "text", length=8, notnull=True),
>>> Field("cod_ibge", "integer", length=7),
>>> auth.signature,
>>> format="%(nome)s"
>>> )
>>>
>>>
>>> *no CONTROLLERS "bases.py" tem esse codigo pra gerar a grid*
>>> *
>>> *
>>> def list_cidade():
>>> query = db.cadcidade.id > 0
>>> headers = {'cadcidade.nome': 'NOME',
>>> 'cadcidade.uf': 'UF',
>>> 'cadcidade.cep': 'CEP',
>>> 'cadcidade.cod_ibge': 'IBGE' }
>>>
>>> grid = SQLFORM.grid(query=query,
>>> user_signature=False,
>>> paginate=20,
>>> searchable=False,
>>> csv=False,
>>> fields=[db.cadcidade.nome, db.cadcidade.uf, db.cadcidade.cep,
>>> db.cadcidade.cod_ibge],
>>> orderby=db.cadcidade.nome,
>>> headers=headers
>>> )
>>> return dict(grid=grid)
>>>
>>>
>>> dai esse *CONTROLLER* é exibido numa *VIEWS - BASES* -
>>> "list_cidade.html" o codigo ta assim...
>>>
>>> {{extend 'layout.html'}}
>>>
>>> {{block main}}
>>>
>>> <H2 ALIGN=CENTER>
>>> <FONT FACE="MS Mincho" COLOR="blue" SIZE="6"> CIDADES </font>
>>> </H2>
>>>
>>> <div class="alert alert-info">
>>> {{=grid}}
>>> </div>
>>>
>>> {{end}}
>>>
>>>
>>> esse é o caminho q usei, a view ta sendo carregado sem erro, so q ta
>>> ligada no banco DUMMY.DB, acho q se nao tem conexao d banco o aplicativo
>>> gera esse banco automatico...
>>>
>>> o postgresql ta instalado correto, pois abro ele pelo PgAdmin e mexo nas
>>> tabelas sem problemas
>>>
>>> lembrando q usando a conexao do sqllite o projeto funciona sem
>>> problemas...
>>> ------------------------------**------------------------------**
>>> ------------------------------**------------------------------**
>>> ------------------------------**---------------------
>>>
>>> alguem pode me ajudar?
>>>
>>>
>>> --
>>> Resources:
>>> - http://web2py.com
>>> - http://web2py.com/book (Documentation)
>>> - http://github.com/web2py/**web2py
>>> <http://github.com/web2py/web2py>(Source code)
>>> -
>>> https://code.google.com/p/**web2py/issues/list<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/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>> .
>>>
>>
>> --
> 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 [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
