Scripts

ELIMINAR USER PROD

--SELECT * FROM [Equipment]
--DELETE FROM [Recommendation] WHERE IdCarrier= '2E24E8A1-9FA4-4601-84F0-DAD62AB3151B'
--DELETE FROM [Equipment] WHERE IdCarrier= '2E24E8A1-9FA4-4601-84F0-DAD62AB3151B'

--DELETE FROM [Trailer] WHERE IdCarrier= '2E24E8A1-9FA4-4601-84F0-DAD62AB3151B'
--DELETE FROM [Truck] WHERE IdCarrier= '2E24E8A1-9FA4-4601-84F0-DAD62AB3151B'
--SELECT * FROM [User]
--DELETE FROM [Notifications] WHERE IdUser= '01E91B57-CB7A-47D8-83D8-D777239B1C34'

carga a quien le llego 0

SELECT idcarrier from [user] where email=''
-- 
select id,description,idcountry,IdCarrier,IdStatus 
from [load] where IdNumeric=
-- 

select * from recommendation where IdLoad=''
--

insert into recommendation 
(IdLoad,IdCarrier,IdEquipment,
[Status],ExpiryDate,created_at,updated_at,deleted_at,SawApproval
)
VALUES ('','',19,
1,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,NULL,0)

update [recommendation] SET ExpiryDate='' where Id=
update [recommendation] SET IdCarrier='' where Id=

reiniciar cargas

TRUNCATE TABLE LoadDataTransitionvalueimage ✅
TRUNCATE TABLE LoadDataTransitionvalue ❌1
TRUNCATE TABLE LoadDataTransition
TRUNCATE TABLE LoadStepTransitionComponent
TRUNCATE TABLE LoadStepTransition

❌1
TRUNCATE TABLE LoadStepTransitionComponent✅
--
LoadDataTransitionvalue✅
DELETE FROM [dbo].LoadDataTransitionvalue
      WHERE Id=1(repetir con todos=2,=3...)
GO
--
LoadDataTransition✅
DELETE FROM [dbo].LoadDataTransition
      WHERE Id!=1
GO
---
LoadStepTransition✅
DELETE FROM [dbo].LoadStepTransition
      WHERE IdLoad='140AB2AD-1004-4F1B-85DD-30D288EBEEC8'
GO

eliminar usuario

select * from [user] where email='pabloierino.kargho@gmail.com'
select * from [driver] where Id='1D110CCC-CDDC-4FCD-BB67-CB34E3419FFC'
select * from [equipment] where IdDriver='1D110CCC-CDDC-4FCD-BB67-CB34E3419FFC'
delete from [Recommendation] where IdEquipment=9
select * from [Load] where IdEquipment=9
select * from [loadsteptransition] where IdLoad='A3C69087-BE0B-42F4-8F40-5461C38152ED'
select * from loaddatatransition
--109,114
delete from [loaddatatransition] where IdLoadStepTransition=111
select * from loaddatatransitionvalue
select * from loaddatatransitionvalue where IdLoadDataTransition=113
delete from loaddatatransitionvalue where IdLoadDataTransition=113
select * from loaddatatransitionvalueimage where id=50
delete from loaddatatransitionvalueimage where id=50
select * from [loadsteptransition] where IdLoad='A3C69087-BE0B-42F4-8F40-5461C38152ED'
--109,114
delete from [loadsteptransition] where IdLoad='A3C69087-BE0B-42F4-8F40-5461C38152ED'
select * from [loadsteptransitioncomponent] where IdLoadStepTransition=109
delete from [loadsteptransitioncomponent] where IdLoadStepTransition=114
delete from [load] where IdEquipment=9
delete from [equipment] where IdDriver='1D110CCC-CDDC-4FCD-BB67-CB34E3419FFC'
delete from [driver] where Id='1D110CCC-CDDC-4FCD-BB67-CB34E3419FFC'
---------------------------------------------------------------------------------------------------
select * from [user] where email='pabloierino.kargho@gmail.com'
select * from [Load] where IdEquipment=9
delete from Recommendation where IdLOAD='376F7F7E-D9D6-4448-B299-AC0698F46402'
select * from Recommendation where IdEquipment=9
delete from [Load] where Id='376F7F7E-D9D6-4448-B299-AC0698F46402'

select * from LoadStepTransition where IdLoad='376F7F7E-D9D6-4448-B299-AC0698F46402'
delete from LoadStepTransition where IdLoad='376F7F7E-D9D6-4448-B299-AC0698F46402'

select * from LoadStepTransition WHERE iDlOAD='A3C69087-BE0B-42F4-8F40-5461C38152ED'
select * from LoadDataTransition WHERE IdLoadStepTransition=114
DELETE from LoadDataTransition WHERE IdLoadStepTransition=114

