July 2016 - Pharo-users - lists.pharo.org

SQLite and sure last_insert_rowid

by Hilaire

Hi guys, In a multi-thread context use of Sqlite, I try to find out how one will fetch securely the automatically last row index of a Primary key. The problem seems to be that between the insert of rows in a table and the moment you request the last row id, you may have another insert from another thread in the same database. In the code bellow, I put the insert and last_insert_rowid() call in a transaction. The returned rowid value is the right one as expected, and now I am wondering if enclosing in a transaction is enought to make the last_insert_rowid() safe. Any trips how you handle this situation? Thanks Hilaire The organisation table is defined as: CREATE TABLE organisation ( idOrg INTEGER PRIMARY KEY, name VARCHAR(30), address TEXT, zipcode INTEGER, city VARCHAR(30), phone VARCHAR(15), email VARCHAR(20) );' The code is as follow: | row res s id | database execute: 'INSERT INTO organisation (name) values (''Pharo consortium'')'. res := database beginTransaction. self assert: res = 0. s := database prepare: 'INSERT INTO organisation (name, address, zipcode, city, phone, email) values (?, ?, ?, ?, ?, ?)'. s at: 1 putString: 'Dupont & co'. s at: 2 putString: '12, rue du pont'. s at: 3 putInteger: 75000. s at: 4 putString: 'Paris'. s at: 5 putString: '0105060708'. s at: 6 putString: 'contact(a)dupont.fr'. s step. s finalize. row := database execute: 'SELECT last_insert_rowid()'. res := database commitTransaction. id := row next at: 'last_insert_rowid()'. row close. self assert: res = 0. self assert: id = 2. -- Dr. Geo http://drgeo.eu

July 16, 2016

Re: Shortcuts for navigation history in Pharo5

by Davide Varvello

Thanks Nicolai, it works. On mac is Cmd+Shift+[ or Cmd+Shift+] I don't know why it is not included in the "Shortcuts description" or in the "Keymap Browser" Cheers Davide Nicolai Hess-3-2 wrote > 2016-07-15 19:21 GMT+02:00 Davide Varvello via Pharo-users < > pharo-users@.pharo >>: > >> >> >> ---------- Weitergeleitete Nachricht ---------- >> From: Davide Varvello < > varvello@ > > >> To: > pharo-users@.pharo >> Cc: >> Date: Fri, 15 Jul 2016 09:37:45 -0700 (PDT) >> Subject: Re: Shortcuts for navigation history in Pharo5 >> Nobody? >> Davide >> > > They just changed to > > $[ meta shift > $] meta shift > > Maybe this shortcuts don't work (for example, on windows with german > keyboard layout, you can not type [ + ctrl or alt) > > You can change them back in > NautilusUI class >> buildHistoryShortcutsOn: > > >> >> >> Pharo Smalltalk Users mailing list wrote >> > Hi Guys,On Pharo4 there was 2 shortcuts to go through navigation >> history: >> > Cmd+[ and Cmd+]Is there something similar in Pharo5? I can't find it. >> > TIADavide >> >> >> >> >> >> -- >> View this message in context: >> http://forum.world.st/Shortcuts-for-navigation-history-in-Pharo5-tp4906689p… >> Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. >> >> >> -- View this message in context: http://forum.world.st/Shortcuts-for-navigation-history-in-Pharo5-tp4906689p… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

July 16, 2016

Re: [Pharo-users] Dynamic visualzation and analysis of tweets

by Arturo Zambrano

Thanks! the code is in SH, of course it needs to be polished before an official release, this is just a report on the advance. On Fri, Jul 15, 2016 at 8:17 PM, Offray Vladimir Luna CÃ¡rdenas < offray.luna(a)mutabit.com> wrote: > Arturo and AgustÃn, > > Seems interesting. Congrats on finishing the thesis and I'll be waiting > for the final text or articles once you have ended the writing. > > I hope to share son some advances on Twitter and Data Visualization > powered by Rossal + GT + Pharo. > > Cheers, > > Offray > > > > On 15/07/16 16:59, Arturo Zambrano wrote: > >> Hi All, >> please check this> >> >> https://youtu.be/VL14jTDvRaY >> >> this is Agustin Meriles's work for his master thesis. We want to share >> this with the community and a big *thank you* for your support... specially >> the Roassal team. >> >> Now the hard time of writing the text comes for Agustin :) >> >> Cheers, >> >> Arturo >> >> > >

