bugGNU Parallel - build and execute command lines from standard input in parallel - Bugs: bug #45665, --sql save to SQL

 
 

bug #45665: --sql save to SQL

Submitted by:  Ole Tange <tange>
Submitted on:  Fri 31 Jul 2015 04:06:48 AM UTC  
 
Category: NoneSeverity: 1 - Wish
Item Group: NoneStatus: Fixed
Privacy: PublicAssigned to: Ole Tange <tange>
Open/Closed: Closed

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

Sun 03 Jan 2016 11:47:44 PM UTC, comment #4:

Fixed in [f4c20c13].
Except for bug #46803.

Ole Tange <tange>
Project AdministratorIn charge of this item.
Sun 02 Aug 2015 03:35:09 AM UTC, comment #3:

If using --hostgroup --dryrun the Host should be @grp.

Status:

  1. - job done - RunTime set.

1 - running - Starttime gives start time.

>1 - priority

Ole Tange <tange>
Project AdministratorIn charge of this item.
Sat 01 Aug 2015 09:25:54 AM UTC, comment #2:

Sql commands:

create table tbl (with Seq index)

  • Sqlite: CREATE TABLE tbl (Seq BIGINT, y, z); CREATE INDEX tblSeq ON tbl(Seq);

add new record

  • INSERT INTO tbl VALUES(1,13153,'thirteen thousand one hundred fifty three');

Update <table> set <column>=<newval> where seq = <#>;

  • Update tbl set EndTime=123456789.999 where seq = 12345;
Ole Tange <tange>
Project AdministratorIn charge of this item.
Sat 01 Aug 2015 05:55:42 AM UTC, comment #1:

Data types http://wiki.ispirer.com/sqlways/postgresql/data-types/bigint:

Seq: BIGINT, Oracle: NUMBER(19,0)
Host: VARCHAR(255) -- RFC 1035
Starttime: FLOAT(44) -- 44 bit of precision for 9999999999.999
RunTime: FLOAT(44) -- 44 bit of precision for 9999999999.999
Send: BIGINT, Oracle: NUMBER(19,0)
Receive: BIGINT, Oracle: NUMBER(19,0)
Exitval: SMALLINT, Oracle: NUMBER(5,0)
Signal: SMALLINT, Oracle: NUMBER(5,0)
Command: TEXT, Oracle: CLOB, MSSQL: Varchar(max)
stdout: http://wiki.ispirer.com/sqlways/informix/data-types/clob
stderr: See stdout

Unnamed arguments:
V1: See Command
V2: See Command

Named:
name1: See Command
name2: See Command

Ole Tange <tange>
Project AdministratorIn charge of this item.
Fri 31 Jul 2015 04:06:48 AM UTC, original submission:

--sql DBURL should save to DBURL.

Initial version will save --joblog, run-state, stdout and stderr.

Needed: How to create tables in different databases?

Seq: Integer64
Host: String255
Starttime: Float 0.001 .. 9999999999.999
RunTime: Float 0.001 .. 9999999999.999
Send: Integer64
Receive: Integer64
Exitval: Integer16
Signal: Integer16
Command: String8M
stdout: String?M
stderr: String?M

Unnamed arguments:
V1: String8M
V2: String8M

Named:
name1: String8M
name2: String8M

Ole Tange <tange>
Project AdministratorIn charge of this item.

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by tange (Submitted the item)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 3 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Sun 03 Jan 2016 11:47:44 PM UTCtangeStatusNone=>Fixed
      Assigned toNone=>tange
      Open/ClosedOpen=>Closed

    Back to the top


    Powered by Savane 3.1-cleanup1