<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><div style='font-size:10pt;font-family:Verdana,Arial,Helvetica,sans-serif;'>Poking around a bit, it appears that down is up and up is down.<div><br></div><div>If you go to </div><div><br></div><div><div><br><blockquote style="border: 1px solid rgb(204, 204, 204); padding: 7px; background-color: rgb(245, 245, 245);">PG3SchemaChanges >> uploadAll<div><br></div><div><span style="white-space: pre;"> </span>changes do: [ :each | </div><div><span style="white-space: pre;"> </span>each isRemoteOnly ifFalse: [ </div><div><span style="white-space: pre;"> </span>each saveToDatabase ] ].</div><div><span style="white-space: pre;"> </span>self refresh</div><div><br></div><div>PG3SchemaChanges >>downloadAll</div><div><br></div><div><span style="white-space: pre;"> </span>changes do: [ :each | </div><div><span style="white-space: pre;"> </span>each isLocalOnly ifFalse: [ </div><div><span style="white-space: pre;"> </span>each saveIntoSchemaMirror ] ].</div><div><span style="white-space: pre;"> </span>self refresh</div><div> </div></blockquote><br>yikes. I am afraid to push the buttons!</div><div><br></div><div><br></div><div><br></div><div class="zmail_extra"><div id="1"><br>---- On Sun, 25 Feb 2018 04:38:14 -0500 <b>gettimothy<gettimothy@zoho.com></b> wrote ---- <br></div><blockquote style="border-left: 1px solid #0000FF; padding-left: 6px; margin:0 0 0 5px"><meta> <div> <div style="font-size: 10pt; font-family: Verdana, Arial, Helvetica, sans-serif"> <div> Hi all. </div> <div> <br> </div> <div> While writing the PostgresV3 help, I am following <a href="http://forum.world.st/template/NamlServlet.jtp?macro=user_nodes&user=368460" style="color: rgb(0, 79, 135); font-size: 13.44px; font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-weight: bold; text-align: center; white-space: nowrap; background-color: rgb(238, 238, 238)" target="_blank" rel="noreferrer">Balázs Kósi-2</a> example here: <a href="http://forum.world.st/Status-of-PostgresV3-td4780110.html" target="_blank" rel="noreferrer">http://forum.world.st/Status-of-PostgresV3-td4780110.html</a> </div> <div> <br> </div> <div> In the section on SchemaMirror </div> <div> <br> <blockquote style="border: 1px solid rgb(204, 204, 204); padding: 7px; background-color: rgb(245, 245, 245)"> <div> </div> <span style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)">To create a schema mirror, subclass PG3SchemaMirror and implement its pool and schema class side methods.</span> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <span style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)">YourSchemaMirror class >> pool</span> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <span style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> ^YourConnectionPool default</span> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <span style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)">YourSchemaMirror class >> schema</span> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <span style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> ^’schema_name’</span> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <span style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)">Schema mirrors mirror the functions in your database and provide an interface to call them. There is a little tool to inspect the differences between the methods of the schema mirror and the functions in the database, which can be invoked by:</span> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <span style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)">YourSchemaMirror browseChanges</span> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <span style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)">You can up and download functions via this interface. In earlier times we would write the database functions in pgAdmin3 and download them into the image. Nowadays we use the smalltalk browser to write the plpgsql code. You can set the autocommit behavior with:</span> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <br style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)"> <span style="color: rgb(51, 51, 51); font-family: Verdana, Geneva, Helvetica, Arial, sans-serif; font-size: 13.44px; background-color: rgb(255, 255, 255)">YourSchemaMirror commitOnAccept: true</span> </blockquote> <br>I have this beautiful tool that lists all the functions in my schema and it has buttons "Download All" and "Upload All" etc. </div> <div> <br> </div> <div> My question are "Which way is Up" and "Which way is Down"? </div> <div> <br> </div> <div> What I want to accomplish is this direction [My database] ---->[Squeak] </div> <div> <br> </div> <div> I am guessing that I want to Upload, BUT for documentation purposes I want to be clear. Also, I don't want to have to re-import the functions. </div> <div> <br> </div> <div> thx </div> <div> <br> </div> <div> <br> </div> <div> <br> </div> <div> <br> </div> <div> <br> </div> <div> <br> <br> </div> </div> <br> <br> </div></blockquote><br></div><br></div></div><br></body></html>