[web2py] Re: fixing .table appears corrupted on a compiled application

[mostwanted]

Thank you @ Marcelo Huerta, i actually got to look at Fossil, its very 
flexible.

On Tuesday, February 5, 2019 at 6:28:31 PM UTC+2, Marcelo Huerta wrote:
>
>
> El domingo, 3 de febrero de 2019, 18:19:34 (UTC-3), Dave S escribió:
>>
>>
>> Back-ups are the nectar of the gods (nodding toward Greek mythonlogy)
>>
>>

> Versioning systems for code, more so.
>
> Mostwanted, if you don't want to start with something heavy and unwieldy 
> as git, at the very least try Fossil  
>

-- 
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/d/optout.

Re: [web2py] Re: Need to change text Size of the header

[sandeep patel]

@ Arindam,
Lionel says that create a new .css and store in static/css folder and add
that path in the layout.html file. Add that path after bootstrap.css
Even you can directly put a style tag in the layout.html file. Style tag
will be inside the end of the head tag. Change the font size according to
your necessity
You can do this way.





  



  
.nav-item > .nav-link{
font-size: 20px;

} 



Thanks

SP


On Sun, Feb 10, 2019 at 9:46 AM Arindam Dasgupta 
wrote:

> Hi Lionel,
> Thanks for your reply. But I cannot understand how to do that in this case.
> Can you please give me some more details ?
>
> Thanks a lot.
>
>
> Redards,
> Arindam
>
> On Feb 9, 2019 8:02 PM, "Leonel Câmara"  wrote:
>
> The simplest way is to add another css file to your project after
> bootstrap and put the styles there.
>
> --
> 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/d/optout.
>
>
> --
> 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/d/optout.
>

-- 
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/d/optout.

Re: [web2py] Re: Need to change text Size of the header

[Arindam Dasgupta]

Hi Lionel,
Thanks for your reply. But I cannot understand how to do that in this case.
Can you please give me some more details ?

Thanks a lot.


Redards,
Arindam

On Feb 9, 2019 8:02 PM, "Leonel Câmara"  wrote:

The simplest way is to add another css file to your project after bootstrap
and put the styles there.

-- 
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/d/optout.

-- 
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/d/optout.

[web2py] Re: Migrate from sqlite to mysql

