teleren/devto huggingface dataset:
Trysil - TWhereClause
Tags: trysil, delphi, orm
Published: 2024-02-19 09:26:49

**Introduzione**
Uno degli attributi disponibili in "Trysil - Delphi ORM" è [TWhereClauseAttribute].

Cerco, in questo articolo, di spiegarne l'utilità.
<br />**Database**
Prendiamo ad esempio la seguente tabella del database:
```
CREATE TABLE Users(
  ID int NOT NULL,
  Firstname nvarchar(255) NOT NULL,
  Lastname nvarchar(255) NOT NULL,
  UserType int NOT NULL,
  VersionID int NOT NULL,
  PRIMARY KEY (ID)
);
```
Stabiliamo che la colonna UserType potrà contenere i valori 0 (Insegnante) e 1 (Studente).

Aggiungiamo un indice alla tabella per ottimizzare i filtri:

```
CREATE INDEX Users_Index1 ON Users (UserType);
```
<br />**TUser**
Definiamo il modello astratto per l'entità TUser:

```
{ TUser }

  [TTable('Users')]
  [TSequence('UsersID')]
  TUser = class abstract
  strict private
    [TPrimaryKey]
    [TColumn('ID')]
    FID: TTPrimaryKey;

    [TColumn('Firstname')]
    FFirstname: String;

    [TColumn('Lastname')]
    FLastname: String;

    [TVersionColumn]
    [TColumn('VersionID')]
    FVersionID: TTVersion;
  strict protected
    [TColumn('UserType')]
    FUserType: Integer;
  public
    property ID: TTPrimaryKey read FID;
    property Firstname: String read FFirstname write FFirstname;
    property Lastname: String read FLastname write FLastname;
    property VersionID: TTVersion read FVersionID;
  end;
```
<br />**TTeacher**
Specializziamo l'entità TTeacher:

```
{ TTeacher }

  [TWhereClause('UserType = 0')]
  TTeacher = class(TUser)
  public
    procedure AfterConstruction; override;
  end;

// ...

procedure TTeacher.AfterConstruction;
begin
  inherited AfterConstruction;
  FUserType := 0;
end;
```
<br />**TStudent**
Specializziamo poi l'entità TStudent:

```
{ TStudent }

  [TWhereClause('UserType = 1')]
  TStudent = class(TUser)
    procedure AfterConstruction; override;
  end;

// ...

procedure TStudent.AfterConstruction;
begin
  inherited AfterConstruction;
  FUserType := 1;
end;
```
<br />**Trysil**
Adesso siamo in grado di utilizzare TTeacher e TStudent con Trysil come se le due entità fossero persistite su due tabelle separate, in realtà entrambe andranno ad eseguire tutte le operazioni di CRUD sulla tabelle Users del database.

Per saperne di più su Trysil - Delphi ORM visita il link al progetto:

