Saturday, July 31, 2021

Work work

 Long story short: I decided this morning I wanted that cure flights table

from sqlite should show a title FLIGHTS. Never manage to do it. 

what I did find is that it is possible to export a databse in an html file.

Here's how that goes:








The created file is indeed html, but the information within it needs to be translated

to html commands!! Quite a bit of work, in fact.


Which is undoubtely the motivation for python/django taking over this task...

Friday, July 30, 2021

Foreign Keys

 Trying to ge tused to inputing to sqlite. The first flights table uses text entries 

for origin and destination. I can redo this table using foreign keys, which adds more information.

I create a table of airports with airport code. Then my flights table - foreing keys - becomes

merely numbers in the origin and destination columns. Neat!!






https://www.sqlite.org/cli.html

Thursday, July 29, 2021

Requirements

 An interesting piece on maintaining weight loss by a kinesiologist. In his

view, exercise is primordial because the more energy one spends, the better,

because eating behavior thus becomes oriented to meeting energy requirements...


https://www.journaldemontreal.com/2021/07/25/les-secrets-du-maintien-de-poids


                                         *     *     *

Ploughing through that tutorial on sqlite and python. the question I answered today

was the following: once I start making chnages to my database from django, is

the original affected. The answer is no; turns out django keeps a running log of

the 'migrations' I have made - much on the model if Git - and I can go back to

an earlier version anytime...

Wednesday, July 28, 2021

Clear Screen

 



control plus down arrow!





Python Shell

 


                                              from: Stackoverflow


                                           from:  W3Schools


Tuesday, July 27, 2021

Tips

 Been re-doing the database, now that I am in a more rested state. Found how to

copy/paste on a command prompt. One left-drags the text one wants to copy,

right-click into it, right-click inthe destination...


Also very useful: how to go back to a previous command using F7

and the arrow board:


                                                 *     *     *

The complete flights board!



                                 *     *     *


After much confusion, got it right:

A clean re-install of sqlite!


A successful link between sqlite data and django models:


The consequence: the appearance of new code, based on my alterations to models.
 




I have added the database to my airline project.


                                             *     *     *

Downloading python comes with a surprise: the Idle code editor. It is

wholly customizable for a friendly coding experience, when using the

python language.




















Monday, July 26, 2021

Buggy

 VSCode is going buggy on me: keeps repeating this message

when I try to do anything. I've re-installed the app, removed every

sqlite extension, all to no avail.



Now what!?

                                                   *     *     *

Fixed that bug by getting rid of trust settings!!

Have a real rpoblem now; coded my tables with amispelled name 'fligths' rather

than 'flights". Will have to redo everything tomorrow. ..

Destruction

 Might do a translate/edit on this later today!?

La flotte russe capable de détruire « n’importe quelle cible », selon Poutine | La Presse


                                                *     *     *

source: La Presse  Posted on July 25, 2021 

author: Agence France Presse

translation: EdgeTranslate/doxa-louise

The Russian fleet is capable of destroying "any target", according to Putin

PHOTO ALEXEI NIKOLSKY, SPUTNIK, KREMLIN VIA AP

"Today, the Russian fleet has everything it needs to defend the homeland and our national interests in an infallible way," President Vladimir Putin said.

(St. Petersburg) President Vladimir Putin said on Sunday that the Russian fleet was capable of detecting and destroying "any target", during a large naval parade he attended in St. Petersburg.

"Today, the Russian fleet has everything it needs to defend the homeland and our national interests in an infallible way. We are able to detect any enemy target underwater, on the ground or in the air and deliver a lethal blow if necessary," Putin said in a televised speech.

According to him, Russia has earned its place among the "world's leading maritime powers" by having developed "efficient short- and long-range naval aviation, reliable coastal defence systems and state-of-the-art high-precision hypersonic weapons, which have no equivalent in the world and which continue to be constantly and successfully improved".

Vladimir Putin and Defense Minister Sergei Shoigu participated in the annual grand parade of the Russian fleet on the Neva in St. Petersburg.

This speech was delivered on the sidelines of the great annual parade of the Russian fleet on the Neva in St. Petersburg, the country's second largest city.

Against the background of strong tensions with the West, Vladimir Putin has not ceased to praise in recent years the new weapons, according to him "invincible", designed by his country.

Among them are the new generation Avangard hypersonic missile, capable of reaching a speed of Mach 27 and changing course and altitude, put into service with the Russian army in December 2019 or the Zircon flying at Mach 7, successfully tested in July.

Sailors lined up on the deck of a K-549 ballistic missile submarine.

Several other weapons, such as the Kinjal hypersonic missile for the air force and the Burevestnik nuclear-powered missile, are being developed.

The state-of-the-art S-500 air defence systems, billed as "unparalleled in the world", were also successfully tested on 20 July.

Sunday, July 25, 2021

New DBase

 Installed sqlite from the site - the windows tools larger file - and 

I'm up and running; created a data base just like in the tutorial...



https://www.servermania.com/kb/articles/install-sqlite/



Delete:


Id problem:


Update:



Saturday, July 24, 2021

Long Day

 Long day trying to get the following equivalent for windows.





Finally got a pip download of sqlite3; have yet to locate it!! Seriously...


Found an interesting youtube on it:

https://youtu.be/wXEZZ2JT3-k


                                                              *     *     *

Made a cake with the Sour Cream I'm not using up on salads...




                                                              *     *     *

Found something:



Friday, July 23, 2021

Veuiller

 Client-side validation and server-side validation are not the same

thing. Server can receive new instructions that client is not aware of.

Below, I have lowered the max priority from 10 to 5, without refreshing

the add view.





Here, the page has been refreshed:


Was managing to have the tasks show up on the tasks list by making tasks a global

variable. Problem was, every instance of the Tasks list had the same tasks on it.

By creating a session and migrating the data (to a table), now have

effierent concurrent sessions.

     






Trounced

 


Seems I am getting trounced at the Google Olympics!!

Thursday, July 22, 2021

Security

 Still with the django tutorial. Interesting to understand how

certain transactions can be hacked... in effect, misdirected.


Below, my add a taks page will not go anywhere without a django

security token:








                                                              *     *     *

Tasks is an app within the lecture3 project. Currently, one can go from

a task list to a submit a task form, and back. All the views are html defined,

with CSS. All the programming logic is python. The modules are django,

written engirely with python: the imports and double curly brackets for

running functiond on variables...







Tomorrow's work: getting the tasks we submit added to the tasks list; creating a session

only available to an individual,user.