July 15, 2016

Re: [Pharo-users] Dynamic visualzation and analysis of tweets

by Offray Vladimir Luna CÃ¡rdenas

Arturo and AgustÃn, Seems interesting. Congrats on finishing the thesis and I'll be waiting for the final text or articles once you have ended the writing. I hope to share son some advances on Twitter and Data Visualization powered by Rossal + GT + Pharo. Cheers, Offray On 15/07/16 16:59, Arturo Zambrano wrote: > Hi All, > please check this> > > https://youtu.be/VL14jTDvRaY > > this is Agustin Meriles's work for his master thesis. We want to > share this with the community and a big *thank you* for your > support... specially the Roassal team. > > Now the hard time of writing the text comes for Agustin :) > > Cheers, > > Arturo >

July 15, 2016

Dynamic visualzation and analysis of tweets

by Arturo Zambrano

Hi All, please check this> https://youtu.be/VL14jTDvRaY this is Agustin Meriles's work for his master thesis. We want to share this with the community and a big *thank you* for your support... specially the Roassal team. Now the hard time of writing the text comes for Agustin :) Cheers, Arturo

July 15, 2016

Re: [Pharo-users] iCal Chronos for Pharo 5 => OSProcess

by Paul DeBruicker

Hi CÃ©drick, I uploaded a new version of the iCal-Core package and iCal-Tests package that should fix most of the issues shown below. I didn't realize I wiped out the #resetAlarms method and also some others with overrides. Hope this gets you on your way Paul -- View this message in context: http://forum.world.st/iCal-Chronos-for-Pharo-5-OSProcess-tp4906567p4906748.… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

July 15, 2016

Re: [Pharo-users] Shortcuts for navigation history in Pharo5

by Nicolai Hess

2016-07-15 19:21 GMT+02:00 Davide Varvello via Pharo-users < pharo-users(a)lists.pharo.org>: > > > ---------- Weitergeleitete Nachricht ---------- > From: Davide Varvello <varvello(a)yahoo.com> > To: pharo-users(a)lists.pharo.org > Cc: > Date: Fri, 15 Jul 2016 09:37:45 -0700 (PDT) > Subject: Re: Shortcuts for navigation history in Pharo5 > Nobody? > Davide > They just changed to $[ meta shift $] meta shift Maybe this shortcuts don't work (for example, on windows with german keyboard layout, you can not type [ + ctrl or alt) You can change them back in NautilusUI class >> buildHistoryShortcutsOn: > > > Pharo Smalltalk Users mailing list wrote > > Hi Guys,On Pharo4 there was 2 shortcuts to go through navigation history: > > Cmd+[ and Cmd+]Is there something similar in Pharo5? I can't find it. > > TIADavide > > > > > > -- > View this message in context: > http://forum.world.st/Shortcuts-for-navigation-history-in-Pharo5-tp4906689p… > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. > > >

July 15, 2016

Re: Shortcuts for navigation history in Pharo5

by Davide Varvello

Nobody? Davide Pharo Smalltalk Users mailing list wrote > Hi Guys,On Pharo4 there was 2 shortcuts to go through navigation history: > Cmd+[ and Cmd+]Is there something similar in Pharo5? I can't find it. > TIADavide -- View this message in context: http://forum.world.st/Shortcuts-for-navigation-history-in-Pharo5-tp4906689p… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

July 15, 2016

Fwd: [vwnc] Publishing an app to apple store : the full script !

by Alexandre Bergel

