If all the tables you define in the shell will be pre-existing, use
DAL(..., migrate_enabled=False), which will prevent all migrations. If you
only need to prevent migrations on a per table basis, then do
db.define_table(..., migrate=False).
Anthony
On Tuesday, March 29, 2016 at 5:28:14 PM UTC-4, Aman Bindal wrote:
>
> Hi,
> I need to access web2py sqlite database from python.
> So, I wrote a python code like this
>
> >> from pydal import DAL, Field
> >> db = DAL('sqlite://storage.sqlite')
> >> print db.tables
> []
> >> db.define_table(... Already existing table,....)
> it is showing an error of sqlite3.OperationalError: table Account_Details
> already exists
>
> Please don't print this e-mail unless you really need to.
>
> Disclaimer:
> "This communication (including any accompanying documents) is intended
> only for the use of the addressee(s) and contains PRIVATE AND CONFIDENTIAL
> information. Unauthorized reading, dissemination, distribution or copying
> of this communication is prohibited. If you have received this
> communication in error, please return the email to the sender promptly and
> delete the original communication.
> Please be informed that any review, dissemination, distribution, or
> copying of this message is strictly prohibited, unless stated.The sender
> confirms that Creditas Solutions shall not be responsible if this email
> message is used for any indecent, unsolicited or illegal purposes, which
> are in violation of any existing laws and the same shall solely be the
> responsibility of the sender and that Creditas Solutions shall at all times
> be indemnified of any civil and/ or criminal liabilities or consequences
> thereof.
> To the contrary, any opinions or comments are personal to the writer and
> do not represent the official view of the company. In case where it
> represents our official view, it needs to be re-validated and is subject to
> the terms of our engagement. Thank you for your co-operation.”
>
--
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/d/optout.
