- Pharo-dev - lists.pharo.org

Prepared Statements on PostgresV2?
by Stephan Eggermont Jan. 11, 2015

Jan. 11, 2015

Stef wrote: >May be this is the time to improve this package :) >I'm sorry I have no DB experience. >As part of the consortium agenda for this year we have > - better ffi > - better db support Moving to Levente's PostgreSQLv3 and migrating that might be a better idea. He has been using it in production systems for a long time AFAIK. The code mirror is very interesting. Porting it needs someone with close access to Opal/old compiler knowledge. The way it works now in Squeak looks ideal for someone with a PostgreSQL background. Using a code browser to edit plsql, and having a directly mirrored smalltalk class for each table. http://forum.world.st/Status-of-PostgresV3-td4780110.html I have verified that the connection works and that I can get data out of postgres. Missing: - switch the code highlighter from smalltalk to one for plsql in nautilus. - connect to glorp - (later) add a real plsql parser (petitsql?) Stephan

4 5

Prepared Statements on PostgresV2?
by David Carlos Manuelda Jan. 10, 2015

Jan. 10, 2015

I've installed and tested PostgresV2 under pharo with the following doits Gofer new smalltalkhubUser: 'PharoExtras' project: 'PostgresV2'; configuration; load. (#ConfigurationOfPostgresV2 asClass project version: '2.4') load While it works good, it is missing a very important feature from both security and performance point of view: The prepared statements. As a brief, prepared statements are parameterized SQL statements that are loaded ONCE per connection instead of sending the whole query to DB every time, and also, they are parameterized, so it completelly prevents SQL injection, as the parameters are automatically 'detected' and scaped and/or handled accordingly without allowing in any case a parameter to alter the SQL meaning, which can happen by using regular SQL queries made by string concatenation. I browsed the class and did not find any prepare: method nor anything similar. Also, you can give a name to a SQL sentence, which makes the code much more readable without messing too much logic with SQL commands and string concatenation. An example is as follows: (supposing we have an instance variable connection, already initialized and connected via PGConnection class) Instead of: self connection execute: 'SELECT data FROM mytable WHERE name=''', anUser userName, ''';'. Would be something like this: self connection executePrepared: 'getUserData' with: anUser userName. And another suggestion could be something like: self connection prepare: 'getUserData' withSQL: 'SELECT data FROM mytable WHERE name=$1' Any plan for this to be implemented or any hint to other PostgreSQL class that already has it? David. P.S. I've written in my blog about this some time ago: http://stormbyte.blogspot.com.es/2012/06/programming-with-database-using.ht… if someone finds it useful.

6 11

[OT] Things people built with Smalltalk on Twitter: #thingsPeopleBuiltWithSmalltalk
by Torsten Bergmann Jan. 10, 2015

Jan. 10, 2015

If you know something built in Smalltalk then twitter it: https://twitter.com/hashtag/thingsPeopleBuiltWithSmalltalk?src=hash Lets make 2015 the "Anybody knows about Smalltalk" year ;)

1 0

TextMorph broken?
by Atlas Jan. 10, 2015

Jan. 10, 2015

