[midPoint] scriptedsql example

[Frigerio, Joshua]

Ah, Ok. I guess I was assuming that Midpoint would have to import it as a
date in order to use the value as a date? (ie, so that rules can be made
that depend on date values).
Is that not the case?  Can I import them as strings and Midpoint will
still be able to use them as dates?


-----Original Message-----
From: midPoint <midpoint-bounces at lists.evolveum.com> on behalf of
František Dvořák <valtri at civ.zcu.cz>
Reply-To: midPoint General Discussion <midpoint at lists.evolveum.com>
Date: Tuesday, August 14, 2018 at 11:49 AM
To: midPoint General Discussion <midpoint at lists.evolveum.com>
Subject: Re: [midPoint] scriptedsql example

>Hello,
>
>Frigerio, Joshua píše v Út 14. 08. 2018 v 14:23 +0000:
>> Hey, can anyone throw me a rope.  How do I get a scriptedsql resource
>> to
>> read the “datetime” type as a date into Midpoint?
>> I tried setting “All native” to true.  No help.
>> I keep getting the same error:
>> 
>> 	"Attribute 'birth' type 'class java.sql.Timestamp' is not
>> supported.’"
>> 
>
>As I understand, ConnId framework doesn't support date types. It needs
>to be converted to Long or String inside the SQL groovy script.
>
>But there are exciting plans in midPoint 3.9 about newer ConnId and
>native date types support:
>
>https://wiki.evolveum.com/display/midPoint/Release+3.9+-+PLANNED#Release3.
>9-PLANNED-Changeswithrespecttoversion3.8
>
>  Frantisek
>
>> Thanks.
>> 
>> 
>> -----Original Message-----
>> From: midPoint <midpoint-bounces at lists.evolveum.com> on behalf of joe
>> schmoe <joshua at uic.edu>
>> Reply-To: midPoint General Discussion <midpoint at lists.evolveum.com>
>> Date: Friday, August 3, 2018 at 8:21 PM
>> To: midPoint General Discussion <midpoint at lists.evolveum.com>
>> Subject: Re: [midPoint] scriptedsql example
>> 
>> > > 
>> > > If you don't want to handle this date as a real date, just
>> > > convert it to
>> > > string using mysql cast function:
>> > 
>> > I want it to remain a date.
>> > I figured in the SchemaScript.groovy, I’d change it to tell
>> > Midpoint it’s
>> > a date, using this line:
>> > 
>> > account.addAttributeInfo(AttributeInfoBuilder.build("birthdate",
>> > String.class));
>> > 
>> > But nothing I change it to matters, same error every time:
>> > "Attribute
>> > 'birthdate' type 'class java.sql.Timestamp' is not supported.”.  :-
>> > (
>> > 
>> > Or am I going about it wrong? How do I get it to see that datetime
>> > field
>> > as a datetime field?
>> > 
>> > 
>> > 
>> > > 
>> > > select cast(timestamp as char) as timestamp
>> > > 
>> > > 
>> > > W dniu 03.08.2018 o 21:27, Frigerio, Joshua pisze:
>> > > > > You have:
>> > > > > sql.eachRow("SELECT name,timestamp,id,notes,birthdate,netid
>> > > > > FROM
>> > > > > person "
>> > > > > + where, {result.add([__UID__:it.id, __NAME__:it.netid,  ])}
>> > > > > );
>> > > > > 
>> > > > > Should be:
>> > > > > sql.eachRow("SELECT name,timestamp,id,notes,birthdate,netid
>> > > > > FROM
>> > > > > person "
>> > > > > + where, {result.add([__UID__:it.id, __NAME__:it.netid,
>> > > > > notes:it.notes,
>> > > > > birthdate:it.birthdate])} );
>> > > > 
>> > > > Ug, that was right there in the example too, somehow I missed
>> > > > thatŠ.
>> > > > Thanks!
>> > > > 
>> > > > Although it doesn¹t work for date fields (datetime or timestamp
>> > > > mysql
>> > > > types). If I try to add the ³timestamp² field or the
>> > > > ³birthdate" field,
>> > > > it
>> > > > says, ³Got unexpected exception:
>> > > > java.lang.IllegalArgumentException:
>> > > > Attribute 'birthdate' type 'class java.sql.Timestamp' is not
>> > > > supported."
>> > > > In the schema groovy script, I told it to treat it as a
>> > > > String.class,
>> > > > but
>> > > > it doesn¹t work anyway. :-(
>> > > > 
>> > > > _______________________________________________
>> > > > midPoint mailing list
>> > > > midPoint at lists.evolveum.com
>> > > > http://lists.evolveum.com/mailman/listinfo/midpoint
>> > > 
>> > > -- 
>> > > Wojciech Staszewski
>> > > Administrator Systemów Sieciowych
>> > > tel. kom: 663 680 236
>> > > www.diagnostyka.pl
>> > > Diagnostyka Sp. z o. o.
>> > > ul. Prof. M. Życzkowskiego 16, 31-864 Kraków
>> > > Numer KRS: 0000381559 (Sąd Rejonowy dla Krakowa-Śródmieścia w
>> > > Krakowie,
>> > > XI Wydział Gospodarczy KRS)
>> > > NIP: 675-12-65-009; REGON: 356366975
>> > > Kapitał zakładowy: 33 756 500 zł.
>> > > 
>> > > Pomyśl o środowisku zanim wydrukujesz ten e-mail.
>> > > 
>> > > _______________________________________________
>> > > midPoint mailing list
>> > > midPoint at lists.evolveum.com
>> > > http://lists.evolveum.com/mailman/listinfo/midpoint
>> > 
>> > _______________________________________________
>> > midPoint mailing list
>> > midPoint at lists.evolveum.com
>> > http://lists.evolveum.com/mailman/listinfo/midpoint
>> 
>> _______________________________________________
>> midPoint mailing list
>> midPoint at lists.evolveum.com
>> http://lists.evolveum.com/mailman/listinfo/midpoint
>_______________________________________________
>midPoint mailing list
>midPoint at lists.evolveum.com
>http://lists.evolveum.com/mailman/listinfo/midpoint