* sabato 20 gennaio 2007, alle 02:57, exhuma.twn wrote :
Sorry,
but I don't understand how create, insert or select data with the array
field in postgres.
I use a composite type in PostgreSQL
fatture=# \d datirim
Composite type public.datirim
Column | Type
+
rim| smallint
hat| time without time zone
hin| time without time zone
hfn| time without time zone
turno | character(1)
in sqlalchemy:
import sqlalchemy as sqa
import re
class _RimType(sqa.types.TypeEngine):
def __init__(self):
pass
def get_col_spec(self):
pass
def convert_bind_param(self, value, engine):
return '('+,.join(value)+')'
def convert_result_value(self, value, engine):
arr = re.sub('[()]','',value).split(',')
return 'Nome %s HAT %s HIN %s HFN %s' % \
(arr[0],arr[1],arr[2],arr[3])
.
_elem_tbl=sqa.Table('elem', _mdata,
sqa.Column('id', sqa.Integer, primary_key=True),
sqa.Column('rim1', _RimType),
sqa.Column('rim2', _RimType),
sqa.Column('tempo', sqa.Time)
)
you can use a similar class for arrays
bye ...
PS sorry for my english ;-)))
--
#include stdio.h
int main(void){char c[]={10,65,110,116,111,110,105,111,32,98,97,114,98,111,110,
101,32,60,104,105,110,100,101,109,105,116,64,116,105,115,99,97,108,105,110,101,
116,46,105,116,62,10,10,0};printf(%s,c);return 0;}
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---