Trying to use databases

[Tomás Acauan Schertel]

Hi there.

I'm having problems to make databasing work (sqlite).
I have a class with this function on it:
def POST():
    i = web.input()
    db.insert('users', name=i.name, email=i.email, password=i.password, groups=i.groups[])

I can't even see the page.
Browser says:

serve.py", line 37
    db.insert('users', name=i.name, email=i.email, password=i.password, groups=i.groups[])
                                                                                        ^
SyntaxError: invalid syntax

What could be wrong?
I checked field names from html page and it's all right.


--
Tomás A. Schertel
----------------------------------------------
Linux Registered User #304838
Arch Linux User
http://www.archlinux-br.org/
----------------------------------------------

[Alice Atlas]

I think you'll want to change "i = web.input()" to "i = web.input(groups=[])", and "groups=i.groups[]" to "groups=i.groups", if I'm understanding the intention correctly. The former change tells web.input that "groups" may have multiple values and should be given as a list; the latter fixes the syntax error (i.groups[] is not valid python; you just use i.groups to refer to the object attached to the key "groups" in i, whether that's a list or a scalar object).

If you actually have the form variable named "groups[]" in your HTML, you should change it to just "groups".

[Alice Atlas]

[Anand Chitipothu]

2011/10/12 Tomás Acauan Schertel <tsch...@gmail.com>:

> Hi there.
>
> I'm having problems to make databasing work (sqlite).
> I have a class with this function on it:
> def POST():
>     i = web.input()
>     db.insert('users', name=i.name, email=i.email, password=i.password,
> groups=i.groups[])
>
> I can't even see the page.
> Browser says:
>
> serve.py", line 37
>     db.insert('users', name=i.name, email=i.email, password=i.password,
> groups=i.groups[])
>
> ^
> SyntaxError: invalid syntax
>
> What could be wrong?

i.groups[] is not a valid python syntax. You need to do it like this:

i = web.input(groups=[])

db.insert('users', name=i.name, email=i.email, password=i.password,

groups=i.groups)

Anand

[Tomás Acauan Schertel]

Hey Anand. Thanks for your reply.
But I'm still getting error when I submit my form.

<type 'exceptions.TypeError'> at /users/
POST() takes no arguments (1 given)

Thank you.

--
Tomás A. Schertel
----------------------------------------------
Linux Registered User #304838
Arch Linux User
http://www.archlinux-br.org/
----------------------------------------------

--
You received this message because you are subscribed to the Google Groups "web.py" group.
To post to this group, send email to we...@googlegroups.com.
To unsubscribe from this group, send email to webpy+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/webpy?hl=en.

[Ben Corneau]

POST is a member function so you must include self.

def POST(self):

[Tomás Acauan Schertel]

Thank you Ben
The error is gone.

--
Tomás A. Schertel
----------------------------------------------
Linux Registered User #304838
Arch Linux User
http://www.archlinux-br.org/
----------------------------------------------

[Tomás Acauan Schertel]

Hi There, me again.

When I POST data to my db.insert, I get this error message:
Error binding parameter 2 - probably unsupported type

I've tried remove fields that has default values from insertion, but no way to figure how solve this.
I've reviewed my form fields vs batabase fields, but I presume it's all right.
Is there any how I can discover what's wrong??

--
Tomás A. Schertel
----------------------------------------------
Linux Registered User #304838
Arch Linux User
http://www.archlinux-br.org/
----------------------------------------------

[Tomas Schertel]

Just tried changing database from sqlite to mysql and aI got this error:

<class '_mysql_exceptions.OperationalError'> at /users/
(1241, 'Operand should contain 1 column(s)')

I'm sending a form with few fields: name, email, password, an array...
<form action="/users/" method="post">
<fieldset  style="width: 500px; height: 500px">
<legend>Informacoes pessoais:</legend>

<label for="name">Nome:</label>
    <input type="text" name="name" /><br />

<label for="email">Email:</label>
    <input type="text" name="email" /><br />

<label for="password">Senha:</label>
    <input type="password" name="password" /><br /><br />

<fieldset  style="width: 300px; height: 70px">
<legend>Informacoes pessoais:</legend>
<input type="checkbox" name="groups" value="administradores" />Administradores<br />

<input type="checkbox" name="groups" value="operadores" />Operadores<br />

<input type="checkbox" name="groups" value="usuarios" checked/>Usu&aacute;rios<br />
</fieldset>
<br/>
<br />
<input type="checkbox" name="is_active" value="1" />Ativo<br />
<input type="submit" value="Enviar" />

This is my code:
def POST(self):
        i = web.input(groups=[])
        db.insert("users", email = i.email, name = i.name, password = i.password, groups = i.groups)
        raise web.seeother('/users/')

Is there any thing wrong here?

[Tomas Schertel]

Found where was the error.
I removed groups from form (and from db.insert) and it's working.
But how can I work with checkboxes?
Isn't a checkbox (with more than one option) an array?