Re: [web2py] Re: fake_migrate=True is not working
Hello Clemens, here you are the answers:
- What about your sql.log? I don't have in the databases folder. I tried
with different combinations of migrate and fake_migrate_all but no way
- Do your have direct access to the database (w/o web2py) using this
user/password account? (sorry for that question, but sometimes it's that
easy :-) YES
- Are there any .table files already in your database folder? Yes all
tables are now in the databases folder
My application is now fully functional, I could change one table in the
db_asset.py because maybe with migrate=true and fake_migrate_all=True it
generates the sql.log. What do you think?
Thank you
Il giorno giovedì 27 agosto 2020 10:51:21 UTC+2, Clemens ha scritto:
>
> Hi,
>
> one more distance try: What does your sql.log file say? It's also to be
> found in the databases folder. For example, I can find there entries like:
> timestamp: 2020-08-21T17:53:29.984015
> CREATE TABLE "functionality_attributes"(
> "id" SERIAL PRIMARY KEY,
> ...
> );
> success!
>
> I had a similar problem about 2 years ago. I can't remember exactly the
> problem/solution. But the reason was, that I've tried to switch the uri to
> another database and therefore the .table files were already existing. That
> confuses the system since the tables were already processed in the (old)
> .table files but didn't exist in the (new) database. It's important for the
> .table files that different databases have different "file IDs"
> (db['_uri_hash']) since these are used for .table file naming.
>
> Well then:
>
>- What about your sql.log?
>- Do your have direct access to the database (w/o web2py) using this
>user/password account? (sorry for that question, but sometimes it's that
>easy :-)
>- Are there any .table files already in your database folder?
>
> Since it's fresh new database I would set fake_migrate to false and
> migrate to true.
>
> Best regards,
> Clemens
>
> On Thursday, August 27, 2020 at 9:30:39 AM UTC+2 and...@gmail.com wrote:
>
>> thank you Jim, but I don't understand...
>>
>> If I set
>> migrate=False
>> fake_migrate= True
>>
>> it means that web2py create the .table files without touching the db,
>> isn'it?
>>
>> If I set
>> migrate=True
>> fake_migrate=True
>>
>> It means what exactly?
>>
>> thank you so much
>>
>>
>> Il giorno mercoledì 26 agosto 2020 17:32:09 UTC+2, Jim S ha scritto:
>>
>>> You still have migrate set to False in your appconfig.ini.
>>>
>>> -Jim
>>>
>>> On Wed, Aug 26, 2020 at 10:14 AM Andrea Fae' wrote:
>>>
>> Thank you for your suggestions...Like this (see attaached files)?
but, no way, no .tables created...I don't know why...
Il giorno mercoledì 26 agosto 2020 14:46:05 UTC+2, Jim S ha scritto:
>
> Did you remove the apostrophe at the bottom as well?
>
> I haven't used migrate / fake migrate in the past the way that you are
> implementing.
>
> Are you intentionally trying to set it by table?
>
> For me, on my DAL statement I'd include:
>
> migrate_enabled=myconf.get('db.migrate')
> fake_migrate_all=myconf.get('db.fake_migrate_all')
>
>
> then in appconfig.ini I'd have:
>
> [db]
> uri = mssql4://sa/Web2PyPassword@TS-SQL2016R2/itassetdb
> migrate = True
> fake_migrate_all = True
>
>
>
> Can you try that and see if it helps?
>
> Also, I'd remove all the migrate stuff from auth and all the
> individual tables. I just set it globally, but that may be a personal
> preference kind of thing.
>
> -Jim
>
> On Wednesday, August 26, 2020 at 1:32:13 AM UTC-5, Andrea Fae' wrote:
>>
>> Hello, thank you for your answer.
>> I deleted the character but nothing changes.
>> Best regards
>> Andrea
>>
>> Il giorno lunedì 24 agosto 2020 12:39:47 UTC+2, Clemens ha scritto:
>>>
>>> Hi,
>>>
>>> I'm not very deep in your issue. But opening your appconfig.ini with
>>> my default editor shows that the apostrophe in your authors value could
>>> be
>>> a problem:
>>>
>>> [image: Untitled.jpg]
>>>
>>> Thus, just delete it and have try. If it doesn't change anything,
>>> please let me know and I will have a closer look.
>>>
>>> Best regards
>>> Clemens
>>>
>>>
>>>
>>>
>>> On Monday, August 24, 2020 at 11:18:32 AM UTC+2 and...@gmail.com
>>> wrote:
>>>
Hello, if I chose migrate= False and fake_migrate=True the .tables
in databases folder are not created.
Why?
I'm attaching appconfig.ini and py.db and my custom db db_asset.py
Thank you
>>> --
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
Re: [web2py] Re: fake_migrate=True is not working
Hi,
one more distance try: What does your sql.log file say? It's also to be
found in the databases folder. For example, I can find there entries like:
timestamp: 2020-08-21T17:53:29.984015
CREATE TABLE "functionality_attributes"(
"id" SERIAL PRIMARY KEY,
...
);
success!
I had a similar problem about 2 years ago. I can't remember exactly the
problem/solution. But the reason was, that I've tried to switch the uri to
another database and therefore the .table files were already existing. That
confuses the system since the tables were already processed in the (old)
.table files but didn't exist in the (new) database. It's important for the
.table files that different databases have different "file IDs"
(db['_uri_hash']) since these are used for .table file naming.
Well then:
- What about your sql.log?
- Do your have direct access to the database (w/o web2py) using this
user/password account? (sorry for that question, but sometimes it's that
easy :-)
- Are there any .table files already in your database folder?
Since it's fresh new database I would set fake_migrate to false and migrate
to true.
Best regards,
Clemens
On Thursday, August 27, 2020 at 9:30:39 AM UTC+2 and...@gmail.com wrote:
> thank you Jim, but I don't understand...
>
> If I set
> migrate=False
> fake_migrate= True
>
> it means that web2py create the .table files without touching the db,
> isn'it?
>
> If I set
> migrate=True
> fake_migrate=True
>
> It means what exactly?
>
> thank you so much
>
>
> Il giorno mercoledì 26 agosto 2020 17:32:09 UTC+2, Jim S ha scritto:
>
>> You still have migrate set to False in your appconfig.ini.
>>
>> -Jim
>>
>> On Wed, Aug 26, 2020 at 10:14 AM Andrea Fae' wrote:
>>
> Thank you for your suggestions...Like this (see attaached files)?
>>> but, no way, no .tables created...I don't know why...
>>>
>>> Il giorno mercoledì 26 agosto 2020 14:46:05 UTC+2, Jim S ha scritto:
Did you remove the apostrophe at the bottom as well?
I haven't used migrate / fake migrate in the past the way that you are
implementing.
Are you intentionally trying to set it by table?
For me, on my DAL statement I'd include:
migrate_enabled=myconf.get('db.migrate')
fake_migrate_all=myconf.get('db.fake_migrate_all')
then in appconfig.ini I'd have:
[db]
uri = mssql4://sa/Web2PyPassword@TS-SQL2016R2/itassetdb
migrate = True
fake_migrate_all = True
Can you try that and see if it helps?
Also, I'd remove all the migrate stuff from auth and all the individual
tables. I just set it globally, but that may be a personal preference
kind
of thing.
-Jim
On Wednesday, August 26, 2020 at 1:32:13 AM UTC-5, Andrea Fae' wrote:
>
> Hello, thank you for your answer.
> I deleted the character but nothing changes.
> Best regards
> Andrea
>
> Il giorno lunedì 24 agosto 2020 12:39:47 UTC+2, Clemens ha scritto:
>>
>> Hi,
>>
>> I'm not very deep in your issue. But opening your appconfig.ini with
>> my default editor shows that the apostrophe in your authors value could
>> be
>> a problem:
>>
>> [image: Untitled.jpg]
>>
>> Thus, just delete it and have try. If it doesn't change anything,
>> please let me know and I will have a closer look.
>>
>> Best regards
>> Clemens
>>
>>
>>
>>
>> On Monday, August 24, 2020 at 11:18:32 AM UTC+2 and...@gmail.com
>> wrote:
>>
>>> Hello, if I chose migrate= False and fake_migrate=True the .tables
>>> in databases folder are not created.
>>> Why?
>>> I'm attaching appconfig.ini and py.db and my custom db db_asset.py
>>> Thank you
>>>
>> --
>>> 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 a topic in the
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/web2py/PLIV6cNvRnc/unsubscribe.
>>>
>> To unsubscribe from this group and all its topics, send an email to
>>> web...@googlegroups.com.
>>
>>
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/web2py/e1702e2a-1c5f-4d0b-a27b-67cece00d923o%40googlegroups.com
>>>
>>>
>>> .
>>>
>>
--
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
Re: [web2py] Re: fake_migrate=True is not working
thank you Jim, but I don't understand...
If I set
migrate=False
fake_migrate= True
it means that web2py create the .table files without touching the db,
isn'it?
If I set
migrate=True
fake_migrate=True
It means what exactly?
thank you so much
Il giorno mercoledì 26 agosto 2020 17:32:09 UTC+2, Jim S ha scritto:
>
> You still have migrate set to False in your appconfig.ini.
>
> -Jim
>
> On Wed, Aug 26, 2020 at 10:14 AM Andrea Fae' > wrote:
>
>> Thank you for your suggestions...Like this (see attaached files)?
>> but, no way, no .tables created...I don't know why...
>>
>> Il giorno mercoledì 26 agosto 2020 14:46:05 UTC+2, Jim S ha scritto:
>>>
>>> Did you remove the apostrophe at the bottom as well?
>>>
>>> I haven't used migrate / fake migrate in the past the way that you are
>>> implementing.
>>>
>>> Are you intentionally trying to set it by table?
>>>
>>> For me, on my DAL statement I'd include:
>>>
>>> migrate_enabled=myconf.get('db.migrate')
>>> fake_migrate_all=myconf.get('db.fake_migrate_all')
>>>
>>>
>>> then in appconfig.ini I'd have:
>>>
>>> [db]
>>> uri = mssql4://sa/Web2PyPassword@TS-SQL2016R2/itassetdb
>>> migrate = True
>>> fake_migrate_all = True
>>>
>>>
>>>
>>> Can you try that and see if it helps?
>>>
>>> Also, I'd remove all the migrate stuff from auth and all the individual
>>> tables. I just set it globally, but that may be a personal preference kind
>>> of thing.
>>>
>>> -Jim
>>>
>>> On Wednesday, August 26, 2020 at 1:32:13 AM UTC-5, Andrea Fae' wrote:
Hello, thank you for your answer.
I deleted the character but nothing changes.
Best regards
Andrea
Il giorno lunedì 24 agosto 2020 12:39:47 UTC+2, Clemens ha scritto:
>
> Hi,
>
> I'm not very deep in your issue. But opening your appconfig.ini with
> my default editor shows that the apostrophe in your authors value could
> be
> a problem:
>
> [image: Untitled.jpg]
>
> Thus, just delete it and have try. If it doesn't change anything,
> please let me know and I will have a closer look.
>
> Best regards
> Clemens
>
>
>
>
> On Monday, August 24, 2020 at 11:18:32 AM UTC+2 and...@gmail.com
> wrote:
>
>> Hello, if I chose migrate= False and fake_migrate=True the .tables in
>> databases folder are not created.
>> Why?
>> I'm attaching appconfig.ini and py.db and my custom db db_asset.py
>> Thank you
>>
> --
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/PLIV6cNvRnc/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web...@googlegroups.com .
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/e1702e2a-1c5f-4d0b-a27b-67cece00d923o%40googlegroups.com
>>
>>
>> .
>>
>
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/323ef7e7-47eb-4f2e-bbc4-46eaacc36d54o%40googlegroups.com.
