On Friday, July 15, 2011 01:36:54 pm John Fabiani wrote:
> Hi,
> Has anyone ever used a postgres temp table as the data source in a bizobj?
>
> I'd like to create a postgres temp table - maybe in the createbizobj()
> then use it as a normal bizobj. But - I'm not sure exactly how I'd set it
> up. Does anyone have any suggestions.
>
> Johnf
It could be much easier. And I have been able to insert over 20,000 records.
1. have a connection
self.Application.addConnectFile("connFile.cnxml")
self.conn = self.Application.getConnectionByName("ConnName")
Then I created a method in MainForm.
self.tempStudentBiz = self.createTempStudentTable(self.conn)
def createTempStudentTable(self, conn):
create_StudenttableStr = """CREATE temporary TABLE tempstudent
(
pkid integer,
referral date,
enrolled date,
fname character varying(25),
lname character varying(50),
address character varying(60),
address2 character varying(60),
city character varying(120),
state_1 character varying(2),
zip character varying(10),
fk_county integer,
homephone character varying(16) DEFAULT '( ) - '::character varying,
cell character varying(20) DEFAULT '( ) - '::character varying,
accept_text boolean DEFAULT false,
fk_cell_carrier integer DEFAULT 0,
email character varying(80),
dvrslic character varying(20),
dvrslicst character varying(2),
born date,
ssn character varying(11),
ethnic_grpid integer DEFAULT 0,
languageid integer,
gender character varying(10) DEFAULT 'Male'::character varying,
longitude character varying(40),
latitude character varying(40),
caseno character varying(13),
ref_no character varying(60),
ref2_no text,
ret_to_court date,
mustenrollby date,
incident_date date,
fk_escourse integer,
fk_escourts integer,
fk_pccode integer DEFAULT 0,
community_tobedeter boolean DEFAULT true,
restitution_tobedeter boolean DEFAULT true,
community_service integer DEFAULT 0,
victim_name character varying(120),
victim_address character varying(100),
victim_address2 character varying(100),
victim_city character varying(80),
victim_zip character varying(15),
victim_state_1 character varying(2),
phone character varying(25),
enroll_comments text,
victim_comments text,
community_comments text
)"""
biz = self.biz = dabo.biz.dBizobj(conn)
biz.execute(create_StudenttableStr)
biz.DataSource = 'tempstudent'
#biz.VirtualFields =
biz.DefaultValues={"referral": datetime.date.today,'born':None,
'gender':'Male'}
biz.new()
return self.biz
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