[Andrea Fae']

Thank you guys!
I will do a test and let you known.
Thank you for now.


Il giorno sabato 9 febbraio 2019 17:47:53 UTC+1, Ben Lawrence ha scritto:
>
> And turn off lazy-tables until mysql has built all the tables.
>
> On Friday, February 8, 2019 at 5:03:29 PM UTC-8, 黄祥 wrote:
>>
>> - what version of mysql do I have to install to my PC where I have 2.17 
>>> version of web2py? Where can I find?
>>>
>>  
>> in windows env there are mysql and mariadb
>> *ref:*
>> https://downloads.mariadb.org
>> https://dev.mysql.com/downloads/mysql/
>>
>> - is it necessary to install drivers or it is still included in my web2py 
>>> installed by windows installation method?
>>>
>>
>> web2py already ship the mysql driver  
>>
>> - what is the procedure to migrate the db of my application?
>>>
>>
>> better to export and import in csv file
>>
>> *step*:
>> - create database mysql
>> - when web2py using sqlite use export_to_csv_file()
>> - change db uri in private/appconfig.ini from sqlite to mysql 
>> - load web2py app, ensure migrate is true, so that will create the tables 
>> defined in web2py
>> - when web2py using mysql use import_from_csv_file() 
>>
>> *ref:*
>>
>> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Exporting-and-importing-data
>>  
>>
>> another way around is web2py have a scripts/cpdb.py
>> *ref:*
>>
>> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Copy-data-from-one-db-into-another
>>
>> - after migrating, how to install the application using pyrhonanywhere 
>>> site? (I'm just using the app made with SQLite)
>>>
>>
>> *local*
>> - export your database using mysqldump
>> - pack your app from web2py admin
>>
>> *pythonanywhere*
>> - login to pythonanywhere, use tab console to import your mysql database
>> - then in web2py admin just Upload and install packed application
>>
>> best regards,
>> stifan
>>
>>

-- 
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/d/optout.

Re: [web2py] Accessing MySQL data without define tables

[Jon Subscripted]

Hi Ben,
Inside my app folder I do have the table defined, but not in my script
(accessing   the db outside web2py).
I thought that the folder path reference solved this (*).
Should i add the define table in my script?
Thanks and regards, Jon.

(*) I guess that’s why .table files are kept even when SQLite is no longer
usted.

El El vie, 8 feb 2019 a las 14:28, Ben Duncan  escribió:

> Did you set up the db_define table for the database in models.
>
> For example, the accounting package I am working on for our Supreme Court
> has and external postgres database.
> From the DDL, I've created, for example, the "ship to code" file (we reuse
> for something else)
>
> -
> db.define_table('ar_ship_code',
> Field('company_number', type='reference company.company_number',
> ondelete='CASCADE'),
> Field('code', type='string', length=10),
> Field('short_desc', type='string', length=20),
> Field('description', type='string', length=255),
> Field('notes', type='text'),
> primarykey=['company_number','code'],
> migrate=False)
>
> ---
>
> For each table you want to access, you will need a "db.define_table" entry
> in the model directory.
>
> Hope this helps
> *Ben Duncan*
> DBA / Chief Software Architect
> Mississippi State Supreme Court
> Electronic Filing Division
>
>
> On Fri, Feb 8, 2019 at 7:17 AM Jon Subscripted 
> wrote:
>
>> Hi everyone,
>> I'm trying to access the data stored in my app db from a different piece
>> of software (apart from my web2py app). But I get an error AttributeError.
>>
>> Based on the manual:
>>
>>
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Using-DAL-without-define-tables
>>
>> I used the code below (from IDLE):
>>
>> import sys
>>
>> sys.path.append(r'C:\Users\Jon\Downloads\web2py_src\web2py\gluon')
>>
>> from gluon import DAL
>>
>> dbpath =
>> r'C:\Users\Jon\Downloads\web2py_src\web2py\applications\xakemate_scratch\databases'
>> problemsuri = 'mysql://root:web2py@localhost/xakemate'
>> pos = 'test_position'
>>
>> db = DAL(problemsuri,folder=dbpath,auto_import=True)
>> query = (db.problem.fen == pos)
>> problem = db(query).select(orderby=db.problem.id).first()
>>
>> I get the following error:
>>
>> Traceback (most recent call last):
>>   File "", line 1, in 
>> query = (dbproblems.problem.fen == posFEN)
>>   File "C:\Python27\lib\site-packages\gluon\dal.py", line 7150, in
>> __getattr__
>> return ogetattr(self, key)
>> AttributeError: 'DAL' object has no attribute 'problem'
>>
>> From what I understood the tables should be auto-imported and thus known
>> to my code. Why is it not finding the table?
>>
>> In addition to that I've got a couple of questions:
>>
>> 1st Should I import PYDAL (from pydal import DAL)  or GLUON.DAL (as I
>> did)?
>>
>> 2nd Even when using the db different from SQLite should we point to
>> "applications/myapp/databases"?
>>
>> Thanks in advance, Jon.
>>
>>
>> 
>>  Libre
>> de virus. www.avast.com
>> 
>> <#m_-6215750885323799383_m_5787271047422858639_m_-5898545075541849496_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>> --
>> 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/d/optout.
>>
> --
> 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/d/optout.
>

-- 
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/d/optout.

[web2py] Re: Migrate from sqlite to mysql

[Ben Lawrence]

And turn off lazy-tables until mysql has built all the tables.

On Friday, February 8, 2019 at 5:03:29 PM UTC-8, 黄祥 wrote:
>
> - what version of mysql do I have to install to my PC where I have 2.17 
>> version of web2py? Where can I find?
>>
>  
> in windows env there are mysql and mariadb
> *ref:*
> https://downloads.mariadb.org
> https://dev.mysql.com/downloads/mysql/
>
> - is it necessary to install drivers or it is still included in my web2py 
>> installed by windows installation method?
>>
>
> web2py already ship the mysql driver  
>
> - what is the procedure to migrate the db of my application?
>>
>
> better to export and import in csv file
>
> *step*:
> - create database mysql
> - when web2py using sqlite use export_to_csv_file()
> - change db uri in private/appconfig.ini from sqlite to mysql 
> - load web2py app, ensure migrate is true, so that will create the tables 
> defined in web2py
> - when web2py using mysql use import_from_csv_file() 
>
> *ref:*
>
> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Exporting-and-importing-data
>  
>
> another way around is web2py have a scripts/cpdb.py
> *ref:*
>
> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Copy-data-from-one-db-into-another
>
> - after migrating, how to install the application using pyrhonanywhere 
>> site? (I'm just using the app made with SQLite)
>>
>
> *local*
> - export your database using mysqldump
> - pack your app from web2py admin
>
> *pythonanywhere*
> - login to pythonanywhere, use tab console to import your mysql database
> - then in web2py admin just Upload and install packed application
>
> best regards,
> stifan
>
>

-- 
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/d/optout.

[web2py] Re: Need to change text Size of the header

[Leonel Câmara]

The simplest way is to add another css file to your project after bootstrap 
and put the styles there.

-- 
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/d/optout.