select * from LoadDataTransition where IdLoadStepTransition=114
delete from LoadDataTransition where IdLoadStepTransition=114

select * from LoadDataTransitionValue
select * from LoadDataTransitionValue WHERE IdLoadDataTransition=116
DELETE from LoadDataTransitionValue WHERE IdLoadDataTransition=116

SELECT * FROM LoadDataTransitionValueImage
SELECT * FROM LoadDataTransitionValueImage where IdLoadDataTransitionValue=52
delete from LoadDataTransitionValueImage where IdLoadDataTransitionValue=52
---------------------------------------------------------------------------------------------------
select * from [user] where email='pabloierino.kargho@gmail.com'
select * from [Load] where IdEquipment=9
delete from Recommendation where IdLOAD='376F7F7E-D9D6-4448-B299-AC0698F46402'
select * from Recommendation where IdEquipment=9
delete from [Load] where Id='376F7F7E-D9D6-4448-B299-AC0698F46402'

select * from LoadStepTransition where IdLoad='376F7F7E-D9D6-4448-B299-AC0698F46402'
delete from LoadStepTransition where IdLoad='376F7F7E-D9D6-4448-B299-AC0698F46402'
--115,120
select * from LoadDataTransition WHERE IdLoadStepTransition=120
DELETE from LoadDataTransition WHERE IdLoadStepTransition=120

select * from LoadDataTransitionValue WHERE IdLoadDataTransition=122
DELETE from LoadDataTransitionValue WHERE IdLoadDataTransition=122

SELECT * FROM LoadDataTransitionValueImage where IdLoadDataTransitionValue=55
delete from LoadDataTransitionValueImage where IdLoadDataTransitionValue=55

select * from LoadStepTransitionComponent where IdLoadStepTransition=116
delete from LoadStepTransitionComponent where IdLoadStepTransition=120
---------------------------------------------------------------------------------------------------
delete from notifications where IdUSER='3581642C-6E58-4D86-8753-E70605C24A5D'
delete from equipment where Id=9
---------------------------------------------------------------------------------------------------
select * from [user] where email='ierino1234@gmail.com'
delete from [user] where email='ierino1234@gmail.com'
delete from notifications where IdUser='3FBA9D46-0E4F-45F0-92B9-E244C3748E56'

select * from truck where idCarrier='22183B0D-6FFD-4DAB-9923-31DA845DE03C'
delete from truck where idCarrier='22183B0D-6FFD-4DAB-9923-31DA845DE03C'

select * from trailer where idCarrier='22183B0D-6FFD-4DAB-9923-31DA845DE03C'
delete from trailer where idCarrier='22183B0D-6FFD-4DAB-9923-31DA845DE03C'

agregar users

-- password 123456. cambiar contra una vez logueado
-- idcountry 1(EEUU), idcountry 2(ARG)
-- driver EEUU

INSERT INTO [User] (Id,Email,EmailVerifiedAt, IdDriver,IdCarrier,
Password,OneSignalId,created_at,updated_at, 
LastRequirementUploadTime,IdUserStatus,HasChangedRole,OnboardingComplete,OnboardingStep,
LastConnection, IdCountry,IdLanguage,IdShipper,IsActive) 
VALUES (NEWID(),'tumail@gmail.com',CURRENT_TIMESTAMP,NULL,NULL,
'$2y$10$3FJszNxBC/gnBwvcNjvJPuaPSbxSSeu/m3WGcaH1aua.kDhWl2W9e',NULL,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,
NULL,1,0,1,2,
CURRENT_TIMESTAMP,1,1,NULL,1)


-- idrole 2 (CARRIER), idrole 3 (DRIVER)
SELECT Id FROM [USER] WHERE EMAIL='tumail@gmail.com'
INSERT INTO [UserRole] (IdUser,IdRole)
VALUES(Id,3)

INSERT INTO [Driver] (Id,[Description],Phone,Email,PersonalAddress,
JobAddress,Sex,FirstName,LastName,created_at,
updated_at,deleted_at,StatePrefix,ELD,IdDriverStatus,
PersonalAddressZipCode,JobAddressZipCode,PersonalAddressState,JobAddressState,HosId,
MondoData,License,Latitude,Longitude,PromotionCode,
Cuit,Patente,CompanyAreaCode)
VALUES(NEWID(),'new_driver',NULL,NULL,NULL,
NULL,NULL,NULL,NULL,CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,NULL,NULL,NULL,1,
NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL
)


SELECT Id FROM [Driver] where [Description]='new_driver'
UPDATE [User] set IdDriver=Id where Email='tumail@gmail.com'

--- ############################################################

-- password 123456. cambiar contra una vez logueado
-- idcountry 1(EEUU), idcountry 2(ARG)
-- carrier ARG