Hi, I hate to bring this up, but it seems that TextMorph is broken: (1) The width of a TextMorph cannot be changed directly, only resetting the content (via #contents:) changes its width. (2) It's not possible to position the cursor past the last character with a point and click operation. (3) Moving the cursor past the last character with the arrow keys makes it disappear (even though it is positioned correctly). (4) It's not possible to change the font in the meta-menu. Is anyone else having similar problems? Any recommendations? All I need is a single line TextMorph that matches its width with the width of its text. I am using Pharo 3.0 (the most recent official version retrievable via the website). Thanks -- View this message in context: http://forum.world.st/TextMorph-broken-tp4798645.html Sent from the Pharo Smalltalk Developers mailing list archive at Nabble.com.

2 3

Need a PC users to get the PDF of
by stepharo Jan. 10, 2015

Jan. 10, 2015

Hi guys I would like to add Smalltalk, Objects and Design to our free book libraries and I do not have a pdf saver on mac for google book https://books.google.fr/books?id=W8_Une9cbbgC&printsec=frontcover&num=15&hl… Could one of you give a try? Thanks Stef

1 2

[ANN] Rewritten EventRecorder (now based on Spec)
by Torsten Bergmann Jan. 10, 2015

Jan. 10, 2015

Hi, I've rewritten, refactored, commented the Event Recorder. The most visible feature is that the UI is now based on Spec to fit Pharo style. Currently it can record and replay events. Saving and loading of events as *.tape files is still missing and (depending on time) will be added as a next step. With this tool we have the ability to record and exchange actions done in an image to reproduce bugs. The tool can also be used for demo purposes. As it is already usable I made it available in the config browser of Pharo 4. Attached is a screenshot, Code is on STHub [1]. Have fun T. [1] http://smalltalkhub.com/#!/~TorstenBergmann/EventRecorder

2 1

are senders and implementors broken in Pharo40?
by stepharo Jan. 9, 2015

Jan. 9, 2015

When I do senders of buildFrom: I get nautilus pointing a class but not the method? No time to fix it but we should avoid to integrate enh that breaks the browser like that. Stef

4 6

'(\w+s*){1, 3}' asRegex - image locks up in Pharo 3 & 4
by Paul DeBruicker Jan. 9, 2015

Jan. 9, 2015

Hi - In a workspace, if you inspect (or print, doIt, ... ) the following: '(\w+s*){1,3}'' asRegex The image will enter into a loop that the Cmd+. can't break out of. '(\w\s){1,3}' asRegex does not lock up the image. Including just one + or * causes the infinite loop when using a quantifier (the {} part). Does anyone know enough about how the Regex parts of the system to know where to look to fix it? Thanks Paul

2 1

[pharo-project/pharo-core]
by GitHub Jan. 9, 2015

Jan. 9, 2015

Branch: refs/tags/40438 Home: https://github.com/pharo-project/pharo-core

1 0

[pharo-project/pharo-core] e4a413: 40438
by GitHub Jan. 9, 2015

Jan. 9, 2015

Branch: refs/heads/4.0 Home: https://github.com/pharo-project/pharo-core Commit: e4a413ae3af041ce1ff751379b628bf18aef5b65 https://github.com/pharo-project/pharo-core/commit/e4a413ae3af041ce1ff75137… Author: Jenkins Build Server <board(a)pharo-project.org> Date: 2015-01-09 (Fri, 09 Jan 2015) Changed paths: M Monticello.package/MCClassDefinition.class/instance/installing/createClass.st A Monticello.package/MCClassDefinition.class/instance/installing/hasComplexVariables.st A Monticello.package/MCClassDefinition.class/instance/installing/variablesOfType_.st A Monticello.package/MCClassDefinition.class/instance/printing/instanceVariables.st M Monticello.package/extension/Class/instance/asClassDefinition.st M Nautilus.package/extension/Class/instance/definitionForNautilusWithSlots.st A ScriptLoader40.package/ScriptLoader.class/instance/pharo - scripts/script438.st A ScriptLoader40.package/ScriptLoader.class/instance/pharo - updates/update40438.st M ScriptLoader40.package/ScriptLoader.class/instance/public/commentForCurrentUpdate.st M Slot.package/OldClassBuilderAdapter.class/instance/adapted api/class_instanceVariableNames_.st M Slot.package/Slot.class/instance/queries/definingClass.st M Slot.package/Slot.class/instance/queries/usingMethods.st M Text-Edition.package/SmalltalkEditor.class/class/menu declaration/smalltalkEditorShiftedMenuOn_.st Log Message: ----------- 40438 14699 Slot: #definingClass and #usingMethods should work on non-used slots https://pharo.fogbugz.com/f/cases/14699 14698 Allow Slots to be saved with Monticello https://pharo.fogbugz.com/f/cases/14698 14697 simplify extended search menu: case insensitive description not needed https://pharo.fogbugz.com/f/cases/14697 http://files.pharo.org/image/40/40438.zip

1 0