Print

---

Hi Daniel,

right, in dataLoader I prepare schema myself before passing it to
qservAdmin. I'm not sure that you can read schema reliably from a 
file, the files that we have contain lots of comments which you 
probably want to strip away. What I do in dataLoader is first to 
create table in mysql and then run "SHOW CREATE TABLE ..." and 
dump its output to CSS (stripping "CREATE TABLE TableName" part).
I do not really know if something like it can be done inside
qserv-admin.py.

Cheers,
Andy


Daniel L. Wang wrote on 2014-12-17:
> Hello,
> 
> I'm taking a look at validating the arguments for qserv-admin.py, and in
> particular, I've noticed that it ignores the "schemaFile" parameter,
> which means that it doesn't bother loading the schema file, which means
> that all the example *.params files that we have that say "schemaFile:
> ....../something.sql" are including that line as a placeholder.
> 
> I think this is the reason why dataLoader.py stuffs the "schema" option
> manually when invoking qservAdmin, rather than passing a schema file.
> 
> Is this correct? I think this means that I need to add logic for loading
> the schema file in qserv-admin.py .
> 
> DM-370 was supposed to improve handling of default values for
> parameters, but in order to do that, it seems to need a solid base of
> validating parameters in order to do the right thing for defaulting. So,
> the scope is bigger than I thought. I will try to complete it in Dec,
> but not positive anymore.
> 
> -Daniel
> 
> ########################################################################
> Use REPLY-ALL to reply to list
> 
> To unsubscribe from the QSERV-L list, click the following link:
> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1




########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1