Home / user-11272

g3rv4's questions

Martin Hope
g3rv4
Asked: 2020-05-30 04:52:57 +0800 CST
  • 11

I have the following code:

text = 'check this regex<placeholder>, it will do what you want';
result = text.replace('<placeholder>', ' `^sql$`');

console.log(result);

As you can see, the result is

check this regex `^sqlcheck this regex, it will do what you want

when i would expect it to be

check this regex `^sql$`, it will do what you want

Why is this happening? and... how can I fix it?

javascript
Martin Hope
g3rv4
Asked: 2020-03-15 16:18:15 +0800 CST
  • 3

I have a table with this structure:

Create Table dbo.DoesNotMakeSense
(
  Id Int Not Null Identity (1, 1),
  Name NVarChar(100),
  CreationDate DateTime Not Null,

  Constraint PK_DoesNotMakeSense Primary Key Clustered (Id Asc)
)
On [Primary]

And I want to insert records using SqlBulkCopy (because there are going to be a lot of them). When I use this code:

static void Main(string[] args)
{
    var table = new DataTable();
    table.Columns.Add("Name", typeof(string));
    table.Columns.Add("CreationDate", typeof(DateTime));

    table.Rows.Add("Pepe", DateTime.UtcNow);

    using(var db = new SqlConnection("Server=127.0.0.1;Database=Traducir;User Id=sa;Password=SuperP4ssw0rd!;"))
    using(SqlBulkCopy copy = new SqlBulkCopy(db))
    {
        copy.DestinationTableName = "dbo.DoesNotMakeSense";
        db.Open();
        copy.WriteToServer(table);
    }
}

It fails with an exception that saysCannot insert the value NULL into column 'CreationDate', table 'Traducir.dbo.DoesNotMakeSense'; column does not allow nulls. INSERT fails.

Obviously, this is inserting NULLinto the CreationDate... but why?

I'm running SQL Server Express on Linux (although I don't think it makes a difference...because my suspicion is that SqlBulkCopy isn't serializing the value of CreationDate) correctly.

c#
Martin Hope
g3rv4
Asked: 2020-07-26 15:42:10 +0800 CST
  • 23

Another developer pushed his changes to the remote repository and when I want to push I get the following error:

error: failed to push some refs to 'xxx@yyy'
hint: Updates were rejected because the remote contains work that you do
hint: not have locally. This is usually caused by another repository pushing
hint: to the same ref. You may want to first integrate the remote changes
hint: (e.g., 'git pull ...') before pushing again.
hint: See the 'Note about fast-forwards' in 'git push --help' for details.

How can I upload my changes?

git
Martin Hope
g3rv4
Asked: 2020-07-22 16:59:41 +0800 CST
  • 2

I have a repository with two remotes... one on GitHub (public) and one on a private server. On GitHub I want the branch to always be available and up-to-date master. On my private server I want to work in peace of mind that all my branches are always up to date and master(the work on my branches is temporary and I don't want it to be visible on GitHub).

How can I make git pushit upload to both remotes when I run if I'm in masteror only to my private repository if I'm in another branch?

git