Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of mjpearson@gmail.com
 designates 209.85.221.192 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=qnCppJW9K3X92nDrGr2pYrD9/FU3Q3awfjBazSP3ihK35zeX8mG6/1VxsWX8bTA/eQ
         6McpJjnmNNkd0Y9Q9Y6ACHs/G+1JhXWmeUNvFVgsbumbKuvt0SOTT6hqAe6a3RYZpF3/
         kp34IfevBj8NofPraenwvD+aohxd/JPIfko5Y=
MIME-Version: 1.0
In-Reply-To: <n2w759d8ad1004060149hb7d6c46fi2fb4a41c53a98257@mail.gmail.com>
References: <n2w759d8ad1004060149hb7d6c46fi2fb4a41c53a98257@mail.gmail.com>
Date: Tue, 6 Apr 2010 19:12:25 +1000
Message-ID: <m2we1611e01004060212sb1af2b19p98246c4167dc97e3@mail.gmail.com>
Subject: Re: how to store list data in Apache Cassndra ?
From: Michael Pearson <mjpearson@gmail.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Column Families are keyed attribute/value pairs, your 'girls' column
will need to be serialised on save, and deserialiased on load so that
it can treated as your intended array.  Pickle will do this for you
(http://docs.python.org/library/pickle.html)

eg:

 import pycassa
 import pickle
 client =3D pycassa.connect()
 cf =3D pycassa.ColumnFamily(client, 'mygame', 'user')

 key =3D '1234567890'
 value =3D {
     'name': 'Lee Li',
     'age'; '21',
     'girls': pickle.dumps(['java', 'actionscript', 'python'])
 }

cf.insert(key, value)

hope that helps

-michael


On Tue, Apr 6, 2010 at 6:49 PM, Shuge Lee <shuge.lee@gmail.com> wrote:
> Dear firends:
>
> how to store list data in Apache Cassndra ?
>
> For example:
> user['lee'] =3D {
> =A0=A0 =A0'name': 'lee',
> =A0=A0 =A0'age'; '21',
> =A0=A0 =A0'girls': ['java', 'actionscript', 'python'],
> }
> Notice key `gils`
>
> I using pycassa (a python lib of cassandra)
>
> import pycassa
> client =3D pycassa.connect()
> cf =3D pycassa.ColumnFamily(client, 'mygame', 'user')
>
> key =3D '1234567890'
> value =3D {
> =A0=A0 =A0'name': 'Lee Li',
>
> =A0=A0 =A0'age'; '21',
> =A0=A0 =A0'girls': ['java', 'actionscript', 'python'],
> }
>
> cf.insert(key, value)
>
>
> Oops, get error while save a `value` like above.
>
> So, how to store list data in Apache Cassndra ?
>
>
> Thanks for reply.
>
>
>
>
> --
> Shuge Lee | Lee Li
>