Take a look here:
http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#One-to-many-relation
You will find that you need to set the *format* value for the table leader
just to inform web2py how to represent the record.
So in your example:
db.define_table(‘LEADER’,
Hi there,
Is it possible to access the Web2Py database remotely using a GUI tool?
Web2Py doesn't seem to use the normal instance of mysql installed on the
server - how can I find that instance and connect to it via an SSH tunnel
using the SQL GUIs on my Mac? I don't want to have to write queries
if you're using sqlite, by default the file is stored under the databases/
directory of your app.
On Thursday, December 10, 2015 at 11:41:27 AM UTC+1, Sam Heather wrote:
>
> Hi there,
> Is it possible to access the Web2Py database remotely using a GUI tool?
> Web2Py doesn't seem to use the norm
It's what I'm using right now (I can log with users from both servers) but
I use the same credentials to process the queries that gather datas for my
app (list of users, list of computers,...) and I need to know on which
server the user is authenticated to in order to use the correct information
On Thursday, December 10, 2015 at 3:48:44 AM UTC-5, Massimiliano wrote:
>
> Take a look here:
>
>
> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#One-to-many-relation
>
> You will find that you need to set the *format* value for the table
> leader just to inform
Can you show your Auth setup code. Merely adding auth.signature to a table
should not enable record versioning nor result in deleted records merely
being marked inactive. Rather, you must explicitly enable record
versioning. If you enable record versioning and the versioned table
contains an "i
So, I see 2 options :
1) Define a common user that has the required level of access to both ldap
server so you can query both server doesn't matter which server user are
autheticated to...
2) Use user credentials to access data you need... This is actually is not
actually what ldap_auth is doing, b
I / We will extend the goodies.
On Thursday, December 10, 2015 at 5:54:23 AM UTC+1, Massimo Di Pierro wrote:
>
> This was built by some of my students. It is incomplete but has lots of
> goodies.
>
> On Wednesday, 9 December 2015 14:53:33 UTC-6, Richard D wrote:
>>
>> Hi,
>>
>> Some years ago a
Hi,
I am trying to create a table which accepts log files.
One of the entries that should be unique is log path. No Duplicate entries.
db.define_table('logs_db',
Field('case_num', requires=IS_NOT_EMPTY()),
Field('case_desc',),
Field('log_gen_time',
>From the book:
Notice that requires=... is enforced at the level of forms, required=True
is enforced at the level of the DAL (insert), while notnull, unique and
ondelete are enforced at the level of the database. While they sometimes
may seem redundant, it is important to maintain the distinct
Hi!
It just to help others
I wasted a pair hours to find right matching expression for searching
selected option's *text*-value (not key-value ). It must be like:
selected_opt_text = form.element('[name=my_select_field_name] option[
*selected=selected*]')[0]
just *'... option[selected]'* mat
I have one table in my mysql db with name "users" with this:
id - name - email
1 - luis - exam...@gmail.com
2 - steff - he...@gmail.com
the field email is unique in the DAL
Field('email', 'string', length=255, required=True, notnull=True,
unique=True),
when i try to edit the form, I only
Ok i understand that, but if my service of mysql is SHUTDOWN, i need one
exepction for that! because generate one traceback, and I need handle this,
maybe return one string saying "mysql its shutdown, page 404"
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://
On Thursday, December 10, 2015 at 3:42:09 AM UTC-8, Niphlod wrote:
>
> if you're using sqlite, by default the file is stored under the databases/
> directory of your app.
>
>
And for a shell running on the webserver machine, cd to that directory
allows you to use the standard SQLite3 command li
Thanks for the tip. I'm specifically looking for a GUI, but as far as I can
tell you have to install one on the local server - it can't be done
remotely without downloading the db, editing it, and re-uploading it :(
Kinda a shame - doesn't seem a very scalable way of making small tweaks.
ᐧ
On 10 D
On Thursday, December 10, 2015 at 2:38:23 PM UTC-8, Sam Heather wrote:
>
> Thanks for the tip. I'm specifically looking for a GUI, but as far as I
> can tell you have to install one on the local server - it can't be done
> remotely without downloading the db, editing it, and re-uploading it :(
>
Just the kind of tweaks where I might want to edit a value. I'm trying to
allow that kind of admin access to non-techies who don't know SQL, so the
kind of GUI that allows them to view the database like a spreadsheet (as is
available for MySQL) would ideal. I read I can actually switch Web2PY to
us
On Thursday, December 10, 2015 at 3:03:23 PM UTC-8, Sam Heather wrote:
>
> Just the kind of tweaks where I might want to edit a value. I'm trying to
> allow that kind of admin access to non-techies who don't know SQL, so the
> kind of GUI that allows them to view the database like a spreadsheet
On Thursday, December 10, 2015 at 3:39:07 PM UTC-8, Dave S wrote:
>
> [...]
SQLite3 is a fairly robustly featured DB, but is best suited for small
> databases and development work.
Note that this has to do with scaling, not features. It's built to use a
conventional filesystem, and uses
The purpose of web2py is not actually to build form to
create/update/read/deletet database value?
If you want to connect to another database then the default one that is
definte in application/welcome/models/db.py connection string which should
be sqlite if you don't have change the welcome app, y
Has anyone got any experience with selinux file permissions and web2py?
Somehow my sessions are not writing for the admin app but they are for the
welcome app...
-Mark
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- h
Have you look to the welcome app user?
ls -al
Then
chown -Rf same_welcome_app_user:same_welcome_app_user
Richard
On Thu, Dec 10, 2015 at 7:50 PM, Mark Graves wrote:
> Has anyone got any experience with selinux file permissions and web2py?
>
> Somehow my sessions are not writing for the admin
with ubuntu the default owner for web server content is www-data
Richard
On Thu, Dec 10, 2015 at 8:02 PM, Richard Vézina wrote:
> Have you look to the welcome app user?
>
> ls -al
>
> Then
>
> chown -Rf same_welcome_app_user:same_welcome_app_user
>
> Richard
>
> On Thu, Dec 10, 2015 at 7:50 PM,
Its centos. I'll check that now. Its owned by apache
On Thu, Dec 10, 2015 at 7:04 PM, Richard Vézina wrote:
> with ubuntu the default owner for web server content is www-data
>
> Richard
>
> On Thu, Dec 10, 2015 at 8:02 PM, Richard Vézina <
> ml.richard.vez...@gmail.com> wrote:
>
>> Have you l
Same permissions =(
On Thu, Dec 10, 2015 at 7:05 PM, Mark Graves wrote:
> Its centos. I'll check that now. Its owned by apache
>
> On Thu, Dec 10, 2015 at 7:04 PM, Richard Vézina <
> ml.richard.vez...@gmail.com> wrote:
>
>> with ubuntu the default owner for web server content is www-data
>>
>>
Nop :
ls -Z
Should provide extended attribute : -rw-r--r-- root root
system_u:object_r:etc_t /etc/passwd
Sorry in french :
https://fr.wikipedia.org/wiki/SELinux
I check english one and there where not this example...
Then I don't know how you chage these exented attribute, there surely other
I am trying to change the font-size of forms as they look too small for the
user input. I am only using forms for sign-up/sign-in but would just like
to change them. I am trying to change from user.html but the form font
size won't change. Any help is appreciated!
--
Resources:
- http://web2p
No. By using auth.signature a deleted field is still deleted.
auth.signature simply add extra fields. If you use a signature AND you
auth.enable_record_versioning(db) then records are never deleted because
it keeps all the history.
On Wednesday, 9 December 2015 23:48:45 UTC-6, at wrote:
>
> Th
good catch! Please open a bug report. we aim to make the element(..) args
as compatible as possible to jQuery.
On Thursday, 10 December 2015 14:10:01 UTC-6, Val K wrote:
>
> Hi!
> It just to help others
>
> I wasted a pair hours to find right matching expression for searching
> selected option'
Thanks Anthony.
On Friday, December 11, 2015 at 12:01:41 AM UTC+5:30, Anthony wrote:
>
> From the book:
>
> Notice that requires=... is enforced at the level of forms, required=True
> is enforced at the level of the DAL (insert), while notnull, unique and
> ondelete are enforced at the level of
This way change all SQLFORM.grid, so its not good enough, because i have
more then one SQLFORM.grid, which i want to change.
I was found next
try:
for x in grid.elements('span.buttontext'):
if x.components[0] == "Edit":
x.components[0] = "Custom edit"
ex
31 matches
Mail list logo
