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 ovidio...@gmail.com Brasil Em 28 de outubro de 2013 10:22, Carlynhos77 <carlynho...@hotmail.com>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 >> ovid...@gmail.com >> Brasil >> >> >> >> Em 27 de outubro de 2013 11:06, Jose Carlos Vicente Pereira < >> carly...@gmail.com> 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 = "alu...@blouweb.com" >>> config.mail.server = "smtp.gmail.com:587" # "smtp.dddd:25" >>> config.mail.login = "alu...@blouweb.com:" >>> >>> 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 web2py+unsubscr...@googlegroups.com. > 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.