declarative – Tarik Billa

SQLAlchemy update if unique key exists

April 10, 2024 by Tarik

From version 1.2 SQLAlchemy will support on_duplicate_key_update for MySQL There is also examples of how to use it: from sqlalchemy.dialects.mysql import insert insert_stmt = insert(my_table).values( id=’some_existing_id’, data=”inserted value”) on_duplicate_key_stmt = insert_stmt.on_duplicate_key_update( data=insert_stmt.values.data, status=”U” ) conn.execute(on_duplicate_key_stmt) From version 1.1 SQLAlchemy support on_conflict_do_update for PostgreSQL Examples: from sqlalchemy.dialects.postgresql import insert insert_stmt = insert(my_table).values( id=’some_existing_id’, data=”inserted value”) do_update_stmt … Read more

Is there a declarative way to transform Array to Dictionary?

December 21, 2023 by Tarik

Swift 4 As alluded to by fl034, this can be simplified some with Swift 4 where an error checked version looks like: let foo = entries .map { $0.components(separatedBy: “=”) } .reduce(into: [String:Int64]()) { dict, pair in if pair.count == 2, let value = Int64(pair[1]) { dict[pair[0]] = value } } Even simpler if you … Read more

SQLAlchemy: a better way for update with declarative?

May 7, 2023 by Tarik

There’s also some update capability at the ORM level. It doesn’t handle any tricky cases yet but for the trivial case of single row update (or bulk update) it works fine. It even goes over any already loaded objects and applies the update on them also. You can use it like this: session.query(User).filter_by(id=123).update({“name”: u”Bob Marley”})

suggestions for declarative GUI programming in Java

April 16, 2023 by Tarik

You might have a look at javabuilders; it uses YAML to build Swing UIs. A simple example from the manual [PDF]: JFrame: name: myFrame title: My Frame content: – JLabel: name: myLabel2 text: My First Label – JLabel: name: myLabel2 text: My Second Label Alternatively: JFrame: name: myFrame title: My Frame content: – JLabel: {name: … Read more

WPF without XAML

April 9, 2023 by Tarik

I support you in Xaml-free WPF. I love layout and binding capabilities of WPF but I hate XAML too. I would love that WPF could be written in plain C#, some advantages: Object and Collection initializers could replace Xaml instantiations. (it’s a pity that xaml prefers top-down than button up). Binding converters could be just … Read more

Very simple, terse and easy GUI programming “frameworks” [closed]

March 27, 2023 by Tarik

Not to kid, but HTML. It’s cross-platform, and sums up the gui-layout in a simple textfile. It’s definitely mature, as well as well-understood and well documented. There’s a bunch of ways to template HTML files for dynamic content, and other ways to convert custom syntaxes to HTML if you dislike angle-brackets. Client-side scripting w/ Javascript, … Read more

What is declarative programming? [closed]

October 19, 2022 by Tarik

Declarative programming is when you write your code in such a way that it describes what you want to do, and not how you want to do it. It is left up to the compiler to figure out the how. Examples of declarative programming languages are SQL and Prolog.