Hello! Here is a procedure to submit a VisualWorks application on AppStore. Maybe it can be adapted for Pharo? Cheers, Alexandre > Begin forwarded message: > > From: Annick Fron <annick.fron(a)afceurope.com> > Subject: [vwnc] Publishing an app to apple store : the full script ! > Date: July 15, 2016 at 3:30:20 PM GMT+2 > To: vwnc NC <vwnc(a)cs.uiuc.edu> > Cc: Annick Fron <info(a)afceurope.com> > Reply-To: Annick Fron <annick.fron(a)afceurope.com> > > Hi, > > > Besides Maartenâs package to publish on applestore, here is a more condensed procedure describing the process. > > Summary of needed actions to publish an application to applestore > > > Note : You can use the nano editor to edit system files using Â« nano" my file to ensure you stick to pure text format > > - 1) Enroll as a developer on developer.apple.com <https://urldefense.proofpoint.com/v2/url?u=http-3A__developer.apple.com&d=C…> > - 2) Generate certificates : Developer id; 3rd party application installer > - 3) Download certificates together with middle certificates from Apple (to complete the CA chain) > - 4) Check availability of certificates in keychain utility, and avoid certificates duplicated in session and system tabs > - 5) Generate one or more application ids in apple developer web site (in the following the app id will be com.fencingfox.saintgeorges) > > - 6) Copy visual.app in a directory and rename it > - 7) Thin visual and its Frameworks components to architecture i386 > > cd myapp.app/Contents > cd MacOS > lipo visual -thin i386 -output visual > cd ../Frameworks > lipo libcairo.2.dylib -thin i386 -output libcairo.2.dylib > lipo libpixman-1.0.dylib -thin i386 -output libpixman-1.0.dylib > lipo libpng15.0.dylib -thin i386 -output libpng15.0.dylib > > Check it > lipo - info visual > > - 8) Edit myapp.app/Contents/Info.plist . To do that download Xcode, create a workspace, import the file myapp.app. > Modify Bundle identifier with one of the application ids you have crated on Apple Developersâ site, define application category, bundle version without any letter > > > - 9) Edit localizations subdirectories under Contents/Resources/English.lproj (resp. French.lproj), etc. Modify the MainMenu.nib under Xcode. > > - 10) Modify the icons MainIcons.icns in Contents/Resources using various tools. In case of problems you may use the following trick : > ICON_OLD=icon.icns > ICON_NEW=icon_new.icns > iconutil -c iconset -o "${ICON_OLD%.icns}.iconset" "$ICON_OLD" > iconutil -c icns -o "$ICON_NEW" "${ICON_OLD%.icns}.iconset" > > -11) Copy your image.im to myapp.app/Contents/Resources/resource.im > > - 12) Ensure everything is readable by all : > chmod -R a+r myapp.app > - 13) Ensure dylibs and visual have executable rights for all (chmod 555 visual). > > > - 14) Optional step : sign the components located in myapp.app/Contents/Frameworks with your developer Id certificate > > codesign -s "Developer ID Application: Annick Fron (XXXXXXXXXX)" -v ./SaintGeorges.app/Contents/Frameworks/libcairo.2.dylib > codesign -s "Developer ID Application: Annick Fron (XXXXXXXXXX)" -v ./SaintGeorges.app/Contents/Frameworks/libpixman-1.0.dylib > codesign -s "Developer ID Application: Annick Fron (XXXXXXXXXX)" -v ./SaintGeorges.app/Contents/Frameworks/libpng15.0.dylib > > - 15) Sign the app > > codesign --entitlements ./sg.entitlements -s "Developer ID Application: Annick Fron (XXXXXXXXXX)" -v ./SaintGeorges.app > > with for instance the following entitlements file (allows for networking) > sg.entitlements > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.apple.com_DTDs_Prop…>"> > <plist version="1.0"> > <dict> > <key>com.apple.security.app-sandbox</key> > <true/> > <key>com.apple.security.device.usb</key> > <true/> > <key>com.apple.security.files.user-selected.read-write</key> > <true/> > <key>com.apple.security.network.client</key> > <true/> > <key>com.apple.security.network.server</key> > <true/> > <key>com.apple.security.print</key> > <true/> > </dict> > </plist> > > - 16) Create an installer > Create a component list : > > pkgbuild --analyze --root ./SaintGeorges.app SaintGeorgesComponents.plist > > Then use it > pkgbuild --root ./SaintGeorges.app --component-plist SaintGeorgesComponents.plist --identifier "com.fencingfox.saintgeorges" --install-location "/" ./SaintGeorges.pkg > > You can also use Packages > http://s.sudre.free.fr/Software/Packages/about.html <https://urldefense.proofpoint.com/v2/url?u=http-3A__s.sudre.free.fr_Softwar…> > http://thegreyblog.blogspot.fr/2014/06/os-x-creating-packages-from-command_… <https://urldefense.proofpoint.com/v2/url?u=http-3A__thegreyblog.blogspot.fr…> > > - 17) Create and sign an archive > productbuild \ > --distribution distribution.plist \ > --resources . \ > --sign "3rd Party Mac Developer Installer: Annick Fron (XXXXXXXXXX)" \ > --package-path ./SaintGeorges.pkg \ > SaintGeorgesFinal.pkg > > > using for instance the following distribution.plist file > <?xml version="1.0" encoding="utf-8" standalone="no"?> > <installer-gui-script minSpecVersion="2"> > <pkg-ref id="com.fencingfox.saintgeorges"/> > <options customize="never" require-scripts="false"/> > <volume-check> > <allowed-os-versions> > <os-version min="10.9"/> > </allowed-os-versions> > </volume-check> > <choices-outline> > <line choice="default"> > <line choice="com.fencingfox.saintgeorges"/> > </line> > </choices-outline> > <choice id="default"/> > <choice id="com.fencingfox.saintgeorges" visible="false"> > <pkg-ref id="com.fencingfox.saintgeorges"/> > </choice> > <pkg-ref id="com.fencingfox.saintgeorges" version="0" onConclusion="none">SaintGeorges.pkg</pkg-ref> > > - 18) Generate the product > productbuild --sign "3rd Party Mac Developer Installer: Annick Fron (XXXXXXXXXX)" --component SaintGeorges.app /Applications SaintGeorgesFinal.pkg --product ./requirements.plist > > using for instance the following empty requirements.plist > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.apple.com_DTDs_Prop…>"> > <plist version="1.0"> > <dict> > <key>os</key> > <array> > </array> > </dict> > </plist> > > > > - 19) From you Apple developer account connect to itunesconnect and describe your product > > - 20) Upload your final package.pkg using ApplicationLoader launched from Xcode menu/Open Developer Tool (double click on the empty zone to upload) > > Enjoy ! > > Annick Fron > > -- _,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;: Alexandre Bergel http://www.bergel.eu ^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.