INSERT INTO [User] (Id,Email,EmailVerifiedAt, IdDriver,IdCarrier,
Password,OneSignalId,created_at,updated_at, 
LastRequirementUploadTime,IdUserStatus,HasChangedRole,OnboardingComplete,OnboardingStep,
LastConnection, IdCountry,IdLanguage,IdShipper,IsActive) 
VALUES (NEWID(),'tucarrier@gmail.com',CURRENT_TIMESTAMP,NULL,NULL,
'$2y$10$3FJszNxBC/gnBwvcNjvJPuaPSbxSSeu/m3WGcaH1aua.kDhWl2W9e',NULL,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,
NULL,1,0,1,2,
CURRENT_TIMESTAMP,2,2,NULL,1)


-- idrole 2 (CARRIER), idrole 3 (DRIVER)
SELECT Id FROM [USER] WHERE EMAIL='tucarrier@gmail.com'
INSERT INTO [UserRole] (IdUser,IdRole)
VALUES(Id,2)

INSERT INTO Carrier (Id,[Description],Mc,Phone,JobAddress,
DotNumber,Sex,FirstName,LastName,ShipperAddress,
ReceiverName,created_at,updated_at,deleted_at,StatePrefix,
MailingAdress,CompanyType,CompanyYearOperating,CarrierOperation,CargoCarried,
CompanyEmployeeQuantity,USCrashQuantity,CanadaCrashQuantity,BusinessType,CompanyEmail,
CompanyPhone,CompanyWeb,ExpertiseAreas,OtherBusinessType,OtherCorporateStructure,
CorporateStructure,BrokerContact,BrokerAddress,CarrierDot,BrokerAddressCity,
CarrierMC,CarrierName,CompanyAlternativePhone,CompanyAlternativeEmail,CompanyEmergencyNumber,
OtherCompanyEmergencyNumber,CompanyZoneUS,CompanyZoneMexico,CompanyZoneCanada,Dni,
Cuit,CompanyAreaCode,MondoApiKey,Ein,Eld,
CompanyAlternativeAreaCode,ProviderGPS)
VALUES(NEWID(),'new_carrier_ar',NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
NULL,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
0,0,0,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
NULL,NULL)


SELECT Id FROM [Carrier] where [Description]='new_carrier_ar'
UPDATE [User] set IdCarrier=Id where Email='tucarrier@gmail.com'

--- ############################################################

-- password 123456. cambiar contra una vez logueado
-- idcountry 1(EEUU), idcountry 1(ARG)
-- shipper ARG

INSERT INTO [User] (Id,Email,EmailVerifiedAt, IdDriver,IdCarrier,
Password,OneSignalId,created_at,updated_at, 
LastRequirementUploadTime,IdUserStatus,HasChangedRole,OnboardingComplete,OnboardingStep,
LastConnection, IdCountry,IdLanguage,IdShipper,IsActive) 
VALUES (NEWID(),'nombreshipper@gmail.com',CURRENT_TIMESTAMP,NULL,NULL,
'$2y$10$3FJszNxBC/gnBwvcNjvJPuaPSbxSSeu/m3WGcaH1aua.kDhWl2W9e',NULL,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,
NULL,1,0,0,0,
CURRENT_TIMESTAMP,2,2,NEWID(),1)

-- idrole 4 (SHIPPER)
SELECT Id FROM [USER] WHERE EMAIL='nombreshipper@gmail.com'
INSERT INTO [UserRole] (IdUser,IdRole)
VALUES(Id,4)

select Id,IdShipper FROM [User] where email='nombreshipper@gmail.com'
INSERT INTO Shippers(Id,IdUser,CompanyName,CompanyRole,CompanyAddress,
CompanyPhone,CompanyEmail,CompanyWeb,[Name],ShipperTitle,
Phone,Email,EINNumber,DOTNumber,MCNumber,
CargoType,ShipmentFrequency,CommonDestinations,SpecialRequeriments,CommunicationDays,
CommunicationHourInit,CommunicationHourFinish,created_at,updated_at)
VALUES (IdShipper,Id,'','','',
'1122334455','companyemail@gmail.com','','nombre',NULL,
'1122334455','nombreshipper@gmail.com','',NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
NULL,NULL,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP)

Insertar requirements

select * from requirement WHERE IdCountry=2

update Requirement set SPANISHDescription='DNI (FRENTE)' where id=11

insert into requirement 
(Description,Code,RequiresBothSides,created_at,updated_at,
deleted_at,Priority,SpanishDescription,IdCountry)
VALUES
('DNI (DORSO)','dni_back',0,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,
NULL,1,'DNI (DORSO)',2)

select * from requirement
select * from requiremententity 

insert into requiremententity(
Id,IdRequirement,[IdEntity],created_at,updated_at,deleted_at
)VALUES(
NEWID(),28,3,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,NULL
)