Buy Ripple with PayPal or credit card

https://platform.twitter.com/widgets.js

Advertisements

Oracle Tips

Oracle SQL reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions183.htm (useless)
http://www.sqlines.com/oracle-to-sql-server/to_date (GOOD)

Last X records

SELECT res.* FROM 
(
    SELECT t.* FROM schema.table t
    ORDER BY t.field [ASC|DESC]
) res
WHERE ROWNUM < 10

Dates in queries

SELECT * FROM  schema.table
WHERE date_field > TO_DATE('2018-04-21', 'YYYY-MM-DD')
BEGIN
   schema.package.procedure(
      p_start_date   => TO_DATE ('27/05/2018 09:00:00',                                  'dd/mm/yyyy hh24:mi:ss'),
      p_end_date     => TO_DATE ('28/05/2018 09:00:00',                                'dd/mm/yyyy hh24:mi:ss'));
   COMMIT;
END;

Cannot delete my (suspended) account on Twitter

I create an account on Twitter on 14 March 2018.
I made apparently 5 tweet:

twitter 02b

I purposely created a Twitter account to advertise my website (www.xrp-shop.com).
As many other people and organization do.
So I thought it was legit.
Probably I violated the Twitter rules and my account was suspended.

twitter 03

I follow the instruction in the link:

twitter 04
and I filed an appeal.

Around 2 Days after I received this email:

twitter 05

Permanently suspended. “This account will not be restored”.
This is bad.

I still can access to my account but I cannot tweet or make any other activity.
So, my tweets are still visible?
Are them removed.
What can I do?
Nothing.

In this situation seems logic to delete the account.
On the help page they says:

twitter 06

I’m using a web browser on my desktop PC, not a mobile, but in the account settings page there noting for “Deactivate my account”.

I searched also in other sections but nothing.

I checked on the PC of a colleague and in its account settings page that link is available:

MaxthonSnap20180403150037

This is the HTML code, I tried to inject and use it for my account but it does not work:

<div class="control-group">
    <div class="controls">
        <p><a id="account_deactivate_link" href="/settings/accounts/confirm_deactivation" rel="noopener">Deactivate your account</a></p>
    </div>
</div>

How can I delete my Twitter account ?

Buy ripple with PayPal is no more a problem

Many people ask on web sites where to buy ripple (XRP) with a credit card or with PayPal.
Many web site suggest procedures where the user have to register on one or more web sites, buy a different cryptocurrency (usually Ethereum) and then exchange it for XRP.
This procedure is long and not simple.

Some example of this request:
https://www.quora.com/Where-can-I-buy-Ripple-XRP-with-PayPal
https://www.quora.com/How-do-I-buy-Ripple-XRP

In the last couple of months many web sites were creatd just to supply this demand.
You can buy XRP directly with a credit card or with PayPal.
Unfortunately the majority of them offer a really bad price or require time for the transaction.
I created one web site were the transaction is IMMEDIATE because I sell XRP that are already in my possession and the price is really competitive.

xrp-shop

It is fast.
I does not need verification.
Available for any country.

It is needed to provide an existent XRP wallet. To create a new one I suggest to use an exchange like Bitstamp, GateHub, Binance or a Toast Wallet.

MongoDB tips

Change user password

db.updateUser(){ , { pwd: ""}}

Choose the ID field

We do not want to pollute our entities/classes with MongoDB attributes.
WE want to store the “Email” property as ID in mongoDB (the “_id” field of the document).

SetIdMember … does not work.
MapIdMember is the right one.


protected override void MapEntity()
{
if (!BsonClassMap.IsClassMapRegistered(typeof(Account)))
{
BsonClassMap.RegisterClassMap(map =>
{
map.AutoMap();
map.MapIdMember(c => c.Email);
map.SetIgnoreExtraElements(true);
});
}
}

SQL Server connection fails

– IDK: I don’t know
– Y: yes
– N: no

Which version is your SQL Server ?
– I don’t know
– 2016
– 2014
– 2005

Are you using an IP in the conenction string?
– Y
– N

Is the application that need to conenct on the same machine of SQL Server ?
– Y
– N

Are you using a Trusted conenction?
– IDK
– Y
– N

Are you using “localhost” as server name?
– IDK
– Y
– N

