bugGNU Parallel - Bugs: bug #45665, --sql save to SQL

 
 

bug #45665: --sql save to SQL

Submitter:  Ole Tange <tange>
Submitted:  Fri 31 Jul 2015 04:06:48 AM UTC
   
 
Category:  None Severity:  1 - Wish
Item Group:  None Status:  Fixed
Privacy:  Public Assigned to:  tange
Open/Closed:  Closed
* Mandatory Fields

Add a New Comment Rich Markup
   

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

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

Ole Tange <tange>
Group administrator
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>
Group administrator
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>
Group administrator
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>
Group administrator
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>
Group administrator

 

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

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

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

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 3 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2016-01-03 tange StatusNone Fixed
        Assigned toNone tange
        Open/ClosedOpen Closed

    Back to the top

    Powered by Savane 3.13-3230.
    Corresponding source code