[https://github.com/davidlastrucci/Trysil](https://github.com/davidlastrucci/Trysil)
Trysil - Delphi ORM
Tags: trysil, delphi, orm
Published: 2024-02-19 09:19:34

Perché continuare a scrivere codice così:

```
Query.SQL.Text :=
  'SELECT I.ID AS InvoiceID, I.Number, ' +
  'C.ID AS CustomerID, C.Name AS CustomerName, ' +
  'U.ID AS CountryID, U.Name AS CountryName ' +
  'FROM Invoices AS I ' +
  'INNER JOIN Customers AS C ON C.ID = I.CustomerID ' +
  'INNER JOIN Countries AS U ON U.ID = C.CountryID ' +
  'WHERE I.ID = :InvoiceID';
Query.ParamByName('InvoiceID').AsInteger := 1;
Query.Open;

ShowMessage(
  Format('Invoice No: %d, Customer: %s, Country: %s', [
    Query.FieldByName('Number').AsInteger,
    Query.FieldByName('CustomerName').AsString,
    Query.FieldByName('CountryName').AsString])); 
```
<br />Quando c'è la possibilità di scriverlo così?

```
LInvoice := FContext.Get<TInvoice>(1);
ShowMessage(
  Format('Invoice No: %d, Customer: %s, Country: %s', [
    LInvoice.Number,
    LInvoice.Customer.Name,
    LInvoice.Customer.Country.Name]));
```

Per maggiori informazioni visitail link al progetto Trysil:

[https://github.com/davidlastrucci/Trysil](https://github.com/davidlastrucci/Trysil)
Top 10 Best Gaming Chairs in 2024
Tags: discuss, gamedev, writing, motivation
Published: 2024-02-19 09:03:37

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/k5x93510epuxm1f29pra.jpg)
Over the past few years, [gaming chairs](https://newone.games/best-gaming-chairs/) have experienced such a dramatic increase in popularity that even non-gamers now own one. However, this unexpected spike in demand has also made it more difficult than ever to come across the [best gaming chairs](https://newone.games/best-gaming-chairs/) that are more than just affordable expenditure but well-built. The most comfortable, adaptable, and stylish gaming seats are the ones that are genuinely worth the investment.

If you play PC games for extended periods and spend a lot of time at your workstation, you need a comfortable seat. Below are the ten Best Gaming Chairs available for various purposes and price ranges.

## Here are the most [comfortable Top Gaming Chairs](https://newone.games/best-gaming-chairs/) – 2024 Edition
1. Cooler Master Caliber X2
2. GT Omega Zephyr
3. Herman Miller X Logitech G Vantum
4. Boulies Master
5. Secretlab Titan EVO (2022 Series)
6. Respawn Spire
7. X Rocker Agility eSports
8. Playseat Puma
9. Razer Fujin Pro
10. Cooler Master Motion 1
Tracking Crypto Prices on Autopilot: GitHub Codespaces & Actions Guide
Tags: python, github, blockchain, automation
Published: 2024-02-19 09:02:26

Want to stay on top of your favorite crypto's price, but tired of manual checks? This guide empowers you to build an automated Cryptocurrency Price Tracker with **GitHub Codespaces**, a cloud-based development environment, and **GitHub Actions**, for commit automation. Let's dive in!

** Step 1: Secure Your Crypto Vault (Repository)**

1. Head to GitHub and create a new **private** repository (e.g., "Cryptocurrency-Price-Tracker").
2. Name it wisely, reflecting your crypto passion!

** Step 2: Enter the Codespace Arena**

1. Open your new repository and click "Code" -> "Codespaces" -> "Create codespace on main".
2. This unlocks your cloud-based development playground. Time to code!

** Step 3: Craft Your Price-Fetching Spell (Script)**

1. In your codespace, conjure a `tracker.py` file.
2. Let's use Python and CoinGecko API to extract the desired crypto's price:

```python
import requests

def get_crypto_price(symbol):
    url = f"https://api.coingecko.com/api/v3/simple/price?ids={symbol}&vs_currencies=usd"
    response = requests.get(url)
    data = response.json()
    return data[symbol]['usd']

print(get_crypto_price('bitcoin'))
```

** Step 4: Automate the Price Updates (GitHub Actions)**

1. Click the "Actions" tab and select "New workflow".
2. Choose the "Python application" template for streamlined setup.
3. Replace the `main.yml` file with this magic formula:

```yaml
name: Daily Crypto Price Update

on:
  schedule:
    - cron: '0 0 * * *' # Runs daily at midnight (UTC)

jobs:
  build:
    runs-on: ubuntu-latest

    steps:
      - uses: actions/checkout@v2

      - name: Set up Python 3.8
        uses: actions/setup-python@v2
        with:
          python-version: 3.8

      - name: Install dependencies
        run: |
          python -m pip install --upgrade pip
          pip install requests

      - name: Run the script
        run: python tracker.py

      - name: Commit and push changes
        run: |
          git config --local user.email "action@github.com"
          git config --local user.name "GitHub Action"
          git add -A
          git diff-index --quiet HEAD || git commit -m "Update crypto price"
          git push
```

** Step 5: Unleash the Automation!**

1. Commit and push your code to the `main` branch.
2. Visit the "Actions" tab and witness your workflow springing to life, updating prices daily!

**Remember:**

* Adjust the script for your desired cryptocurrency.
* Replace `'bitcoin'` with its symbol.

**Now you have a self-updating Cryptocurrency Price Tracker, powered by the magic of GitHub! Feel free to customize and explore further!**

**P.S.:** A simple project to wish all of you: Happy coding!
Elevate Your Home Entertainment with Professional Speaker Installation Services in Dubai, UAE
Tags: villasoundsysteminstallation, speakerinstallation, homespeakerinstallation, speakersoundsystem
Published: 2024-02-19 09:00:38

In the bustling metropolis of Dubai, where luxury and innovation converge, finding the perfect balance between technology and comfort is paramount. One such avenue where this harmony is achieved is through state-of-the-art [home speaker installation services](https://technical-24.com/en/speaker-installation/). At Technical-24, we bring unparalleled expertise and dedication to transforming your living space into a haven of immersive audio experiences.

Tailored Solutions for Every Home

Our commitment to excellence begins with understanding the unique needs and preferences of each homeowner. Whether you reside in a spacious villa or a cozy apartment, our speaker installation services are designed to elevate your audio experience to new heights. From selecting the perfect speakers to configuring the sound system for optimal performance, our team of experts ensures a seamless installation process tailored to your specific requirements.

Seamless Integration, Superior Performance

At Technical-24, we recognize that aesthetics play a crucial role in home design. That’s why our skilled professionals meticulously integrate speaker sound systems into your home’s architecture, ensuring a seamless blend that enhances both form and function. Whether it’s a [villa sound system installation](https://technical-24.com/en/speaker-installation/) or configuring a sound system for a villa, our attention to detail ensures that every element aligns harmoniously, delivering superior audio performance without compromising on style.

Unrivaled Expertise, Unmatched Quality

With years of experience in the industry, Technical-24 has earned a reputation for excellence in home speaker installation services across Dubai, UAE. Our team’s expertise extends beyond mere installation — we are your partners in creating unforgettable audio experiences within the comfort of your home. From concept to completion, we prioritize quality craftsmanship and personalized service, ensuring that every installation exceeds expectations.

Transform Your Home Entertainment Experience

With Technical-24’s home speaker sound system installation services, you can unlock the full potential of your home entertainment system. Whether you’re hosting movie nights with friends or enjoying a quiet evening with your favorite music, our professional installations guarantee immersive sound quality that transports you into the heart of the action.

Experience the Difference with Technical-24

In Dubai’s dynamic landscape, where luxury knows no bounds, Technical-24 stands as a beacon of innovation and excellence in home speaker installation services. Elevate your home entertainment experience with our bespoke solutions, meticulously crafted to exceed your expectations and enrich your lifestyle. Discover the perfect harmony of technology and comfort with Technical-24 — where every installation is a masterpiece in sound.
Colab on a project
Tags: javascript, programming, react, aws
Published: 2024-02-19 09:00:13

I’m the founder of JobTask.

Our website is www.JobTask.co.uk

I’m looking to collaborate with some developers on my project.

The project is halfway done and needs improvement.

The aim is to digitise the services industry and become a market leader.

We have a website and iOS / Android App(s).

I cannot afford to pay you for your work right now but can offer you shares in the company.

I strongly believe in my company and I believe this is a Unicorn.

I seek to find likeminded, hardworking individuals who can bring us to production in record breaking time.

Thank you for taking time to read this post and I look forward to embarking on this exciting journey together.
Detect MacOS, iOS, Windows, Android and Linux OS with JS
Tags: codepen, javascript, webdev, tutorial
Published: 2024-02-19 08:59:01

This code snippet detects the user's operating system (OS) and performs a specific action based on their OS. It starts by displaying an element on the webpage with the class "os" where the detected OS will be shown.

The getOS() function determines the user's OS by examining the platform information obtained from the user agent string. It checks for various platform strings associated with popular operating systems such as Mac OS, iOS, Windows, Android, and Linux. Once the OS is determined, it is stored in the os variable.

The detected OS is then displayed on the webpage by assigning it to the innerText property of the selected HTML element. This provides a visual representation of the user's OS.

Additionally, if the detected OS is "Android", the code redirects the user to a specific URL using window.location.replace(). In this case, the URL corresponds to an intent URL for the Instagram app, potentially directing Android users to the app for further interaction. If the OS is not "Android", no redirection occurs.

This code snippet allows for OS-specific handling and customization, enhancing the user experience by providing tailored functionality based on their operating system.

Demo:
{% codepen https://codepen.io/webs95/pen/ZERPWdO %}
S01E02: Website, Mastodon and Event Catalogues
Published: 2024-02-19 08:57:47


## Website
We build the[ website](https://how.camp). It's a static HTML template we purchased at Themeforest. We did it in the two languages of the conference - Bulgarian and English.

Since we didn't have much information, we added everything we knew and filled the empty spaces with an FAQ. Usually, no one reads it.

## Mastodon
We created a Mastodon account to share news and contact the community. It's [@howcamp@fosstodon.org](https://fosstodon.org/@howcamp), and we currently have **19 **followers.

## Submit to event catalogs.
We know the date and the location, so we added the event to the event listings: 

- foss.events  -[ you start from here](https://foss.events/new-event).
- confs.tech - start [here](https://confs.tech/conferences/new), but you would need GitHub account to do a PR.
- dev. events - fill in a form on the website.
- developers.events - you need to create a [PR against their repo](https://github.com/scraly/developers-conferences-agenda)
- EOS - start with a PR [here](https://github.com/Everything-Open-Source/open-source-events).

Then, just after a few days, your event will be present on their website, and thanks to their authority, it will be easily discovered by search engines.

## Search for speakers
We started reaching out to people we know from the past or we liked by watching their presentations at events like [FOSSDEM ](https://fosdem.org) or [OpenFest](https://openfest.org). 

At the moment, we have one confirmed speaker. His name is [Luca Weiss](https://lucaweiss.eu/), and he is an Android Developer at FairPhone. 

## Venue
Since we aim to organize the event via the Internet, we approached a few venues over e-mail. We received offers from 3 out of 3 we asked. We must pick one soon, based on our budget and other factors we will share next week.

## Registrations
The event is free, but we would like to encourage people to pre-register so we can know how big of a room to book. Currently, we aim for 80 people present, and we have 75 seats left!


Till next week, friend!
Disable auto line break in VS Code
Published: 2024-02-19 08:54:17

To disable the auto line break in the VS code.
Are you struggling to disable the auto line break in vs code from the Prettier extension? If yes this is for you :)

Open vs code => Code => Preferences => Settings => In the search field type: Prettier
Now from the provided Prettier settings, choose the Prettier: Print Width


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5xtjardr13jwmqqrm839.png)


Screenshot
And Instead of 80, you can make it a big number. Eg: 999999
Now you don't have to worry about the line break.

[link](https://www.reddit.com/r/vscode/comments/lkz3d7/to_disable_the_auto_line_break_in_the_vs_code/)
85win 75win 85win.me Link Dang Ky Moi Nhat Tang 185K
Published: 2024-02-19 08:53:12

85win la san choi so huu rat nhieu tua game ca cuoc hap dan. De tim hieu het nhung tro choi nay thi moi ban theo doi bai viet sau day cua chung toi.
Dia chi: 1 Nguyen Van Qua, Dong Hung Thuan, Quan 12, Thanh pho Ho Chi Minh, Viet Nam
Email: 85win.me@gmail.com
Website: https://85win.me/
Dien thoai: (+63)9627550925
#85win #85winme #75win #85winapp #85wintop #85win99com #85win88com #85win55com




Social links:




https://85win.me/

https://85win.me/thanh-nam/

https://85win.me/chinh-sach-bao-mat/

https://85win.me/dieu-khoan-dich-vu/

https://85win.me/gioi-thieu-85win/

https://85win.me/lien-he-85win/

https://85win.me/dang-ky-85win/

https://85win.me/dang-nhap-85win/

https://www.facebook.com/85winme1

https://twitter.com/85winme

https://vimeo.com/85winme

https://www.pinterest.com/85winme/

https://www.tumblr.com/85winme

https://www.twitch.tv/85winme/about

https://www.reddit.com/user/85winme/

https://www.youtube.com/@85winme

https://500px.com/p/85winme?view=photos

https://www.flickr.com/people/85winme/

https://gravatar.com/85winme

https://about.me/nhacai85winme

https://www.instapaper.com/p/85winme

https://www.mixcloud.com/85winme/

https://hub.docker.com/u/85winme

https://flipboard.com/@85winme/

https://issuu.com/85winme

http://www.babelcube.com/user/nha-cai-85win

https://beermapping.com/account/85winme

https://qiita.com/85winme

https://profile.hatena.ne.jp/nhacai85winme/

https://www.reverbnation.com/artist/85winme

https://guides.co/g/85winme/343510

https://myanimelist.net/profile/85winme

https://os.mbed.com/users/85winme/

https://glose.com/u/85winme

https://www.blogger.com/profile/13828519617771229712
Weekly Roundup 040 (Feb 12): 🔥Hot Topics🔥 in #workplace, #sharepoint, and #powerplatform
Tags: roundup, workplace, sharepoint, powerplatform
Published: 2024-02-19 08:52:29

Hey fellow developers! It's @jaloplo, here to give you the latest scoop on what's been happening in the [#workplace](https://dev.to/t/workplace), [#sharepoint](https://dev.to/t/sharepoint), and [#powerplatform](https://dev.to/t/powerplatform) communities. 😎

## [#workplace](https://dev.to/t/workplace)

- [5M’s of Document Digitization](https://dev.to/aiqod/5ms-of-document-digitization-2lf0) by [AIQoD](https://dev.to/aiqod)

## [#sharepoint](https://dev.to/t/sharepoint)

- [Are We Evolving to Homo Copilot?](https://dev.to/jaloplo/should-we-call-us-homo-copilot-1aoo) by [Jaime López](https://dev.to/jaloplo)
- [SPFx web part and navigation in the property pane](https://dev.to/guidozam/spfx-web-part-and-navigation-in-the-property-pane-5edk) by [Guido Zambarda](https://dev.to/guidozam)

## [#powerplatform](https://dev.to/t/powerplatform)

- [How to - Power Apps Getting Polling Update from File Upload](https://dev.to/wyattdave/how-to-power-apps-getting-polling-update-from-file-upload-547g) by [david wyatt](https://dev.to/wyattdave)
- [Banana Decryption: Unpacking Caesar Cipher with Power Automate](https://dev.to/balagmadhu/banana-decryption-unpacking-caesar-cipher-with-power-automate-595p) by [Bala Madhusoodhanan](https://dev.to/balagmadhu)
- [Building app using Power Apps in teams](https://dev.to/ladislavszolik/building-app-using-power-apps-in-teams-38io) by [Ladislav Szolik](https://dev.to/ladislavszolik)
- [Unraveling Microsoft Fabric: A Comprehensive Guide to SaaS, Power BI, and Real-Life Applications](https://dev.to/shishsingh/unraveling-microsoft-fabric-a-comprehensive-guide-to-saas-power-bi-and-real-life-applications-4h32) by [Shish Singh](https://dev.to/shishsingh)

> *Are you well-acquainted with SharePoint, Microsoft Teams, or OneDrive and their capacity to enhance employee value? Familiar with the intricacies of Power Apps, Power Automate, or other Power Platform services? Concerned about the Workplace experience and eager to share insightful perspectives?* 
> 
> *Let's harness your expertise to create valuable content! I'm on the lookout for collaborators to co-author insightful articles and support others. 🚀💼 Connect with me on [Twitter](https://twitter.com/jaloplo), [Mastodon](https://techhub.social/@jaimelopezlopez) or [LinkedIn](https://www.linkedin.com/in/jaimelopezlopez/). Feel free to send me a message!*


That's all for this week's roundup! Thanks for tuning in, and remember to keep the discussions lively and informative in our tags. 💬 If you have any suggestions for future topics, feel free to drop them in the comments below. See you next week! 👋
Unlock Your Potential with DumpsVilla
Published: 2024-02-19 08:50:07

Empowering Learners Through Accessibility:
Dumps Villa is dedicated to making education accessible to all, regardless of barriers such as geography, <a href="https://dumpsvilla.com/">DumpsVilla</a> disability, or financial constraints. Through its online platform, Dumps Villa provides a flexible and inclusive learning environment that allows learners to access study materials, participate in discussions, and engage with instructors from anywhere in the world. Additionally, Dumps Villa offers financial assistance programs and scholarships to ensure that cost is not a barrier to education.
Driving Social Impact:
Dumps Villa recognizes the transformative power of education in driving social change and is committed to making a positive impact on society. Through initiatives such as community outreach programs, partnerships with non-profit organizations, and volunteer opportunities for staff and users, Dumps Villa contributes to initiatives that address issues such as educational inequality, workforce development, and digital literacy.
Promoting Lifelong Learning:
Lifelong learning is a core value at Dumps Villa, and it encourages learners to embrace a mindset of continuous growth and development. By offering a diverse range of courses, workshops, and resources across various disciplines, Dumps Villa supports learners in pursuing their interests, acquiring new skills, and adapting to a rapidly changing world. Whether it's <a href="https://dumpsvilla.com/">Dumps Villa</a> exploring new hobbies, gaining professional certifications, or simply expanding one's knowledge, Dumps Villa provides the tools and support for lifelong learning journeys.

Click Here For More Details>>>>>>>: https://dumpsvilla.com/
Unlock Your Potential with DumpsVilla
Published: 2024-02-19 08:50:05

Empowering Learners Through Accessibility:
Dumps Villa is dedicated to making education accessible to all, regardless of barriers such as geography, <a href="https://dumpsvilla.com/">DumpsVilla</a> disability, or financial constraints. Through its online platform, Dumps Villa provides a flexible and inclusive learning environment that allows learners to access study materials, participate in discussions, and engage with instructors from anywhere in the world. Additionally, Dumps Villa offers financial assistance programs and scholarships to ensure that cost is not a barrier to education.
Driving Social Impact:
Dumps Villa recognizes the transformative power of education in driving social change and is committed to making a positive impact on society. Through initiatives such as community outreach programs, partnerships with non-profit organizations, and volunteer opportunities for staff and users, Dumps Villa contributes to initiatives that address issues such as educational inequality, workforce development, and digital literacy.
Promoting Lifelong Learning:
Lifelong learning is a core value at Dumps Villa, and it encourages learners to embrace a mindset of continuous growth and development. By offering a diverse range of courses, workshops, and resources across various disciplines, Dumps Villa supports learners in pursuing their interests, acquiring new skills, and adapting to a rapidly changing world. Whether it's <a href="https://dumpsvilla.com/">Dumps Villa</a> exploring new hobbies, gaining professional certifications, or simply expanding one's knowledge, Dumps Villa provides the tools and support for lifelong learning journeys.

Click Here For More Details>>>>>>>: https://dumpsvilla.com/