merge

MySQL: Merge 2 tables for a SELECT query?

First.. here are the two tables I've created (sans irrelevant columns).. CREATE TABLE users_history1 ( circuit tinyint(1) unsigned NOT NULL default '0', userh_season smallint(4) unsigned NOT NULL default '0', userh_userid int(11) unsigned NOT NULL default '0', userh_rank varchar(2) NOT NULL default 'D', userh_wins int(11) NOT ...

Why won't JPA delete owned entities when the owner entity loses the reference to them?

Hi! I've got a JPA entity "Request", that owns a List of Answers (also JPA entities). Here's how it's defined in Request.java: @OneToMany(cascade= CascadeType.ALL, mappedBy="request") private List<Answer> answerList; And in Answer.java: @JoinColumn(name = "request", referencedColumnName="id") @ManyToOne(optional = false) private Req...

Unable to merge between branches in SVN due to "Invalid character '[]' found in range list"

I encounter this issue pretty consistently when trying to merge a branch back into the trunk in TorstoiseSVN 1.5. Update and commit to both branch and trunk have no issue, its not until I try to merge that I get the: Invalid character '[]' found in range list Sometimes it occurs only using one merge method, primarily "merge a range o...

Git question: possible to merge two different by equal repositories?

If I have a code base. Code base-1, Code Base-2. I run the command: git init git add . git commit -m "Initial Commit" Into both repositories (directories). There are code differences between code base-1 and code base-2 I can't branch them because they already contain differences of about 0.1%. The filenames are the same but th...

LabVIEW, SVN, and Branching -- any method to the madness? (Method to branch/merge binary files?)

I'm using LabVIEW (8.6) for a project with SVN for my revision control and I've come to a point where I need to branch it. I already know I'll need to make changes in the branch that I will want in the trunk. Is there any suggested method or ways to merge binary files from branches in SVN, specifically with respect to LabVIEW? Or will...

Merging MySQL Query results with PHP

I have a table of Calendar event information (Date, username). I want to print the following information for each "event" for a selected month in a table, using PHP and MySQL: SELECT DAYOFWEEK( eventDate ) AS DAY , YEAR( eventDate ) AS YEAR, `primary` , secondary, weekend FROM eventcal WHERE region = 4 AND MONTH( eventDate ) =7 O...

*FIXED* Good with PHP arrays? HELP!

I know there are a lot of smart people, so prove me right! I want to combine arrays where similar named keys merge together to form a single array. See example: [Bob] => Array ( [BobsDetails] => Array ( [Title] => Mr ) ) [Bob] => Array ( [BobsDetails] => Array ( [Surname] => Smith ) ) How do ...

Are svn merges idempotent?

Seems to me like they should be. I'm assuming you've resolved any conflicts that arose during the first merge operation. ...

Merge sorted lists in python

I have a bunch of sorted lists of objects, and a comparison function class Obj : def __init__(p) : self.points = p def cmp(a, b) : return a.points < b.points a = [Obj(1), Obj(3), Obj(8), ...] b = [Obj(1), Obj(2), Obj(3), ...] c = [Obj(100), Obj(300), Obj(800), ...] result = magic(a, b, c) assert result == [Obj(1), Obj(...

Handling image (bmp, png, jpg, etc) file merge conflicts in mercurial

At a minimum, what I'd like is to have "hg merge" open up the conflicting versions in side by side instances of, say, MS Paint (ugh), so I can do the merging manually. Bonus points for tool suggestions other than MS Paint. At the moment I'm looking at Araxis Merge. ...

How do I merge/join mp3 files with c#

I have a library of different words/phrases, and in order to build sentences at present I add a combination of these phrases into a playlist to make a sentence. Unfortunately if the user is running cpu intensive applications (which most of my users are) there can be a lag of a few seconds mid-sentence (in between phrases). In order to ...

merging two or more revisions

In tortoise svn, is it possible to merge two revisions within the trunk (not two branches)? ![alt text][1] ...

Updating a Type-2 Dimension with the MERGE command

I am managing a data warehouse. I have several dimension tables most of which are type-2 and some are type-1. I was able to figure out how to use MERGE to maintain my type-1 dimension tables. I am stumped on how to do the type-2 dimension tables. How do I do both, the update to the EndDate and an insert using the MERGE Command? ...

git: can I subtree merge just a subpath of a repository?

Hi, I have the remotes Foo and Bar. Foo is a web application that has lots of directories, relevent amongst them is /public which cointains assorted files and other directories. Bar is a set of libraries and whatnot used on the front end, as such, it should go in /public/bar in Foo. Foo has no files there. That would all be piece of c...

Mysql merge field from table to another

Hello. I want to merge the field "price" from the table "products" into the field "price" in the table "products_description". Both tables has "products_id" that match. Can't really get my head around it :( ...

Methods for merging or moving an active MySql database

I am upgrading a set of tables, adding and shifting things around. I copy all my data into the new format.... then it automatically becomes old as new data is constantly being added and changed in the old system. Without shutting down the old system for too long, is there a way to merge the two systems when data is still going into the ...

Merge two checkouts in bazaar

I'm just starting out with bazaar, and I've found that the checkout feature is the most useful for the way I work - namely I can c/o from a "master copy", do some development and then commit my changes in the new directory. This then updates the "master copy". But what if I'm working on (eg) two projects, changing different portions of...

svn merge functionality broken by tree conflicts

I don't know when the svn team decided to inflict tree conflicts on us but it has completely broken the merge functionality of svn. I have a branch and I want to merge the latest changes from the trunk into the branch. I've already done one such merge, but this one fails because of a tree conflict. Here's the command: $ svn --force m...

git segfaults on merge - submodule conflict

I'm trying to combine code on two branches with the 'git merge' command, but git is crashing during the process. I need to find an alternative way to merge these branches. To increase merge output to a debug level I ran: $ export GIT_MERGE_VERBOSITY=5 I am currently on the destination branch. git-status shows everything clean an...

Tracking what the MERGE command and its OUTPUT did

I am modifying a Type 2 dimension using the following (long) SQL statement: INSERT INTO AtlasDataWarehouseReports.District ( Col01, Col02, Col03, Col04, Col05, Col06, Col07, Col08, Col09, Col10, StartDateTime, EndDateTime ) SELECT Col01, Col02, Col03, Col04, Col05, ...