DEV Community: cGIfl300

Seasons in Dart

cGIfl300 — Sun, 15 Dec 2024 21:33:28 +0000

Few lines of code to get the actual season, I absolutely needed that on my computer. Sure, you need too.

#!/usr/bin/env dart

class Translate {
  String spring;
  String summer;
  String autumn;
  String winter;
  Translate({this.spring = "Printemps",
            this.summer = "Été",
            this.autumn = "Automne",
            this.winter = "Hiver"});
  }

class LastSeasonDate {
  int month;
  int day;
  LastSeasonDate({this.month = 0, this.day = 0});
  }

Translate translate = Translate();

String getSeason() {
  DateTime now = DateTime.now();
  int day = now.day;
  int month = now.month;

  LastSeasonDate endWinterDate = LastSeasonDate(month: 3, day: 20);
  LastSeasonDate endSpringDate = LastSeasonDate(month: 6, day: 20);
  LastSeasonDate endSummerDate = LastSeasonDate(month: 9, day: 20);
  LastSeasonDate endAutumnDate = LastSeasonDate(month: 12, day: 20);

  if ((month == endWinterDate.month && day > endWinterDate.day)
      || (month < endSpringDate.month )
      || (month == endSpringDate.month && day < endSpringDate.day + 1)) {
    return translate.spring;
  } else if ((month == endSpringDate.month && day > endSpringDate.day)
      || (month < endSummerDate.month)
      || (month == endSummerDate.month && day < endSummerDate.day + 1)) {
    return translate.summer;
  } else if ((month == endSummerDate.month && day > endSummerDate.day)
      || (month < endAutumnDate.month)
      || (month == endAutumnDate.month && day < endAutumnDate.day + 1)) {
    return translate.autumn;
  } else {
    return translate.winter;
  }
}

void main() {
  print(getSeason());
}

DJango Secret

cGIfl300 — Mon, 07 Feb 2022 22:14:15 +0000

How to create a DJango secret ?

The DJango SECRET is an important random string for the security of your project, the problem is to generate a new one when needed.

Django includes a simple way to do it, why not using it?

Create your venv, activate it and install the jango package

Once done, just use the CLI.

From the terminal

python -c 'from django.core.management.utils import get_random_secret_key; print(get_random_secret_key())'

Happy New Year

cGIfl300 — Sun, 02 Jan 2022 15:50:23 +0000

Hire me !
https://www.cgifl300.com/hire_me.html

Embed YouTube Videos in a Markdown document

cGIfl300 — Sun, 02 Jan 2022 09:21:37 +0000

Memo - Insert a YouTube video into a Markdown document

How-to

You can click on the video above to see animated images :-).

[![Watch the video](https://img.youtube.com/vi/<your video id>/hqdefault.
jpg)]
(https://youtu.be/<your video id>)

Example:

[![Watch the video](https://img.youtube.com/vi/KdBwnjDa_8Y/hqdefault.
jpg)]
(https://youtu.be/KdBwnjDa_8Y)

This memo is also avaible there

PostgreSQL Fast deploy and Easy Remote Admin

cGIfl300 — Thu, 30 Dec 2021 16:04:46 +0000

PostgreSQL managed servers are expansive, why not just using your own VPS to add one?

This is a really short memo, the purpose is to have a PostgreSQL server running on a single computer as fast as possible to start dev things.

PostgreSQL

Installation

To allow connexions from any host on the internet

Edit the postgresql.conf file

sudo pico /etc/postgresql/13/main/postgresql.conf

# - Connection Settings -

listen_addresses = '*'          # what IP address(es) to listen on;

Add users authentification

sudo pico /etc/postgresql/13/main/pg_hba.conf

host    all             all              0.0.0.0/0                       md5
host    all             all              ::/0                            md5

Create your first remotely allowed superuser

sudo -u postgres psql

postgres=# CREATE USER username WITH PASSWORD 'password' CREATEDB SUPERUSER CREATEROLE INHERIT LOGIN REPLICATION BYPASSRLS;
CREATE ROLE
postgres=# \q

sudo service postgresql restart

Admin

The best way to admin the database will be to remotely use pgAdmin you
could add users, change passwords and add databases on demand.

Enought reading here, start reading on My Blog

Hyper QuickStart to MySQL

cGIfl300 — Wed, 29 Dec 2021 08:34:34 +0000

Be straight, just do it.

MySQL

MySQL is a SQL Database.

To connect to a MySQL Database you need:

The server address
A username
A password
A database

Admin the MySQL

To enter the admin console you have 2 options.

mysql

As root, use mysql:

mysql

As user:

mysql -u=my_username -p

-p means a password is required, you need to have a user account on the
MySQL server to use it.
To exit the shell, use:

exit;

MySQL Workbench

A very good tool you can download with a GUI to remote control any MySQL
server.

Using your user account you can manage everything with few clicks.

Users

Create a user

When you create a user account, it doesn't have any right, you have to add them
to use a database or anything.

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

% as domain allow a connexion from anywhere

localhost as domain restrict the usage to a local connexion only.

Grant a user

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

Grant Different User Permissions

Common possible permissions users can enjoy.

ALL PRIVILEGES - as we saw previously, this would allow a MySQL user full access to a designated database (or if no database is selected, global access across the system)
CREATE - allows to create new tables or databases
DROP - allows to them to delete tables or databases
DELETE - allows to delete rows from tables
INSERT - allows to insert rows into tables
SELECT - allows to use the SELECT command to read through databases
UPDATE - allow to update table rows
GRANT OPTION - allows to grant or remove other users’ privileges

You can use this template to grant a permission to a user:

GRANT type_of_permission ON database_name.table_name TO 'username'@'localhost';
FLUSH PRIVILEGES;

Update a password

ALTER USER 'user-name'@'localhost' IDENTIFIED BY 'NEW_USER_PASSWORD';
FLUSH PRIVILEGES;

Delete a user

DROP USER 'user'@'localhost';

Databases

Add a database to a specific user

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE my_database;
GRANT ALL PRIVILEGES ON my_database TO 'newuser'@'localhost';

Delete a database

DROP DATABASE db_name;

Alternative:

DROP SCHEMA db_name;

Both commands do the same.

You don't like dev.io? No problem, bookmark this

Everyone should be a full-stack developer

cGIfl300 — Tue, 28 Dec 2021 08:33:21 +0000

In the early 2000s, the software industry was in dire need of workers, so specialists appeared. Like the surface technician, it was the logical consequence of strong industrialization. It is faster to break up a project into small tasks given to low-skilled workers than recruit full skilled workers for a project.

Since the 2000s, therefore sectors have emerged to meet these needs and certifications to validate the skills of these low-skilled workers.

Gentlemen, Ladies, stop procrastinating by repeating no one can develop an electronic system and the program that fit in, no one can write a front-end and a backend, you are only accentuating the reflect of your incompetence, your willingness not to learn anything in a domain where information and learning skills are sold.

Please, start improving your skills instead of trying to do less for more...

First Post

cGIfl300 — Tue, 14 Dec 2021 15:03:49 +0000

Hi around, here is my first post, have a fly to my website.