EF Core – Misc Notes

dotnet tool install --global dotnet-ef
dotnet tool update --global dotnet-ef
dotnet add package Microsoft.EntityFrameworkCore.Design
dotnet ef
dotnet ef migrations add InitialCreate
dotnet add package Microsoft.EntityFrameworkCore.Design
dotnet tool update --global dotnet-ef
dotnet tool install --global dotnet-ef
dotnet --list-sdks
dotnet tool install --global dotnet-ef --version 9.0.0
dotnet add package Microsoft.EntityFrameworkCore --version 9.0.0

Code Test

myURL = "https://someurl.com/dir/page.html"
URLparts = myURL.rpartition('/')
print(URLparts[0])
print(myURL.rpartition("/")[0])
print(URLparts)

Common Powershell Commands

get-service

Get-Help
Get-Help -Name Get-*
Get-Command –Name *IP*
Set-ExecutionPolicy
Get-ExecutionPolicy
Get-Service
ConvertTo-HTML
Export-CSV
Get-Service | Export-CSV c:\service.csv
Select-Object
Get-Service | Select-Object Name, Status | Export-CSV c:\service.csv
Get-EventLog
Get-Process
Stop-Process
gwmi Win32_USBControllerDevice
Get-Process | Where-Object {$_.Name –eq “iexplore”}

Top 10 Cmdlets to Start Using Immediately
Get-Command retrieves a list of all available cmdlets.
Get-Help displays help information about cmdlets and concepts.
Get-WMIObject retrieves management information by using WMI.
Get-EventLog retrieves Windows event logs.
Get-Process retrieves a single or list of active processes.
Get-Service retrieves a Windows service.
Get-Content reads in text files, treating each line as a child object.
Add-Content appends content to a text file.
Copy-Item copies files, folders, and other objects.
Get-Acl retrieves access control lists (ACLs).

(more…)

Turn on PHP error reporting

To display error messages caused by your PHP script you can include these lines of code:

ini_set('display_errors',1); 
 error_reporting(E_ALL);

Another way to do it is to edit your php.ini file and include this option:

error_reporting = E_ALL

To turn error reporting off for a single document, include this line:

error_reporting(0);
Posted in: PHP

Time and Date w. Linux

View Time
To view the current date and time, the following command will be enough

date

Set Time
To change time means to set a new time. To set time in Ubuntu (or any Linux), just run the following command
sudo date newdatetimestring where newdatetimestring has to follow the format nnddhhmmyyyy.ss which is described below:

  • nn is a two digit month, between 01 to 12
  • dd is a two digit day, between 01 and 31, with the regular rules for days according to month and year applying
  • hh is two digit hour, using the 24-hour period so it is between 00 and 23
  • mm is two digit minute, between 00 and 59
  • yyyy is the year; it can be two digit or four digit: your choice. I prefer to use four digit years whenever I can for better clarity and less confusion
  • ss is two digit seconds. Notice the period ‘.’ before the ss.

Let’s say you want to set your computer’s new time to December 6, 2007, 22:43:55, then you would use:

sudo date 120622432007.55

MySQL Date Math

SELECT DATE_SUB(CURDATE(), INTERVAL 30 DAY);
SELECT DATE_SUB(CURDATE(), INTERVAL 1 MONTH)
SELECT DATE_SUB(CURDATE(), INTERVAL 3 MONTH)
SELECT DATE_SUB(CURDATE(), INTERVAL 6 MONTH)
SELECT DATE_SUB(CURDATE(), INTERVAL 12 MONTH)
SELECT DATE_SUB(CURDATE(), INTERVAL 18 MONTH)

SELECT DATE_SUB(CURDATE(), INTERVAL 24 MONTH)
SELECT DATE_SUB(CURDATE(), INTERVAL 10 YEAR)
SELECT DATE_SUB(CURDATE(), INTERVAL 100 YEAR)

1997-11-01

SELECT COUNT( `WB1` ) FROM `PB` WHERE `WB1` =  15 and `DDate` >= DATE_SUB(CURDATE(), INTERVAL 10 MONTH)



CURDATE()
  • Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context. 
    mysql> SELECT CURDATE();
        -> '2008-06-13'
mysql> SELECT CURDATE() + 0;
        -> 20080613