Do you know which connection string are you using?
– IDN
– Y
– N

Are the TCP inbound/outboundport allowed for port 1433?
– IDN
– Y
– N

The Login user in SQL Server is allowed to connect and login?
– IDN
– Y
– N

+ A001: use “(local)” instead of “localhost”
+ A002: check this: https://support.microsoft.com/en-us/help/328306/potential-causes-of-the-sql-server-does-not-exist-or-access-denied-err
+ A003: use “(local)” or instead of the IP address
+ A004: check this settings in Server/Security/Logins/User/(right click)/Properties/(Status section)
[attach image]

Connection fail to SQL Server after a database restore

Scenario.

Restore SQL Server database X.
Try to conenct using the usual connection string. Conenction fail.

Yes
Yes
Delete the user in “Security” of SQL Server.
Delete the user from the “Users” of the database.
Create a new user in Server/Securit6y/Logins:
– User name: seelct a user that exists in the machine, ex.: \user
– leave everything unchaged
Create a user in the database in database/Security/Users:
– Login namne: seelct <achine\
– User name: select \
No
Todo
> Yes
< Do you use an IP address in the connection string?

in the database:
– User name: select / using hhe selector
– Login name:
– Default schema:
> No
Yes
Check the user defined in the Application Pool of the current web site
> No
Todo
> No
Todo

MVC API tests – manage unknown error raised by HttpServer

Scenario: integration tests against ASP.Net MVC API.
MVC version 5.2

Create a base class test to manage the repetitive API GET/POST calls like:

protected HttpResponseMessage Execute(HttpMethod method, string url, T data)
{
url = BASE_URL + url;

HttpRequestMessage request = new HttpRequestMessage(method, url);
request.Headers.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

JsonMediaTypeFormatter formatter = new JsonMediaTypeFormatter();
formatter.SerializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver();
if (method == HttpMethod.Post && data != null)
request.Content = new ObjectContent(data, formatter);

using (var server = new HttpServer(GetConfiguration()))
using (var client = new HttpClient(server))
{
var response = client.SendAsync(request).Result;
return response;
}
}

Boom.

500. Internal server Error.

The server is set like this:
private HttpConfiguration GetConfiguration()
{
HttpConfiguration configuration = new HttpConfiguration();
//var dependencyResolver = new WindsorDependencyResolver(container);
//configuration.DependencyResolver = dependencyResolver;
WebApiConfig.Register(configuration);

// remove all HostAuthenticationFilter due to the error “no OWIN Authentication manager…”
foreach (var filter in configuration.Filters.Where(f => f.Instance is HostAuthenticationFilter).ToList())
configuration.Filters.Remove(filter.Instance);

return configuration;
}

mmhh… try to debug:
It enter in the ApiController, get the data from the REpository and it exit from the class with a nice colelction of data… what is wrong ???

Routing is ok, it is actually passing the request to the right controller.
Injection of repositories is ok, it is fetching and returning data.
Log4Net is ok, I’m not calling the “log4net.Config.XmlConfigurator.Configure();” without a proper configuration in app.config.

Adding “configuration.IncludeErrorDetailPolicy = IncludeErrorDetailPolicy.Always;”
is absolutely useless for this problem.

What to do now?

I’ll check one of 2 or 3 previous project where I’ve already done this a where I spent 1,2 or 7 days to figure out this ALL THE TIMES fucking problem !

What I think is wrong in Python

datetime.now() vs datetime.today()

datetime.today() returns a datetime WITH the time part.
datetime.now() returns a datetime WITH the time part.
So…
from datetime import datetime
now = datetime.now()
today = datetime.today()
print(now)
print(today)

In other languages today is used to return a date time WITHOUT the time part.

Output:
datetime.datetime(2017, 6, 24, 21, 11, 27, 374230)
datetime.datetime(2017, 6, 24, 21, 12, 1, 166053)

filter(filter_rule, collection) vs filter(collection, filter_rule)

filter(lambda x: x > 1, []) is Correct.
filter(lambda x: x > 1, []) is Wrong.

I expect to have filter(what, how), that means filter(collection, filter) followinth the “pattern” Object.Action.
I think the form filter(collection, filter_rule) is more intuitive.

%y %m %d is embarassing

Every time I have to parse or format a string to a date I need to read the documentation carefully.