July 15, 2016

Re: [Pharo-users] iCal Chronos for Pharo 5 => OSProcess

by CÃ©drick BÃ©ler

Hello, Itâs getting better. I loaded the last configuration (ConfigurationOfChronos-PaulDeBruicker.54). It loads ok, and the constant AnsiStandardCalendarClock is well initialized this time. Then I load iCal (not through the configuration that loads OSProcess for I think CommandShell). (First I loaded HTTPAPIClient through configuration without problem) Then I loaded in that order: ICal-Core-PaulDeBruicker.16 Ical-znurl-PaulDeBruicker.2 ICal-Tests-PaulDeBruicker.9 ICalChronos-PaulDeBruicker.8 (no magritte) ICal-HTTPAPIClient-PaulDeBruicker.1 Then I run tests. Several problem because of mainly : ICToDo>>resetAlarmTimes Some other methods are missing: ICJob>>hasAlarms Do you have an idea why these methods are missing ? If I implement them: ICJob>>resetAlarmTimes self alarms: OrderedCollection new. => 171 tests pass instead of 132. ICJob>>hasAlarm ^ self alarms isNotEmpty => no change, still 171 passes, 12 errors and 3 failures. Some identified problems: isRelatedToStart is implemented in ICTrigger not in ICAlarm (several errors on that one) => not sure how to implement it. I tried: ICAlarm>> is RelatedToStart (did the same with isRelatedToEnd) ^ self trigger isRelatedToStart True and False do not implement asIcalBooleanString I implement in True (and False) so that to return âTRUEâ (or âFALSE) - *ICal-Core extension asIcalString is not implement in ScaledDecimal (but in Float and Number). - I donât know pushing the method up is ok or if it has to be implemented again in ScaledDecimal (I did that) - and implementing class side fromICalString (still Ical-Core extension ?) ScaleDecimal class>>fromICalString: aString ^ self readFrom: aString => now 6 errors left TimeOfDay epoch (not implemented) => not sure TimeOfDay class >>epoch "{TimeOfDay epoch}" ^AnsiStandardCalendarClock epoch Also error that seems details (I have a look this afternoon): "The resource that defines the ruleset for the VariableOffsetTimezone identified by 'Europe/Berlin' is not accessible. Â» I think this is because I donât load OSProcess A test error where an expected string is not exactly the same: ... expected := 'FREQ=MONTHLY;BYDAY=MO,2TU'. rule asICalString => "FREQ=MONTHLY;BYDAY=2TU,MO" â¦ etc... Final state: Do I push the changes I made ? Cheers, CÃ©drik > Le 14 juil. 2016 Ã 22:04, Paul DeBruicker <pdebruic(a)gmail.com> a Ã©crit : > > How did you load Chronos? > > > > CÃ©drick BÃ©ler wrote >> Hi again,: >> >> Iâve loaded all required packages I think, tests do not pass. >> >> Main errors comes from AnsiStandardCalendarClock that cannot be found. >> >> Does someone know how to solve that ? >> I think Iâve loaded all chronos packages. >> >> Cheers, >> >> CÃ©drik >> >>> Le 14 juil. 2016 Ã 15:51, CÃ©drick BÃ©ler < > >> cdrick65@ > >> > a Ã©crit : >>> >>> Hi Paul, >>> >>> Thanks for the information. Iâll give a try. >>> >>> Cheers, >>> >>> CÃ©drik >>> >>> >>>> Le 13 juil. 2016 Ã 20:51, Paul DeBruicker < > >> pdebruic@ > >> > a Ã©crit : >>>> >>>> Hi CÃ©drick, >>>> >>>> The iCal load fails or it puts up a warning that you must load some >>>> other >>>> classes (e.g. OSProcess) first before loading other definitions? >>>> >>>> The OSProcess use in the iCal package it pretty minimal and would be >>>> easy to >>>> split out into a separate package if you were motivated to port iCal to >>>> OSSubProcess. >>>> >>>> >>>> As for Chronos, I'm not positive but am pretty sure that OSProcess is >>>> only >>>> used for generating the Chronos time zone rules from the olson time zone >>>> db >>>> files. >>>> >>>> So I'd guess both iCal and Chronos will work fine for testing purposes >>>> without porting anything to OSSubProcess and just skipping the load of >>>> the >>>> OSProcess parts. >>>> >>>> >>>> Hope this helps >>>> >>>> Paul >>>> >>>> >>>> >>>> >>>> CÃ©drick BÃ©ler wrote >>>>> Hi all, >>>>> >>>>> Iâm trying to load the iCal package from the catalog. It is available >>>>> on >>>>> smalltalkhub. >>>>> http://www.smalltalkhub.com/#!/~pdebruic/iCal >>>>> >>>>> It has some problem (installation fails) but the package is not tagged >>>>> as >>>>> Pharo5. Plus it seems to use OSProcess. Iâm trying to avoid to load >>>>> OSProcess as I use OSSubprocess (probably for Chronos ?). >>>>> >>>>> Any idea on what I can do ? >>>>> (Iâd like to install/evaluation iCal vCard and Chronos) >>>>> >>>>> Thanks for any help, >>>>> >>>>> Cheers, >>>>> >>>>> CÃ©drik >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> View this message in context: >>>> http://forum.world.st/iCal-Chronos-for-Pharo-5-OSProcess-tp4906567p4906585.… >>>> Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. >>>> >>> > > > > > > -- > View this message in context: http://forum.world.st/iCal-Chronos-for-Pharo-5-OSProcess-tp4906567p4906672.… <http://forum.world.st/iCal-Chronos-for-Pharo-5-OSProcess-tp4906567p4906672.…> > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com <http://nabble.com/>.

July 15, 2016