Left justify labels

[avalon60]

OK, so I have my table working. Currently it looks like this:

Is there a way to left justify the button labels? I know there is the .edit_row method, but I am not sure how I could use it, to shift the text to the left.

Also I am not sure how you can edit a button, to give it an icon.

[Akascape]

@avalon60 Just add justify parameter when defining the table. All other args are passed directly to the button cells.

[avalon60]

I'll give that a try, but also how do I add an icon and command to an individual button. Is that possible?

[Akascape]

@avalon60 we can use .insert method to configure specific button. You can pass the image parameter there.

[avalon60]

Not sure how, because the other_options are passed as a string. In principle, that's fine for scalar settings (expressed as literals), but how do you pass a reference to an object - i.e. an image?

[Akascape]

Other options is not a parameter, it is just to show that we can pass other parameters just like normal parameter.

[avalon60]

@avalon60 Just add justify parameter when defining the table. All other args are passed directly to the button cells.

The justify parameter isn't valid for buttons, I tried anchor and that has no effect.

[Akascape]

@avalon60 Oh sorry, i mean anchor not justify.
It will work:

table = CTkTable(master=frame, row=5, column=5, values=values, height=100, anchor="w")

[avalon60]

Other options is not a parameter, it is just to show that we can pass other parameters.

Other options is not a parameter, it is just to show that we can pass other parameters just like normal parameter.

Ahh - ok, that's good.

However, I think I may now be hitting a bug. When I iterate to add the rows, and also include an insert to add icons, the icon only shows for the last row. So here I try both add and insert:

        for i, connection_name in enumerate(connections.keys(), start=1):

            db_account_name = connections[connection_name]["db_account_name"]
            connect_string = connections[connection_name]["connect_string"]
            start_directory = connections[connection_name]["start_directory"]
            table_row = [connection_name, db_account_name, connect_string, '', '']
            self.tbv_connections.add_row(values=table_row)
            icon_file = 'tick1.png'
            icon_image = ctk.CTkImage(light_image=Image.open(images_location / icon_file),
                                      dark_image=Image.open(images_location / icon_file))

            self.tbv_connections.insert(i, 3, '', image=icon_image)
            

This gives me:

