![]() Hint Available settings for Input, Output, and Trigger are scope-depended and Input fallback and BLOB settings depend on the setting for Input. The following list describes the possible settings of each Bundle command. The names in the list directly match the name of any installed *.spBundle files names so make sure to also use unique and valid file names, otherwise we will rename your file to avoid conflicts with existing Bundles. As you write a new Bundle it will dynamically update its location in the Bundles list according to the Bundle Scope you have specified (and optionally the Menu Category you have entered). The new bundle editor allows you to manage the bundles you have installed and to share your bundles. In addition commands for the scopes “Input Field” and “Data Table” will be appended to the corresponding context menus (right-click).Įach Bundle command passes data to the script and returns data back to Sequel Pro UTF-8 encoded. By defining a menu category it is possible to group commands inside a scope which will be displayed by themselves as submenus. Stored Bundle commands will be populated in the main menu under “Bundles” grouped into the submenus “Input Field” and “Data Table”, commands saved with the scope “General” will be added successively. to execute any SQL statement in the front most connection window and process the result, select tables, databases, and table rows, change the current view, reload the Content view table by a passed WHERE clause etc.Ī Bundle command has to be defined for one of theses scopes (a GUI type which has the key focus) “Input Field” – any text input field including table cells while edited, “Data Table” – the data tables in Content and Query view, and “General” – neither text input fields nor data tables.Įach new generated Bundle will have an Universally Unique Identifier (UUID) to make it possible to identify (mainly for updating) Bundles regardless the Bundle spBundle name.īecause a bundle is just a specially named folder it is possible to include any additional files that are necessary to perform the action. These sequelpro:// URL scheme commands allow you e.g. PrimaryKey key = myTable.createPrimaryKey() ĮnumValue ev = row.get("testEnum").Accessorily in any scripting language one can use Sequel Pro's URL scheme commands. * Create a primary key for user id 12345 and get a row */ Alternatively, you can use EnumValue.getIndex() to retrieve the stored value's index position.įor example: TableAPI tableH = kvstore.getTableAPI() You can then use EnumValue.get() to retrieve the stored enum value's name as a string. To read the enum, use Row.get().asEnum(). ![]() Table myTable = tableH.getTable("myTable") If the enumeration value that you use with this method does not match a value defined on the -enum-values parameter during table definition, an IllegalArgumentException is thrown. To define a simple two-field table where the primary key is a UID and the second field contains an enum, you use the following DDL statement: CREATE TABLE myTable (ĭEFAULT and NOT NULL constraints are supported for enumerated fields. You must declare the acceptable enumeration values when you use this statement. ![]() Enumerated types are declared using the ENUM() statement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |