hollusion

Keybase proof

I hereby claim:

• I am hollusion on github.
• I am erdem (https://keybase.io/erdem) on keybase.
• I have a public key ASBaiRksHrx_Qvt3DQnMNEpOu20SsvS2pkQ8jTsSrlpw5wo

To claim this, I am signing this object:

hollusion

            const updateColumns = self.csv.headers.map(column => {
                const attributes = db.Entgelte.tableAttributes;
                const dataType   = attributes[column].type.constructor.name;

                switch (dataType) {
                    case 'DECIMAL':
                        return `${column} = REPLACE(${column}, ',', '.')`;
                    case 'DATEONLY':
                        return `${column} = STR_TO_DATE(${column}, '%Y%m%d')`;
                    case 'DATE':

hollusion

somePromise
        .then(() => db.sequelize.query(`
            LOAD DATA LOCAL INFILE '${filePath}' INTO TABLE ${tempTable}
            FIELDS TERMINATED BY '${self.csvOptions.separator}'
            LINES TERMINATED BY '${self.csvOptions.newline}'
            IGNORE ${skipHeader} LINES
            (${columnNames.join(',')})
            SET
                importId  = ${self.id},
                createdAt = CURRENT_TIMESTAMP,

hollusion

# returns 27 rows
SELECT * FROM hdl_development.Fall WHERE (Fall.Geburtsjahr LIKE('19%'))

# returns over 13k rows
SELECT DISTINCT * FROM hdl_development.Fall
        LEFT JOIN Entgelte ON Entgelte.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
        LEFT JOIN FAB ON FAB.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
        LEFT JOIN ICD ON ICD.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
        LEFT JOIN OPS ON OPS.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
        WHERE (Fall.Geburtsjahr LIKE('19%'))

hollusion

SELECT * FROM hdl_development.Fall WHERE (Fall.Geburtsjahr LIKE('19%'))

SELECT * FROM hdl_development.Fall
        LEFT JOIN Entgelte ON Entgelte.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
        LEFT JOIN FAB ON FAB.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
        LEFT JOIN ICD ON ICD.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
        LEFT JOIN OPS ON OPS.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
        WHERE (Fall.Geburtsjahr LIKE('19%'))
        GROUP BY Fall.Geburtsjahr

hollusion

    db.Import.findAll({
        attributes: [
            'name',
            [
                db.sequelize.fn(
                    'GROUP_CONCAT',
                    db.sequelize.fn(
                        'DATE_FORMAT',
                        db.sequelize.col('createdAt'),
                        '%d.%m.%y %H:%i:%s'

hollusion

KeyPress event, serial 34, synthetic NO, window 0x6000001,
    root 0x2e, subw 0x0, time 400426603, (144,89), root:(1015,537),
    state 0x1, keycode 249 (keysym 0xfe50, dead_grave), same_screen YES,
    XLookupString gives 1 bytes: (60) "`"
    XmbLookupString gives 0 bytes: 
    XFilterEvent returns: True

hollusion

[861613.877608] nspr-2: sending ioctl 5393 to a partition!
[861613.877661] nspr-2: sending ioctl 5393 to a partition!
[861614.787141] SUP_IOCTL_COOKIE: Version mismatch. Requested: 0x290001  Min: 0x290001  Current: 0x2a0000
[861614.789664] SUP_IOCTL_COOKIE: Version mismatch. Requested: 0x290001  Min: 0x290001  Current: 0x2a0000
[861614.836854] nspr-3: sending ioctl 5393 to a partition!
[861614.836906] nspr-3: sending ioctl 5393 to a partition!
[861622.127865] SUP_IOCTL_COOKIE: Version mismatch. Requested: 0x290001  Min: 0x290001  Current: 0x2a0000
[861622.198158] nspr-2: sending ioctl 5393 to a partition!
[861622.198177] nspr-2: sending ioctl 5393 to a partition!
[861622.257624] SUP_IOCTL_COOKIE: Version mismatch. Requested: 0x290001  Min: 0x290001  Current: 0x2a0000

hollusion

VirtualBox VM 5.2.12 r122591 linux.amd64 (May  9 2018 13:59:46) release log
00:00:02.708714 Log opened 2018-06-18T13:17:57.376081000Z
00:00:02.708715 Build Type: release
00:00:02.708717 OS Product: Linux
00:00:02.708717 OS Release: 4.4.0-127-generic
00:00:02.708718 OS Version: #153-Ubuntu SMP Sat May 19 10:58:46 UTC 2018
00:00:02.708734 DMI Product Name: PowerEdge T30
00:00:02.708738 DMI Product Version: 
00:00:02.708768 Host RAM: 7849MB (7.6GB) total, 6209MB (6.0GB) available
00:00:02.708770 Executable: /usr/lib/virtualbox/VirtualBox

hollusion

VirtualBox VM 5.1.34_Ubuntu r121010 linux.amd64 (Feb  2 2018 12:27:46) release log
00:00:00.141266 Log opened 2018-06-18T12:30:11.108573000Z
00:00:00.141267 Build Type: release
00:00:00.141269 OS Product: Linux
00:00:00.141270 OS Release: 4.4.0-127-generic
00:00:00.141271 OS Version: #153-Ubuntu SMP Sat May 19 10:58:46 UTC 2018
00:00:00.141283 DMI Product Name: PowerEdge T30
00:00:00.141288 DMI Product Version: 
00:00:00.141318 Host RAM: 7849MB (7.6GB) total, 5999MB (5.8GB) available
00:00:00.141320 Executable: /usr/lib/virtualbox/VirtualBox