If subsequent to this I add in this extra code, (which doesn't have the add_row method - there but commented out), it properly populates the icons:

        for i, connection_name in enumerate(connections.keys(), start=1):

            table_row = [connection_name, db_account_name, connect_string, '', '']
            # self.tbv_connections.add_row(values=table_row)
            icon_file = 'tick1.png'
            icon_image = ctk.CTkImage(light_image=Image.open(images_location / icon_file),
                                      dark_image=Image.open(images_location / icon_file))

            self.tbv_connections.insert(i, 3, '', image=icon_image)

The above is added as an extra block after the first snippet - we need to keep that first snippet in, in order to populate the table with the add_row.
Note that this last is just a copy/paste of the original, but with add_row commented out. Now I get what I expected:

Just to prove the point further, if I remove the hash, to un-comment that add_row in the last snippet, we get this:

We get duplicates as you would expect, but again, the icons aren't appearing as anticipated.

[avalon60]

The last thing I now do is an edit_column, for each of the columns, but it has no effect:

    def launch_connections_scan(self):
        """The launch_connections_scan creates a CTkToplevel and reports the connection availability of the user
        connections. It also provides a launch option for each all connections which appear to be available."""
        CSCAN_WIDTH = 860
        CSCAN_HEIGHT = 470
        widget_corner_radius = 5
        self.mvc_controller.status_bar.set_status_text(
            status_text='Scanning your connection ports, please wait...')
        position_geometry = self.mvc_controller.retrieve_geometry(window_category='toplevel')
        self.top_cscan = ctk.CTkToplevel(master=self)
        self.top_cscan.title('DCCM Connectivity Scan')
        self.top_cscan.geometry(position_geometry)
        self.top_cscan.geometry(f'{CSCAN_WIDTH}x{CSCAN_HEIGHT}')
        # Make preferences dialog modal
        self.top_cscan.rowconfigure(0, weight=1)
        self.top_cscan.rowconfigure(1, weight=0)
        self.top_cscan.columnconfigure(0, weight=1)

        frm_cscan_main = ctk.CTkFrame(master=self.top_cscan)
        frm_cscan_main.grid(column=0, row=0, sticky='nsew')
        frm_cscan_main.columnconfigure(0, weight=1)
        frm_cscan_main.rowconfigure(0, weight=1)

        frm_cscan_widgets = ctk.CTkScrollableFrame(master=frm_cscan_main)
        frm_cscan_widgets.grid(column=0, row=0, padx=10, pady=10, sticky='nsew')

        frm_buttons = ctk.CTkFrame(master=frm_cscan_main)
        frm_buttons.grid(column=0, row=1, padx=(10, 10), pady=(0, 10), sticky='ew')

        btn_ok = ctk.CTkButton(master=frm_buttons, text='OK', width=CSCAN_WIDTH - 30,
                               command=self.top_cscan.destroy)
        btn_ok.grid(row=0, column=0, padx=(5, 5), pady=10)

        connections = self.mvc_controller.connections_dict()
        row = 0
        self.launch_buttons = {}
        HEADING_UL = HEADING2 = ('Roboto', 14)

        connection_table = [['Connection Id', 'DB Account', 'Connect String', 'Contactable', 'Launch']]

        button_fg_color = cbtk.get_color_from_name(widget_type='CTkButton', widget_property='fg_color')
        button_hover_color = cbtk.get_color_from_name(widget_type='CTkButton', widget_property='hover_color')
        self.tbv_connections = CTkTable(master=frm_cscan_widgets,
                                        values=connection_table,
                                        hover=True,
                                        header_color=button_fg_color)
        self.tbv_connections.grid(row=0, column=0)
        self.tbv_connections.insert(0, 0, 'Connection Id', anchor='w')
        self.tbv_connections.insert(0, 1, 'DB Account', anchor='w')
        self.tbv_connections.insert(0, 2, 'Connect String', anchor='w')

        row += 1
        for i, connection_name in enumerate(connections.keys(), start=1):
            db_account_name = connections[connection_name]["db_account_name"]
            connect_string = connections[connection_name]["connect_string"]
            start_directory = connections[connection_name]["start_directory"]
            table_row = [connection_name, db_account_name, connect_string, '', '']
            self.tbv_connections.add_row(values=table_row)

        # Second loop. We need this because we can't combine add_row and insert in
        # the same loop (current limitation on CTkTable).
        for i, connection_name in enumerate(connections.keys(), start=1):
            db_account_name = connections[connection_name]["db_account_name"]
            connect_string = connections[connection_name]["connect_string"]
            start_directory = connections[connection_name]["start_directory"]
            self.tbv_connections.insert(i, 0, db_account_name, anchor='w')
            self.tbv_connections.insert(i, 1, connect_string, anchor='w')
            self.tbv_connections.insert(i, 2, start_directory, anchor='w')

            try:
                host, port = self.mvc_controller.resolve_connect_host_port(connection_name=connection_name)
            except FileNotFoundError:
                host = port = None
            tk_state = None
            stale_connection = False
            port_open = False
            if host is not None and port is not None:
                stale_connection = False
                port_open = mod.port_is_open(host=host, port_number=port)
            elif host is None or port is None:
                stale_connection = True
                port_open = False

            if not stale_connection:
                stale_icon = ctk.CTkImage(light_image=Image.open(images_location / 'launch_lm.png'),
                                          dark_image=Image.open(images_location / 'launch_dm.png'),
                                          size=(20, 20))
            else:
                stale_icon = ctk.CTkImage(light_image=Image.open(images_location / 'x_bones_lm.png'),
                                          dark_image=Image.open(images_location / 'x_bones_dm.png'),
                                          size=(20, 20))

            if port_open:
                tk_state = tk.NORMAL
                tooltip_text = 'Database server appears to be contactable.'
                hover_colour = button_hover_color
                icon_file_lm = 'tick_lm.png'
                icon_file_dm = 'tick_dm.png'
            elif not port_open and stale_connection:
                tk_state = tk.DISABLED
                hover_colour = button_fg_color
                icon_file_lm = 'q_mark_lm.png'
                icon_file_dm = 'q_mark_dm.png'
                tooltip_text = 'Connection entry appears to be stale. Has an associated tnsnames.ora entry been ' \
                               'deleted? '
            else:
                tooltip_text = 'Database server cannot be contacted.'
                hover_colour = button_fg_color
                tk_state = tk.DISABLED
                icon_file_lm = 'cross_lm.png'
                icon_file_dm = 'cross_dm.png'

            icon_image = ctk.CTkImage(light_image=Image.open(images_location / icon_file_lm),
                                      dark_image=Image.open(images_location / icon_file_dm),
                                      size=(16, 16))

            print(f'Configuring for row {i}')
            hove_colour = 'white'
            self.tbv_connections.insert(i, 3, '', width=40, image=icon_image)
            self.tbv_connections.insert(i, 4, '', width=40, image=stale_icon, state=tk_state,
                                        hover_color=hover_colour,
                                        command=lambda connection=connection_name:
                                        self.mvc_controller.launch_client_connection(connection_name=connection))

            # btn_probe.grid(row=row, column=4, padx=(0, 50), pady=(0, 5))
            # if self.tooltips_enabled():
            #     self.probe_tooltip = ToolTip(btn_probe, tooltip_text, TOOLTIP_DELAY)

            launch = ctk.CTkImage(light_image=Image.open(images_location / 'launch_lm.png'),
                                  dark_image=Image.open(images_location / 'launch_dm.png'),
                                  size=(16, 16))
            # self.launch_buttons[row].grid(row=row, column=5, padx=(5, 50), pady=(0, 5), sticky='w')

            if tk_state == tk.DISABLED:
                availability = ' [ disabled ]'
            else:
                availability = ''

            row += 1
        self.tbv_connections.edit_column(0, anchor='w')
        self.tbv_connections.edit_column(1, anchor='w')
        self.tbv_connections.edit_column(2, anchor='w')
        self.tbv_connections.edit_column(3, width=40)
        self.tbv_connections.edit_column(4, width=40)
        self.top_cscan.grab_set()

as we see here:

The left justification of the first 3 header columns is from the earlier insert statements, which appear before the first loop:

        self.tbv_connections.insert(0, 0, 'Connection Id', anchor='w')
        self.tbv_connections.insert(0, 1, 'DB Account', anchor='w')
        self.tbv_connections.insert(0, 2, 'Connect String', anchor='w')

The good news is that the column widths are working - yay!

[Akascape]

@avalon60 Make sure that you edit the row/column again after adding new row/column, instead you can pass the anchor while inserting the value.

[avalon60]

That's what I am doing. If you look at the code, it's the last thing I do, before the grab_set():

        self.tbv_connections.edit_column(0, anchor='w')
        self.tbv_connections.edit_column(1, anchor='w')
        self.tbv_connections.edit_column(2, anchor='w')
        self.tbv_connections.edit_column(3, width=40)
        self.tbv_connections.edit_column(4, width=40)
        self.top_cscan.grab_set()

These are the last lines of the method. Am I misunderstanding?

[Akascape]

@avalon60 Update the package once again, add anchor="w" while defining the table, add anchor="c" while inserting the image. That will be the best method.

[avalon60]

Well, I had to reduce the corner radius (it caused the top and bottom leftmost cells to shunt text to the right), but I have to say that I am VERY pleased with the result. Thanks for sticking with it and helping me on this.