Hi, I try to populate database defined below:
db.define_table('t_yeast',
Field('f_gene_id', type='string',
label=T('Gene Id')),
Field('f_oid', type='string',
label=T('Other IDs')),
Field('f_l', type='integer',
label=T('transcript length [codons] - L')),
Field('f_x', type='double',
label=T('transcripts per cell - x')),
Field('f_bs', type='double',
label=T('number of proteins produced from a single transcript
during its lifespan - b')),
Field('f_g', type='double',
label=T('ribosome density in number of ribosomes per 100 codons -
g')),
Field('f_w', type='double',
label=T('number of ribosomes attached to a single transcript -
w')),
Field('f_i', type='double',
label=T('translation initiation time [ms] - I')),
Field('f_a', type='integer',
label=T('total protein abundance - A')),
Field('f_e', type='double',
label=T('translation elongation time [ms] - E')),
Field('f_em', type='double',
label=T('mean codon elongation time [ms] - ē')),
Field('f_m', type='datetime',
label=T('transcript mean lifetime [ms] - m')),
Field('f_gene_desc', type='string',
label=T('Gene Description')),
Field('f_q', type='text',
label=T('FASTA sequence')),
format='%(f_gene_id)s',
migrate=settings.migrate)
db.define_table('t_yeast_archive',db.t_yeast,Field('current_record','reference
t_yeast',readable=False,writable=False))
with following data from csv file:
"t_yeast.id","t_yeast.f_gene_id","t_yeast.f_l","t_yeast.f_x","t_yeast.f_bs","t_yeast.f_g","t_yeast.f_w","t_yeast.f_i","t_yeast.f_a","t_yeast.f_e","t_yeast.f_em","t_yeast.f_m","t_yeast.f_gene_desc","t_yeast.f_q","t_yeast.f_oid"
"1000","YAL001C",1161,1.3,89,0.491,5.7,49.477,,282.084,243,1:13:21,"Largest
of six subunits of the RNA polymerase III transcription initiation factor
complex (TFIIIC); part of the TauB domain of TFIIIC that binds DNA at the
BoxB promoter sites of tRNA and similar genes; cooperates with Tfc6p in DNA
binding","ATG","TFC3 SGDID:S000000001 Verified ORF"
"1001","YAL002W",1275,0.4,149.6,0.715,9.12,34.276,,312.664,245.2,1:25:28,"Membrane-associated
protein that interacts with Vps21p to facilitate soluble vacuolar protein
localization; component of the CORVET complex; required for localization
and trafficking of the CPY sorting receptor; contains RING finger
motif","ATG","VPS8 SGDID:S000000002 Verified ORF"
I get information "data uploaded" but nothing happens.
Any help, please?
best regards,
Marian
